三台服务器都安装mysql，将manager作为管理节点
3、配置等价性
manager：
| ssh-keyger -t rsa ssh-coyp-id -i /root/.ssh/id_rsa.pub root@192.168.216.50 ssh-coyp-id -i /root/.ssh/id_rsa.pub root@192.168.216.51 ssh-coyp-id -i /root/.ssh/id_rsa.pub root@192.168.216.52 ssh 192.168.216.50 date ssh 192.168.216.51 date ssh 192.168.216.52 date |
master:
| ssh-keyger -t rsa ssh-coyp-id -i /root/.ssh/id_rsa.pub root@192.168.216.50 ssh-coyp-id -i /root/.ssh/id_rsa.pub root@192.168.216.51 ssh-coyp-id -i /root/.ssh/id_rsa.pub root@192.168.216.52 ssh 192.168.216.50 date ssh 192.168.216.51 date ssh 192.168.216.52 date |
slave:
| ssh-keyger -t rsa ssh-coyp-id -i /root/.ssh/id_rsa.pub root@192.168.216.50 ssh-coyp-id -i /root/.ssh/id_rsa.pub root@192.168.216.51 ssh-coyp-id -i /root/.ssh/id_rsa.pub root@192.168.216.52 ssh 192.168.216.50 date ssh 192.168.216.51 date ssh 192.168.216.52 date |
4、安装mysql
| groupadd mysql useradd -g mysql -s /bin/nologin -M mysql mkdir -pv /data/mysql tar -zxvf mysql-5.6.16-linux-glibc2.5-x86_64.tar.gz mv mysql-5.6.16-linux-glibc2.5-x86_64 /usr/local/mysql cd /usr/local/mysql/script ./ mysql_install_db –user=mysql –basedir=/usr/local/mysql –datadair=/data/mysql |
创建mysql配置文件
| vim /usr/local/mysql/my.cnf |
| [mysql] # CLIENT # port = 3306 socket = /tmp/mysql.sock [mysqld] # GENERAL # user = mysql default-storage-engine = InnoDB socket = /tmp/mysql.sock pid-file = /data/mysql/mysql.pid # MyISAM # key-buffer-size = 32M myisam-recover = FORCE,BACKUP # SAFETY # max-allowed-packet = 16M max-connect-errors = 1000000 # DATA STORAGE # datadir = /data/mysql/ # BINARY LOGGING # server_id = 1 #不同服务器不一样 log-bin = /data/mysql/mysql-bin expire-logs-days = 14 sync-binlog = 1 # CACHES AND LIMITS # tmp-table-size = 32M max-heap-table-size = 32M query-cache-type = 0 query-cache-size = 0 max-connections = 500 thread-cache-size = 50 open-files-limit = 65535 table-definition-cache = 1024 table-open-cache = 2048 # INNODB # innodb-flush-method = O_DIRECT innodb-log-files-in-group = 2 innodb-log-file-size = 64M innodb-flush-log-at-trx-commit = 1 innodb-file-per-table = 1 innodb-buffer-pool-size = 592M # LOGGING # log-error = /data/mysql/mysql-error.log log-queries-not-using-indexes = 1 slow-query-log = 1 slow-query-log-file = /data/mysql/mysql-slow.log |
