From: John P. Looney (john at domain antefacto.com)
Date: Fri 14 Jun 2002 - 09:33:04 IST
On Fri, Jun 14, 2002 at 12:27:46AM +0100, Niall O Broin mentioned:
> I know there are quite a number of people here using MySQL to greater or
> lesser extents. How are you dealing with backing up the databases ?
> i) Shut down database, copy / snapshot database files, start database again.
> ii) mysqldump
> iii) mysqlhotcopy
> iv) Backing up the live files and hoping God is on your side
> v) Backups are for wimmin
vi) Have a second mysql instance, setup as a slave, which get pushed
changes as they happen, possibly on another machine. You can then take the
slave down whenever you want, and do proper backups that way. You can also
offer the slave as an option to your production software - connect to it,
if the master isn't responding.
Use replication Luke. Advanced technology designed to facilitate uptime &
-- _______________________________________ John Looney Chief Scientist a n t e f a c t o t: +353 1 8586004 www.antefacto.com f: +353 1 8586014
This archive was generated by hypermail 2.1.6 : Thu 06 Feb 2003 - 13:17:15 GMT