Hi All
We are looking at setting up a MySQL V5.x cluster. We want to use 3 machines for this(1 Controller and 2 data servers). We have ± 15 Gb of data split over 42 databases. The total data grows by 100 - 200 mb per day and this will increase in the near future. We have 60 - 80 users connecting at the same time and running 300 - 800 qps depending on the day(Thursday and Friday avg. 750 qps) and transferring 1.5 mb - 2mb data per second.
What server hardware should we look at to begin with? I read somewhare that MySQL clustering needs alot of memory, is this true?