I would strongly recommend proving that your solution will work acceptably
by testing it first; don't just assume that all will go well or that we can
anticipate all the problems sight unseen.
Make small test copies of your databases first and then try doing backups
and restores to verify that your procedures work acceptably. Then, when that
is satisfactory, clone the full databases and try the procedures again to be
sure that the performance/downtime is acceptable for your environment. If it
isn't modify your procedures and do the whole cycle again.
Rhino
----- Original Message -----
From: "Sp.Raja" <[EMAIL PROTECTED]>
To: "mysql" <[EMAIL PROTECTED]>
Sent: Friday, April 02, 2004 10:28 AM
Subject: Backup/Restore Procedures
Hi List,
I use 3 databases Current, Persistent-1 and Persistent-2. I would like to
take backups of Current as when and required and restore them as desired
without affecting Persistent-1 and Persistent-2.
Initially thought of using mysqldump for this, but was worried about the
performance (I use huge DBs). So have come up with the following procedure,
When using single tablespace (4.0.15a)
Backup process is
use innobackup/ibbackup
or bring mysqld down and copy all data dir files
Restore process is
Take mysqldump of Persistent-1 and Persistent-2
Do Restore following either of the two approach
For each table discard old tablespace, copy the backup file, import new
tablespace
or bring down MySQL and copy files
Destroy Persistent-1 and Persistent-2
Run sql files of Persistent-1 and Persistent-2
When using per table tablespace (4.1.1 alpha)
Backup process is
use innobackup/ibbackup or
bring mysqld down and copy all files in data/Current
Restore process is
Do Restore following either of the two approach
For each table discard old tablespace, copy the backup file, import new
tablespace
or bring down MySQL and copy files
Do you expect any issues in the above method?
Are there any other efficient, minimum downtime (zero is desirable) method
to do the same?
Please mail me your view, to help me out.
Thanks,
Sp.Raja
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
