Server Backup and Recovery Updates

Archival storage for Announcements. Peruse old Announcements here!

Moderators: Media Team, Community Team, Global Moderators

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
Colonel bigWham
Webmaster
Webmaster
 
Posts: 2154
Joined: Mon Aug 26, 2013 12:08 pm
Medals: 20
Standard Achievement (2) Doubles Achievement (1) Assassin Achievement (1) Polymorphic Achievement (1) Nuclear Spoils Achievement (1)
Fog of War Achievement (2) Trench Warfare Achievement (1) Speed Achievement (2) Random Map Achievement (1) Cross-Map Achievement (1)
Beta Map Achievement (1) Tournament Achievement (5) General 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 / 2225 points -- May15, 2014

Tournament wins:
Kuma's GC Qualifier: City Mogul
Jules Verne Contest - Team Finals
The Great Community Map Project: Tournament Five
Serbia's NFL 2013 Poly Trip
User avatar
Captain rjhankey
 
Posts: 856
Joined: Sun Jun 20, 2010 10:43 pm
Location: Portage, Michigan, USA
Medals: 52
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) Polymorphic Achievement (1) Nuclear Spoils Achievement (2)
Fog of War Achievement (4) 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 (4) 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
Private cairnswk
 
Posts: 11492
Joined: Sat Feb 03, 2007 8:32 pm
Medals: 51
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 (36) 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: 304
Joined: Sat Jun 28, 2008 2:23 pm
Location: New Jersey
Medals: 71
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 (11) 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
General drpall
 
Posts: 84
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
Private blakebowling
Administrator
Administrator
 
Posts: 5032
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
General drpall
 
Posts: 84
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
Brigadier Jippd
 
Posts: 1382
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
Major iAmCaffeine
 
Posts: 3392
Joined: Mon Apr 01, 2013 5:38 pm
Medals: 73
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 (4) Beta Map Achievement (2) Battle Royale Achievement (3) Ratings Achievement (4) Tournament Achievement (8)
General Achievement (6) Clan Achievement (4) Challenge Achievement (1) Tournament Contribution (1) General Contribution (5)


Return to Announcement Archives

Who is online

Users browsing this forum: No registered users

Login