Re: Refresh slave state

2015-06-25 Thread Ben RUBSON
2015-06-25 14:02 GMT+02:00 wagnerbianchi.com m...@wagnerbianchi.com: Some additional information here, just my 2 cents. (...) Just checking in: using two servers in replication, idle servers, on the slave side I configured globally the slave_net_timeout=1 and log_warnings=2, as I'm using

Re: server-side logging of query errors?

2015-06-25 Thread Andrew Moore
Further more, use logstash to collect the audit events and you can filter out anything that wasn't an error and move it to a query error log. On Wed, Jun 24, 2015 at 5:32 PM, Singer Wang w...@singerwang.com wrote: Yep, as shown below: root@audit-db.ec2:(none) select fark from fark from fark

Re: Refresh slave state

2015-06-25 Thread wagnerbianchi.com
Some additional information here, just my 2 cents. The system variables slave_net_timeout will controls over the time the slave server will be waiting for new data dumped form master's binlog. If no interaction or inactivity is greater than slave_net_timeout, the reconnection will be made. Here