I don't know if this is at all possible, but I need to somehow copy in real-time to a slave MYSQL that I can access for stats, instead of risking the MYSQL database that is being used LIVE for our client.
The slave MYSQL will be linked to our website and will only be used to do functions like count and other stuff that does not need to modify the data.
The reason we don't want to give outside IP access to our internal MYSQL so instead by using a remote MYSQL server I am hoping to be able to watch a table and if modified then update the slave server with the changes.