Server Backup and Recovery Updates

Archival storage for Announcements. Peruse old Announcements here!

Moderators: Community Team, Global Moderators, Media Team

Forum rules
Please read the Community Guidelines before posting.

Server Backup and Recovery Updates

Postby bigWham on Wed Oct 09, 2013 5:24 pm

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
Major bigWham
Webmaster
Webmaster
 
Posts: 1718
Joined: Mon Aug 26, 2013 12:08 pm
Medals: 11
Standard Achievement (2) Assassin Achievement (1) Polymorphic Achievement (1) Fog of War Achievement (2) Trench Warfare Achievement (1)
Speed Achievement (1) Random Map Achievement (1) Beta Map Achievement (1) Tournament Achievement (1)

Re: Server Backup and Recovery Updates

Postby rjhankey on Thu Oct 10, 2013 9:27 am

Sounds like the right amount of attention is being focused on this ... thanks for keeping us updated, and for your efforts!
Highest rank/rating -- Major / 2220 points -- Oct 22, 2012

Tournament wins:
Kuma's GC Qualifier: City Mogul
Jules Verne Contest - Team Finals
The Great Community Map Project: Tournament Five


Image
User avatar
Captain rjhankey
 
Posts: 836
Joined: Sun Jun 20, 2010 10:43 pm
Location: Portage, Michigan, USA
Medals: 49
Standard Achievement (3) Doubles Achievement (2) Triples Achievement (2) Quadruples Achievement (2) Terminator Achievement (2)
Assassin Achievement (2) Manual Troops Achievement (2) Freestyle Achievement (1) Nuclear Spoils Achievement (2) Fog of War Achievement (3)
Trench Warfare Achievement (2) Teammate Achievement (1) Random Map Achievement (2) Cross-Map Achievement (3) Beta Map Achievement (1)
Battle Royale Achievement (1) Ratings Achievement (4) Tournament Achievement (3) General Achievement (5) Clan Achievement (1)
Training Achievement (1) Tournament Contribution (4)

Re: Server Backup and Recovery Updates

Postby cairnswk on Thu Oct 10, 2013 3:20 pm

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

+1 well done. :)
User avatar
Corporal cairnswk
 
Posts: 11490
Joined: Sat Feb 03, 2007 8:32 pm
Medals: 50
Standard Achievement (2) Doubles Achievement (1) Fog of War Achievement (1) Speed Achievement (1) Teammate Achievement (1)
Cross-Map Achievement (1) Ratings Achievement (3) General Achievement (2) Map Contribution (35) General Contribution (3)

Re: Server Backup and Recovery Updates

Postby Robespierre__ on Thu Oct 10, 2013 4:49 pm

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

Robes
User avatar
Colonel Robespierre__
 
Posts: 291
Joined: Sat Jun 28, 2008 2:23 pm
Location: New Jersey
Medals: 70
Standard Achievement (3) Doubles Achievement (3) Triples Achievement (3) Quadruples Achievement (3) Terminator Achievement (2)
Assassin Achievement (1) Manual Troops Achievement (2) Freestyle Achievement (1) Nuclear Spoils Achievement (2) Fog of War Achievement (4)
Trench Warfare Achievement (2) Teammate Achievement (2) Random Map Achievement (3) Cross-Map Achievement (3) Beta Map Achievement (1)
Ratings Achievement (4) Tournament Achievement (17) General Achievement (3) Clan Achievement (10) Tournament Contribution (1)

Re: Server Backup and Recovery Updates

Postby drpall on Thu Oct 10, 2013 9:18 pm

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?
Image
User avatar
Brigadier drpall
 
Posts: 65
Joined: Tue Mar 01, 2011 3:51 pm
Medals: 25
Standard Achievement (3) Doubles Achievement (2) Triples Achievement (2) Quadruples Achievement (2) Manual Troops Achievement (1)
Polymorphic Achievement (1) Fog of War Achievement (3) Trench Warfare Achievement (1) Speed Achievement (3) Teammate Achievement (1)
Random Map Achievement (1) Cross-Map Achievement (1) Ratings Achievement (2) Clan Achievement (2)

