安装galera-3、mysql-wsrep-5.7、Percona-XtraBackup-2.4.15 2. 修改配置文件 3. 初始化集群 4. 启动集群其它节点的mysqld服务 5. 安装galera-3、mysql-wsrep-5.7、Percona-XtraBackup-2.4.15 以下步骤以root用户在三台主机执行。 releases.galeracluster.com/mysql-wsrep-5.7.27-25.19/GPG-KEY-galeracluster.com gpgcheck = 1 END (3)安装galera -3与mysql-wsrep-5.7 yum install -y galera-3 mysql-wsrep-5.7 (4)确认相关的rpm包 [root@hdp2~]#rpm -qa | grep - 修改配置文件 编辑/etc/my.cnf文件,增加以下内容: [mysqld] log-error=/var/log/mysqld.log wsrep_provider=/usr/lib64/galera
软件组成 Galera Cluster由两部分组成 the Galera Replication Library (galera-3) a version of MySQL extended with
软件组成 Galera Cluster由两部分组成 the Galera Replication Library (galera-3) a version of MySQL extended with
Galera gpgcheck=0 enabled=1 baseurl=http://releases.galeracluster.com/centos/6/x86_64/ yum安装:yum install galera innodb_flush_log_at_trx_commit=0 transaction-isolation=READ-COMMITTED #galera cluster参数 wsrep_provider=/usr/lib64/galera innodb_flush_log_at_trx_commit=0 transaction-isolation=READ-COMMITTED #galera cluster参数 wsrep_provider=/usr/lib64/galera innodb_flush_log_at_trx_commit=0 transaction-isolation=READ-COMMITTED #galera cluster参数 wsrep_provider=/usr/lib64/galera
releases.galeracluster.com/mysql-wsrep-5.6/ubuntu xenial main deb http://releases.galeracluster.com/galera 在所有服务器上安装MySQL和Galera 在所有三台服务器上运行以下命令,以安装修补的MySQL版本,以便与Galera以及Galera和几个依赖项一起使用: sudo apt-get install galera
packages were automatically installed and are no longer required: apache2-bin apache2-data apache2-utils galera
# wsrep_provider = /usr/lib64/galera-3/libgalera_smm.so # Location of Galera Plugin
# wsrep_provider = /usr/lib64/galera-3/libgalera_smm.so # Location of Galera v3 Plugin