[ale] backup mysql

[Kevin O'Neill Stoll]

Replication != backups.

Replication will simply execute very quickly and with some
resiliency your transactions from one master to one or many
slaves (or PC, Primary and Secondaries)

Replication could be used for failover of mysql server
services but not as a verifiable backup. 

Instead, use
http://dev.mysql.com/doc/refman/5.0/en/backup-policy.html ,
you can do this while the server instance(s) are online
without much impact to the running instance, although ymmv.

HTH


--- Christopher Fowler <cfowler at outpostsentinel.com> wrote:

>
http://www.onlamp.com/pub/a/onlamp/2005/06/16/MySQLian.html
> 
> Wow, you should have been at the ALE NW meeting a few
> months back.
> 
> On Thu, 2006-12-14 at 17:42 -0500, Jim Popovitch wrote:
> > What's a good way to backup a mysql server to a second
> host, preferably
> > in real-time?
> > 
> > Tia,
> > 
> > -Jim P.
> > 
> > _______________________________________________
> > Ale mailing list
> > Ale at ale.org
> > http://www.ale.org/mailman/listinfo/ale
> 
> _______________________________________________
> Ale mailing list
> Ale at ale.org
> http://www.ale.org/mailman/listinfo/ale
> 


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com