THE370Z is Moving to a New Server (starting) on July 18th!!!

houkouonchi · 08-02-2011, 08:24 AM

Quote:

Originally Posted by AK370Z

Isamu thanks for posting. But I have noticed that the downtime starts at 2 am and takes about 3 hours to complete. During this 3 hour time, forum is on and off (some section works while some sections get DB errors. Also some features work and some features doesn't). But after 3 hours when it's fully backed up, the site works perfectly. So judging by your time stamp, it looks like you got the DB error during those time (1:00 am to 4:00ish for you. CST.). Hope it makes sense. I am gonna update the downtime thread soon with new info.

thanks

AK, is there a reason why you don't convert the mysql tables to innodb (assuming they are myisam) and do mysqldump with --single-transaction to prevent the tables from being locked so you don't have the site go down during the mysqldump?

I work for a web-hosting company and our central database is over 100GB. Its not really feasible to have downtime during backup so most of our stuff is innodb. Another option is to have two mysqld's (would use more disk I/O if you don't have another server to run it on) and do mysql replication and then just run the dump on the slave.

Isamu · 08-02-2011, 08:57 AM

Quote:

Originally Posted by houkouonchi

AK, is there a reason why you don't convert the mysql tables to innodb (assuming they are myisam) and do mysqldump with --single-transaction to prevent the tables from being locked so you don't have the site go down during the mysqldump?

I work for a web-hosting company and our central database is over 100GB. Its not really feasible to have downtime during backup so most of our stuff is innodb. Another option is to have two mysqld's (would use more disk I/O if you don't have another server to run it on) and do mysql replication and then just run the dump on the slave.

houkouonchi · 08-03-2011, 07:50 AM

Quote:

Originally Posted by Isamu

I realized one of the things you lose (I believe still to be true) is full text searching which is probably needed for a few of the tables for a forum (but probably not all). If some tables can't be converted than the mysql replication should be a good option

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
LBI Caravan Part 2 - July 18th	BalanBro	North East Region	3	07-15-2010 06:16 PM
SPOCOM LONG BEACH JULY 18TH, who's GOING?	LOU@AMPLIFIED	Southern California Region	11	06-02-2010 11:40 AM
The370Z is FINALLY moved to the new server	AK370Z	Announcements	9	01-15-2010 08:46 PM
The370Z.com is moving to a new server. Expect Downtime next 24-96 hours :(	AK370Z	Announcements	2	01-05-2010 09:01 PM
Broward Meet Sat July 18th	westpak	South East Region	4	07-15-2009 09:26 PM