Details
-
Bug
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Not a Bug
-
10.4.13
-
None
-
CENTOS 7
Description
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;
----------------------------------------------+
fixture_name | process_id |
----------------------------------------------+
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;
----------------------------------------------+
fixture_name | process_id |
----------------------------------------------+
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;
----------------------------------------------+
fixture_name | process_id |
----------------------------------------------+
1-3 | blahblah |
1-4 | f19f668c491e4f49a86f4a750dbcf4da |
1-5 | f5dfb550380a4cf9a3f5ba9fc702e7b2 |
2-3 | 4d001043269b4483b3c5abaf3b1c4aa5 |
3-2 | f61c4892dd554e3dac4ac0d5fe0f5e33 |
----------------------------------------------+
------------------------------------------------------------+
Variable_name | Value |
------------------------------------------------------------+
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.