Posted by Vic_ on April 2, 2013 at 2:28am
Hi Guys
I am looking for a system where I can cluster MySQL. I saw an article which guided me to custom Drupal schema for NDBCluster engine for MySQL clustering, Btw. I am using Drupal 7 with Varnish, memcache etc.
And I also saw another solution for clustering MySQL using Galera Cluster
(MariaDB and Percona also uses this for Clustering) Scaling Drupal stack with Galera)
The reason why I need a cluster is because my fields are over 8 kilobytes There will be a minimum of 15.000 Users visiting the site at the same time.
What would you guys think would be the most optimal solution? for this ?
what is the performance expectations?
Comments
If the issue is that you have
If the issue is that you have large fields, then I don't think a "cluster" will really help too much. The types of clustering you're referring to is really adding complexity to try and improve write performance. If you're trying to improve reads with big fields, you could just use MySQL slaves or maybe even something like EntityCache with Memcached.