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

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

Test Server Feedback

 
  • Topic is locked indefinitely.
 

Singularity: Database changes inbound

First post
Author
CCP Habakuk
C C P
C C P Alliance
#1 - 2013-10-22 17:19:17 UTC  |  Edited by: CCP Habakuk
Hi!

In the next days we will be running a test on Singularity to upgrade the database to SQL Server 2012. We will be testing performance and stability to make sure everything is ready for the upgrade of Tranquility at some later point.

Details: A copy of the current Sisi DB was taken yesterday, which is now running SQL Server 2012. Tomorrow we will switch Singularity to this DB, which means a roll-back of Singularity to the state of Monday. On Thursday we will run a mass test on this setup, which should also stress the DB a bit. Next week we plan to switch back to the old DB (again some kind of roll-back).

With dates (future dates are subject to change):
Oct 21 - Current Sisi (let's call it DB A) is copied to DB B
Oct 23 - Sisi is switched from DB A to DB B
Oct 24 - Mass Test
Oct 29 - Sisi is switched back to DB A

SP for the mass test will be applied on both databases. All other changes on the temporary database will be lost after we change back to the old DB.

CCP Habakuk | EVE Quality Assurance | Team Five 0 | (Team Gridlock)

Bug reporting | Mass Testing

LtCol Laurentius
The Imperial Sardaukar
#2 - 2013-10-22 18:01:12 UTC
Does this mean that the Rubicon features will be deployed back to Sisi only after this DB-test?
CCP Habakuk
C C P
C C P Alliance
#3 - 2013-10-22 18:04:07 UTC  |  Edited by: CCP Habakuk
LtCol Laurentius wrote:
Does this mean that the Rubicon features will be deployed back to Sisi only after this DB-test?

No, the Rubicon features will probably be deployed back to Sisi within a few hours of the DB switch (or even at the same time).

CCP Habakuk | EVE Quality Assurance | Team Five 0 | (Team Gridlock)

Bug reporting | Mass Testing

Kor'el Izia
#4 - 2013-10-22 18:22:46 UTC
Yay, upgrades!

Any particular reason for upgrading, support running out? Numbers, graphs or descriptions of the improvements is always a pleasure to digest.
Alvatore DiMarco
Capricious Endeavours Ltd
#5 - 2013-10-22 21:46:21 UTC
Hooray, Rubicon is coming back to SiSi!

Also, you typoed "Singularity" in the thread title.
CCP Habakuk
C C P
C C P Alliance
#6 - 2013-10-22 23:39:07 UTC
Alvatore DiMarco wrote:
Hooray, Rubicon is coming back to SiSi!

Also, you typoed "Singularity" in the thread title.


Ooops, fixed. Smile

CCP Habakuk | EVE Quality Assurance | Team Five 0 | (Team Gridlock)

Bug reporting | Mass Testing

Allandri
Liandri Industrial
Liandri Covenant
#7 - 2013-10-23 01:06:53 UTC
Is there going to be any noticeable difference in performance with an updated SQL database, and is there going to be a dev blog regarding this or is this little thread going to be it?
CCP Habakuk
C C P
C C P Alliance
#8 - 2013-10-23 11:47:26 UTC
Short update:

Singularity is currently down for the DB upgrade. The update to Rubicon will happen later (probably late afternoon, if nothing breaks).

Allandri wrote:
Is there going to be any noticeable difference in performance with an updated SQL database, and is there going to be a dev blog regarding this or is this little thread going to be it?

I don't have enough details, but I will push for a dev blog about this (probably when TQ is being upgraded).

CCP Habakuk | EVE Quality Assurance | Team Five 0 | (Team Gridlock)

Bug reporting | Mass Testing

CCP Habakuk
C C P
C C P Alliance
#9 - 2013-10-23 15:08:31 UTC
Singularity is now open, running on the new DB.

The server will go down again in a few hours for the update to Rubicon.

CCP Habakuk | EVE Quality Assurance | Team Five 0 | (Team Gridlock)

Bug reporting | Mass Testing

Jonny Copper
Patriotic Tendencies
Goonswarm Federation
#10 - 2013-10-23 15:21:08 UTC
Quick question. Does this mean anything I did between when the DB was taken and when you switch it is lost? I drop a fair bit of ihubs, and did a fair bit of hauling in between those dates. Will I need to do that all over again?
Pertuabo Enkidgan
Center for Advanced Studies
Gallente Federation
#11 - 2013-10-23 17:37:30 UTC
CCP Habakuk wrote:
Singularity is now open, running on the new DB.

The server will go down again in a few hours for the update to Rubicon.

neat
here we go!
Katabrok First
Apukaray Security
#12 - 2013-10-23 19:01:42 UTC
I would love some feedback from what did you find on the change to SQL 2012.
Divi Filus
New Xenocracy
#13 - 2013-10-23 19:17:34 UTC
Data package unavailable for the Mac launcher.
William Clarque
Free Traders
#14 - 2013-10-23 19:26:34 UTC
Any idea when the SOE ships will be added to market or LP stores?
CCP Garpr
C C P
C C P Alliance
#15 - 2013-10-23 21:24:13 UTC
Jonny Copper wrote:
Quick question. Does this mean anything I did between when the DB was taken and when you switch it is lost? I drop a fair bit of ihubs, and did a fair bit of hauling in between those dates. Will I need to do that all over again?


Not lost no. The database on the SQL 2008 instance is and will be in the same state as when we shut down Singularity for this temporary SQL 2012 test.

CCP Garpr | Senior Database Administrator

CCP Garpr
C C P
C C P Alliance
#16 - 2013-10-23 21:27:12 UTC  |  Edited by: CCP Garpr
Katabrok First wrote:
I would love some feedback from what did you find on the change to SQL 2012.


As CCP Habakuk said earlier, there will be a proper DEV (Tech) blog on this project but not until after we go live on Tranquility.
It will hopfully be filled with fancy graphs and numbers to compare. We've started gathering info to use in that blog.

CCP Garpr | Senior Database Administrator

Shivanthar
#17 - 2013-10-25 10:12:04 UTC
CCP Garpr wrote:
Katabrok First wrote:
I would love some feedback from what did you find on the change to SQL 2012.


As CCP Habakuk said earlier, there will be a proper DEV (Tech) blog on this project but not until after we go live on Tranquility.
It will hopfully be filled with fancy graphs and numbers to compare. We've started gathering info to use in that blog.


2012 has some support for new cpu instruction sets as any new release has, but also has some memory management goods behind the scenes.

Ah, almost forgetting, there is also this

_Half _the lies they tell about me **aren't **true.

CCP Habakuk
C C P
C C P Alliance
#18 - 2013-10-28 17:04:06 UTC
Singularity has been switched back to the old DB.

We are still experiencing problems with login through the launcher, but this should be fixed soon.

CCP Habakuk | EVE Quality Assurance | Team Five 0 | (Team Gridlock)

Bug reporting | Mass Testing

kogelbiefstuk
Contraband lnc
Appetite 4 Destruction.
#19 - 2013-10-28 18:22:25 UTC
yup i still get the error code
CCP Habakuk
C C P
C C P Alliance
#20 - 2013-10-28 18:33:41 UTC
CCP Habakuk wrote:
Singularity has been switched back to the old DB.

We are still experiencing problems with login through the launcher, but this should be fixed soon.

And the launcher is fixed now.

CCP Habakuk | EVE Quality Assurance | Team Five 0 | (Team Gridlock)

Bug reporting | Mass Testing