|
Galera Config:
[mysqld]
log-bin
binlog_format=ROW
default-storage-engine=innodb
innodb_autoinc_lock_mode=2
bind-address=0.0.0.0
- Galera Provider Configuration
wsrep_on=ON
wsrep_provider=/usr/lib64/galera-4/libgalera_smm.so
- Galera Cluster Configuration
wsrep_cluster_name="test_cluster"
wsrep_cluster_address="gcomm://192.168.56.101,192.168.56.105,192.168.56.106"
- Galera Synchronization Configuration
wsrep_sst_method=rsync
- Galera Node Configuration
wsrep_node_address="192.168.56.101"
wsrep_node_name="debug"
- Table configuration
replicate_ignore_table=mfg.backend_fixtureprocess
The Galera cluster has 3 nodes.
Node 3:
MariaDB [mfg]> select * from backend_fixtureprocess;
----------------------------------------------+
----------------------------------------------+
| 1-3 |
234de06ee794423dbe95c22586a003ab |
| 1-4 |
f19f668c491e4f49a86f4a750dbcf4da |
| 1-5 |
f5dfb550380a4cf9a3f5ba9fc702e7b2 |
| 2-3 |
4d001043269b4483b3c5abaf3b1c4aa5 |
| 3-2 |
f61c4892dd554e3dac4ac0d5fe0f5e33 |
----------------------------------------------+
After I issue:
update backend_fixtureprocess set process_id='blahblah' where fixture_name="1-3";
It gets replicated on the other 2 nodes
Node 2:
MariaDB [mfg]> select * from backend_fixtureprocess;
----------------------------------------------+
----------------------------------------------+
| 1-3 |
blahblah |
| 1-4 |
f19f668c491e4f49a86f4a750dbcf4da |
| 1-5 |
f5dfb550380a4cf9a3f5ba9fc702e7b2 |
| 2-3 |
4d001043269b4483b3c5abaf3b1c4aa5 |
| 3-2 |
f61c4892dd554e3dac4ac0d5fe0f5e33 |
----------------------------------------------+
5 rows in set (0.000 sec)
Node 1:
MariaDB [mfg]> select * from backend_fixtureprocess;
----------------------------------------------+
----------------------------------------------+
| 1-3 |
blahblah |
| 1-4 |
f19f668c491e4f49a86f4a750dbcf4da |
| 1-5 |
f5dfb550380a4cf9a3f5ba9fc702e7b2 |
| 2-3 |
4d001043269b4483b3c5abaf3b1c4aa5 |
| 3-2 |
f61c4892dd554e3dac4ac0d5fe0f5e33 |
----------------------------------------------+
------------------------------------------------------------+
------------------------------------------------------------+
| replicate_annotate_row_events |
ON |
| replicate_do_db |
|
| replicate_do_table |
|
| replicate_events_marked_for_skip |
REPLICATE |
| replicate_ignore_db |
|
| replicate_ignore_table |
mfg.backend_fixtureprocess |
| replicate_wild_do_table |
|
| replicate_wild_ignore_table |
|
------------------------------------------------------------+
I opened it as blocker because I am unable to continue deployment.
Thank you for reviewing it.
|