You may want to dig into some of the Wordpress plugins (10, 20, 30
million WP blogs now?) that automate backing up mysql dbs Probably
some tight code in there. Maybe a tip or 2 buried within on how they
tackle it.
Google, our great overloard, will turn up a few I suspect. ;-)
Sent from my iPhone
On Feb 20, 2010, at 7:42 PM, Konstantin K <[email protected]> wrote:
Hi guys,
I've been reading Maatkit documentation, High Performance MySQL 2nd
Edition, and googling to try to learn what my options are in terms of
backing up and recovery of MySQL.
For our database layer, we will be launching with several physical
machines, each of which will have MySQL 5.1, RAID-10 (hardware), NO
LVM, and will have about 1000 database shards, with all tables using
the INNODB engine.
In the documentation for mk-parallel-dump (http://www.maatkit.org/doc/
mk-parallel-dump.html), it says:
"...mk-parallel-dump is not a backup program! It is only designed
for
fast data exports, for purposes such as quickly loading data into test
systems. Do not use mk-parallel-dump for backups..."
But in the book, it seems to point that mk-parallel-dump can be used
as a backup solution.
So my questions are:
1. Can mk-parallel-dump be used to backup the innodb databases?
2. Is it recommended to use innodb_file_per_table option?
3. What do you recommend for specific documentation, methodologies,
techniques for raw and logical backups?
Thanks,
Konstantin
_______________________________________________
New York PHP Community MySQL SIG
http://lists.nyphp.org/mailman/listinfo/mysql
NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php
_______________________________________________
New York PHP Community MySQL SIG
http://lists.nyphp.org/mailman/listinfo/mysql
NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php
