I’ve setup a 4 node cluster with Ubuntu. If I create a DB from the command line and insert some data, it seems to replicate to the other nodes as expected. However, I have created a database for use with Kamailio, and when I try to insert data into (via the Kamailio app or the mysql cli) none of the data replicates to any of the other nodes (it is available to the local node, though). I’ve dropped and re-created the Kamailio DB as well, no good. Any help would be great!
I would check to see what table types your application uses. Based on your description, I’m guessing the app is using MyISAM, which would not replicate:
http://www.percona.com/doc/percona-xtradb-cluster/limitation.html
That was it! Thanks.