mysql-ha-docker

KO | EN

gitlite — search

#javascript #python #ai #typescript #llm #golang #linux #macos #java #awesome #cli #kubernetes #pytorch #openai

mysql-ha-docker

(★ 20)

Basic MySQL HA environment build with ProxySQL, Percona Heartbeat and Orchestrator

mysql-ha-docker Latest Version Download

Download Latest Version (.zip)

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

[![GitHub issues](https://img.shields.io/github/issues/garutilorenzo/mysql-ha-docker)](https://github.com/garutilorenzo/mysql-ha-docker/issues)
[![MySQL HA CI](https://github.com/garutilorenzo/mysql-ha-docker/actions/workflows/ci.yml/badge.svg)](https://github.com/garutilorenzo/mysql-ha-docker/actions/workflows/ci.yml)
![GitHub](https://img.shields.io/github/license/garutilorenzo/mysql-ha-docker)
[![GitHub forks](https://img.shields.io/github/forks/garutilorenzo/mysql-ha-docker)](https://github.com/garutilorenzo/mysql-ha-docker/network)
[![GitHub stars](https://img.shields.io/github/stars/garutilorenzo/mysql-ha-docker)](https://github.com/garutilorenzo/mysql-ha-docker/stargazers)

![MySQL Logo](https://garutilorenzo.github.io/images/mysql.png?)

# MySQL HA with ProxySQL Percona Heartbeat and Orchestrator

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

* [ProxySQL](https://github.com/sysown/proxysql/wiki) - High performance, high availability, protocol aware proxy for MySQL
* [Heartbeat](https://www.percona.com/doc/percona-toolkit/LATEST/pt-heartbeat.html) - Monitor MySQL replication delay
* [Orchestrator](https://github.com/github/orchestrator/tree/master/docs) - MySQL high availability and replication management tool

## Notes about environment

* MySQL replication is setup with [GTID](https://dev.mysql.com/doc/refman/5.7/en/replication-gtids.html)

## Setting up environment

Start environment with

```
docker-compose pull
docker-compose up -d
```

If you wish to rebuild the images locally run:

```
docker-compose -f .docker-compose.yml-ci build
```

```
docker build mysql/ -t garutilorenzo/mysql-gtid-replication:latest
docker build heartbeat/ -t garutilorenzo/heartbeat:latest
```

### Show cluster status

**ProxySQL**

Via console:

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

**Orchestrator**

Via web Browser:

http://localhost:3000

**Heartbeat**

Via console:

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

NOTE: all the cluster's password are defined in grants/users.sql

### Clean all data

```
docker-compose down -v
```

mysql-ha-docker

mysql-ha-docker Latest Version Download

Today's picks

Was this content helpful?

Recent Feedback

mysql-ha-docker

mysql-ha-docker Latest Version Download

Today's picks

Was this content helpful?

Recent Feedback

Download README