maria-discuss team mailing list archive

[Justin Swanhart <greenlion@xxxxxxxxx>]

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@xxxxxxxxxxx> 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@xxxxxxxxxxxxxxx> 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@xxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx
>>>> Unsubscribe : https://launchpad.net/~maria-discuss
>>>> More help   : https://help.launchpad.net/ListHelp
>> 
>> 
>> 
>> _______________________________________________
>> Mailing list: https://launchpad.net/~maria-discuss
>> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
>> 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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp