EVE Search - Eve down due to SQL problems

Check My IP Information

All Channels

EVE General Discussion

Eve down due to SQL problems

» Click here to find additional results for this topic using Google

Monitor this thread via RSS [?]

Pages: [1] 2 :: one page

Author	Thread Statistics \| Show CCP posts - 0 post(s)
Tobin Shalim Eclipse Industrials Quantum Forge	Posted - 2010.01.09 22:44:00 - [1] This is what happens when you use SQL on a database the size of Eve. It's just not built for it. ----- Originally by: Gierling Tech III is going to be "Fully modular" until someone crams the "EW Bonus" modules together with the "8 Midslots" modules...
Sky Montana Caldari State War Academy	Posted - 2010.01.09 22:46:00 - [2] what's SQL
Dizzy Lizzie	Posted - 2010.01.09 22:47:00 - [3] What do you propose then :) ?
Vossejongk Caldari Bendebeukers Green Rhino	Posted - 2010.01.09 22:48:00 - [4] Originally by: Sky Montana what's SQL Lots of text But then again I cant really approve of any of this because this is my signature
SwitchBl4d3 Quam Singulari	Posted - 2010.01.09 22:48:00 - [5] It's nerd speek for something nerdy no doubt, btw ta for posting. Next time I need to know why eves down ill convo you! Please all send this guy 1 isk when u log in Originally by: Stavros BUNGLE IN JUNGLE? J tHX OMG YEAH CHICKEN WINGS K? LOLLER SKATESWIHT LUBE K? MIUOINKEYT!!!
Spurty Caldari Rionnag Alba Triumvirate.	Posted - 2010.01.09 22:49:00 - [6] Structured Query Language just a way to access data in a database. Its NOT the only way. I do not believe for a moment CCP uses SQL to do anything to do with serious computation in the game. Sure, they might use it to access market listings, but after that, they'll be using some other technique Originally by: Hurley I WAS NOT QUITTING SoT AND WAS NOT THINKING ABOUT JOINING IT. PL/SoT MADE A MISTAKE AND ARE NOT MAN ENOUGH TO ADMIT IT OR FIX IT.
Zalinor	Posted - 2010.01.09 22:51:00 - [7] ohhhh i think a bomb touch the server.....
Knorkor Gallente	Posted - 2010.01.09 22:51:00 - [8] Originally by: Dizzy Lizzie What do you propose then :) ? Rather MySQL than M$-SQL ;) regards --------------------------------------- Sometimes it pays to stay in bed in Monday, rather than spending the rest of the week debugging Monday's code. ~Dan Salomon
Sabastian Cane	Posted - 2010.01.09 22:51:00 - [9] Edited by: Sabastian Cane on 09/01/2010 22:52:22 The entire system is built on top of SQL databases... and what you on about, some of the largest databases in the world are run on SQL databases... MySQL doesn't scale well, the clustering solutions sucks too.
Tobin Shalim Eclipse Industrials Quantum Forge	Posted - 2010.01.09 22:52:00 - [10] Originally by: Spurty Structured Query Language just a way to access data in a database. Its NOT the only way. I do not believe for a moment CCP uses SQL to do anything to do with serious computation in the game. Sure, they might use it to access market listings, but after that, they'll be using some other technique I can't remember where I read it, but there was a devblog or forum post about the technology behind the backend (database) of Eve and it was stated by the main programmer that they use SQL for EVERYTHING. ----- Originally by: Gierling Tech III is going to be "Fully modular" until someone crams the "EW Bonus" modules together with the "8 Midslots" modules...

Blane Xero Amarr The Firestorm Cartel	Posted - 2010.01.09 22:52:00 - [11] Originally by: Knorkor Originally by: Dizzy Lizzie What do you propose then :) ? Rather MySQL than M$-SQL ;) regards Thanks for the laugh. _____________________________________ Haruhiist since December 2008 Originally by: CCP Fallout :facepalm:
Dizzy Lizzie	Posted - 2010.01.09 22:55:00 - [12] Originally by: Knorkor Originally by: Dizzy Lizzie What do you propose then :) ? Rather MySQL than M$-SQL ;) regards XD you wish. Michael fanboy anyone?
w1ldt4ngent SWARTA	Posted - 2010.01.09 22:58:00 - [13] CCP uses Microsoft SQL Server 2008. Not surprised for a second the house of cards fell down. Methinks they should upgrade to Oracle, but with the amount of nodes they have, and Oracle's per-core licensing... that would be costly. ___________________________ Swartans! Tonight we dine in Hek!
NeanderthalX	Posted - 2010.01.09 23:05:00 - [14] Originally by: w1ldt4ngent CCP uses Microsoft SQL Server 2008. Not surprised for a second the house of cards fell down. Methinks they should upgrade to Oracle, but with the amount of nodes they have, and Oracle's per-core licensing... that would be costly. If they are running a DB instance on each node then shame on them. Should be on Oracle as you say, but on AIX to maximize the performance and soften the per core cost blow. It's not the cheapest solution as you mentioned, but it would stop the bleeding. No one, including Microsoft themselves uses SQL 2008 for anything with high transaction rates. Look at Exchange, it's on JET, SQL is too slow for it and it's just passing email.
RalphsInTown Gallente Great Sage Equaling Heaven	Posted - 2010.01.09 23:07:00 - [15] I say replace it with dBase IV. I heard it's great.
Mihara Shiharu	Posted - 2010.01.09 23:08:00 - [16] Time to trash MS-SQL and use something else imo. And bring back the linux client tyvm
Infraeon	Posted - 2010.01.09 23:08:00 - [17] CCP should implement their own NoSql solution
w1ldt4ngent SWARTA	Posted - 2010.01.09 23:08:00 - [18] Ya, I doubt they run an instance of SQL Server on each node, that would be... dumb. But Oracle is still a lot more expensive than MSSQL, but as much as Oracle makes me want to pull my hair out when I work with it, at least it works... most of the time. ___________________________ Swartans! Tonight we dine in Hek!
NeanderthalX	Posted - 2010.01.09 23:14:00 - [19] Originally by: w1ldt4ngent Edited by: w1ldt4ngent on 09/01/2010 23:12:03 Ya, I doubt they run an instance of SQL Server on each node, that would be... dumb. But Oracle is still a lot more expensive than MSSQL, but as much as Oracle makes me want to pull my hair out when I work with it, at least it works... most of the time. An IBM mainframe would probably work a lot better than their current DB cluster, but it would of course be orders of magnitude more expensive. Agreed.
Andrea Griffin	Posted - 2010.01.09 23:16:00 - [20] Originally by: Tobin Shalim This is what happens when you use SQL on a database the size of Eve. It's just not built for it. Originally by: Dizzy Lizzie What do you propose then :) ? I bet he'd rather be using flat files in combination with sed, awk, grep and some perl scripts thrown in, too.

