Skip to main content

Posts

Showing posts from October, 2023

Percona Xtradb Cluster and Proxysql

  Percona Xtradb Cluster and Proxysql 192.168.2.78 dbnode1.db   node1 192.168.2.233 dbnode2.db node2 192.168.2.167 dbnode3.db node3 192.168.2.232 dbnode4.db proxysql Percona xtradb cluster 8 ProxySQL version 2.5.4-percona-1.1 Install percona xtradb cluster 8 in node1, node2, node3 # yum install https://repo.percona.com/yum/percona-release-latest.noarch.rpm # percona-release enable-only pxc-80 release # percona-release enable tools release # yum module disable mysql -y # yum install percona-xtradb-cluster Then, start service mysql in node1, node2 and node3 # service mysql start Find temporary password in mysqld.log # grep 'temporary password' /var/log/mysqld.log Login mysql with temporary password # mysql -u root -p After login, you must reset root password with your own password. MySQL> ALTER USER 'root'@'localhost' IDENTIFIED BY 'Percona@pxc8'; Then, Verify wsrep parameters in the database. MySQL> show variables like '%wsrep%'; Before conf