Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have created a MYSQL cluster using network speed 100-megabit Ethernet

  • 2 Data Node (3G RAM)
  • 1 Management Node (3G RAM)
  • 2 SQL Node (3G RAM)
  • 2 HAProxy with heartbeat cluster to balance between SQL Nodes

and I have created a separated MYSQL server (3G RAM)

I want to compare between this two MYSQLs and prove that MYSQL cluster is the best

I searched on the Internet for a big database and found (4 million row) link and exported on the two MySQLs

I was surprised when I started testing quires the MYSQL server speed than MYSQL cluster, is this normal? and how to compare?

share|improve this question

closed as unclear what you're asking by Mark Storey-Smith, Phil, Max Vernon, Michael - sqlbot, Kin Jul 22 at 18:43

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question.If this question can be reworded to fit the rules in the help center, please edit the question.

    
I am sorry I posted this question on serverfault I didn't know there is dba.stackexchange.com –  motaz Jun 28 at 18:40
    
"MYSQL cluster is the best", - MySQL cluster is not the best. It's different. And if it's not obvious it's better to stick with MySQL server. –  akuzminsky Jun 28 at 19:08