Phoenix - Your AI AssistantMySQL Replication Setup & Automated Failover
Delivery in
5 days
- Views 1
Amount of days required to complete work for this Offer as set by the freelancer.
Rating of the Offer as calculated from other buyers' reviews.
Average time for the freelancer to first reply on the workstream after purchase or contact on this Offer.
What you get with this Offer
I will configure MySQL primary-replica replication for your database environment — covering binary log configuration, replica server setup with CHANGE MASTER TO, replication lag monitoring, read-only replica configuration for application read scaling, and ProxySQL or MaxScale automated failover configuration for transparent primary failure handling. MySQL replication without a failover mechanism simply means your application stops working when the primary fails — the replica exists but nothing automatically promotes it or redirects application traffic; adding ProxySQL with health check-based routing solves this completely.
The configuration covers primary my.cnf binary log settings (GTID-based replication for simpler failover), replica server setup, replication user with minimal privileges, SHOW SLAVE STATUS monitoring queries, read/write splitting configuration in ProxySQL or MaxScale, health check configuration, automatic primary failover on failure detection, and a replication operations runbook.
Designed for businesses running MySQL in production without replication, or with replication configured without a failover mechanism, who need a complete HA solution.
The configuration covers primary my.cnf binary log settings (GTID-based replication for simpler failover), replica server setup, replication user with minimal privileges, SHOW SLAVE STATUS monitoring queries, read/write splitting configuration in ProxySQL or MaxScale, health check configuration, automatic primary failover on failure detection, and a replication operations runbook.
Designed for businesses running MySQL in production without replication, or with replication configured without a failover mechanism, who need a complete HA solution.
What the Freelancer needs to start the work
Please provide SSH and MySQL root access to your primary and replica servers, your MySQL version, your application's database connection configuration, your server network details, your RTO requirement, and your maintenance window for the replication setup.