sql compatibility with sharding[schemarouter]

[HUI LIU]

I want to know what sql are supported with sharding in maxscale, but there is nothing about it in documentation.

[Markus Mäkelä]

Hi,

There's no limit to the SQL that's supported as long as MaxScale is able to identify which tables are being used by the query. The main limitation is that cross-node queries are not supported as the queries will eventually be sent to only one node. This is what the documentation says:

The main limitation of SchemaRouter is that aside from session variable writes and some specific queries, a query can only target one server. This means that queries which depend on results from multiple servers give incorrect results. See Limitations for more information.

Markus

On 1/17/24 10:51, HUI LIU wrote:

I want to know what sql are supported with sharding in maxscale, but there is nothing about it in documentation. --
You received this message because you are subscribed to the Google Groups "MaxScale" group.
To unsubscribe from this group and stop receiving emails from it, send an email to maxscale+u...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/maxscale/e99884e1-c727-4dec-87e6-44028eb4b776n%40googlegroups.com.

-- 
Markus Mäkelä, Senior Software Engineer
MariaDB Corporation