MariaDB

Sharding support in MariaDB

Asked by Gopal Annasundaram

Hi,
         I'm looking for a scale-out open source DB solution. Does MariaDB support sharding? Though MySQL has one called clusters, with ORACLE ownership of MySQL I'm hesitant to go for it.

Appreciate your response.

Thanks

Question information

Language:
English Edit question
Status:
Answered
For:
MariaDB Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Arjen Lentz (arjen-lentz) said : 		#1

MariaDB does not offer a specific cross-db sharding feature directly.

It's generally possible to design and build your application in such a way that it enables sharding.
Different sharding options are possible, such as functional sharding (different tasks using different datasets) as well as sharding of bigger dataset by some other attribute (different clients, time, etc).

As you can see this requires a level of insight into the structure of the application that the database itself cannot have.
But with foresight, it's relatively easy to deal with it in the application logic, or a specific lower layer in the app.

Regards, Arjen.
Exec.Director, Open Query

Can you help with this problem?

Provide an answer of your own, or ask Gopal Annasundaram for more information if necessary.

To post a message you must log in.