I am new to Apache Ignite. Here's what I am curious about: Can I setup an ignite cluster as the frontend proxy to distribute requests based on some data column like tenantID, to mysql instances where each mysql instance holds data for single tenant?
Just to make it clear, it is pretty much like a proxy to multiple database instances with same table. So I could save single tenant data into an isolated database.
It's possible two approaches:
You could implement a custom cache store implementation[1] that uses the right connection depending on the record's attribute.
You could use tenantId as affinity key to map records with the same tenantId to the same partitions. Also a custom affinity function[2] allows to map partitions to corresponded nodes marked with some attribute[3]. On each node the cache store configuration[4] could use a datasource to a concrete mysql server based on node attribute.
You can also just use the default cache store implementation, just pass a different data source to each node. It is taken from local Spring container typically.
In this case, every node will only talk to a local MySQL, leading to the consequence that every MySQL only holds data of one node, and then you can configure the distribution via Ignite's facilities.
I have not tried this, but it may be sound.
