replication
Hi, I would like to know how mySQL manage the identity (auto increment counter) in a replication environment when 2 servers are both master on the same database. Here's a sample of my problem. We have 2 servers running mySQL. Server1 replicate data on server2 and server2 replicate data on server1 for the same table on the same database. Both server are connected together. At this point, there's no problem, the two server shares the same identity and the key grows up with new record. But, now, suppose that the connection between server1 and server2 is broken (Two different site for example and the link between site goes down) during one hour or one day. On each server, people insert records because both of them continious to see the server assigned to their site. When the link go up again, and the server will begin to replicate data.How the identity created will be reassigned or affected ? Does both mySQL server had assigned the same key ? Is there some solution to manage this problem ? What are you thinking of this problem ? What are you thinking of Britney Spears ? ;o) This solution is going to be implemented in high critical environmment, with 100 percent uptime needed, that's why we want to be sure we use the better solution. Thanks for your answer. - 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
replication and auto_increment
hi, i would like to create a dual master/slave replication with mysql i think i wouldn't have any problem but i wonder how mysql manage auto_increment id ... how it works ? maxime - 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
RE: replication and auto_increment
hi, here is the problem ... think about this : serverR1 / serverR2 : replication servers serverWWW : webserver serverWWW reads/writes data from/to serverR1 serverR2 replicate serverR1 data serverR1 crashes serverWWW reads/writes data from/to serverR2 serverR1 (up) replicate serverR2 data the goal of this architecture is to prevent to lose data i don't know if it's possible with mysql (that depends of internal auto_increment id management) -Message d'origine- De : gerald_clark [mailto:[EMAIL PROTECTED]] Envoye : jeudi 19 decembre 2002 16:59 A : [EMAIL PROTECTED] Objet : Re: replication and auto_increment Do not allow inserts on both machines. Maxime LEMAIRE wrote: hi, i would like to create a dual master/slave replication with mysql i think i wouldn't have any problem but i wonder how mysql manage auto_increment id ... how it works ? maxime - 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
RE: problem with replication
hi check the master-slave replication compatibility see http://www.mysql.com/doc/en/Replication_Implementation.html maxime -Message d'origine- De : Natale Babbo [mailto:[EMAIL PROTECTED]] Envoyé : jeudi 12 décembre 2002 17:49 À : [EMAIL PROTECTED] Cc : [EMAIL PROTECTED] Objet : RE: problem with replication Hi ... i have just tried by nothing's changed! ... i mean ... now in the show slave status i can see the right master_log_filename, log_position etc. but the error persists! What's wrong? help me please! Thanks and bye --- Maxime LEMAIRE [EMAIL PROTECTED] ha scritto: hi, try this : mysql SHOW MASTER STATUS; +--++--+--+ | File | Position | Binlog_do_db | Binlog_ignore_db | +--++--+- + | some-file| XX | | | +--++--+--+ mysql CHANGE MASTER TO MASTER_HOST='host', MASTER_USER='repl', MASTER_PASSWORD='repl', MASTER_LOG_FILE='some-file', MASTER_LOG_POS=XX; then restart the slave. -Message d'origine- De : Natale Babbo [mailto:[EMAIL PROTECTED]] Envoyé : jeudi 12 décembre 2002 16:27 À : [EMAIL PROTECTED] Objet : Fwd: problem with replication Any suggestion about this error? Thanks to all. --- Natale Babbo [EMAIL PROTECTED] ha scritto: Data: Wed, 11 Dec 2002 17:03:51 +0100 (CET) Da: Natale Babbo [EMAIL PROTECTED] Oggetto: problem with replication A: [EMAIL PROTECTED] Hi all, I have a problem with replication between two servers. I created user repl on the master, I restored the master's dump on the slave, I changed both my.cnf settings but I got this error from slave .err file: MySql: ready for connections 021211 16:56:12 InnoDB: Started 021211 16:56:12 Slave I/O thread: connected to master 'repl@sviluppo01:3306', replication started in log 'FIRST' at position 4 021211 16:56:12 Error updating slave list: Query error 021211 16:56:12 Slave I/O thread exiting, read up to log 'FIRST', position 4 Master my.cnf: log-bin=/usr/local/mysql/log/MySQL-bin server-id=1 Slave My.ini: server-id=2 master-host=sviluppo01 master-user=repl master-password=repl What's wrong? Thanks in advance. __ Yahoo! Foto: salva, ritocca, condividi e ordina stampe professionali http://it.yahoo.com/mail_it/foot/?http://it.photos.yahoo.com __ Yahoo! Foto: salva, ritocca, condividi e ordina stampe professionali http://it.yahoo.com/mail_it/foot/?http://it.photos.yahoo.com - 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 - 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 __ Yahoo! Foto: salva, ritocca, condividi e ordina stampe professionali http://it.yahoo.com/mail_it/foot/?http://it.photos.yahoo.com - 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
RE: problem with replication
hi, try this : mysql SHOW MASTER STATUS; +--++--+--+ | File | Position | Binlog_do_db | Binlog_ignore_db | +--++--+- + | some-file| XX | | | +--++--+--+ mysql CHANGE MASTER TO MASTER_HOST='host', MASTER_USER='repl', MASTER_PASSWORD='repl', MASTER_LOG_FILE='some-file', MASTER_LOG_POS=XX; then restart the slave. -Message d'origine- De : Natale Babbo [mailto:[EMAIL PROTECTED]] Envoyé : jeudi 12 décembre 2002 16:27 À : [EMAIL PROTECTED] Objet : Fwd: problem with replication Any suggestion about this error? Thanks to all. --- Natale Babbo [EMAIL PROTECTED] ha scritto: Data: Wed, 11 Dec 2002 17:03:51 +0100 (CET) Da: Natale Babbo [EMAIL PROTECTED] Oggetto: problem with replication A: [EMAIL PROTECTED] Hi all, I have a problem with replication between two servers. I created user repl on the master, I restored the master's dump on the slave, I changed both my.cnf settings but I got this error from slave .err file: MySql: ready for connections 021211 16:56:12 InnoDB: Started 021211 16:56:12 Slave I/O thread: connected to master 'repl@sviluppo01:3306', replication started in log 'FIRST' at position 4 021211 16:56:12 Error updating slave list: Query error 021211 16:56:12 Slave I/O thread exiting, read up to log 'FIRST', position 4 Master my.cnf: log-bin=/usr/local/mysql/log/MySQL-bin server-id=1 Slave My.ini: server-id=2 master-host=sviluppo01 master-user=repl master-password=repl What's wrong? Thanks in advance. __ Yahoo! Foto: salva, ritocca, condividi e ordina stampe professionali http://it.yahoo.com/mail_it/foot/?http://it.photos.yahoo.com __ Yahoo! Foto: salva, ritocca, condividi e ordina stampe professionali http://it.yahoo.com/mail_it/foot/?http://it.photos.yahoo.com - 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 - 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