Hello again :)
On 4/10/06, Shawn Green <[EMAIL PROTECTED]> wrote:
>
> First rule: Do NOT share data files between server processes. Nothing
> should directly interact with a datafile other than the server to which
> it belongs. This includes other server processes as well as direct user
> actions
Shawn Green wrote:
I understand now.
You have 3 slave server processes replicating independently from their
own separate master servers. You have a fourth MySQL server process
that shares the same data files as your 3 slaves but it does not know
when replication occurs and when it hasn't (fo
--- Leonardus Setiabudi <[EMAIL PROTECTED]> wrote:
> let me re-explain my situation ..
>
> the mysql server was on /home/mysql/mysql4111
> and the data directory was on /home/mysql/mysql4111/data
> in data directory, there are 4 databases, db1, db2, db3, db4
> all configurations resided in /hom
>
> Hold on, "(it should be, its the same file)", you're saying that db2 on
> server1 and server2 are using the same database files (datadir)? If that's
> the case, why? That doesn't make any sense.
>
>
> Atle
> -
> Flying Crocodile Inc, Unix Systems Administrator
>
Im replying from another accoun
On Sat, 8 Apr 2006, Leonardus Setiabudi wrote:
> when i log into server 2 using port 3307, i can see the data in db2
> updated, which means the replication succeed (show slave status tells
> the same thing), and the same thing with server 3, i can see db3
> updated, also with server 4 where db4 up
[EMAIL PROTECTED] wrote:
Leonardus Setiabudi <[EMAIL PROTECTED]> wrote on 04/07/2006
05:33:50 AM:
> Hi All,
>
> I have a problem with my multi master replication plan.
> I have set my server (linux) to run 4 instance of mysqld, each with a
> different port, socket, tmpdir, log file, relay lo
Leonardus Setiabudi <[EMAIL PROTECTED]> wrote on 04/07/2006 05:33:50
AM:
> Hi All,
>
> I have a problem with my multi master replication plan.
> I have set my server (linux) to run 4 instance of mysqld, each with a
> different port, socket, tmpdir, log file, relay log file, master info
> and r
Hi All,
I have a problem with my multi master replication plan.
I have set my server (linux) to run 4 instance of mysqld, each with a
different port, socket, tmpdir, log file, relay log file, master info
and relay info.
the illustration as follow :
Server 1 (non slave)
db1
db2
db3
d