MySQL adds subsecond failover

Daily Newsletters

Sign up to ZDNet UK's daily newsletter.

NEWS

MySQL plans to announce a higher-end addition next month that will allow more than one instance of its open-source database to take over if another fails.

The software, MySQL Cluster, is based on software called NDB Cluster that telecommunications equipment maker Ericsson developed, and then sold to MySQL in October. MySQL plans to announce the new version at its user conference from 14-16 April, said Zack Urlocker, vice president of marketing for the Swedish company.

So-called high-availability software -- which can be databases, operating systems, application servers and other packages -- works by monitoring multiple versions on a network. If one instance fails, another takes over in a process called "failover".

"For business-critical applications, it'll provide subsecond failover," Urlocker said, referring to the delay between the first system crash and the second system picking up the load. The technology has been demonstrated to work with a cluster of 32 nodes protecting each other, the company has said.

MySQL is one of a handful of open-source database programs that some analyst firms expect to become mainstream products in coming years, pressuring proprietary database sellers such as IBM, Oracle and Microsoft. Adding higher-end features is part of a plan by MySQL to better compete with those established players, which already support clustering.

Another new feature being added to move MySQL closer to the mainstream is support for predefined programs called stored procedures. That feature is included not only in commercial databases, but also in rival open-source databases including PostgreSQL and Firebird.

Stored-procedure support is included in MySQL version 5, a program currently in early testing, Urlocker said.

MySQL was able to add the stored procedure support by re-implementing a version of the technology used in another database program the company develops and sells, MaxDB, through a partnership with German software giant SAP, Urlocker said.

Although MySQL is moving features from MaxDB to the MySQL software and is making MySQL a certified foundation for SAP's business software, the company doesn't plan to phase out MaxDB. "We'll be supporting that for 10 or 15 years," Urlocker said.

Also at the MySQL conference in April, the company plans to announce a program to make it easier for "value-added resellers", or VARs, to work with the database company, Urlocker added. VARs typically incorporate one company's technology into a larger offering, often customised for a particular customer segment.

Through the program, it will be easier for VARs to create packages that can use a variety of database programs -- from MySQL, IBM, Oracle, Microsoft or others. It also will let them dovetail with MySQL without having to sign a commercial licence to use a proprietary version of MySQL's software, Urlocker said.

MySQL uses a dual-licence philosophy under which it releases its software under the open-source General Public License for incorporation into other open-source software or under a commercial licence for incorporation into proprietary software.

MySQL Chief Executive Marten Mickos plans to tout his company's dual-licence model at the Open Source Business Conference in San Francisco on Tuesday.

Post your comment

In order to post a comment you need to be registered and logged in.

You can also log in with Facebook. Log in or create your ZDNet UK account below

  • Login

Will not be displayed with your comment

By signing up for this service, you indicate that you agree to our Terms and Conditions and have read and understood our Privacy Policy. Questions about membership? Find the answers in the Community FAQ

Get ZDNet UK's daily newsletter

Enter your email address to sign up

ZDNet UK Live

kevinmchapman

"the very significant number of users" and "many (most) of us" - you have no evidence for these statements. It is a fact that most users are saying...

4 hours ago by kevinmchapman on A tale of two distros: Ubuntu and Linux Mint
Marg Menzies Harrison

Another grammar faux pas is the improper use of "you". When sitting down down in a restaurant, for example, I get cringe when the waitress...

6 hours ago by Marg Menzies Harrison via Facebook on 10 flagrant grammar mistakes that make you look stupid
zdnetukuser

And NOW, folks, for Canonical's next trick... Kubuntu is late. Here's a pencil. Draw your own conclusions. cf.:...

7 hours ago by zdnetukuser on Linux Minterface
Moley

@kevinmchapman. The discussion here reflects the very significant number of users who really do like the traditional menu system and who wish to...

9 hours ago by Moley on A tale of two distros: Ubuntu and Linux Mint
kevinmchapman

Er, no... It is an efficient means of finding the application/file/setting you need in one place. The icons are a simply a fallback for when you...

10 hours ago by kevinmchapman on A tale of two distros: Ubuntu and Linux Mint
TerryRK

Isn't the provision of a text based search an admission by the developers that the mass of icons approach does not work? I don't need to use a...

11 hours ago by TerryRK on A tale of two distros: Ubuntu and Linux Mint
kevinmchapman

"Unity and GNOME 3 both abandon the old text-based cascading menus in favour of a graphical icon-driven system." Point truly missed. Both use a...

12 hours ago by kevinmchapman on A tale of two distros: Ubuntu and Linux Mint
TerryRK

whs001 - Thank you, I'm glad you liked the article. I absolutely agree with you on your first point. I should perhaps have made it clearer that...

12 hours ago by TerryRK on A tale of two distros: Ubuntu and Linux Mint
Dennis Nilsson

If we allow corporate interest to dictate the way our government circumvents due process against foreign entities then we should accept the same...

13 hours ago by Dennis Nilsson via Facebook on ACTA stumbles in Germany
GHar123

I totally dislike pirating of works, I fear that artists will be deterred from creating works if they think that they are going to get ripped off....

15 hours ago by GHar123 on ACTA stumbles in Germany
JCB33

How dare film makers, artists or anybody that invests in creativity stop us pirating their works for free. I want to be able to walk into my local...

21 hours ago by JCB33 on ACTA stumbles in Germany
Moley

@GrueMaster. I prefer horses for courses rather than one size fits all. I, and I suspect most other computer users, do not really wish to have...

23 hours ago by Moley on A tale of two distros: Ubuntu and Linux Mint
greycynic

The product that scares me every time I have to use it is the Office 2007 version of Excel. The first bug that I found was applying the median...

23 hours ago by greycynic on Ten flawed products that derail productivity
GrueMaster

Nice review and very informative. One thing I'd like to add (in reply to whs001's 1st question), the main reason to have the same interface from...

1 day ago by GrueMaster on A tale of two distros: Ubuntu and Linux Mint
Frederick Wrigley

I'be been using Mint 12 since the RC came out, and I am far more happy with the Cinnamon, the Mate, and, yes (with extensions), theGnome 3...

1 day ago by Frederick Wrigley via Facebook on A tale of two distros: Ubuntu and Linux Mint
bdantas

Excellent article. One small correction, though--although a fresh installation of Linux Mint 12 will, indeed, provide the user with a version of...

1 day ago by bdantas on A tale of two distros: Ubuntu and Linux Mint
Alan Ralph

In related news, the ISPs club together to get the members of the Home Affairs Select Committee (ya goofed on that part, ZDNet UK) copies of "The...

1 day ago by Alan Ralph via Facebook on MPs urge ISPs to take down terrorist material
Alan Ralph

In related news, the ISPs club together to get the members of the Home Affairs Select Committee (ya goofed on that part, ZDNet UK) copies of "The...

1 day ago by Alan Ralph via Facebook on MPs urge ISPs to take down terrorist material
Moley

For Gnome 2 die-hards, it is possible to add icons to the bottom panel (or top top panel, if you prefer) which provide the exact Gnome 2...

1 day ago by Moley on A tale of two distros: Ubuntu and Linux Mint
ramwellian

Your comments would seem pretty naive and immature. Your 'solution' appears to be, "gee, let's all just give in to the hackers and give them...

1 day ago by ramwellian on Cloud computing security: no more oxymoron?