[MXS-2852] data dependency of the replicated data on the meta data Created: 2020-01-27  Updated: 2020-02-14  Resolved: 2020-02-14

Status: Closed
Project: MariaDB MaxScale
Component/s: N/A
Affects Version/s: None
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Zdravelina Sokolovska (Inactive) Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: HTAP
Environment:

GKE

Issue Links:
Relates
relates to MXS-2846 Binlogfilter: Add syntactic identifie... Closed

 Description   

When rewrite_src matches constant data in the SQL, it also gets rewritten. For example, with rewrite_src=db.tree the data in the following SQL gets modified as the regex matches the data:

INSERT INTO db.tree VALUES (1, 'Cigartree');

Original description and title:

data dependency of the replicated data on the meta data

 
 
MariaDB [(none)]> select list_replications();
 
+------------------------------------------------------------------------------------------------------------------------+
 
| list_replications()                                                                                                    |
 
+------------------------------------------------------------------------------------------------------------------------+
 
|
 
        === replication_filter ===
 
        table: customers
 
        source database: source_customers
 
        target database: target_customers
 
 
 
 |
 
+------------------------------------------------------------------------------------------------------------------------+
 
1 row in set (0.002 sec)
 
 
 
 

MariaDB [(none)]> insert into source_customers.customers values ( 6 , ' source_customers') ;
Query OK, 1 row affected (0.006 sec)

MariaDB [(none)]> insert into source_customers.customers values (7 , ' target_customers') ;
Query OK, 1 row affected (0.005 sec)

MariaDB [(none)]> select * from target_customers.customers ;
-------------------------+

a b

-------------------------+

1 internal_customers
2 external_customers
3 unknown_customers
4 vip_customers
5 back_customers
6 target_customers
7 target_customers

-------------------------+
7 rows in set (1.066 sec)



 Comments   
Comment by markus makela [ 2020-01-28 ]

This is expected behavior with regular expressions. The caveats of this approach of rewriting are described here: https://mariadb.com/kb/en/mariadb-maxscale-24-binlog-filter/#rewrite_src-and-rewrite_dest

Comment by markus makela [ 2020-02-14 ]

Closing as Not a Bug since it's a known limitation of the rewriting mechanism.

Comment by Zdravelina Sokolovska (Inactive) [ 2020-02-14 ]

hi ,
returning the original issue Summary of the ticket , as it was reported in DBAAS and
moving to Incomplete since of the unpredictability
problem character of the data dependency of the replicated data on the meta data
can cause data inconsistency.

Generated at Thu Feb 08 04:17:09 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.