Re: Replication setup hep
if the server is offline , what kind of operation happens on it. On Thu, Aug 2, 2012 at 11:31 AM, Pothanaboyina Trimurthy skd.trimur...@gmail.com wrote: Hi everyone i have 4 mysql servers out of those one server will be online always and the remaining will be offline and online. the operations takes place at the offline servers i want to replicate the data from the offline servers to the online server. for this can any one help me which kind of replication suits for this kind of situation. thanks in advance -- 3murthy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
RE: Replication setup hep
1 Master replicationg to 3 Slaves. You can use any of the Slaves for readonly (online), or you can not use them (offline). All writes go to the Master. It will be online for writes, and optionally online for reads. -Original Message- From: Ananda Kumar [mailto:anan...@gmail.com] Sent: Wednesday, August 01, 2012 11:20 PM To: Pothanaboyina Trimurthy Cc: mysql Subject: Re: Replication setup hep if the server is offline , what kind of operation happens on it. On Thu, Aug 2, 2012 at 11:31 AM, Pothanaboyina Trimurthy skd.trimur...@gmail.com wrote: Hi everyone i have 4 mysql servers out of those one server will be online always and the remaining will be offline and online. the operations takes place at the offline servers i want to replicate the data from the offline servers to the online server. for this can any one help me which kind of replication suits for this kind of situation. thanks in advance -- 3murthy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
RE: replication setup
You need to GRANT the appropriate privs-for the slave in question to replicate from the master on the master. Look up Grant on mysql.com - Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc. - http://friendfinder.com/go/p40688 ---Original Message- --From: Ilia Kantor [mailto:[EMAIL PROTECTED] --Sent: Sunday, November 02, 2003 1:11 PM --To: [EMAIL PROTECTED] --Subject: replication setup -- --Hello, -- --I'm not so newbie to mysql yet have troubles setting up the --replication.. Could you advise a way out ? -- --I set up slave, master and rerun them. -- --But when I type -- --LOAD DATA FROM MASTER --on slave server - I see -- --ERROR 1218: Error connecting to master: Access denied for user: --'[EMAIL PROTECTED]' (Using password: YES) -- --How can that happen? -- --mysql --host=.. --port=.. -u.. -p --connects quite well. -- -- -- -- -- --Best regards, -- Ilia mailto:[EMAIL PROTECTED] -- -- --MySQL General Mailing List --For list archives: http://lists.mysql.com/mysql --To unsubscribe: --http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: replication setup
I've set up replication with a master and two slaves, all running 3.23.43, and it works like a charm. Except for... When the master goes down, the slave tries to reconnect after 60 seconds, but just once. That shouldn't be. I have the same problem here with the same version! I expected it to retry until it can connect, because when the master comes up again, it should catch up on updates and everything would work like it should. That should be. But when the master goes down for a period exceeding 60 seconds (well, the timeout interval), the slave thread exits and never tries to start replicating again, unless I manually do a SLAVE START on all the slaves. Is there a way to make a slave hammer the master indefinitely, until it can connect? I've read the manual several times, and found no clue... What does the slave's error log say? Can we see replication items listed in the slave's my.cnf file? error log: 011104 11:02:34 Error reading packet from server: Lost connection to MySQL server during query (read_errno 22,server_errno=2013) 011104 11:02:34 Slave: Failed reading log event, reconnecting to retry, log 'db2-bin.001' position 51733535 011104 11:03:04 Slave thread: error re-connecting to master: Lost connection to MySQL server during query, last_errno=2013, retry in 60 sec 011104 11:04:04 Slave thread killed during or after a reconnect done to recover from failed read 011104 11:04:04 Slave thread exiting, replication stopped in log 'db2-bin.001' at position 51733535 my.cnf : [mysqld] port= 3306 socket = /tmp/mysql.sock skip-locking set-variable= key_buffer=16K set-variable= max_allowed_packet=1M set-variable= thread_stack=64K set-variable= table_cache=4 set-variable= sort_buffer=64K set-variable= net_buffer_length=2K server-id = 2 master-host = db2.sayhi.net master-user = don't tell master-password = don't tell master-port = 3306 Any hint? Arne - 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 setup
On Thu, Nov 15, 2001 at 09:32:56AM +0100, Jure Koren wrote: Hello! I've set up replication with a master and two slaves, all running 3.23.43, and it works like a charm. Except for... When the master goes down, the slave tries to reconnect after 60 seconds, but just once. That shouldn't be. I expected it to retry until it can connect, because when the master comes up again, it should catch up on updates and everything would work like it should. That should be. But when the master goes down for a period exceeding 60 seconds (well, the timeout interval), the slave thread exits and never tries to start replicating again, unless I manually do a SLAVE START on all the slaves. Is there a way to make a slave hammer the master indefinitely, until it can connect? I've read the manual several times, and found no clue... What does the slave's error log say? Can we see replication items listed in the slave's my.cnf file? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 71 days, processed 1,555,429,044 queries (253/sec. avg) - 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