My current database software is using MySQL Server 5.1 and MySQL tools 5.0 for a mixture of InnoDB and MyISAM tables. I have a new Windows 2012 server. Should I install the same software for the database? If not, what should I install?
I see two version of the database now: MySQL Community Server (MySQL Community Server is the world’s most popular open source database) and MySQL Cluster (MySQL Cluster is a real-time, open source transactional database). What’s the difference?
I would stick with the Community Server. The other version is more complicated and needs two servers.
It is more for scalability if you need to have a huge server set up and need redundant backups. Here is the way it is worded on one site I was reading:
The difference is that MySQL Cluster includes the NDB storage engine.NDB stores data not on the same server where the MySQL service runs, but instead stores data among multiple servers, for the purposes of scalability and high availability. NDB reads and writes data across the network on demand.
Otherwise it’s more or less the same as MySQL Community Edition.
So, what that says is basically if you have a huge server, you can use the NDB and store copies across many servers. This would in effect give a better response when the site demand is high. (At the cost of copying the data across many servers.) If you get to a point where you need this version, you will have already hired a networking specialist on your payroll. LOL…
Hope that helps…
Thanks