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,