Re: Refresh slave state

2015-06-25 Thread Ben RUBSON
2015-06-25 14:02 GMT+02:00 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 5.6 for these test

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 is

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 wrote: > Yep, as shown below: > > root@audit-db.ec2:(none)> select fark from fark from fark fark fark from >