安徽建设通网站,html常用标签代码大全,游戏软件开发专业,轻量级服务器wordpress密钥Percona XtraDB Cluster提供的特性有#xff1a;1.同步复制#xff0c;事务要么在所有节点提交或不提交。2.多主复制#xff0c;可以在任意节点进行写操作。3.在从服务器上并行应用事件#xff0c;真正意义上的并行复制。4.节点自动配置。5.数据一致性#xff0c;不再是异… Percona XtraDB Cluster提供的特性有1.同步复制事务要么在所有节点提交或不提交。2.多主复制可以在任意节点进行写操作。3.在从服务器上并行应用事件真正意义上的并行复制。4.节点自动配置。5.数据一致性不再是异步复制。 开始搭建 三台服务器先设置hosts
10.0.0.231 node1
10.0.0.232 node2
10.0.0.233 node3 1下载安装文件 官网https://www.percona.com 下载地址https://www.percona.com/downloads/Percona-XtraDB-Cluster-LATEST/Percona-XtraDB-Cluster-5.7.18-29.20/binary/tarball/Percona-XtraDB-Cluster-5.7.18-rel15-29.20.1.Linux.x86_64.ssl100.tar.gz 2解压到指定目录 tar -zxvf Percona-XtraDB-Cluster-5.7.18-rel15-29.20.1.Linux.x86_64.ssl101.tar.gz -C /usr/localln -s Percona-XtraDB-Cluster-5.7.18-rel15-29.20.1.Linux.x86_64.ssl101 mysql5.7 3创建目录 mkdir -p /usr/local/mysql5.7/data
mkdir -p /usr/local/mysql5.7/tmp 4:创建用户 useradd -d /usr/local/mysql5.7 -m mysql
chown -R /usr/local/mysql5.7
chmod 600 /usr/local/mysql5.7 5:配制/etc/my.cnf note1: [mysqld]server_id231
datadir/usr/local/mysql5.7/data
usermysql
basedir/usr/local/mysql5.7default_storage_engineInnodbinnodb_buffer_pool_size1610612736
innodb_log_file_size104857600wsrep_provider/usr/local/mysql5.7/lib/libgalera_smm.so
wsrep_cluster_addressgcomm://10.0.0.231,10.0.0.232,10.0.0.233
wsrep_node_namenode1
wsrep_node_address10.0.0.231
wsrep_cluster_namepxc_sampson
wsrep_sst_authsst:sampson
wsrep_sst_methodrsync
wsrep_slave_threads2
pxc_strict_modeENFORCING
innodb_autoinc_lock_mode2
wsrep_provider_optionsdebug1;gcache.size1G note2: [mysqld]
server_id232
datadir/usr/local/mysql5.7/data
usermysql
basedir/usr/local/mysql5.7default_storage_engineInnodbinnodb_buffer_pool_size1610612736
innodb_log_file_size104857600wsrep_provider/usr/local/mysql5.7/lib/libgalera_smm.so
wsrep_cluster_addressgcomm://10.0.0.231,10.0.0.232,10.0.0.233
wsrep_node_namenode2
wsrep_node_address10.0.0.232
wsrep_cluster_namepxc_sampson
wsrep_sst_authsst:sampson
wsrep_sst_methodrsync
wsrep_slave_threads2
pxc_strict_modeENFORCING
innodb_autoinc_lock_mode2
wsrep_provider_optionsdebug1;gcache.size1G note3: [mysqld]server_id233
datadir/usr/local/mysql5.7/data
usermysql
basedir/usr/local/mysql5.7
default_storage_engineInnodbinnodb_buffer_pool_size1610612736
innodb_log_file_size104857600wsrep_provider/usr/local/mysql5.7/lib/libgalera_smm.so
wsrep_cluster_addressgcomm://10.0.0.231,10.0.0.232,10.0.0.233
wsrep_node_namenode3
wsrep_node_address10.0.0.233
wsrep_cluster_namepxc_sampson
wsrep_sst_authsst:sampson
wsrep_sst_methodrsync
wsrep_slave_threads2
pxc_strict_modeENFORCING
innodb_autoinc_lock_mode2
wsrep_provider_optionsdebug1;gcache.size1G 6:初始化mysql note1,note2,note3 /usr/local/mysql5.7/bin/mysql_install_db --defaults-file/etc/my.cnf --usermysql --basedir/usr/local/mysql5.7/ --datadir/usr/local/mysql5.7/data/ 7启动第一个节点 node1: /usr/local/mysql5.7/bin/mysqld_safe --ledir/usr/local/mysql5.7/bin --wsrep-new-cluster 完成后CtrlC 8修改mysql密码 查看初使密码cat /root/.mysql_secret 假设初始密码为abcde修改初始密码先进入mysql命令行mysql -u root -p输入初始密码abcde修改初始密码SET PASSWORD PASSWORD(123456); 9启动第二三个节点 node2,node3 /usr/local/mysql5.7/bin/mysqld_safe --ledir/usr/local/mysql5.7/bin 10:查看 登录mysql mysqlshow global status like wsrep_cluster_size;mysqlshow global status like wsrep%; 11:设置开机启动 cp /usr/local/mysql5.7/support-files/mysql.server /etc/init.d/mysql …复制启动文件 chmod 755 /etc/init.d/mysql …增加执行权限 chkconfig --add mysql …加入自动启动项chkconfig --level 2345 mysql on …设置MySQL 在345 等级自动启动 12环境变量 export PATH/usr/local/mysq5.7l/bin:$PATH 转载于:https://www.cnblogs.com/feiyun126/p/7268967.html
