open All Channels
seplocked EVE Information Portal
blankseplocked New Dev Blog: Full Suite of Upgrades to the Tranquility DB - Yippie!
 
This thread is older than 90 days and has been locked due to inactivity.


 
Pages: [1] 2 3 4 5

Author Topic

CCP Zymurgist


Gallente
C C P
Posted - 2011.03.24 16:29:00 - [1]
 

CCP Yokai has a new blog in our technical series about the upgrades we have applied to the Tranquility Database. Read more about it here.

Lothros Andastar
Gallente
Posted - 2011.03.24 16:41:00 - [2]
 

IBC!

So, at first I was liek D: but then I saw the graphs (especially the Disk Busy one) and was liek :D

Walextheone
The Red Circle Inc.
Posted - 2011.03.24 16:56:00 - [3]
 

Wow :-D

Dansels Friend
Posted - 2011.03.24 17:01:00 - [4]
 

That's some serious hardware!

Now go out there and take some pictures! Want to see them in action so to speak. Very Happy

Moraguth
Amarr
Paragon Fury
Cascade Imminent
Posted - 2011.03.24 17:03:00 - [5]
 

omg... itsbeautiful.jpg

ps. can we buy the old pieces of TQ that you aren't frankensteining over to the new setups?

Vuk Lau
4S Corporation
Morsus Mihi
Posted - 2011.03.24 17:05:00 - [6]
 

:fapfapfap:

Zhentar
Minmatar
The 5th Freedom
Wildly Inappropriate.
Posted - 2011.03.24 17:08:00 - [7]
 

Can I have your [old] stuff? :)

Marconus Orion
D00M.
Northern Coalition.
Posted - 2011.03.24 17:11:00 - [8]
 

I'm not very tech savy so for us laymen non-super geeks, please using a car reference, what is the comparison?

We going from a Fiesta to a Mustang?

CCP Yokai

Posted - 2011.03.24 17:16:00 - [9]
 

Originally by: Marconus Orion
I'm not very tech savy so for us laymen non-super geeks, please using a car reference, what is the comparison?

We going from a Fiesta to a Mustang?


We had a Ferrari 1985 288 GTO

We have a Ferrari 2011 599 GTO

Both great... both fast... the new one is just magic.

make sense?

chainedtofate
Caldari
Creative Cookie Procuring
Rote Kapelle
Posted - 2011.03.24 17:18:00 - [10]
 

Originally by: Marconus Orion
I'm not very tech savy so for us laymen non-super geeks, please using a car reference, what is the comparison?

We going from a Fiesta to a Mustang?


think of it more going from a 96 mustang with 200k miles to a 2011 mustang with 10 miles

momma like
Posted - 2011.03.24 17:20:00 - [11]
 

Edited by: momma like on 24/03/2011 17:20:30

Crux Croupier Locutus
Posted - 2011.03.24 17:22:00 - [12]
 

confirming my laptop has 128GB of ram Laughing

also pics plz so the faping can begin Neutral

Chihiro Ma
Posted - 2011.03.24 17:26:00 - [13]
 

Amazing... so now you dont have to tune those SQL's for a while ;)

Dziu
Posted - 2011.03.24 17:28:00 - [14]
 

Well i guess someone has new toys. We better see some improvements in clusters so we dont die on grid every time there 600+ pilots in a nod. :)

Commander Azrael
Red Federation
Posted - 2011.03.24 17:28:00 - [15]
 

Epic hardware is epic Shocked

DTson Gauur
Caldari
Blend.
Nulli Tertius
Posted - 2011.03.24 17:30:00 - [16]
 

Tech**** the best **** ( in dev blogs you PERVS! ) \o/

Quite simply epic step forward , finally after what? 6 years the DB Failovers actually WORK as they're supposed to :)

EliteSlave
Minmatar
Macabre Votum
Morsus Mihi
Posted - 2011.03.24 17:32:00 - [17]
 

I wish i could post that screen cap of Stan after sneaking into that trailer with internet....

But, I have so many questions about the hardware... like specific model numbers, firmware. More so to do with possible integration here at my office as we have a pretty large database and are looking to scale up our hardware as we are approaching saturation of it.

so any **** is good ****

Chribba
Otherworld Enterprises
Otherworld Empire
Posted - 2011.03.24 17:32:00 - [18]
 

zomg.

CCP Yokai

Posted - 2011.03.24 17:34:00 - [19]
 

Originally by: EliteSlave
I wish i could post that screen cap of Stan after sneaking into that trailer with internet....

But, I have so many questions about the hardware... like specific model numbers, firmware. More so to do with possible integration here at my office as we have a pretty large database and are looking to scale up our hardware as we are approaching saturation of it.

so any **** is good ****


Ask and I'll try and answer... better yet if you are at Fanfest... I present all that tomorrow.

Nayette Ellis Dalogne
Posted - 2011.03.24 17:34:00 - [20]
 

Holy whopping cow! And here I was thinking I already had all my nergasms this week. ugh

Neramore
Posted - 2011.03.24 17:34:00 - [21]
 

Awesome stuff; I has an envy!
However, would you mind translating some of that to units we can all relate to, like Library of Congresses per Second (LoC/S), maybe?

EliteSlave
Minmatar
Macabre Votum
Morsus Mihi
Posted - 2011.03.24 17:43:00 - [22]
 

Originally by: CCP Yokai
Originally by: EliteSlave
I wish i could post that screen cap of Stan after sneaking into that trailer with internet....

But, I have so many questions about the hardware... like specific model numbers, firmware. More so to do with possible integration here at my office as we have a pretty large database and are looking to scale up our hardware as we are approaching saturation of it.

so any **** is good ****


Ask and I'll try and answer... better yet if you are at Fanfest... I present all that tomorrow.


Wow, didnt expect a response like that..

Well I guess the first few questions are we are currently doing the FC/IP (Fibre Chan over IP) and we are kinda limited in the I/O factor of around 30 that we have currently attached to 12 Dell Powervault 3610's ( ISCSI / FC/IP and FC ) and we are already maxing out the hardware and we are trying to get the next bang for out buck with going full FC but since this will be our first foray into the "Enterprise" level we are reading "blah blah blah" and dont really understand what we should be looking for of sorts. Now im not expecting you to give me a visio flowchart of the equipment or how its setup. But if you can say broad terminology that is well acceptable for growth of the next 2-3 years and allows for 1000-1500 ( ideally would like to have hardware that supports 2500-3000 to allow for growth) users concurrently hitting the database at any given time would mucho appreciated.

Emrys Ap'Morgravaine
Caldari
Minmatar Ship Construction Services
Ushra'Khan
Posted - 2011.03.24 17:43:00 - [23]
 

Confirming that I've just had multiple "personal" moments in my pants, and may now die of dehydration...

Ban Doga
Posted - 2011.03.24 17:46:00 - [24]
 

Edited by: Ban Doga on 24/03/2011 17:46:25
I remember that someone (CCP Explorer ?) said not so long ago, that the DB is not anywhere near its performance limit.
So I'm really looking forward to seeing no performance improvements from this one.

I'm happy that you are happy, tho...

Psihius
Caldari
Anarchist Dawn
U N K N O W N
Posted - 2011.03.24 17:52:00 - [25]
 

Edited by: Psihius on 24/03/2011 17:53:32
BEST
GEEK
****
EVAR!


Most of us, geeks, would work for food to get our hands on that hardware, to be able to touch it with some very nasty thoughts ;) :D

I'll blow my head with a shotgun if I will not make it to the next Fanfest!

CCP Yokai

Posted - 2011.03.24 17:54:00 - [26]
 

Edited by: CCP Yokai on 24/03/2011 17:57:15
Originally by: EliteSlave
Originally by: CCP Yokai
Originally by: EliteSlave
I wish i could post that screen cap of Stan after sneaking into that trailer with internet....

But, I have so many questions about the hardware... like specific model numbers, firmware. More so to do with possible integration here at my office as we have a pretty large database and are looking to scale up our hardware as we are approaching saturation of it.

so any **** is good ****


Ask and I'll try and answer... better yet if you are at Fanfest... I present all that tomorrow.


Wow, didnt expect a response like that..

Well I guess the first few questions are we are currently doing the FC/IP (Fibre Chan over IP) and we are kinda limited in the I/O factor of around 30 that we have currently attached to 12 Dell Powervault 3610's ( ISCSI / FC/IP and FC ) and we are already maxing out the hardware and we are trying to get the next bang for out buck with going full FC but since this will be our first foray into the "Enterprise" level we are reading "blah blah blah" and dont really understand what we should be looking for of sorts. Now im not expecting you to give me a visio flowchart of the equipment or how its setup. But if you can say broad terminology that is well acceptable for growth of the next 2-3 years and allows for 1000-1500 ( ideally would like to have hardware that supports 2500-3000 to allow for growth) users concurrently hitting the database at any given time would mucho appreciated.


