[Fwd: Re: Replication syncronization lag.]

2004-01-15 Thread Jonathan Tullett
give us quite a performance increase. Do you 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 g

Re: Replication syncronization lag.

2004-01-13 Thread Jonathan Tullett
s 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: # Here follows entries for some specific programs [safe_mysqld] err-log = /var/l

Replication syncronization lag.

2004-01-08 Thread Jonathan Tullett
sync), 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/mys

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 rat

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 dat

Replication RO/RW DBs on same server.

2003-10-21 Thread Jonathan Tullett
thought? It is purely the setup config/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