MySQL Community Edition Capacity

amazon-rdsMySQLmysql-5mysql-5.5

I am using MySQL Community Edition on Amazon RDS service. It is a very large database, 2/3 tables has about 10 millions records and 4-5 tables has 7-8 millions records.

Questions

  • How much capacity does MySQL Community Edition have?
  • Should I have to purchase MySQL Enterprise Edition for my application?
  • Where can I get pricing information for the same?

Thanks

Best Answer

The server core is similar (identical?) on the GA and Standard Edition (SE)/Entreprise Edition (EE). What you're getting with SE/EE is stuff like (from here) 

MySQL Partitioning
MySQL Enterprise Backup
MySQL Enterprise Monitor
MySQL Enterprise HA
MySQL Enterprise Scalability
MySQL Enterprise Security
MySQL Enterprise Audit

You also get support and some access to goodies on Oracle's MOS (My Oracle Support, used to be Metalink). You can tell your PHB - "look, if anything goes wrong, at least _you_ won't be blamed!".

The funny thing is that many of these "enterprise" solutions are available from open source contributors in various guises, and I for one am convinced that it's possible to have at least an entreprise standard setup using only Open Source components. With the advent of WebScaleSQL, that situation could move up to carrier grade.

As for pricing - see here, it's basically $2.000 (Standard), $5.000 (Enterprise) or $10.000 (Carrier grade) per year. See the features table for a comparison.

Related Question