Today’s a MySQL day. After the shocker that is Microsoft Licensing I decided to seriously look at what MySQL has to offer the enterprise. I read their white paper and thought something sounds too good to be true. So I spent half an hour on the phone with someone in their enterprise team.
Let’s go look back at what started this. We have a Microsoft Enterprise Agreement (EA) and have Software Assurance (SA). This gives up an open catalogue of Microsoft products that we can install and then report our usage at the anniversary of the agreement. The year before last we had 22 virtual CPU’s in use across 10 virtual servers, running on 4 physical servers each with 2 CPU’s and each CPU with 6 cores.
We run Microsoft SQL on our VMware estate so we can make use of the virtual features, in particular High Availability.
Last year nothing changed. Same servers, same CPU’s, same number of virtuals etc. But suddenly we were doing it wrong. Microsoft initially allowed us to use one SQL Enterprise license and treat it as 16 cores to run on our virtual estate and allocate them as a minimum of 2 virtual CPU’s per virtual server. Last year that changed, we now find that when we allocate cores to a virtual machine it must be done as a minimum of 4 virtual CPU’s per virtual server. Some servers that meant nothing to, as we’d allocated 4 virtual CPU’s. But we have quite a few lightweight servers that we allocated only 2 virtual CPU’s to. This now means that their license overhead is double what we’ve allocated! That means Microsoft doubling the license cost per server, when NOTHING has changed!
Add to this that we use High Availability and migrate systems between 4 hosts we have few choices. Accept double the cost of the affected servers,by buying more cores – so we’ll probably need another 12 cores, or buy enough cores to cover all the physical servers we have (48 cores) and then be able to allocate ass many cores as we like to the virtuals!
Or heaven forbid, we reduce the number of physical hosts that the virtual machines can run on to only 2 of the 4 physicals, and reduce it so we need only 24 cores for those 2 physical servers. Now this would be very short sighted, the virtual estate is due for a refresh next year. If I buy 4 new servers, chances are I’d aim for dual CPU’s with 8 or 12 cores each. This would then mean I could only run all our current Microsoft SQL servers on ONE server!
One way or another Microsoft make a shed load more cash for supplying us with NOTHING extra! No wonder you see the spelling of Micro$oft with a dollar sign so often!
I’ve been a long term user of MySQL for Open Source projects and personal use, so a call to MySQL was in order. Not to make an immediate replacement, but to begin a strategic business decision that will not put us at the mercy of software licensing rules that can impact on our budgets whilst delivering no extra value. The outcome was shocking.
The MySQL licensing model is so significantly different that it makes it a no brainer. You pay only for the physical server you run the software on – up to 4 physical CPU’s per physical server. That’s it!
No extra cost for how ever many cores you have, in up to 4 physical sockets. So 4 CPU’s with 12 cores = same price!
That’s $5,000 per physical server, per annum. To me that’s capping my budget at $20,000 per year to run as much as I like, however I like, on all four of the physical VMware hosts we run. It includes upgrades, there is no SA required for HA, just keep paying your annual subscription and it’s an all you can eat buffet.
The annual subscription price of a MySQL Enterprise license includes, support and consultancy, a monitoring tool, hot backups and all features including clustering and replication as you like. No license confusion about Active/Passive, Active/Active clusters
Not just the server costs, but there are NO Client Access Licenses (CAL’s)! I don’t need to pay per user or workstation to use it. I don’t need an MSDN subscription to be able to use a development server.
Trouble is it’s not going to happen overnight. The reality is that when we go out in search of a CRM, finance, payroll or document management system those that support MySQL will be given a significantly higher score rating within our tender process than those that require Microsoft SQL – how can I not? Using Microsoft means I can’t remain in control of my budget, they could change the rules again and overnight I’m facing a price hike.
Add to that MySQL runs on Windows AND Linux. I’M SOLD.
By way of follow up this is what I received from MySQL following my call with them:
It was good to chat with you earlier and in follow up to our call I have put together some information which may be of further help.
MySQL is available as a Subscription for on-premise requirements and as discussed we also have Oracle MySQL Cloud Service
MySQL Enterprise Subscription is priced per physical server and we have 2 parameters
1-4 socket server and 5+ socket server
MySQL Enterprise Subscription, includes our advanced features, like Enterprise Monitor, Enterprise Back up, Security ( Enterprise Firewall; Encryption; Audit; Authentication) scalability and High
Availability in conjunction with Technical support and consultative support our proactive support option.
The price per server is £4,020 /year
Please see links below
https://www.mysql.com/products/enterprise/
https://www.mysql.com/support/consultative.html
https://www.mysql.com/customers/migration/
Oracle MySQL Cloud Service
MySQL is available on the Oracle cloud in a non-metered option for PAAS and IAAS
PAAS – is priced per OCPU and RAM
An OCPU provides CPU capacity equivalent of one physical core of an Intel Xeon processor with hyper threading enabled. Each OCPU corresponds to two hardware execution threads, known as vCPUs.
Compute Cloud service is IAAS
I have included the link below to give you a view on the pricing
https://cloud.oracle.com/en_US/mysql/pricing
LikeLiked by 1 person
Hi, I’m trying to confirm whether or not MySQL licenses are required for all servers in a cluster where vMotion is active? For instance, if there are 14 servers in a cluster and MySQL instances could vMotion to any of those servers, do I need to license all of them? The only information I’ve been able to find is license per physical server, but I’ve found nothing that discusses this.
LikeLike
It depends what your need is. If you use the community edition then no licenses are required. You can use as many processors as you like across how ever many servers and instances you want.
If you want the enterprise version then you license it based on the number of physical processors. So in a single VM host you could have 4 CPU’s with 12 cores and still only pay one enterprise license for the entire physical host! Seems crazily cheap if you looks at other licensing models.
It doesn’t really care about vMotion either. If you’re running all instances on only one of the VM hosts then it’s one license. It’s only if you have several instances and want to spread them over physical hosts that you need to license each physical host that it actively runs on.
Even then it’s only £5k per VM host. I can’t install a single instance of MSSQL onto a VM host for that! I need an SA license covering every core that the instance “could” use and must allocate a minimum of 4 core licenses per instance!
But drop MySQL a line and they will call you and they are super helpful and not at all sales pushy. I just wish we had more corporate systems that would actually use MySQL.
LikeLike
0 Pingbacks