Buster Bloodvessel	Posted - 2010.01.09 23:18:00 - [21] Pardon my ignorance of versions of SQL, but I would have thought a linux/unix version would be more stable? I know MySquirrel doesn't scale well but are there not other linux equivalents? wystler stole my sig
Arimus Darkhart Caldari Sane Industries Inc. Initiative Mercenaries	Posted - 2010.01.09 23:21:00 - [22] SQL is not a database :) Its just a means of accessing data using a defined standards based language. Structured Query Language gives a small hint that its not a database in and of itself. Its not the best thing ever but a number of companies keep trying to come up with something better than SQL and usually fall flat on their faces. -- Users are like a virus - each causing a thousand tiny crises until the host finally dies.
Robdon Baptism oF Fire Sons of Tangra	Posted - 2010.01.09 23:33:00 - [23] Originally by: Infraeon CCP should implement their own NoSql solution This. There is no way you should use SQL for something that needs this much power.
Spurty Caldari Rionnag Alba Triumvirate.	Posted - 2010.01.09 23:37:00 - [24] Originally by: Tobin Shalim I can't remember where I read it, but there was a devblog or forum post about the technology behind the backend (database) of Eve and it was stated by the main programmer that they use SQL for EVERYTHING. very possible they said that (you're not a liar or insane or probably even misremembering), but, they are quite public about their use of Python. "What does that mean?" "means that Python might call up a query via bindings using an SQL call. Once it has that info, it processes it (does calculations over it), then passes it back to the database again, once more using an SQL call." Originally by: Hurley I WAS NOT QUITTING SoT AND WAS NOT THINKING ABOUT JOINING IT. PL/SoT MADE A MISTAKE AND ARE NOT MAN ENOUGH TO ADMIT IT OR FIX IT.
Jordon Spikes	Posted - 2010.01.09 23:39:00 - [25] i think lotus 123 would be a good choice
JitaEspion	Posted - 2010.01.09 23:45:00 - [26] Everyone knows this game is run off of Excel.
Windows ME	Posted - 2010.01.09 23:47:00 - [27] If they want the game to carry on and carry on attracting more and more people, they need to do something about this SQL problem NOW.
Forge Lag Jita Lag Preservation Fund	Posted - 2010.01.09 23:48:00 - [28] NOW?! Can't you see that I am yet to take my "pay but not play" vacation? "Real men play badminton, deep diving is for pussies." PvP 13373P33K unscrambled
J Random Tax Protestants	Posted - 2010.01.10 00:17:00 - [29] Edited by: J Random on 10/01/2010 00:20:16 Ja during the post dominion crash the CCP Senior DBA (which doesn't mean squat, he could have one year of DBA experience and is senior to the junior who has one month experience) stated they use MS 2008 in a non-HAC cluster. What happened last time was large chunk of the active nodes died and it didn't fail over. The solution was to put in a ticket with Microsoft (I joke you not). At least the forth time now Eve failed since Dominions because of their crappy DB. I mean if they want to stick with a Windows OS, fine; run Oracle on Windows. BTW while Oracle charges per core MSSQL Enterprise ain't cheap either, just bought a couple licenses at US$50,000 a pop. Also when you couple it with the Microsoft 2008 OS licenses and loss of reputation for crappy preventable outages they really need to move to Oracle. If they want to lesson cost go Oracle on Windows 2008 then later migrate to Oracle on Solaris or AIX. Sun (now that Oracle owns them) will throw in some sweet deals to get the TCO down. Course then you would have hire a real DBA and not some system admin who calls himself a DBA cause he can double click the MSSQL installer and build tables with the MSSQL GUI.
Muhammed Jafar	Posted - 2010.01.10 01:09:00 - [30] I heard this was a good place to get some nerd cred so... SQL is way better than SQL because of random.choice([scaling, speed, cost, small woodland mammals])



Pages: [1] 2 :: one page
First page \| Previous page \| Next page \| Last page

COPYRIGHT NOTICE
EVE Online, the EVE logo, EVE and all associated logos and designs are the intellectual property of CCP hf. All artwork, screenshots, characters, vehicles, storylines, world facts or other recognizable features of the intellectual property relating to these trademarks are likewise the intellectual property of CCP hf. EVE Online and the EVE logo are the registered trademarks of CCP hf. All rights are reserved worldwide. All other trademarks are the property of their respective owners. CCP hf. has granted permission to EVE-Search.com to use EVE Online and all associated logos and designs for promotional and information purposes on its website but does not endorse, and is not in any way affiliated with, EVE-Search.com. CCP is in no way responsible for the content on or functioning of this website, nor can it be liable for any damage arising from the use of this website.