CODEWITHSUNDEEP
mysql
Vijay Gharge
Vijay Gharge

Reputation: 57

Utilizing 5 physical servers in 1 cluster

I have 5 physical servers with low end memory & cpu resources. I want to create 1 cluster using all these servers and want to run mysql db on the same such that mysql db would utilize 5 server's CPU power to execute db queries & same for memory. Could you please help me understanding how to achieve this?

Regards,

Upvotes: 1

Views: 87

Answers (2)

staticsan
staticsan

Reputation: 30555

MySQL doesn't scale up like that. The only effective way to scale up MySQL's performance is more memory.

However, if you have the resources to re-tool your application and your database will partition well at the table level, then it's possible to have your app connect to multiple databases depending on what tables it needs. You basically will want an ORM layer (such as Hibernate) that can be taught to associated an object's table with a particular database.

Upvotes: 0

Chase Seibert
Chase Seibert

Reputation: 15851

You should be aware that MySQL clustering is primarily for availability, not performance. With low end servers, your performance will not be nearly as good as one server with the same aggregate cpu/memory resources.

Upvotes: 1

Related Questions