Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

set test environment? #3

Closed
siddontang opened this issue Aug 8, 2014 · 3 comments
Closed

set test environment? #3

siddontang opened this issue Aug 8, 2014 · 3 comments
Labels

Comments

@siddontang
Copy link
Owner

use docker to support multi mysql in one computer?

@siddontang siddontang added the todo label Aug 8, 2014
@jomenxiao
Copy link

yes,it's ok
Without docker,it's ok too

Sent from my iPhone

On 2014Äê8ÔÂ8ÈÕ, at 15:11, siddontang notifications@github.com wrote:

use docker to support multi mysql in one computer?

¡ª
Reply to this email directly or view it on GitHub.

@siddontang
Copy link
Owner Author

@siddontang
Copy link
Owner Author

# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html

[mysqld_multi]
mysqld     = /usr/local/Cellar/mysql/5.6.19/bin/mysqld_safe
mysqladmin = /usr/local/Cellar/mysql/5.6.19/bin/mysqladmin
user       = mysql
#password   = 

[mysqld1]
datadir = /usr/local/var/mysql1
port = 3306
socket     = /tmp/mysql.sock1
pid-file   = /usr/local/var/mysql1/mysqld.pid1
user = mysql

innodb_buffer_pool_size = 24M
skip-name-resolve
skip-slave-start
skip-external-locking
key_buffer_size = 16K
max_allowed_packet = 1M
table_open_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 128K
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 

[mysqld2]
datadir = /usr/local/var/mysql2
port = 3307
socket     = /tmp/mysql.sock2
pid-file   = /usr/local/var/mysql2/mysqld.pid2
user = mysql

innodb_buffer_pool_size = 24M
skip-name-resolve
skip-slave-start
skip-external-locking
key_buffer_size = 16K
max_allowed_packet = 1M
table_open_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 128K
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
sudo ./mysqld_multi --defaults-file=/etc/my_multi.cnf start
sudo ./mysqld_multi --defaults-file=/etc/my_multi.cnf report

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants