From: Daevid Vincent Date: February 15 2011 10:33pm Subject: RE: Multi slave-single master List-Archive: http://lists.mysql.com/mysql/224418 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Absolutely true. 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 and seemless. > -----Original Message----- > From: Jo=E3o C=E2ndido de Souza Neto [mailto:joao@stripped] = > Sent: Tuesday, February 15, 2011 4:50 AM > To: mysql@stripped > Subject: Re: Multi slave-single master >=20 > As far as I know your correcct. You can set as much slave=20 > servers as you=20 > need. >=20 > --=20 > Jo=E3o C=E2ndido de Souza Neto >=20 > "Machiel Richards" escreveu na mensagem=20 > news:1297774004.1798.25.camel@machielr-laptop... > > 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=20 > serverB and > > serverC) > > > > Am I correct in this matter? > > > > We are busy with a migration to new hardware this=20 > weekend and my > > plan is to setup the new master server as a slave to=20 > current production > > master in order to get all data in sync and during=20 > switchover to simply > > shutdown current production and change over to the new servers using > > relevant configuration. > > > > Regards > > Machiel > > > > > > > >=20 >=20 >=20 >=20 > --=20 > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: =20 > http://lists.mysql.com/mysql?unsub=3Ddaevid@stripped >=20