Andrew, can you define massive installation?
I need to move from MySQL Cluster to a normal InnoDB implementation. Currently we have around 20M impressions day, running on 6 large webservers(32core/90GB ram, SSHD) and 4 nodes MySQL cluster(32cores/96GB), where data nodes use raid 10 on SAS disks. Obviously, it is too much power for 20M.
To keep delivery smooth I am thinking about 1 or 2 Web and 1 DB server, just not sure about whether use or not distributed statistics, also MariaDB is in the board.
Currently delivery DB stats are: 1.2K inserts/sec, 200 select/sec
Can you guys give me your thoughts about distributed stats and MariaDB?