Accueil Explorer Aide
S'inscrire Connexion
Goog
/
ProxySQL
2
0
Fork 0
Fichiers Tickets 0 Pull Requests 0 Wiki

Aucune description

Aborescence: 464ec8d473
Branches Tags
ProxySQL
ZIP TAR.GZ
Chris Mague 464ec8d473 working replication setup il y a 2 ans
README.md 464ec8d473 working replication setup il y a 2 ans
docker-compose.yml 464ec8d473 working replication setup il y a 2 ans
master.cnf 464ec8d473 working replication setup il y a 2 ans
proxysql.cnf db7aaa979b initial setup il y a 2 ans
replica.cnf 464ec8d473 working replication setup il y a 2 ans
setup_replication.sh 464ec8d473 working replication setup il y a 2 ans
setup_servers.sql db7aaa979b initial setup il y a 2 ans

README.md

Starting up

docker-compose rm --force
docker-compose up

# Wait
./setup_replication.sh

Checking the ProxySQL

mysql -u radmin -pradmin --protocol=tcp -h 127.0.0.1 -P16032 --prompt='RAdmin> '

Connecting to the two MySQL DBs

mysql --protocol tcp  -P 3307 -u root -pmysql1
mysql --protocol tcp  -P 3308 -u root -pmysql2

Connectiong through the proxy

mysql --protocol tcp -P 16033 -u monitoruser -pmonitorpass