Skip to content

Instantly share code, notes, and snippets.

@davidlzs

davidlzs/create_mysql_test_schema.sh

Created March 25, 2021 21:55
Show Gist options

  • Select an option

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

Select an option

Learn more about clone URLs
Save davidlzs/38bafac0beb700641a2a9fb896e0c19d to your computer and use it in GitHub Desktop.
Download ZIP
Create mysql test schema for ProxySQL test
Raw
create_mysql_test_schema.sh
# open a bash to our test conainer
docker exec -it db_backend_switch_nose_1 bash
# in the bash shell connect to db1 directly
mysql -usbtest1 -ppassword -hdb1
# run the following sql to create our test table in db1
create table test(id int primary key);
# in the bash shell connect to db2 directly
mysql -usbtest1 -ppassword -hdb2
# run the following sql to create our test table in db2
create table test(id int primary key);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment