MariaDB多实例的安装配置

 

 初始化数据库：

mysql_install_db  --basedir=/var/lib/mysql --datadir=/data/3306/data --user=mysql

mysql_install_db  --basedir=/var/lib/mysql  --datadir=/data/3307/data  --user=mysql

 

[mysqld_multi]
mysqld = /usr/bin/mysqld_safe
mysqladmin = /usr/bin/mysqladmin
user = root

[mysqld1]
socket = /data/3306/mysql.sock
port = 3306
pid-file = /data/3306/mysql.pid
datadir = /data/3306
log = /data/3306/log/mysqld1.log
user = mysql


[mysqld2]
socket = /data/3307/mysql.sock
port = 3307
pid-file = /data/3307/mysql.pid
datadir = /data/3307
log = /data/3307/log/mysqld1.log
user = mysql

 

mysqld_multi --defaults-extra-file=/data/my_multi.cnf start|stop 1,2

mysqladmin -uroot  -S /data/3306/mysql.sock password 123456

 

 

 

 

 

附录：

MariaDB [(none)]> show variables like '%timeout%';

MariaDB [(none)]> show variables like 'log_bin%';
+---------------------------------+-------+
| Variable_name | Value |
+---------------------------------+-------+
| log_bin                                       | ON |
| log_bin_trust_function_creators | OFF |
+---------------------------------+-------+
2 rows in set (0.00 sec)

 

#手动修改参数

MariaDB [(none)]> set global wait_timeout=30;

 

flush table with read lock   #锁表

unlock tables  #解锁