We have a master/slave pair and a secondary slave that is our 'live backup'
and we take offline every night to rsync the tarballs to tape backup too.
When it comes online, it syncs up with master. Rinse repeat. Works awesome
> -----Original Message-----
> From: João Cândido de Souza Neto [mailto:joao@stripped]
> Sent: Tuesday, February 15, 2011 4:50 AM
> To: mysql@stripped
> Subject: Re: Multi slave-single master
> As far as I know your correcct. You can set as much slave
> servers as you
> João Cândido de Souza Neto
> "Machiel Richards" <machielr@stripped> escreveu na mensagem
> > Good day all
> > I just have a quick question in order to confirm something..
> > If I remember correctly, one master are allowed to have more
> > than one slave server (i.e. serverA can be master to both
> serverB and
> > serverC)
> > Am I correct in this matter?
> > We are busy with a migration to new hardware this
> weekend and my
> > plan is to setup the new master server as a slave to
> current production
> > master in order to get all data in sync and during
> switchover to simply
> > shutdown current production and change over to the new servers using
> > relevant configuration.
> > Regards
> > Machiel
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: