garutilorenzo/heartbeat repository overview

⁠MySQL HA with ProxySQL Percona Heartbeat and Orchestrator

Basic MySQL HA environment, for advanced and custom configurations see:

• ProxySQL⁠ - High performance, high availability, protocol aware proxy for MySQL
• Heartbeat⁠ - Monitor MySQL replication delay
• Orchestrator⁠ - MySQL high availability and replication management tool

⁠Notes about environment

• MySQL replication is setup with GTID⁠

⁠Setting up environment

Start environment with

docker-compose build
docker-compose up -d

⁠Show cluster status

ProxySQL

Via console:

docker-compose exec proxyqsl bash
root@proxysql:/#  mysql -u admin -pproxysql -h 127.0.0.1 -P6032
select * from stats_mysql_connection_pool;

Orchestrator

Via web Browser:

http://localhost:3000⁠

Heartbeat

Via console:

docker-compose exec proxyqsl bash
root@proxysql:/# mysql -u super -Ap -h 127.0.0.1 -P3306
Enter password:
select * from percona.heartbeat;

⁠Clean all data

docker-compose down -v