SEO

#1 (**permalink**) 02-28-2008, 06:05 AM

Hi,
I tried to set a replication as below.
S1(master) ---> S2 (slave), (master) --> S3 (slave)
I have set S1 and S2 (slave) without problem. However, there is a
problem in S2 as a master.
I found the the position in "show master status" also keep as 98 but I
am sure the replication from S2 to S1 works. It seems that S2 master
hasn't started yet. I have restarted the mysql and found no error in
the db log. Anyone can help?

#2 (**permalink**) 02-28-2008, 06:06 AM

In news:6fbb529e0703280127sbe43f28maf7f832af06d6d72@m ail.gmail.com,
"Rilawich Ango" <maillisting@gmail.com> wrote:

> I found the the position in "show master status" also keep as 98 but I
> am sure the replication from S2 to S1 works. It seems that S2 master
> hasn't started yet.

If by that you mean that you want the changes made on S1 to be replicated to
S2, and also through S2 to S3, then you should run MySQL on S2 with
log-slave-updates option. Otherwise it will not write into its own binary
log statements received from S1 via replication.

Maciek

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

master and slave in same machine