First off... nothing over anything if you can do it... FC is the best bet for "Enterprise" like you said because of the session based communications and the potential for synchronous protection to redundant SAN controllers. I am biased... this is my opinion but I avoid iSCSI unless forced buy sharp object.

Next... direct connection or true SAN need to be decided on early. Direct connecting the disks is faster (like nano seconds only) but cheaper because you don't have to buy switches. BUT!!! When you run out of host ports and you need to get another system attached or accessing the LUNs, boy are you gonna miss those switches.

Next... SAS unless you know better. SAS is great! I love this stuff... cheaper than FC-SCSI and much better than SATA... best mid-ground disks. SSD's rock my socks but you will pay massively for them or you will get cheap ones and hate what you did later.

Last... Find the right performance metric. Concurrent users means lots to lots of people. I would suggest looking at your IOPS. A 12 drive tray of SAS usually nets 5-10K IOPS on normal workloads for a DB.

Hope that helps a little. All I can toss at you between beers at Fanfest :)

CCP Yokai


EliteSlave
Minmatar
Macabre Votum
Morsus Mihi
Posted - 2011.03.24 17:55:00 - [27]
 

Originally by: Psihius
BEST
GEEK
****
EVAR!


Most of us, geeks, would work for food to get our hands on that hardware, to be able to touch it with some very nasty thoughts ;) :D


I would work just for boarding for CCP for the experience alone. I would work for free ( just pay for my housing / dont mind me going to the chef with a big take home tupperware box)

lceman
Gallente
FinFleet
Raiden.
Posted - 2011.03.24 17:55:00 - [28]
 

impressive wall of text, but unfortunely i can only come up with.

Try harder, Try again, u fail.

Why cause eve is still broken by lag, by unfair advantages, biased gm/dev.

And to the next obvious question why do i still play eve, well thats easy question
Cause of the friends i have trough the community i'm in, in eve simple as that.
I don't play it be cause its a cool awsome game that exciting and thrilling or cause i'm building up a corp or an alliance, all that is more or less broken either by faulty game mechanic's or simple bad choices by gm/[email protected] public relation.

To put it simple i play eve to be able to sit on teamspeak and talk to my [email protected] wich some of them have become [email protected], but eventually like everything else this group is becomimg smaller and smaller and then when there is no left ill quit too.

CCP Yokai

Posted - 2011.03.24 17:56:00 - [29]
 

Originally by: Ban Doga
Edited by: Ban Doga on 24/03/2011 17:46:25
I remember that someone (CCP Explorer ?) said not so long ago, that the DB is not anywhere near its performance limit.
So I'm really looking forward to seeing no performance improvements from this one.

I'm happy that you are happy, tho...


Check the disk busy... CPU... um and other graphs in the blog... We dug deeper and found some bottlenecks recently.

Ban Doga
Posted - 2011.03.24 18:00:00 - [30]
 

Edited by: Ban Doga on 24/03/2011 18:02:45
Originally by: CCP Yokai
Originally by: Ban Doga
Edited by: Ban Doga on 24/03/2011 17:46:25
I remember that someone (CCP Explorer ?) said not so long ago, that the DB is not anywhere near its performance limit.
So I'm really looking forward to seeing no performance improvements from this one.

I'm happy that you are happy, tho...


Check the disk busy... CPU... um and other graphs in the blog... We dug deeper and found some bottlenecks recently.


I didn't say the DB is not running better now (it certainly is).
I was just repeating what a CCP official said: the DB is not a bottleneck itself (I'll try to find the original statement on eve-search).

If your SOL nodes hit 100% CPU load your improved DB performance won't matter that much...

*EDIT*
Reduced stress for the machines is great (especially for the ones in charge of the health of those servers), but how does this translate into perceived performance for the users?


Pages: [1] 2 3 4 5

This thread is older than 90 days and has been locked due to inactivity.


 


The new forums are live

Please adjust your bookmarks to https://forums.eveonline.com

These forums are archived and read-only