maria-discuss team mailing list archive

[Riz Plate <riz.plate@xxxxxxxxx>]

Hi

I have a very basic scenario, we have one database which is running out of
space.

database have some tables with incremental primary key ids.


1- for new ids , we want to send read/write to new server and preferably ,
do id based statement  routing i.e. if id%2=0 push to new-server1 , else
read/write to new-server2.

2- some tables are created dynamically i.e. dynamic_table_123. we want to
send 123%2=0 to new-server1 else read/write to new-server2.

3- all statements in above #1, #2 should go to same MaxScale abstraction
i.e. application should not have logic for routing.


Can we do this with MaxsScale? what are the configuraion readwriterouter or
the cluster?

Thanks for your insight and recommendations.

Thanks