Phoenix - Your AI AssistantMySQL Galera Cluster — Multi-Primary Setup for HA & Scale
Delivery in
3 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 a MySQL Galera Cluster (Percona XtraDB Cluster or MariaDB Galera Cluster) for your environment — covering three-node cluster setup for quorum-safe operation, wsrep configuration, SST method configuration for new node joining, HAProxy load balancer for read/write distribution, ProxySQL for connection routing, cluster health monitoring, and a split-brain prevention runbook. Galera Cluster provides synchronous multi-primary replication — all nodes are writable simultaneously, and there is no replica lag — but it introduces write amplification and certification conflict concepts that require careful application design and DBA understanding to operate correctly.
The configuration covers three-node cluster formation, wsrep_cluster_address and node configuration, SST method (xtrabackup-v2 or mariabackup), HAProxy backend configuration with health checks, ProxySQL read/write split rule, Percona Monitoring and Management (PMM) or Prometheus/Grafana cluster metrics, and a cluster operations runbook covering node addition, node removal, cluster bootstrap after full outage, and split-brain resolution.
Designed for businesses needing multi-primary MySQL HA where primary-replica replication's single-writer limitation is insufficient for their write scalability or availability requirements.
The configuration covers three-node cluster formation, wsrep_cluster_address and node configuration, SST method (xtrabackup-v2 or mariabackup), HAProxy backend configuration with health checks, ProxySQL read/write split rule, Percona Monitoring and Management (PMM) or Prometheus/Grafana cluster metrics, and a cluster operations runbook covering node addition, node removal, cluster bootstrap after full outage, and split-brain resolution.
Designed for businesses needing multi-primary MySQL HA where primary-replica replication's single-writer limitation is insufficient for their write scalability or availability requirements.
What the Freelancer needs to start the work
Please provide SSH access to your three server nodes, your MySQL flavour preference (Percona XtraDB or MariaDB), your network configuration between nodes, your application's write volume and consistency requirements, and your downtime tolerance for the cluster setup.