MySQL Cluster Casual Talks
On last Thursday, I attended the event. It was first time for me to attend the event related MySQL. The atmosphere was casual and relax but the contents were interesting and helpful.
Let me share my feedback here.
By the way, at this time the details mainly refer to the version 7.3.
Full ACID properties support
No SPOF, good for DR because it can be composed of nodes across data centers and so on, they mentioned and emphasized some good points of it.
But just for me the full ACID support can be the key feature as a distributed product. for MySQL guys it seems natural thing but I think MySQL Cluster can stress the ACID support more if compared to other distributed system.
Strict limitation of the scale out
An expert said, MySQL Cluster can have 48 nodes as the SQL node and also 256 as the data node at the most.
I was surprised with the strict number. as far as I know all the other distributed system doesn't have such a concrete number of limitation. I'd like to check the reason of it later.
Notes from experience with MySQL Cluster for 4 years
Another expert gave presentation based on his experience. It was very informative for me. That kind of topics will never be written in the white paper.
If GCP (Global Check Point) stops, your system severely damaged. Adjust the threshold for it.
Data node rolling restart is enable, but if you do it without service out, you must consider a plan for coincident errors during the restart in advance.
Hard to locate bottleneck. It seems to me that any distributed system requires monitoring system to be maintained.
Take care of data life cycle. For instance, if 'DELETE' data to make spare memory space without restating the data node, the spare will reuse only for the same table.
NDB has online backup function, but recovery data with it will be very slow.
An attendee asked some questions. One of them is very interesting for me.
Q. How can we design data schema for NDB storage engine ? Or can we reuse data schema for InnoDB to it ?
A. There’s only one way to find out. :p
Anyway, there is no silver bullet. Just demonstrate it and go for yourself!
Before decide to go with MySQL Cluster, do consider MySQL.
At the last, I'd like to thank all the community member involved and GMO guys. I had good time in the event. Thanks so much !