MySQL Cluster Performance

MySQL & MariaDB Other MySQL® Questions
1

Hello,

I am looking to move my current architecture to MySQL Cluster 7 to achieve better performance for web application for read and write.
I know data is partitioned on primary key basis. Can anyone help me to know how is the performance to select data from multiple partitions ?

Let suppose i have one table having 3000 records and data is partitioned on primary key basis in such a way
partition A 1-1000 records
partition B 1000-2000 records
partition C 2000-3000 records

when i query from SQL Node How is performance for the queries and how those queries going to be handled by transaction coordinator.

SELECT * FROM table WHERE id BETWEEN 1 AND 1000; (partition A)
SELECT * FROM table WHERE id BETWEEN 500 AND 1500; (partition A & B)
SELECT * FROM table WHERE id BETWEEN 500 AND 2500; (partition A,B & C)

Thanks in advance.

2

You should search the web for the various “what is Cluster good at” articles and white papers. The limitations are well documented and explained. Cluster is special-purpose, not general-purpose. Your use case might not even be suitable for it.