maria-discuss team mailing list archive

[l vic <lvic4594@xxxxxxxxx>]

I don't have requirements that specific, It's more like i am looking for
solution to manage(scale) large size datasets for  MariaDB/ Galera
clusters...

On Wed, Oct 5, 2016 at 4:05 PM, Justin Swanhart <greenlion@xxxxxxxxx> wrote:

> 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
>
>
> _______________________________________________
> 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
>
>