[MCOL-593] support columnstore tables as slaves to innodb master tables Created: 2017-02-27 Updated: 2020-03-11 Resolved: 2020-03-11 |
|
| Status: | Closed |
| Project: | MariaDB ColumnStore |
| Component/s: | MariaDB Server |
| Affects Version/s: | 1.0.7 |
| Fix Version/s: | 1.2.5 |
| Type: | New Feature | Priority: | Major |
| Reporter: | David Thompson (Inactive) | Assignee: | Unassigned |
| Resolution: | Done | Votes: | 4 |
| Labels: | documentation, relnote | ||
| Attachments: |
|
||||||||
| Issue Links: |
|
||||||||
| Sprint: | 2019-04 | ||||||||
| Description |
|
Setting up a columnstore table in a slave and replicating to it currently does not work and silently fails. I believe this is because we use master / slave replication in a multi um setup to ensure synchronization of non columnstore lookup tables and columnstore table definitions where we obviously don't want the slave to process any dml since the data is already available. Another challenge is that columnstore does not have a mode to ignore non supported constructs and so most innodb ddl will fail. This could be worked around by precreating the schema. |
| Comments |
| Comment by Andrew Hutchings (Inactive) [ 2019-04-15 ] | ||||||||
|
Patch adds a MariaDB replication option which can be enabled using the following in the SystemConfig section of Columnstore.xml: <ReplicationEnabled>Y</ReplicationEnabled> For QA: There may be issues with multi-UM setups for now. Improvements for this will come later, this is why it is a hidden option for now. | ||||||||
| Comment by Daniel Lee (Inactive) [ 2019-04-22 ] | ||||||||
|
Build verified: 1.2.2-1 nightly [root@localhost centos7]# cat gitversionInfo.txt 1. installed MariaDB Server 10.3.14, set it as replication master After replication has been setup, tables can be setup as the following: 1. stop replication slave in ColumnStore (stop slave) Notes: On Master MariaDB [repdb]> CREATE USER 'replication_user'@'%' IDENTIFIED BY 'bigs3cret'; MariaDB [repdb]> GRANT REPLICATION SLAVE ON . TO 'replication_user'@'%'; MariaDB [repdb]> show master status;
-------------------
------------------- On Slave: update /etc/hosts file 10.0.0.15 repmaster MariaDB [repdb]> CHANGE MASTER TO MariaDB [repdb]> start slave; MariaDB [repdb]> show slave status\G;
| ||||||||
| Comment by YURII KANTONISTOV [ 2020-01-20 ] | ||||||||
|
Tried this feature with MariaDB 10.3.21 innodb as a master and Columnstore 1.2.5(MariaDB 10.3.16) as a slave, simplest 1xUM+1xPM configuration. Replication can be established - both master and slave has pre-created table: master: slave: "CHANGE MASTER TO/start slave/show slave status" commands work smoothly, but when doing very first "insert into xxx values (1);" on the master - ... Will appreciate any hint how to fix it or at least how to investigate it further. |