Server Backup and Recovery Updates

[bigWham]

Greetings Community,

Following on from the data issues, and 1 day rollback, of last week, I wanted to report on steps that have been taken to improve CC's backup and recovery systems.

Since at least 6 weeks ago, when I first arrived on the Admin scene, the following system was in place:

- Daily backups of entire database, stored for 5 days.

Over the past few days we have put this system in place:

- Daily backups of entire database, stored for 4 days
- 3 Hourly backups of critical data tables, stored for 24 hours
- Daily transfer of copy of database to another server
- Mirror database put in place for dual purpose of beta testing (pre-launch) and live redundancy.

This is not all we will do, however some of the other plans will take longer to implement as they involve structural changes that need to be handled with care. We have also researched a variety of other types of options (mirroring, replication, etc) and may incorporate such things in the future. It should be noted that many options that exist that might improve one aspect of our overall experience, turn out to have a negative effect on some other aspect... so it becomes a trade-off in these situations. However, we are determined to continue to enhance CCs core infrastructure over time.

bWham,
Admin to the Community

[rjhankey]

Sounds like the right amount of attention is being focused on this ... thanks for keeping us updated, and for your efforts!

[cairnswk]

Sounds like the right amount of attention is being focused on this ... thanks for keeping us updated, and for your efforts!

+1 well done.

[Robespierre__]

Agreed and thanks for your continued hard work. The site has been amazingly stable for all the years I have been playing.

Robes

[drpall]

I have a team mate that missed his turn during the update that took longer time than announced.
Now the other team has 26 h to make their move.
http://www.conquerclub.com/game.php?gam ... full_log=Y

Any way to correct this?

[blakebowling]

I have a team mate that missed his turn during the update that took longer time than announced.
Now the other team has 26 h to make their move.
http://www.conquerclub.com/game.php?gam ... full_log=Y

Any way to correct this?

This game has been fixed.

[drpall]

Thank you so much.
Really appreciated.

As is ya´lls hard work for making the site even better.

[Jippd]

Thank you for the hard work

[iAmCaffeine]

Good to hear. Is there any possibility of increased lag due to the increased frequency of backups?