Start with the basics: http://dev.mysql.com/doc/refman/5.0/en/replication-howto.html
For a bit more of a walkthrough: https://www.digitalocean.com/community/articles/how-to-set-up-master-slave-replication-in-mysql
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.
This guide whil teach how to setup live replication (database mirroring) on 2 servers for backup or other purposes. In our example situation we have this network schema (see atachment).
We need to replicate EVERY executed SQL query on server 1 to…
As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs. This Article is intended to be a resource for such a task.
The other day, I was involved …