Database maintenance today! (finished)

Discussions about BGA (all languages)
User avatar
Een
Posts: 1936
Joined: 16 June 2010, 19:52

Database maintenance today! (finished)

Postby Een » 27 June 2018, 06:59

Image

Work in progress! EDIT: finished!

We have been preparing for some weeks to upgrade our database architecture to make it more resilient, and yesterday an electrical failure at our hosting provider proved again that it was necessary.

So today we'll be making the necessary changes, with some downtime, but that's to make the service better in the long run!

New table creation will be locked starting at 8AM CEST. You can follow up on our progress on Twitter.

User avatar
haxxorn
Posts: 2
Joined: 04 December 2015, 12:19

Re: Database maintenance today!

Postby haxxorn » 27 June 2018, 08:24

Thanks for a great service :)

User avatar
Een
Posts: 1936
Joined: 16 June 2010, 19:52

Re: Database maintenance today!

Postby Een » 27 June 2018, 14:04

haxxorn wrote:Thanks for a great service :)


Thanks for your support and your patience!

The maintenance operation is over, we gathered all the data and files and made the necessary updates to be able to setup the failover. Work continues, but in background: you can enjoy playing again! Have fun! :)

djabwana
Posts: 1
Joined: 02 April 2018, 03:55

Re: Database maintenance today! (finished)

Postby djabwana » 27 June 2018, 14:59

As a software engineer myself, I'm curious what the new database is vs. the old. Did you go from a more traditional SQL database to something different, if you don't mind sharing?

User avatar
Een
Posts: 1936
Joined: 16 June 2010, 19:52

Re: Database maintenance today! (finished)

Postby Een » 27 June 2018, 15:12

djabwana wrote:As a software engineer myself, I'm curious what the new database is vs. the old. Did you go from a more traditional SQL database to something different, if you don't mind sharing?


This maintenance consisted in a version upgrade and data preparation to setup a replicated failover database. Before, we had backups but no failover, and restoring from backups with the size of the database would have meant a really big downtime in case of a database crash.

With a replicated failover, it should be a matter of minutes. We are currently working on finishing to set it up. This will still take time, but it's a background task that should have no impact on the service.


Return to “Discussions”

Who is online

Users browsing this forum: No registered users and 2 guests