安裝
|
1 2 3 |
$ brew install percona-server $ unset TMPDIR $ mysql_install_db --verbose --user=`whoami` --basedir="$(brew --prefix percona-server)" --datadir=/usr/local/var/percona --tmpdir=/tmp |
Launch Agent
如果開機就要啟動，需設定 Launch Agent. 如果已有 ~/Library/LaunchAgents 則不需 mkdir.
|
1 2 3 |
$ mkdir -p ~/Library/LaunchAgents $ cp /usr/local/opt/percona-server/homebrew.mxcl.percona-server.plist ~/Library/LaunchAgents/ $ launchctl load -w ~/Library/LaunchAgents/homebrew.mxcl.percona-server.plist |
開防火牆
如 Mac OS X 有開防火牆，需允許 mysqld 傳入連線
改 root 密碼
|
1 |
$ /usr/local/opt/percona-server/bin/mysqladmin -u root password 'new-password' |
設定 my.cnf
可以從內建的樣板來修改
|
1 |
sudo cp $(brew --prefix percona-server)/support-files/my-small.cnf /etc/my.cnf |
在 my.cnf 中設定 InnoDB (XtraDB)，uncomment 樣板設定即可
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
# Uncomment the following if you are using InnoDB tables #innodb_data_home_dir = /usr/local/var/percona #innodb_data_file_path = ibdata1:10M:autoextend #innodb_log_group_home_dir = /usr/local/var/percona # You can set .._buffer_pool_size up to 50 - 80 % # of RAM but beware of setting memory usage too high #innodb_buffer_pool_size = 16M #innodb_additional_mem_pool_size = 2M # Set .._log_file_size to 25 % of buffer pool size #innodb_log_file_size = 5M #innodb_log_buffer_size = 8M #innodb_flush_log_at_trx_commit = 1 #innodb_lock_wait_timeout = 50 |
啟動 mysql 的 script
|
1 |
$ mysql.server {start|stop|restart|reload|force-reload|status} |