Feeds

MySQL – is this database fit for the Enterprise?

Part 2: Carving a niche

Top 5 reasons to deploy VMware with Tegile

MySQL has recently appeared as an Enterprise edition. We have already looked at whether MySQL (the company) is enterprise ready, but we can also ask whether the product itself is suitable for enterprise use.

Some Reg Dev readers clearly have strong views about this already.

First up, remember that Enterprises come in all kinds of shapes and sizes. In the UK, 58.7 per cent of employed people (2005 figures) work for what we Brits call SMEs (Small and Medium sized Enterprises). The US has different definitions (see the SBA site).

Irrespective of the exact definition, MySQL can, quite clearly, compete effectively in the small enterprise space – which means it can already service nearly 60 per cent of the working population.

As an example, I talked to John Dyson, the IT director at First B2B. This is a new technology company that essentially manages messaging between other companies. Company A needs to send a message in CSV format to company B which needs it in EDI. First B2B receives the message, converts it to XML, stores it, and then forwards it in the correct format.

First B2B has a database of 24GB which runs on a four processor box with 2 GB of RAM. In the past, it used Progress as its database, but has now switched to MySQL and is very happy with the result.

Dyson said: "The support is excellent; indeed it is the best support I have ever known. The guys on the support desk are very quick and very knowledgeable."

He is also a major fan of MySQL's Monitoring and Advisory service: "It doesn't just highlight the problem, it will supply methods of how to fix it. It has made a significant improvement in the performance of some of our slower queries."

OK, so small enterprises can use MySQL very effectively. What about large ones?

Well, the classic way to answer that question is to quote a customer list. MySQL has a list that is long and distinguished, which is fine, but you have to bear in mind that it is just a list of the enterprises that use MySQL somewhere. It is not a list of the enterprises that use MySQL exclusively. It is certainly not a list of large enterprises that formerly used Oracle, took a look at MySQL, found it was great, threw Oracle out the door, replaced all of their Oracle installations with MySQL, saved quadrillions of dollars per year, and lived happily ever after.

The real picture is that many large enterprises that still rely on traditional database engines (such as Oracle, DB2 – and even SQL Server) to run their mission critical systems, are starting to try out MySQL. They use it for small applications, at the departmental level, for the newer web-based applications – in other words, in all sorts of innovative ways that are well suited to MySQL's particular strengths. But they are not yet using it for the "traditional" enterprise database application workloads.

How can I be so sure of this? Because I'm quoting Steve Curry, the director of corporate communications at MySQL who really ought to know:

"I think we'll all agree that MySQL is not a 'traditional' enterprise database - we never have been and aren't trying to suddenly become one now.

"We don't compete head-to-head against Oracle, DB2, Teradata, etc. If users are looking to build that type of higher-end data warehouse/OLTP/client-server application, then they've probably selected one of the traditional vendors or one of the open-source alternatives that are trying to directly emulate them. That's just not us - we're carving out new, different ground that is not based on replacing existing applications but creating new complementary online ones."

So, am I saying that MySQL is not, and never will be, a traditional, mission-critical, enterprise database engine? No, certainly not. What MySQL (the company) is doing is very, very smart. It has done a great job of establishing the product in a niche market which includes SMEs and departmental use in large enterprises. With the new tools and support options, it has laid the foundations which will allow for further expansion into the enterprise. What it will now do is further develop the product and wait for further adoption.

Curry said: "What we believe is that today's web technologies like LAMP, AJAX and Ruby will become tomorrow's enterprise infrastructure. So, we have come out with a 'MySQL Enterprise' subscription to help those companies who may need some help/support/risk management instead of relying on their own MySQL DIY hacker/guru types."

Although neither company will thank me for the comparison, this reminds me of the route that SQL Server started upon 10 years ago.

Remember SQL Server 6.5? It was a dog. When 7.0 arrived, it was a revelation – a completely different product; but its reputation preceded it, barking all the while. So Microsoft bundled all manner of excellent analysis tools in the box. Many large enterprises started to deploy SQL Server, not for the engine, but for the analytical capabilities. SQL Server got its foot in the enterprise door. After 10 years that foot has booted out innumerable Oracle installations and SQL Server is now one of the big three.

MySQL is starting out along the same track. I don't think that it's currently "enterprise ready" in the sense of being a direct replacement, throughout an organisation, for one of the big three. But it is ready for deployment in small to medium sized enterprises and at the departmental level in large enterprises. It already has that crucial foot in the door and this new edition gives it some kicking potential. ®

Security for virtualized datacentres

More from The Register

next story
PEAK APPLE: iOS 8 is least popular Cupertino mobile OS in all of HUMAN HISTORY
'Nerd release' finally staggers past 50 per cent adoption
Microsoft to bake Skype into IE, without plugins
Redmond thinks the Object Real-Time Communications API for WebRTC is ready to roll
Microsoft promises Windows 10 will mean two-factor auth for all
Sneak peek at security features Redmond's baking into new OS
Mozilla: Spidermonkey ATE Apple's JavaScriptCore, THRASHED Google V8
Moz man claims the win on rivals' own benchmarks
Yes, Virginia, there IS a W3C HTML5 standard – as of now, that is
You asked for it! You begged for it! Then you gave up! And now it's HERE!
FTDI yanks chip-bricking driver from Windows Update, vows to fight on
Next driver to battle fake chips with 'non-invasive' methods
DEATH by PowerPoint: Microsoft warns of 0-day attack hidden in slides
Might put out patch in update, might chuck it out sooner
Ubuntu 14.10 tries pulling a Steve Ballmer on cloudy offerings
Oi, Windows, centOS and openSUSE – behave, we're all friends here
prev story

Whitepapers

Why and how to choose the right cloud vendor
The benefits of cloud-based storage in your processes. Eliminate onsite, disk-based backup and archiving in favor of cloud-based data protection.
Getting started with customer-focused identity management
Learn why identity is a fundamental requirement to digital growth, and how without it there is no way to identify and engage customers in a meaningful way.
Reg Reader Research: SaaS based Email and Office Productivity Tools
Read this Reg reader report which provides advice and guidance for SMBs towards the use of SaaS based email and Office productivity tools.
Saudi Petroleum chooses Tegile storage solution
A storage solution that addresses company growth and performance for business-critical applications of caseware archive and search along with other key operational systems.
Internet Security Threat Report 2014
An overview and analysis of the year in global threat activity: identify, analyze, and provide commentary on emerging trends in the dynamic threat landscape.