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

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

		Nissan 370Z Forum > 370Z Forum > Announcements
THE370Z is Moving to a New Server (starting) on July 18th!!!

LinkBack

Thread Tools

Display Modes

08-02-2011, 08:57 AM

#37 (permalink)

Isamu

A True Z Fanatic

Join Date: Jul 2010

Location: Minot ND

Posts: 51,960

Drives: every day...

Rep Power: 215

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.

__________________

Quote:

It's not an oil leak, it's sweat from all the horsepower!

黒子 ('Kuroko')
Project: SuperNova Owner/Operator and Lead designer @BlackGuard Aeroworks

Bookmarks

« Previous Thread | Next Thread »

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On Forum Rules

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

All times are GMT -5. The time now is 10:16 AM.