| Pages: 1 2 3 4 5 [6] 7 :: one page |
| Author |
Thread Statistics | Show CCP posts - 1 post(s) |
M3ta7h3ad
Caldari
Open University of Celestial Hardship
New Bastion
   |
Posted - 2010.01.09 23:12:00 -
[151]
 Originally by: Shoikan
Originally by: Noram Rad
Originally by: Ath'daru
they need to upgrade from MySQL to Oracle imho 
It's using MSSQL, which is one of the most used SQL database engines in many large sites.
What it is, is that they haven't got enough blade servers to share the load on the database cluster for when it goes over a certain number, which is creating the bottlenecks and forcing the server to crash.
I am sorry mate, but.... Using MSSQL for any database over a couple of hundred MBs is asking for trouble. MSSQL is only an old version of Sybase with some GUI eyecandy tacked onto it, don't pretend it's much more than that. For serious SQL stuff, stick to either the original thing (Sybase) or Oracle or something. Not something that is liked more for it's GUI than it's stability...
Were you born ******ed? Or did repeatedly licking windows at the back of the special bus just make you that way?
An example of how misguided the above comments are:
http://www.microsoft.com/casestudies/Case_Study_Detail.aspx?CaseStudyID=49677 - 7 Terabytes just for starters.
We are talking about MSSQL not Microsoft Access.
Now please google hard next time if you lack the knowledge to make informed posts before making ill-judged and completely non-sensical sweeping statements such as the above.
More reading re: performance and scaling for high-availability systems.
http://www.microsoft.com/sqlserver/2005/en/us/cs-government-perfscale.aspx
Thank you.
-----
If you kill all the wolves, your gonna end up with a crapload of bunnies, and by bunnies I mean stupid people
Eve & Linux Woot! |
Vyktor Abyss
The Abyss Corporation
|
Posted - 2010.01.09 23:12:00 -
[152]
So...
I guess the traffic police are busy... 
|
Zanthosistine
|
Posted - 2010.01.09 23:13:00 -
[153]
I am in but I have a message saying my "player is stuck" whatever the heck that means.  |
Shemmy
7th Space Cavalry
Don't Panic.
|
Posted - 2010.01.09 23:13:00 -
[154]
Originally by: HazeInADaze
If you're planning to play eve, let CCP know ahead of time by filling out the i want to play eve notification form.
|
Samroski
Middle-Earth
|
Posted - 2010.01.09 23:13:00 -
[155]
I think we're heading towards another crash...
|
Kronon Tarr
|
Posted - 2010.01.09 23:15:00 -
[156]
Edited by: Kronon Tarr on 09/01/2010 23:14:54
Originally by: Noram Rad
Originally by: Ath'daru
they need to upgrade from MySQL to Oracle imho
It's using MSSQL, which is one of the most used SQL database engines in many large sites.
You really dont know anything about this do you?
MSSQL is ****, MySQL is a lot better than MSSQL.. besides this the run everything on stupid windows machines which is worst mistake you can make for such a large environment
|
Setertius
|
Posted - 2010.01.09 23:16:00 -
[157]
Originally by: Samroski
I think we're heading towards another crash...
Agreed. Alternating between 'stuck', 'failed' and 'currently loading'
|
Wrayeth
Sharks With Frickin' Laser Beams
|
Posted - 2010.01.09 23:16:00 -
[158]
Edited by: Wrayeth on 09/01/2010 23:17:40
Originally by: Br41n
CCP forgot to pay the gas bill,
heaters all stopped functioning,
hamsters froze to death
You forget that hamsters generate their own heat; sufficiently powerful ones act like a space heater.
Also, "You are located in _____, which is currently stuck. Please select a different character or try again later." ...on both my main AND my alt. >.<
-Wrayeth
n00b Extraordinaire
"Look, pa! I just contributed absolutely nothing to this thread!" |
Br41n
Amarr
Pinky and the Brain corp
|
Posted - 2010.01.09 23:17:00 -
[159]
Originally by: Wrayeth
Originally by: Br41n
CCP forgot to pay the gas bill,
heaters all stopped functioning,
hamsters froze to death
You forget that hamsters generate their own heat; sufficiently powerful ones act like a space heater.
Well looking in game i think they are cold blooded and just stopped again
~~~~~~~~~~~~~~~~~~~~~
Pinky: Gee, Brain. What are we going to do tonight?
Brain: The same thing we do every night, Pinky. Try to take over the world.
~~~~~~~~~~~~~~~~~~~~~ |
Blane Xero
Amarr
The Firestorm Cartel
|
Posted - 2010.01.09 23:18:00 -
[160]
Originally by: Kronon Tarr
Edited by: Kronon Tarr on 09/01/2010 23:14:54
Originally by: Noram Rad
Originally by: Ath'daru
they need to upgrade from MySQL to Oracle imho
It's using MSSQL, which is one of the most used SQL database engines in many large sites.
You really dont know anything about this do you?
MSSQL is ****, MySQL is a lot better than MSSQL..
Thats two laughs in one night. Sorry, but if you really think MySQL Can run as big-time as the eve servers, you better do some reading. MySQL is good for small implimentations, not HUGE ones.
_____________________________________
Haruhiist since December 2008
Originally by: CCP Fallout
:facepalm:
|
Guttripper
Caldari
State War Academy
|
Posted - 2010.01.09 23:20:00 -
[161]
Originally by: Roemy Schneider
oh hai - it's 2006 again \o/
"Oh no! I have a skill ending soon and the server is down!"
Now that would be 2006...
|
Roemy Schneider
Vanishing Point.
|
Posted - 2010.01.09 23:20:00 -
[162]
gamelog 20100109_231114.txt is exploding.....
-
putting the gist back into logistics |
Professor Tarantula
Hedion University
|
Posted - 2010.01.09 23:22:00 -
[163]
I'm in, and there are traffic advisories running constantly for pretty much every system in game. Expect another reboot.
My deepest sympathies.
Prof. Tarantula, Esq. |
almost bald
Sacred Templars
Black Swan.
|
Posted - 2010.01.09 23:22:00 -
[164]
any1 else having problems with no pos shied and lockable in pos ?
|
Swygg
|
Posted - 2010.01.09 23:22:00 -
[165]
CTD??? Wow, just wow...haven't had that in Eve for a couple of years....Tell the hamsters to lay off the green chili...
|
SomebodyKickedMyDog
|
Posted - 2010.01.09 23:22:00 -
[166]
Originally by: Blane Xero
Originally by: Kronon Tarr
Edited by: Kronon Tarr on 09/01/2010 23:14:54
Originally by: Noram Rad
Originally by: Ath'daru
they need to upgrade from MySQL to Oracle imho
It's using MSSQL, which is one of the most used SQL database engines in many large sites.
You really dont know anything about this do you?
MSSQL is ****, MySQL is a lot better than MSSQL..
Thats two laughs in one night. Sorry, but if you really think MySQL Can run as big-time as the eve servers, you better do some reading. MySQL is good for small implimentations, not HUGE ones.
unsubstantiated claims ftw! 
|
Bill Serkoff2
|
Posted - 2010.01.09 23:23:00 -
[167]
Suggestion posted
|
Lost Hamster
Hamster Holding Corp
|
Posted - 2010.01.09 23:23:00 -
[168]
Originally by: Yal XianKun
Originally by: Ath'daru
they need to upgrade from MySQL to Oracle imho
I believe they use MS SQL 2007 cluster as MySQL cluster is not that hot for this sort of thing. However, Oracle would be a good choice imho.
Oracle?
I see that you have never mainteaned an Oracle db. 
|
Eddie Laydon
Caldari
Innovative Creation Industries
Sons of RA
|
Posted - 2010.01.09 23:23:00 -
[169]
waaaa.......
Why don't they make the whole plane out of that black box stuff.
-- Steven Wright |
Gariuys
Evil Strangers Inc.
|
Posted - 2010.01.09 23:24:00 -
[170]
Originally by: Blane Xero
Originally by: Kronon Tarr
Edited by: Kronon Tarr on 09/01/2010 23:14:54
Originally by: Noram Rad
Originally by: Ath'daru
they need to upgrade from MySQL to Oracle imho
It's using MSSQL, which is one of the most used SQL database engines in many large sites.
You really dont know anything about this do you?
MSSQL is ****, MySQL is a lot better than MSSQL..
Thats two laughs in one night. Sorry, but if you really think MySQL Can run as big-time as the eve servers, you better do some reading. MySQL is good for small implimentations, not HUGE ones.
The only thing that makes it slightly less funny is that every single time there's a database problem.... the "I've got a friend that knows someone that knows a dba that says... "come out of the woodworks too tell us how much MSSQL sucks.... ( hint... it doesn't )
|
Jordon Spikes
|
Posted - 2010.01.09 23:24:00 -
[171]
all miners are to dock now as concord is reported to be on strike
|
Leandro Salazar
Quam Singulari
|
Posted - 2010.01.09 23:26:00 -
[172]
Quote:
23:21:06 Notify Traffic Advisory: Officials have closed the stargates and undocking ramps due to heavy congestion (in the J155928 system in the Unknown constellation of the Unknown region). Travellers are advised to seek alternate routes.
So there are now stargates and stations in wormhole systems? :D
And if you are reading this, you have arrived at the signature without noticing...
|
Muhammed Jafar
|
Posted - 2010.01.09 23:27:00 -
[173]
Originally by: M3ta7h3ad
Originally by: Shoikan
Originally by: Noram Rad
Originally by: Ath'daru
they need to upgrade from MySQL to Oracle imho
It's using MSSQL, which is one of the most used SQL database engines in many large sites.
What it is, is that they haven't got enough blade servers to share the load on the database cluster for when it goes over a certain number, which is creating the bottlenecks and forcing the server to crash.
I am sorry mate, but.... Using MSSQL for any database over a couple of hundred MBs is asking for trouble. MSSQL is only an old version of Sybase with some GUI eyecandy tacked onto it, don't pretend it's much more than that. For serious SQL stuff, stick to either the original thing (Sybase) or Oracle or something. Not something that is liked more for it's GUI than it's stability...
Were you born ******ed? Or did repeatedly licking windows at the back of the special bus just make you that way?
An example of how misguided the above comments are:
http://www.microsoft.com/casestudies/Case_Study_Detail.aspx?CaseStudyID=49677 - 7 Terabytes just for starters.
We are talking about MSSQL not Microsoft Access.
Now please google hard next time if you lack the knowledge to make informed posts before making ill-judged and completely non-sensical sweeping statements such as the above.
More reading re: performance and scaling for high-availability systems.
http://www.microsoft.com/sqlserver/2005/en/us/cs-government-perfscale.aspx
Thank you.
NERD FIGHT!!!
|
Forge Lag
Jita Lag Preservation Fund
|
Posted - 2010.01.09 23:28:00 -
[174]
Originally by: Kalissa
Is it me or does it seem that these "database crashes" have been happening more since Dominion was released?
Actually, they are happening since certain dev nerfed moms. Unfortunetelly someone nuked fleet battles too so the database crashes stay.
Not that I know anything I just observe strange coincidence.
"Real men play badminton, deep diving is for pussies."
PvP 13373P33K unscrambled
|
Fearless M0F0
Gallente
Aliastra
|
Posted - 2010.01.09 23:29:00 -
[175]
23:26:23 Notify Traffic Advisory: Officials have closed the stargates and undocking ramps due to heavy congestion (in the J135411 system in the Unknown constellation of the Unknown region). Travellers are advised to seek alternate routes.
Uh, w-space systems have stargates and stations?
|
Ellan Thrace
Caldari
Tadakastu-Obata Corporation
The Honda Accord
|
Posted - 2010.01.09 23:32:00 -
[176]
Oh, a your mama SQL war!!!
So currently I architect commercial enterprise applications for a well known communications company for a living. MSSQL is DEFINITELY a reasonable choice for something like Eve. The nice part about it is you can use it out of the box, deployment is a well understood problem and you have great support. There a lots of examples of huge deployments being very successful. So known and a safe choice.
MySQL can also be used in massive systems. Google is basically built on a variant of MySQL and that is considered to be one of the largest database applications on the planet. Problem is though, not really a "commercial" product so you have to assume a lot of the burden to support it in your application that you might be able to get from a third party.
There are other high performance and scalable database back ends as well. But there really isn't any reason to consider them over the two I just discussed.
So I am happy with CCP using MSSQL because it lets the concentrate on other aspects of their product and largely count on Microsoft to be making MSSQL as good as it can be.
So as it is with every decision when crafting a software solution, you have to look at all aspects of the impact of a decision, not just raw performance.
Starbuck
Press Officer
Tadakatsu Obata Corporation
Helping make the world less bum-optimal! |
Mal Lokrano
Gallente
Delve Inc.
|
Posted - 2010.01.09 23:33:00 -
[177]
I think its safe to say at this point the server not only went down but has yet to fully come up again.
____________________________________________
When going to a party with wine, women, and song. Always ascertain the vintage of the first two. |
Uronksur Suth
|
Posted - 2010.01.09 23:36:00 -
[178]
Guys..... It wasn't the database. Clearly someone at CCP just tripped over a power cord! 
|
Kazuo Ishiguro
House of Marbles
|
Posted - 2010.01.09 23:36:00 -
[179]
Originally by: Fearless M0F0
23:26:23 Notify Traffic Advisory: Officials have closed the stargates and undocking ramps due to heavy congestion (in the J135411 system in the Unknown constellation of the Unknown region). Travellers are advised to seek alternate routes.
Uh, w-space systems have stargates and stations?
I can't comment on any individual stargates or stations, but I'm sure they're all closed.
---
34.4:1 mineral compression |
Kronon Tarr
|
Posted - 2010.01.09 23:37:00 -
[180]
Originally by: Blane Xero
Originally by: Kronon Tarr
Edited by: Kronon Tarr on 09/01/2010 23:14:54
Originally by: Noram Rad
Originally by: Ath'daru
they need to upgrade from MySQL to Oracle imho
It's using MSSQL, which is one of the most used SQL database engines in many large sites.
You really dont know anything about this do you?
MSSQL is ****, MySQL is a lot better than MSSQL..
Thats two laughs in one night. Sorry, but if you really think MySQL Can run as big-time as the eve servers, you better do some reading. MySQL is good for small implimentations, not HUGE ones.
I dont doubt about your MSSQL knowledge, also seen in the links you provided in your prev post.
It does look like you don't know anything about MySQL after this reply.
MySQL is perfect for huge environments like also EVE, especially if you go look into the clustering possibilities.
|
| |
|
| Pages: 1 2 3 4 5 [6] 7 :: one page |
| First page | Previous page | Next page | Last page |