Re: synchronisation (replication)

2001-08-20 Thread Jeremy Zawodny
On Thu, Aug 16, 2001 at 12:20:07PM +, Neil Tompkins wrote: > Hello > > Below is a message I posted earlier. But what I'm really looking > for is does MySQL provide synchrosisation of data. If so, can > someone point me in the right direction Yes it does. It is described in the Replication

RE: synchronisation (replication)

2001-08-16 Thread Robinson, Mike
It seems certainly possible to automate 2 mysql servers in circular replication, each being master/slave to the other, provided your code is written in such a way to circumvent the auto_increment issue. Generating unique ids on a machine basis and using those values instead of an autoincrement wou

RE: synchronisation (replication)

2001-08-16 Thread Simon Green
Hi Neal All that replication douse is use the master database logs to update an identical database (slave). All you should need to do is make shore both databases are the same. Make changes to both the my.cnf file and restart the mysqld... Hope this helps Simon -Original Message- From:

Re: synchronisation (replication)

2001-08-16 Thread Werner Stuerenburg
Neil Tompkins schrieb am Donnerstag, 16. August 2001, 14:20:07: > Below is a message I posted earlier. But what I'm really looking for is > does MySQL provide synchrosisation of data. If so, can someone point me in > the right direction Well, I'll give it another try. The answer is Yes and