Re: Server Backup and Recovery Updates

Postby blakebowling on Thu Oct 10, 2013 9:28 pm

drpall wrote: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.
12:39:59 AM rdsrds2120: sorry, I had a lot of lasagna tonight
12:40:06 AM rdsrds2120: I'm pretty out of it. CRAAZZYYY NIGHT
12:31:04 * Metsfanmax quit (kicked from Social by Metsfanmax - reason: haha gotcha now)
12:59:32 * #1_stunna gropes blakebowling
Cadet blakebowling
Operations Manager
Operations Manager
 
Posts: 4998
Joined: Wed Jan 23, 2008 12:09 pm
Location: 127.0.0.1
Medals: 41
Standard Achievement (3) Doubles Achievement (1) Triples Achievement (1) Quadruples Achievement (1) Terminator Achievement (1)
Assassin Achievement (2) Manual Troops Achievement (1) Freestyle Achievement (3) Fog of War Achievement (3) Speed Achievement (3)
Teammate Achievement (1) Random Map Achievement (1) Ratings Achievement (3) Tournament Achievement (1) General Achievement (3)
Tournament Contribution (3) General Contribution (10)

Re: Server Backup and Recovery Updates

Postby drpall on Thu Oct 10, 2013 9:31 pm

=D> =D> =D> =D>
Thank you so much.
Really appreciated.

As is ya´lls hard work for making the site even better.
Image
User avatar
Brigadier drpall
 
Posts: 65
Joined: Tue Mar 01, 2011 3:51 pm
Medals: 25
Standard Achievement (3) Doubles Achievement (2) Triples Achievement (2) Quadruples Achievement (2) Manual Troops Achievement (1)
Polymorphic Achievement (1) Fog of War Achievement (3) Trench Warfare Achievement (1) Speed Achievement (3) Teammate Achievement (1)
Random Map Achievement (1) Cross-Map Achievement (1) Ratings Achievement (2) Clan Achievement (2)

Re: Server Backup and Recovery Updates

Postby Jippd on Mon Oct 14, 2013 10:58 am

Thank you for the hard work
Image
User avatar
Colonel Jippd
 
Posts: 1373
Joined: Sun Aug 03, 2008 9:05 pm
Medals: 102
Standard Achievement (4) Doubles Achievement (3) Triples Achievement (3) Quadruples Achievement (3) Terminator Achievement (2)
Assassin Achievement (2) Manual Troops Achievement (3) Freestyle Achievement (2) Polymorphic Achievement (1) Nuclear Spoils Achievement (3)
Fog of War Achievement (4) Trench Warfare Achievement (3) Speed Achievement (4) Teammate Achievement (2) Random Map Achievement (3)
Cross-Map Achievement (4) Beta Map Achievement (1) Bot Achievement (1) Ratings Achievement (4) Tournament Achievement (15)
General Achievement (6) Clan Achievement (17) Challenge Achievement (1) Tournament Contribution (11)

Re: Server Backup and Recovery Updates

Postby iAmCaffeine on Mon Oct 14, 2013 10:58 am

Good to hear. Is there any possibility of increased lag due to the increased frequency of backups?
Image
User avatar
Captain iAmCaffeine
 
Posts: 2622
Joined: Mon Apr 01, 2013 5:38 pm
Medals: 63
Standard Achievement (3) Doubles Achievement (3) Triples Achievement (2) Quadruples Achievement (2) Terminator Achievement (2)
Assassin Achievement (1) Manual Troops Achievement (2) Freestyle Achievement (2) Polymorphic Achievement (2) Nuclear Spoils Achievement (2)
Fog of War Achievement (4) Trench Warfare Achievement (3) Speed Achievement (2) Teammate Achievement (2) Random Map Achievement (3)
Cross-Map Achievement (3) Beta Map Achievement (2) Battle Royale Achievement (3) Ratings Achievement (4) Tournament Achievement (6)
General Achievement (5) Clan Achievement (3) General Contribution (2)


Return to Announcement Archives

Who is online

Users browsing this forum: No registered users and 1 guest

Login