What are your sharding requirements?

Do you plan to report or aggregate the data across shards?  Do you need parallelism when accessing more than one shard (or more than one partition in a table)?  Do you need to push down aggregation, filtering, and joins?  Joins between sharded and un-sharded tables?  Consider using Shard-Query if you answered yes to any of those questions.  

Otherwise you should probably consider MySQL Fabric for pure OLTP sharding if that meets your requirements.

In any case, a shard would be three or more servers in a synchronous replication architecture.  It is usually possible to use master/master replication for un-sharded tables, and you could need to use this "on top of" the sync replication clusters if needed, for un sharded (replicated on all nodes) tables.

Note: I'm the author of Shard-Query.  

Sent from my iPhone

On Oct 5, 2016, at 3:47 PM, Markus Mäkelä <markus.makela@mariadb.com> wrote:

MaxScale does have a simple sharding module: https://mariadb.com/kb/en/mariadb-maxscale-14/maxscale-routers-schemarouter-router/

Markus

On 05/10/16 22:36, l vic wrote:

Isn't Maxscale a loadbalancer? Failed to see how you'd use it for db sharding.

On Wed, Oct 5, 2016 at 3:19 PM, Karthick Subramanian <ksubramanian@paycommerce.com> wrote:

Instead of using Vitess, can't we use maxscale? 

Can anyone provide me comparision of Vitess Vs Maxscale. Thank you. 

On Wed, Oct 5, 2016 at 11:21 PM, l vic <lvic4594@gmail.com> wrote:

I wonder how to use sharding with symmetric replication... Does that mean I have to partition every database instance? Does it work with third-party tools, like Vitess (http://vitess.io/)?

Thanks

_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to     : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp

_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to     : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp

-- 
Markus Mäkelä, Software Engineer
MariaDB Corporation
t: +358 40 7740484 | Skype: markus.j.makela 

_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to     : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp

_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to     : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp