MySQL Forums
Forum List  »  General

Rrunning mutliple mysql dump on single instance
Posted by: venkat mysql
Date: January 30, 2014 09:13AM

I have a requirement of running 5 mysql dump export in parallel using perl script from single MySQL instance. Dump works fine and import data are also intact.

But however my concern is will this multiple dump query cause any corruption/damage on current mysql instance beocz this MySQL insatnce has huge data.

ibdata1 = 500GB, single database with 14 tables.
each having 200M rows.

mydump query is below,

mysqldump --port=3306 --host=localhost --user=root --password=vembu --quick --skip-comments database_name table1 table2 table3 table4 ...... table14 --where "CUSTOMER_ID='1' and CLIENT_NAME='test' and BACKUP_NAME='test'" > /mnt/test.sql

This will give me single sql file containg all 14tables. So I would be running 4x250 where thread=4 and dump query=250.

would that be fine ? Anyone any suggestions ?

Options: ReplyQuote


Subject
Written By
Posted
Rrunning mutliple mysql dump on single instance
January 30, 2014 09:13AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.