[ale] MySQL sync

Chuck Huber chuck at cehuber.org
Fri Feb 21 11:28:10 EST 2003


On Fri, Feb 21, 2003 at 06:57:04AM -0800, Martha Armour wrote:
> One note about inserting records into the slave is
> if you have an auto-increment field and create a
> record
> with let's say "302", and the master then sends over
> its newly created "302", replication will break.

Excellent point that I failed to mention.  Now that you bring it
up, I vaguely recall reading something about that.  Perhaps it
was mentioned in the MySQL docs.

Enjoy,
    - Chuck

-- 
"The purpose of encryption is to protect good people
from bad people, not to protect bad people from the government."
     Scott McNealy, CEO Sun Microsystems
"The best way for government to control people is to remain in
   a constant threat of war." ---Karl Marx
"They that can give up essential liberty to obtain a little temporary
   safety deserve neither liberty nor safety." -- Benjamin Franklin

 PGP signature




More information about the Ale mailing list