Re: MySQL Master Master Replication and data loss
Dear Suresh, Thank you. In MySQL Replication, as the slave itself takes the writes from master but in how much time period does slave goes to master. is there any parameter where I can set this. that after every 60 seconds slave should write data from master to its own local database. -- Regards, Manasi Save Quoting Suresh Kuna sureshkumar...@gmail.com: Hi Manasi, As both are implemented by replication, there is a possibility for loosing data. Thanks Suresh Kuna MySQL DBA On Wed, Jan 13, 2010 at 8:20 PM, Manasi Save manasi.s...@artificialmachines.com wrote: Hi All, I want to implement MySQL Master Master Replication. But I have read in the various documentation that in mysql replication it is possible that I loose data. Is it also applicable to MySQL Master Master Replication. Thanks in advance. -- Regards, Manasi Save -- Thanks Suresh Kuna MySQL DBA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: MySQL Master Master Replication and data loss
Hi Manasi, Inside MySQL, there are no such parameters and the Slave delay depends on different things like network between Master and Slave, load of the MySQLD server etc... To make the slave behind for a particular period of time, use mk-slave-delay tool from the the maakit. It help your slave to be lack for a particular period of time. On Thu, Jan 14, 2010 at 2:11 PM, Manasi Save manasi.s...@artificialmachines.com wrote: Dear Suresh, Thank you. In MySQL Replication, as the slave itself takes the writes from master but in how much time period does slave goes to master. is there any parameter where I can set this. that after every 60 seconds slave should write data from master to its own local database. -- Regards, Manasi Save Quoting Suresh Kuna sureshkumar...@gmail.com: Hi Manasi, As both are implemented by replication, there is a possibility for loosing data. Thanks Suresh Kuna MySQL DBA On Wed, Jan 13, 2010 at 8:20 PM, Manasi Save manasi.s...@artificialmachines.com wrote: Hi All, I want to implement MySQL Master Master Replication. But I have read in the various documentation that in mysql replication it is possible that I loose data. Is it also applicable to MySQL Master Master Replication. Thanks in advance. -- Regards, Manasi Save -- Thanks Suresh Kuna MySQL DBA -- Thanks Suresh Kuna MySQL DBA
MySQL Master Master Replication and data loss
Hi All,I want to implement MySQL Master Master Replication. But I have read in the various documentation that in mysql replication it is possible that I loose data.Is it also applicable to MySQL Master Master Replication. Thanks in advance.--Regards, Manasi Save
Re: MySQL Master Master Replication and data loss
Hi Manasi, As both are implemented by replication, there is a possibility for loosing data. Thanks Suresh Kuna MySQL DBA On Wed, Jan 13, 2010 at 8:20 PM, Manasi Save manasi.s...@artificialmachines.com wrote: Hi All, I want to implement MySQL Master Master Replication. But I have read in the various documentation that in mysql replication it is possible that I loose data. Is it also applicable to MySQL Master Master Replication. Thanks in advance. -- Regards, Manasi Save -- Thanks Suresh Kuna MySQL DBA
MySQL MASTER/MASTER REPLICATION
In my RHEL5, I am using this link to create MySQL replication an did work the first time I did it: http://crazytoon.com/2008/02/29/mysql-how-do-you-set-up-mastermaster-replication-in-mysql-centos-rhel-fedora/ I change the ip address and the hostname and it is not working now. My new ip is 10.100.1.170 and my hostname is wahoo1. The other ip address in my master/master replication is 10.100.1.171 and wahoo2 *This is what wahoo1 my.cnf looks like*: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock old_passwords=1 auto_increment_increment=2 auto_increment_offset=1 relay-log=wahoo1-relay-bin log-bin=wahoo1-bin binlog-ignore-db=mysql binlog-ignore-db=test server-id = 1 master-host = 10.100.1.171 master-user = slaveuser master-password = slavepw master-port = 3306 [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid *This is what wahoo2 my.cnf looks like:* [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock old_passwords=1 auto_increment_increment=2 auto_increment_offset=2 relay-log=wahoo2-relay-bin log-bin=wahoo2-bin binlog-ignore-db=mysql binlog-ignore-db=test server-id = 2 master-host = 10.100.1.170 master-user = slaveuser master-password = slavepw master-port = 3306 [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid *This is the error I get on my mysqld.log file*: 080401 15:15:07 [Note] Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log './wahoo2-relay-bin.02' position: 98 080401 15:15:07 [ERROR] Slave I/O thread: error connecting to master ' [EMAIL PROTECTED]:3306': Error: 'Lost connection to MySQL server during query' errno: 2013 retry-time: 60 retries: 86400 HELP! Thanks, Néstor :-)
Re: MySQL MASTER/MASTER REPLICATION
is your mysql running on the master host i,e 10.100.1.170 Also can you please execute show status on that host to see how long the server is up, may be the server is restarted and your slave is retrying on the same old connection HTH, -srini Néstor wrote: In my RHEL5, I am using this link to create MySQL replication an did work the first time I did it: http://crazytoon.com/2008/02/29/mysql-how-do-you-set-up-mastermaster-replication-in-mysql-centos-rhel-fedora/ I change the ip address and the hostname and it is not working now. My new ip is 10.100.1.170 and my hostname is wahoo1. The other ip address in my master/master replication is 10.100.1.171 and wahoo2 *This is what wahoo1 my.cnf looks like*: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock old_passwords=1 auto_increment_increment=2 auto_increment_offset=1 relay-log=wahoo1-relay-bin log-bin=wahoo1-bin binlog-ignore-db=mysql binlog-ignore-db=test server-id = 1 master-host = 10.100.1.171 master-user = slaveuser master-password = slavepw master-port = 3306 [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid *This is what wahoo2 my.cnf looks like:* [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock old_passwords=1 auto_increment_increment=2 auto_increment_offset=2 relay-log=wahoo2-relay-bin log-bin=wahoo2-bin binlog-ignore-db=mysql binlog-ignore-db=test server-id = 2 master-host = 10.100.1.170 master-user = slaveuser master-password = slavepw master-port = 3306 [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid *This is the error I get on my mysqld.log file*: 080401 15:15:07 [Note] Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log './wahoo2-relay-bin.02' position: 98 080401 15:15:07 [ERROR] Slave I/O thread: error connecting to master ' [EMAIL PROTECTED]:3306': Error: 'Lost connection to MySQL server during query' errno: 2013 retry-time: 60 retries: 86400 HELP! Thanks, Néstor :-) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL MASTER/MASTER REPLICATION
YEs, both of MySQL are running on each system. Show status display a big long list of items, any specific? uptime is 3239 on 10.100.1.170 uptime is 3353 on 10.100.1.171 Thanks, Néstor :-) On Tue, Apr 1, 2008 at 3:46 PM, Srini [EMAIL PROTECTED] wrote: is your mysql running on the master host i,e 10.100.1.170 Also can you please execute show status on that host to see how long the server is up, may be the server is restarted and your slave is retrying on the same old connection HTH, -srini Néstor wrote: In my RHEL5, I am using this link to create MySQL replication an did work the first time I did it: http://crazytoon.com/2008/02/29/mysql-how-do-you-set-up-mastermaster-replication-in-mysql-centos-rhel-fedora/ I change the ip address and the hostname and it is not working now. My new ip is 10.100.1.170 and my hostname is wahoo1. The other ip address in my master/master replication is 10.100.1.171 and wahoo2 *This is what wahoo1 my.cnf looks like*: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock old_passwords=1 auto_increment_increment=2 auto_increment_offset=1 relay-log=wahoo1-relay-bin log-bin=wahoo1-bin binlog-ignore-db=mysql binlog-ignore-db=test server-id = 1 master-host = 10.100.1.171 master-user = slaveuser master-password = slavepw master-port = 3306 [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid *This is what wahoo2 my.cnf looks like:* [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock old_passwords=1 auto_increment_increment=2 auto_increment_offset=2 relay-log=wahoo2-relay-bin log-bin=wahoo2-bin binlog-ignore-db=mysql binlog-ignore-db=test server-id = 2 master-host = 10.100.1.170 master-user = slaveuser master-password = slavepw master-port = 3306 [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid *This is the error I get on my mysqld.log file*: 080401 15:15:07 [Note] Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log './wahoo2-relay-bin.02' position: 98 080401 15:15:07 [ERROR] Slave I/O thread: error connecting to master ' [EMAIL PROTECTED]:3306': Error: 'Lost connection to MySQL server during query' errno: 2013 retry-time: 60 retries: 86400 HELP! Thanks, Néstor :-)
Re: MySQL master-master replication on windows platform information wanted
At 12:01 PM 11/27/2007, you wrote: Who has experience with setting up master-master replication with MySQL between two Windows-servers. I would like to try setting it up and am looking for experiences, tips an possibly a hands-on manual. Arno Bouwman. Arno, The search engine is your friend. :) Online Tutorials: http://www.google.ca/search?hl=enq=mysql+replication+tutorialbtnG=Google+Searchmeta= Books on MySQL Replication: http://www.google.ca/search?hl=enq=site%3Awww.amazon.com+mysql+replicationbtnG=Searchmeta= Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]