These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Information Portal

 
  • Topic is locked indefinitely.
 

Dev Blog: Behind the scenes of a long EVE Online downtime!

First post First post
Author
Previous Topic Next Topic
KenFlorian
Jednota Inc
#81 - 2015-08-14 16:22:29 UTC  |  Edited by: KenFlorian
CCP DeNormalized wrote:
Actually, Oracle RAC is super sexy stuff and I'd love to get some experience with it!

it kicks the pants off SQL Server's offerings in this regard (although I've never used it and perhaps it's junk - but it sounds awesome!)

Actually, I am the HR guy for a company that works on Netezza.

6th normal form on many-terabyte sized data?

No problem.
KenFlorian
Jednota Inc
#82 - 2015-08-14 16:34:07 UTC  |  Edited by: KenFlorian
I don't know anything about RAC but the companies that are choosing Netezza are not the small players in the world. If you need many petabytes and up, then you need to look somewhere else...Hadoop for instance.

But, the stuff our guys do with Netezza is very cool.

Did I mention 6th normal form?

Want a 300G data mart from N data sources that did not exist 10 minutes ago?

No problem.

It's all good fun until a naughty line of loggihg code completely spoils your day.

Better have been damn fine pizza.
Corraidhin Farsaidh
Federal Navy Academy
Gallente Federation
#83 - 2015-08-17 08:41:25 UTC
CCP DeNormalized wrote:
Cor'len wrote:


I expect it was also a case of "We can't reproduce this reliably on our test servers, so we have to debug it in production". I think it was somewhat unclear whether the DB was modified in a way which would've prevented the rollback, and as Masterplan said, a DB restore takes time - I seem to recall a figure of multiple hours.


CCP: Thanks for fixing it, for the skillpoints, and also for the well-written report on the pizza. <3



We take full backups prior to each DT, so it would of been a full backup in no recovery mode plus a few transaction log backups to bring us to just past DT.

Roughly 3 hours for the 3 TB+ restore.

Funny enough we can restore faster in our test env. due to having a massive pool of SAS disks (100's) on the SAN vs. the small pool of SSD disks that the TQ DB uses :)



Pssst...you know that Oracle can do incremental backups whilst the DB is still up and running...would take significantly less time that 3 hours..

On a completely unrelated note I know lots about Oracle RMAN backup and recovery...
Corraidhin Farsaidh
Federal Navy Academy
Gallente Federation
#84 - 2015-08-17 08:44:15 UTC
KenFlorian wrote:
CCP DeNormalized wrote:
Actually, Oracle RAC is super sexy stuff and I'd love to get some experience with it!

it kicks the pants off SQL Server's offerings in this regard (although I've never used it and perhaps it's junk - but it sounds awesome!)

Actually, I am the HR guy for a company that works on Netezza.

6th normal form on many-terabyte sized data?

No problem.


Oracle RAC works very well indeed as long as it is configured correctly (just like anything else :D ). If you want a nice stable cluster with great backup options (RMAN is free btw) You should really look at Oracle

And nice Oracle DBA's....
Tex Bloodhunter
SciFiCentral Explorations Inc.
#85 - 2015-08-26 23:15:58 UTC
That's a good read! Thanks for putting all the details out there!