mysql多实例安装 mysql



mkdir -pv /home/data/mysql_3309

chown -R mysql:mysql /home/data/mysql_3309

/usr/local/mysql/bin/mysql_install_db --basedir=/usr/local/mysql --datadir=/home/data/mysql_3309/data  --user=mysql


vim /etc/my_multi.cnf

[mysqld9]
socket = /home/data/mysql_3309/mysql3309.sock
port = 3309
pid-file = /home/data/mysql_3309/mysqld3309.pid
datadir = /home/data/mysql_3309/data
log_bin=/home/data/mysql_3309/binlog
server-id = 9
relay_log =/home/data/mysql_3309/relay_log/mysql-relay-bin
log_slave_updates = 1
max_connections = 1000
max_connect_errors = 6000
innodb_buffer_pool_size = 128M
innodb_flush_log_at_trx_commit = 0

/usr/local/mysql/bin/mysqld_multi --defaults-extra-file=/etc/my_multi.cnf start 3309

or

nohup /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/home/data/mysql_3309/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-bin=/home/data/mysql_3309/binlog --server-id=9 --relay-log=/home/data/mysql_3309/relay_log/mysql-relay-bin --log-slave-updates=1 --max-connections=1000 --max-connect-errors=6000 --innodb-buffer-pool-size=128M --innodb-flush-log-at-trx-commit=0 --log-error=/home/data/mysql/mysql-error.log --open-files-limit=65535 --pid-file=/home/data/mysql_3309/mysqld3309.pid --socket=/home/data/mysql_3309/mysql3309.sock --port=3309 < /dev/null >> /home/data/mysql/mysql-error.log 2>&1


mysql --socket=/home/data/mysql_3309/mysql3309.sock



签名:这个人很懒,什么也没有留下!
最新回复 (0)
返回