Multi slave-single master

--=-U1siJPJJzpyycG5ao/sg
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: 7bit

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




--=-U1siJPJJzpyycG5ao/sg--

Re: Multi slave-single master

As far as I know your correcct. You can set as much slave servers as you
need.

--
João Cândido de Souza Neto

"Machiel Richards" escreveu na mensagem
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 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: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

RE: Multi slave-single master

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@consultorweb.cnt.br] =

> Sent: Tuesday, February 15, 2011 4:50 AM
> To: mysql@lists.mysql.com
> 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@daevid.com
>=20


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg