[Fwd: Re: Replication syncronization lag.]

2004-01-15 Thread Jonathan Tullett
have any other suggestions that you may be able to offer? Ive copied the my.cnf files from the master and the slave at the bottom of this email if that may offer any clues to what else we can do. many thanks in advance for any assistance you can give. -- Jonathan Tullett my.cnf on the MASTER

Re: Replication syncronization lag.

2004-01-13 Thread Jonathan Tullett
of this email if that may offer any clues to what else we can do. many thanks in advance for any assistance you can give. -- Jonathan Tullett my.cnf on the MASTER: # Here follows entries for some specific programs [safe_mysqld] err-log = /var/log/mysql/mysql.err # The MySQL server [mysqld

Replication syncronization lag.

2004-01-08 Thread Jonathan Tullett
), even if the overhead of this check means that the servers themselves operate slightly slower? Many thanks in advance for any help/links/pointers you may be able to offer me. -- Jonathan Tullett Systems Administrator -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Replication RO/RW DBs on same server.

2003-10-22 Thread Jonathan Tullett
Hi, thank you very much for your reply! I think it's simpler than you thought. This is just the kind of response I was hoping for :) Just set up circular replication (A replicates B, B replicates A) and ensure, at the application level, that you only write on one machine for each separate

Re: Replication RO/RW DBs on same server.

2003-10-22 Thread Jonathan Tullett
Hello, I am no expert on playing around with IP addresses, but I would think this a rather dodgy option. Wouldn't connections which you appear to have open still get through, and connect to something unexpected? Dynamic DND would probably work. I cannot guarantee access to the DNS system I (or

Replication RO/RW DBs on same server.

2003-10-21 Thread Jonathan Tullett
/theory I am looking for here, once that is sorted ill work on the fail over mechanisms myself. Any help/advice/assistance you can provide will be greatly appreciated. Many thanks, Jonathan Tullett -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http