0

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

  • What do you mean with capacity? If you mean database sizes, there is no limit. – ypercubeᵀᴹ Jun 26 '14 at 9:27
  • @ypercube, I mean to say capability to handle workload. Currently, some of my queries includes multiple tables getting very slow (this tables are well normalized and properly indexed as per EXPLAIN) – Manish Sapkal Jun 26 '14 at 11:25
  • In most of databases/workload I've ever seen hardware was the limiting factor, not MySQL itself. – akuzminsky Jun 26 '14 at 14:25
1

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.

  • Community and Enterprise editions are identical indeed. – akuzminsky Jun 26 '14 at 14:23
1

When it comes to capacity, all your constraints start with Amazon RDS, not MySQL. Why ?

I have posts about MySQL in Amazon RDS

Your main bottlenecks for RDS are

  • Transaction Log size (always 128M and immutable across all server models)
  • Maximum number of connections (set per server model)
  • Buffer Pool Size (set per server model)

Either go to EC2 or bare metal server. That way you can be a little more liberal in configuring MySQL.

You should go with MySQL Community version thereafter.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.