# How conf multi cluster same nodes **URL:** \ **Category:** Percona XtraDB Cluster 8.x\ **Created:** [December 17, 2024, 1:12pm UTC](https://forums.percona.com/t/how-conf-multi-cluster-same-nodes/35702 "2024-12-17T13:12:15Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![akin.temel](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@akin.temel](https://forums.percona.com/u/akin.temel)\ **Post date:** [December 17, 2024, 1:12pm UTC](https://forums.percona.com/t/how-conf-multi-cluster-same-nodes/35702/1 "2024-12-17T13:12:15Z")
Hello All , I want to set up a second xtra mysql cluster on the same server. I added the my.cnf files from the 1st server. I ran the 1st cluster with systemctl bootstart and there is no problem, I get the error in the attachment when I run the 2nd cluster with mysqld bootstart. If you have any suggestions on the subject, please help. Thank you very much 1. Cluster Conf root@mysql01:~# cat /etc/mysql/my.cnf [mysqld] server-id = 101 datadir = /clu01 log-bin = mysql01 log-error = /var/log/mysql/error.log log\_error\_verbosity = 2 bind-address = 10.0.5.71 pxc\_encrypt\_cluster\_traffic = OFF #InnoDB innodb\_buffer\_pool\_size = 512M #Wsrep wsrep\_provider = /usr/lib/galera4/libgalera\_smm.so wsrep\_cluster\_address = “gcomm://10.0.5.71,10.0.5.72,10.0.5.73” wsrep\_cluster\_name = clu01 wsrep\_node\_name = mysql01 wsrep\_node\_address = 10.0.5.71 wsrep\_sst\_method = xtrabackup-v2 1. Cluster Conf \*root@mysql01:~# cat /etc/mysql/my2.cnf \* _[mysqld]_ _server-id = 201_ _port = 5306_ _mysqlx\_port = 53060_ _socket=/var/run/mysqld/mysqld2.sock_ _pid-file=/var/run/mysqld/mysqld2.pid_ _datadir = /clu02_ _log-bin = mysql01_ _log-error = /var/log/mysql/error2.log_ _log\_error\_verbosity = 2_ _bind-address = 10.0.5.71_ _pxc\_encrypt\_cluster\_traffic = OFF_ _#InnoDB_ _innodb\_buffer\_pool\_size = 256M_ _#Wsrep_ _wsrep\_provider = /usr/lib/galera4/libgalera\_smm.so_ _wsrep\_cluster\_address = “gcomm://10.0.5.71,10.0.5.72,10.0.5.73”_ _wsrep\_provider\_options =“base\_port=6567;gmcast.listen\_addr=tcp://0.0.0.0:5567;”_ _wsrep\_cluster\_name = clu02_ _wsrep\_node\_name = mysql01_ _wsrep\_node\_address = 10.0.5.71_ _wsrep\_sst\_method = xtrabackup-v2_ To run the 1st cluster; systemctl start mysql@bootstrap.service To run the 2nd cluster; mysqld --defaults-file=/etc/mysql/my2.cnf --user=mysql --bootstrap Thanks & Regards ---
**Author:** ![akin.temel](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@akin.temel](https://forums.percona.com/u/akin.temel)\ **Post date:** [December 18, 2024, 8:43am UTC](https://forums.percona.com/t/how-conf-multi-cluster-same-nodes/35702/2 "2024-12-18T08:43:27Z")
Helllo All , I forget put error2.log.Here is the error2.log 2024-12-18T08:41:28.400785Z 0 [Note] [MY-000000] [Galera] Failed to establish connection: Connection refused 2024-12-18T08:41:28.424523Z 0 [Note] [MY-000000] [Galera] PC protocol downgrade 1 → 0 2024-12-18T08:41:28.424630Z 0 [Note] [MY-000000] [Galera] Current view of cluster as seen by this node view ((empty)) 2024-12-18T08:41:28.425278Z 0 [ERROR] [MY-000000] [Galera] failed to open gcomm backend connection: 110: failed to reach primary view (pc.wait\_prim\_timeout) at …/…/…/…/percona-xtradb-cluster-galera/gcomm/src/pc.cpp:connect():176 2024-12-18T08:41:28.425362Z 0 [ERROR] [MY-000000] [Galera] …/…/…/…/percona-xtradb-cluster-galera/gcs/src/gcs\_core.cpp:gcs\_core\_open():222: Failed to open backend connection: -110 (Connection timed out) 2024-12-18T08:41:29.425869Z 0 [Note] [MY-000000] [Galera] gcomm: terminating thread 2024-12-18T08:41:29.425978Z 0 [Note] [MY-000000] [Galera] gcomm: joining thread 2024-12-18T08:41:29.426085Z 0 [ERROR] [MY-000000] [Galera] …/…/…/…/percona-xtradb-cluster-galera/gcs/src/gcs.cpp:gcs\_open():1934: Failed to open channel ‘clu02’ at ‘gcomm://10.0.5.71,10.0.5.72,10.0.5.73’: -110 (Connection timed out) 2024-12-18T08:41:29.426124Z 0 [ERROR] [MY-000000] [Galera] gcs connect failed: Operation timed out 2024-12-18T08:41:29.426141Z 0 [ERROR] [MY-000000] [WSREP] Provider/Node (gcomm://10.0.5.71,10.0.5.72,10.0.5.73) failed to establish connection with cluster (reason: 7) 2024-12-18T08:41:29.426163Z 0 [ERROR] [MY-010119] [Server] Aborting Thanks ---
**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\ **Post date:** [December 18, 2024, 5:53pm UTC](https://forums.percona.com/t/how-conf-multi-cluster-same-nodes/35702/3 "2024-12-18T17:53:36Z")
> _wsrep\_cluster\_address = “gcomm://10.0.5.71,10.0.5.72,10.0.5.73”_ This needs to be port specific: 10.0.5.71:5557 Running two, independent, 3-node PXC clusters (ie: 6 mysql daemons) on 1 machine will be quite difficult. You can get free VMs from AWS to test out something like this if you are tight on resources. You might want to also look at [anydbver](https://github.com/ihanick/anydbver) which has support for PXC.