# source mysql_functions.sh# mstatus
ID DIRECTORY PORT STATUS PID
PRI /var/lib/mysql 3306 ON 21441/var/lib/mysql1 3307 ON 30292/var/lib/mysql2 3308 ON 3048
# source mysql_functions.sh
# mstatus
ID DIRECTORY PORT STATUS PID
PRI /var/lib/mysql 3306 ON 2144
1 /var/lib/mysql1 3307 ON 3029
2 /var/lib/mysql2 3308 ON 3048
Stopping MySQL instance 2
1
2
3
4
5
6
7
# source mysql_functions.sh# mstop 2# mstatus
ID DIRECTORY PORT STATUS PID
PRI /var/lib/mysql 3306 ON 21441/var/lib/mysql1 3307 ON 30292/var/lib/mysql2 3308 OFF
# source mysql_functions.sh
# mstop 2
# mstatus
ID DIRECTORY PORT STATUS PID
PRI /var/lib/mysql 3306 ON 2144
1 /var/lib/mysql1 3307 ON 3029
2 /var/lib/mysql2 3308 OFF
Starting MySQL instance 2
1
2
3
4
5
6
7
# source mysql_functions.sh# mstart 2# mstatus
ID DIRECTORY PORT STATUS PID
PRI /var/lib/mysql 3306 ON 21441/var/lib/mysql1 3307 ON 30292/var/lib/mysql2 3308 ON 3049
# source mysql_functions.sh
# mstart 2
# mstatus
ID DIRECTORY PORT STATUS PID
PRI /var/lib/mysql 3306 ON 2144
1 /var/lib/mysql1 3307 ON 3029
2 /var/lib/mysql2 3308 ON 3049
Restarting MySQL instances 1 2
1
2
3
4
5
6
7
# source mysql_functions.sh# mrestart 1 2# mstatus
ID DIRECTORY PORT STATUS PID
PRI /var/lib/mysql 3306 ON 21441/var/lib/mysql1 3307 ON 30292/var/lib/mysql2 3308 ON 3049
# source mysql_functions.sh
# mrestart 1 2
# mstatus
ID DIRECTORY PORT STATUS PID
PRI /var/lib/mysql 3306 ON 2144
1 /var/lib/mysql1 3307 ON 3029
2 /var/lib/mysql2 3308 ON 3049
Creating 10 MySQL instances at once
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
# source mysql_functions.sh# for i in `seq 1 10`; do mclone $i; done# mstatus
ID DIRECTORY PORT STATUS PID
PRI /var/lib/mysql 3306 ON 21441/var/lib/mysql1 3307 ON 302910/var/lib/mysql10 3316 ON 40182/var/lib/mysql2 3308 ON 30483/var/lib/mysql3 3309 ON 35624/var/lib/mysql4 3310 ON 36275/var/lib/mysql5 3311 ON 36926/var/lib/mysql6 3312 ON 37577/var/lib/mysql7 3313 ON 38228/var/lib/mysql8 3314 ON 38879/var/lib/mysql9 3315 ON 3952
# source mysql_functions.sh
# for i in `seq 1 10`; do mclone $i; done
# mstatus
ID DIRECTORY PORT STATUS PID
PRI /var/lib/mysql 3306 ON 2144
1 /var/lib/mysql1 3307 ON 3029
10 /var/lib/mysql10 3316 ON 4018
2 /var/lib/mysql2 3308 ON 3048
3 /var/lib/mysql3 3309 ON 3562
4 /var/lib/mysql4 3310 ON 3627
5 /var/lib/mysql5 3311 ON 3692
6 /var/lib/mysql6 3312 ON 3757
7 /var/lib/mysql7 3313 ON 3822
8 /var/lib/mysql8 3314 ON 3887
9 /var/lib/mysql9 3315 ON 3952
What’s up i am kavin, its my first time
to commenting anywhere, when i read this piece of writing
i thought i could also make comment due to this brilliant post.
I’ve been exploring for a bit for any high quality articles or blog posts in this kind of space
. Exploring in Yahoo I ultimately stumbled upon this web
site. Studying this information So i’m satisfied to express
that I’ve an incredibly excellent uncanny feeling
I found out exactly what I needed. I so much indisputably will make sure to don?t omit this site and provides it a look regularly.
I am not sure where you are getting your info, but good topic.
I needs to spend some time learning more or
understanding more. Thanks for magnificent
information I was looking for this info for my mission.
Pretty! This was an extremely wonderful post. Many thanks for providing this info.
Thank you for your post. Cool.
What’s up i am kavin, its my first time
to commenting anywhere, when i read this piece of writing
i thought i could also make comment due to this brilliant post.
I’ve been exploring for a bit for any high quality articles or blog posts in this kind of space
. Exploring in Yahoo I ultimately stumbled upon this web
site. Studying this information So i’m satisfied to express
that I’ve an incredibly excellent uncanny feeling
I found out exactly what I needed. I so much indisputably will make sure to don?t omit this site and provides it a look regularly.
I am not sure where you are getting your info, but good topic.
I needs to spend some time learning more or
understanding more. Thanks for magnificent
information I was looking for this info for my mission.
Everything is very open with a clear clarification of the issues. It was truly informative. Your site is useful. Thank you for sharing!