1.We are configuring data streaming from MariaDB TX to ColumnStore in MariaDB AX using Maxscale , BinLog Router, CDC and Avro data.
2.We have MariaDB and Columnstore on one server.
3.MaxScale, CDC Adapter, CDC connector and Columnstore API on another server.
MariaDB [(none)]> select @@version;
> ---------------------------------
> | @@version |
> ---------------------------------
> | 10.5.4-2-MariaDB-enterprise-log |
> ---------------------------------
MaxScale version: 2.5
Software Installed on MaxScale server:
-------------------------------------------
MariaDB-client-10.5.4_2-1.el7.x86_64.rpm
mariadb-columnstore-api-1.1.7-1-x86_64-centos7.rpm
mariadb-columnstore-maxscale-cdc-adapters-1.1.7-1-x86_64-centos7.rpm
MariaDB-common-10.5.4_2-1.el7.x86_64.rpm
MariaDB-compat-10.5.4_2-1.el7.x86_64.rpm
maxscale-2.5.1-1.centos.7.x86_64.rpm
maxscale-cdc-connector-2.5.1-1.centos.7.x86_64.rpm
4. We have successfully created the Master and Slave.
5. The data is not replicated to Columnstore database as the avro files were not generated.
6. The mxs_adapter is failing with the error - 2020-07-23 15:27:04 [test_inno.cdc_tab] MaxScale connection could not be created: MaxScale responded with an error: ERR NO-FILE File 'test_inno.cdc_tab.000001.avro' not found.
mxs_adapter -ucdcuser -pxxxxx -hxxxxxxx -P4001 test_inno cdc_tab