Re: 2Q: odd number of nodes; one time queries

[Harrison Fisk]

Hi,

Here are the answers to your questions:

1. The number of data node has to be divisible by the NoOfReplicas setting. Most people set it to 2, which would make the number have to be even. If you set it to 3, then you could have some possible odd values (3,9, etc..).

2. The cluster internally handles all of the distributed locking. So you can read/write data all you want on any data node, without any problems at all. If you were going to update the same row on two SQL nodes, one would wait for the other to commit, just like with normal row level locking.

Harrison Fisk, Trainer and Consultant
MySQL AB, www.mysql.com