Link to home
Start Free TrialLog in
Avatar of luigidenaro
luigidenaro

asked on

Should I use Mysql Cluster for an application with High mysql concurrent connections?

Dear Experts,

Actually I have a mysql database where I record user website visits statistics (like google analytics).
This database is experiencing a high volume of concurrent connections and it's killing my Dedicated Server, I also have a java chat application on the same server which is affected for the CPU consummed for this Statistics Database.

Im planning to move this Database to a separate Dedicated Server but I want to think ahead on growing and I thought on create a mysql cluster for this database.

You should know I have a diarly cron process that totalizes all tables into smaller ones and my clients consult this information in real time.
Also my java chat application is the one that writes this database then I need high availability and low resources consumption.
 
I need your advice on this, Im doing right thinking on mysql cluster? There is another better alternative for the solution Im looking for?

Thx and Regards,
Luis Rinaldi.
ASKER CERTIFIED SOLUTION
Avatar of dpearson
dpearson

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of dpearson
dpearson

I should also have mentioned that today there are companies offering products that will support automatic sharding of MySQL.  But I'm assuming you're looking for non-commercial solutions?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of luigidenaro

ASKER

Thx For ur comments, Im not looking For a not comercial solution, but I preffer to don't change The dB engine to avoid changing my app programming, what product do You know with automatic sharding support?
I'm not personally aware of anyone doing automatic MySQL sharding outside of commercial solutions.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
And do you know any recommended commercial solutions I can use?

Thx and Regards,
Luis Rinaldi.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial