Hey guys, I followed the mysql replication instructions in the mysql manual to the tee. http://www.mysql.com/doc/en/Replication_HOWTO.html However replication immediately fails. I tailed the logs and noticed that it failed on an insert query on key1, claiming "duplicate entry". Now I've read online that duplicate entry problems are often caused by autoincrement fields. The query was writing to a table that had an autoincrement index, however it was not attempting to write to the index field. I also attempted to have it skip the entry with the SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; command. This command failed. It did not fail when I eliminated the GLOBAL word in the command like so: SET SQL_SLAVE_SKIP_COUNTER=1; However, still no luck with replication. It failed on the very next insert query.
FYI: I am using Linux (Redhat 7.3), and the simplest possible replication scheme, with one master and one slave on separate machines, both using the latest stable version of mysql 3.23.54a. Any ideas? Is there a better "how to" on the web that any of you know of? Have any of you seen this issue. I really appreciate any help you have to offer. Thanks much. -Dan --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
