# Percona XtraDB MySQL Cluster not replicate between nodes

**URL:** <https://forums.percona.com/t/percona-xtradb-mysql-cluster-not-replicate-between-nodes/2716>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [May 28, 2013, 4:51am UTC](https://forums.percona.com/t/percona-xtradb-mysql-cluster-not-replicate-between-nodes/2716 "2013-05-28T04:51:13Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![pyco](https://avatars.discourse-cdn.com/v4/letter/p/e47774/32.png) [@pyco](https://forums.percona.com/u/pyco)\
**Post date:** [May 28, 2013, 4:51am UTC](https://forums.percona.com/t/percona-xtradb-mysql-cluster-not-replicate-between-nodes/2716/1 "2013-05-28T04:51:13Z")

</div>

Hi Pro,

I setup MySQL Cluster using Percona XtraDB Cluster + Galera  
My system:

- MySQL Cluster Control: 192.168.180.20
- DB Master Node 1: 192.168.180.21
- DB Master Node 2: 192.168.180.22
- DB Master Node 3: 192.168.180.23

We setup without DB Slave.

1. 

- My problem: When i restart mysql service or restart database server, database not replicate between nodes. Or node restarted kick out database cluster.
- My Solution for this case: I must delete database and file in /var/lib/mysql on all database and restart mysql service. Command restart:

- DB Node 1: service mysql start --wsrep-cluster-address=gcomm://
- DB Node 2: service mysql start
- DB Node 3: service mysql start  
When i restart node 2 and node 3, it take 15-30 minutes to join cluster and replicate  
And i check port mysql i see only port 4567 is open (after 15-30 minutes port 3306 just open)  
After i do this Mysql Cluster is working well and i reimport database.

My question: how can i resolve this problem quickly when a node in cluster fail

1. When i use Mysql Cluster using Percona XtraDB Cluster + Galera

- The size of general\_log table in default database (mysql) is very large (26GB), while my production database is 1.3GB
- My question: Can i remove or empty general\_log table?

Thanks

---

<div class="post-metadata">

**Author:** ![azigui](https://avatars.discourse-cdn.com/v4/letter/a/cab0a1/32.png) [@azigui](https://forums.percona.com/u/azigui)\
**Post date:** [May 28, 2013, 6:24am UTC](https://forums.percona.com/t/percona-xtradb-mysql-cluster-not-replicate-between-nodes/2716/2 "2013-05-28T06:24:38Z")

</div>

Hi,

Can I see your logs and your my.cnf files

Thx

Azigui

---

<div class="post-metadata">

**Author:** ![pyco](https://avatars.discourse-cdn.com/v4/letter/p/e47774/32.png) [@pyco](https://forums.percona.com/u/pyco)\
**Post date:** [May 29, 2013, 4:12am UTC](https://forums.percona.com/t/percona-xtradb-mysql-cluster-not-replicate-between-nodes/2716/3 "2013-05-29T04:12:47Z")

</div>

Hi azigui,

My log is very long, so i can’t post this here.  
Please have a look my configure file and log in here: [url][http://pastebin.com/yFdnKLxC[/url]](http://pastebin.com/yFdnKLxC%5B/url%5D)

thanks