Skip to content

Instantly share code, notes, and snippets.

@davidlzs

davidlzs/simulated_application_connect_to_mysql_via_proxysql.sh

Created March 25, 2021 22:21
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save davidlzs/8627ff849eab59eb097e46787699e2f1 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save davidlzs/8627ff849eab59eb097e46787699e2f1 to your computer and use it in GitHub Desktop.
Download ZIP
Open a bash shell to test container to simulate application connection to mysql via ProxySQL
Raw
simulated_application_connect_to_mysql_via_proxysql.sh
# open a bash to our test conainer
docker exec -it db_backend_switch_nose_1 bash
# in the bash shell connect to mysql db via proxysql
mysql -usbtest1 -ppassword -hproxysql -P6033
# turn off autocommit
set autocommit=0;
# start long running transaction
begin;
insert into test values (11);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment