On 11/30/2016 11:57 AM, Patrick B
wrote:
you would insert that data into a table on the MASTER, as the slave can't be written directly to. I would configure the slave to allow the master to connect to it for monitoring purposes, then on the master, run a monitoring script that looks something like... connect to master as mdb
I've left out error handling, of course. and thats pseudocode, I'd probably use perl, but python, php, java, even C++ could be used for this, pretty much any language that can connect to the database and do queries. I would NOT do this in a shell script as each interation would involve multiple forks.
-- john r pierce, recycling bits in santa cruz |