asked on

MariaDB Xpand

hi,

I studied about MariaDB Xpand, the new distributed SQL for MariaDB and serve the same purpose as Oracle ASM.

any the same component on MySQL and Percona PXC ?

only MariaDB Enterprise offer MariaDB Xpand ?

David Favor

This appears to be a MariaDB-ism, so only from MariaDB.

Suggestion: Before setting this up, open a 2nd question discussing your data access pattern + what you hope to achieve by using multiple database instances.

Ask other EE'ers how they've solved similar problems in the past.

ASKER CERTIFIED SOLUTION

Tomas Helgi Johannsson

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

marrowyung

ASKER

David,

This appears to be a MariaDB-ism, so only from MariaDB.

tks. but what I am concerning is, I haven't touch MariaDB for a while and this is the key component I can see MariaDB is improving further.

so I;d like to compare with MySQL and PXC if sth close also come with MySQL and percona, this is what about this post is.

Tomas ,

Oracle ASM is more like the Spider Engine thus only a Storage Volume Manager. Xpand includes distribution of the SQL engine while Oracle ASM lacks SQL handling capability.

Xpand is good on SQL handling and this looks like the PROXYSQL for PXC, SQL native!

So by this, it seems XPand is even better than ASM, right?

runs it against the data stored on the node and returns the result to the master node that collects all parts of the distributed SQL from each node and finally returns the result to the client.

yeah.

and I;d like to see if MySQL and PXC has their component function like that.

marrowyung

ASKER

tks all.