This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-17. For the latest, interactive version please visit https://mariadb.com/kb/.

Can MaxScale proxy to MariaDB_ColumnStore

Hi community !

My question is - can i realise the following scenario with MaxScale? Client send an INSERT or UPDATE to the database (which is a classic relational db). Then when MaxScale catch the statement, it should execute the statement (ie write to db) as well, as creating a new statement (or nor necessary, maybe there are some mechanisme existing for these purposes) to write/add a new line to another database (in my case I think i would use MariaDB_ColumnStore). Can MaxScale work at the same time with both, relational and ColumnStore databases?

Answer Answered by Markus Mäkelä in this comment.

The mariadb-maxscale-22-tee-filter is probably quite close to what you would like to do. It duplicates the statements executed on one server to another one.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.