Goog/ProxySQL @ 88b7e5481c05e70e3671fc9214ec1ad2bd8c1fcc

Nav apraksta

1 Atzari

Chris Mague 88b7e5481c setup some users		2 gadi atpakaļ
README.md	88b7e5481c setup some users	2 gadi atpakaļ
docker-compose.yml	464ec8d473 working replication setup	2 gadi atpakaļ
master.cnf	464ec8d473 working replication setup	2 gadi atpakaļ
proxysql.cnf	88b7e5481c setup some users	2 gadi atpakaļ
replica.cnf	464ec8d473 working replication setup	2 gadi atpakaļ
setup_replication.sh	464ec8d473 working replication setup	2 gadi atpakaļ
setup_servers.sql	db7aaa979b initial setup	2 gadi atpakaļ
users.sql	88b7e5481c setup some users	2 gadi atpakaļ

		
				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

Add Some Data

mysql --protocol tcp  -P 3307 -u root -pmysql1 < users.sql