Checking if Replication really works

2002-01-18 Thread Henning Sprang
Hy, having Replication running now, I would like to know if there are ways to test if it all _really_ works ok. Things i know I could do: - checking that no errors occur in the logs on master and slave - testing some queries an see if the changes take effect on the master and the slave in

Re: Checking if Replication really works

2002-01-18 Thread sascha mantscheff
I'm not using replication, but for a test if it really works I would do some data manipulations on the master and afterwards a complete mysqldump of master and replica and diff the result. s.m. - Before posting, please check:

Re: Checking if Replication really works

2002-01-18 Thread Henning Sprang
sascha mantscheff wrote: I'm not using replication, but for a test if it really works I would do some data manipulations on the master and afterwards a complete mysqldump of master and replica and diff the result. ok, this is an new and interesting idea, has anyone an idea how long it

Re: Checking if Replication really works

2002-01-18 Thread sascha mantscheff
Ihre Nachricht vom Friday 18 January 2002 12:14: sascha mantscheff wrote: I'm not using replication, but for a test if it really works I would do some data manipulations on the master and afterwards a complete mysqldump of master and replica and diff the result. ok, this is an new and

Re: Checking if Replication really works

2002-01-18 Thread Henning Sprang
sascha mantscheff wrote: Ihre Nachricht vom Friday 18 January 2002 12:14: sascha mantscheff wrote: I'm not using replication, but for a test if it really works I would do some data manipulations on the master and afterwards a complete mysqldump of master and replica and diff the result. ok,

Re: Checking if Replication really works

2002-01-18 Thread Rune Sandbakken
Henning Sprang wrote: sascha mantscheff wrote: I'm not using replication, but for a test if it really works I would do some data manipulations on the master and afterwards a complete mysqldump of master and replica and diff the result. ok, this is an new and interesting idea, has

Re: Checking if Replication really works

2002-01-18 Thread sascha mantscheff
Ihre Nachricht vom Friday 18 January 2002 12:14: sascha mantscheff wrote: I'm not using replication, but for a test if it really works I would do some data manipulations on the master and afterwards a complete mysqldump of master and replica and diff the result. ok, this is an new and