maria-discuss team mailing list archive

[Justin Swanhart <greenlion@xxxxxxxxx>]

Hi,  

Galera is a higher availability, not a sharding system.  You can use spider or shard-query to handle transparent sharding.  Spider is a storage engine and does most work in a single thread.  Shard query is MPP and executes sort, join and group operations in parallel, but joins between shards are not possible unless you use sub queries in the from clause.

Sent from my iPhone

> On Jan 3, 2014, at 11:50 AM, AskMonty KB <noreply@xxxxxxxxxxxx> wrote:
> 
> Hello,
> 
> A new question has been asked in "MariaDB FAQ" by pranava:
> --------------------------------
> I have some questions on Maria DB Galera Cluster.
> 
> Q1) If I partition a table in a schema which is part of MariaDB Galera Cluster, can i configure partitions in such a way that a one partition resides in one Node, another partition resides in second Node and so on? I'm trying to shard the data and use Galera cluster nodes to accommodate parts of that shard.
> 
> Q2) Scenario - During replication of MariaDB Galera Cluster, the Master node gets a request, it processes it and then sends to other nodes for approval, followed by a commit at every node. What if commit happens on majority of nodes except one or two? What happens to that transaction and how about Data consistency among all nodes?
> 
> Q3) Which protocol is used for communicating between nodes during data replication in MariaDB Galera Cluster? Is it TCP or a Broadcast to all other nodes or Some customized protocol between nodes that enables replication in the cluster.
> 
> Thanks a lot in advance. 
> 
> Thanks
> Pranav.
> --------------------------------
> 
> To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-galera-cluster-questions/
> 
> _______________________________________________
> 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