九.mysql数据库多实例安装

=3306 socket=/tmp/mysql.sock [mysqld_multi] mysqld=/usr/local/mysql/bin/mysqld_safe mysqladmin=/usr/local/mysql/bin/mysqladmin log=/home/mysql/mysqld_multi.log [mysqld] user=mysql basedir=/usr/local/mysql sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES [mysqld3306] mysqld=mysqld mysqladmin=mysqladmin datadir=/home/mysql/mysql3306/data port=3306 server_id=3306 socket=/tmp/mysql3306.sock log-output=file slow_query_log = 1 long_query_time = 1 slow_query_log_file = /home/mysql/mysql3306/log/slow.log log-error = /home/mysql/mysql3306/log/error.log binlog_format = mixed log-bin = /home/mysql/mysql3306/log/mysql3306_bin [mysqld3307] mysqld=mysqld mysqladmin=mysqladmin datadir=/home/mysql/mysql3307/data port=3307 server_id=3307 socket=/tmp/mysql3307.sock log-output=file slow_query_log = 1 long_query_time = 1 slow_query_log_file = /home/mysql/mysql3307/log/slow.log log-error = /home/mysql/mysql3307/log/error.log binlog_format = mixed log-bin = /home/mysql/mysql3307/log/mysql3307_bin [mysqld3308] mysqld=mysqld mysqladmin=mysqladmin datadir=/home/mysql/mysql3308/data port=3308 server_id=3308 socket=/tmp/mysql3308.sock log-output=file slow_query_log = 1 long_query_time = 1 slow_query_log_file = /home/mysql/mysql3308/log/slow.log log-error = /home/mysql/mysql3308/log/error.log binlog_format = mixed log-bin = /home/mysql/mysql3308/log/mysql3308_bin

 

3.运行mysqld_multi

# 启动
/usr/local/mysql/bin/mysqld_multi start  

# 停止
/usr/local/mysql/bin/mysqld_multi stop  

# 查询状态
/usr/local/mysql/bin/mysqld_multi report  

 

九.mysql数据库多实例安装

标签：ror   style   sql_mod   mysql数据库   l数据库   art   mysql   结构   目录