安裝MySQL和HandlerSocket

標籤：

CentOS 6.5
MySQL 5.6.33
HandlerSocket 1.1.2

# Get packages
shell> wget http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.33.tar.gz
shell> wget https://github.com/DeNA/HandlerSocket-Plugin-for-MySQL/archive/1.1.2.tar.gz
shell> mv 1.1.2.tar.gz handlerSocket-1.1.2.tar.gz

## MySQL
# System Requirements
shell> sudo yum install cmake make gcc gcc-c++ perl ncurses-devel bison libtool
shell> sudo mv /etc/my.cnf /etc/my.cnf.bak (dependes)

# Preconfiguration setup
shell> sudo groupadd mysql
shell> sudo useradd -r -g mysql -s /bin/false mysql

# Beginning of source-build specific instructions
shell> tar zxvf mysql-5.6.33.tar.gz
shell> cd mysql-5.6.33
shell> cmake .
shell> make
shell> sudo make install
# End of source-build specific instructions

# Postinstallation setup
shell> cd /usr/local/mysql
shell> sudo chown -R mysql:mysql .
shell> sudo scripts/mysql_install_db --user=mysql
shell> sudo chown -R root .
shell> sudo chown -R mysql data
shell> sudo bin/mysqld_safe --user=mysql &
# Next command is optional
shell> sudo cp support-files/mysql.server /etc/init.d/mysqld

## HandlerSocket
# Build Handlersocket
shell> tar zxvf handlerSocket-1.1.2.tar.gz
shell> cd HandlerSocket-Plugin-for-MySQL-1.1.2
shell> ./autogen.sh
shell> ./configure --with-mysql-source=/home/susl/tools/mysql-5.6.33 --with-mysql-bindir=/usr/local/mysql/bin --with-mysql-plugindir=/usr/local/mysql/lib/plugin
shell> make
shell> sudo make install

# Using Handlersocket
shell> sudo sh -c "echo ‘[mysqld]
loose_handlersocket_port = 9998
loose_handlersocket_port_wr = 9999
loose_handlersocket_threads = 16
loose_handlersocket_threads_wr = 1
open_files_limit = 65535
‘ >> /usr/local/mysql/my.cnf"
# Log in to mysql as root
mysql> install plugin handlersocket soname ‘handlersocket.so‘;

----------
附：二進位包/源碼安裝方式的MySQL卸載
1.關閉MySQL服務進程
shell> sudo service mysqld stop
2.尋找MySQL的安裝目錄並徹底刪除
#系統內建的mysql-libs包不要卸載，對應目錄不要刪掉：/usr/share/mysql, /usr/lib64/mysql
shell> sudo find / -name mysql
shell> sudo rm -rf xxx ...
3.視情況刪除設定檔my.cnf
4.視情況刪除MySQL使用者以及使用者組

安裝MySQL和HandlerSocket