A Little Noise

February 11, 2010

Restore from mysqldump --all-databases in parallel

Filed under: MySQL — snoyes @ 3:12 pm

csplit backup.sql /"^-- Current Database"/ {*}; for f in xx*; do cat xx00 "$f" | mysql& done;

and then rm xx* when the background jobs have finished.

I haven’t done any benchmarking, and I haven’t worked out what to do if the number of databases exceeds the number of available connections.

1 Comment »

  1. It is unlikely that you want to have so many connections running that the instance would hit max_connections. I suggest reading the notes pgrestore’s -j option ( http://www.postgresql.org/docs/8.4/static/app-pgrestore.html )

    Have you considered mk-parallel-dump and mk-parallel-restore ?

    Comment by Robert Wultsch — February 11, 2010 @ 10:07 pm

RSS feed for comments on this post. TrackBack URL

Leave a comment

Powered by WordPress