MySQL's non-heroic future runs Castle Oracle

The price of 'victory' is Windows

OpenWorld It's unheard of for a CEO to slip into his previous company's branded shirt and speak to users - unless the occasion is some kind of anniversary.

Yet the ex-MySQL chief executive and former head of Sun Microsystems' MySQL unit did just that at OpenWorld - the come-to-Jesus mega event run by MySQL's new owner Oracle.

Why would the Eucalyptus CEO Marten Mickos go back in time for any other reason than to have been brought in by Oracle in a symbolic act to steady the nerves of MySQLers nervous of their loved database's future?

With Monty Widenius and Brian Aker, Mickos was one of the best-known faces of MySQL. But Widenius and Aker weren't present - or, in all likelihood, not invited. They were busy hacking their MySQL forks. Widenius is more than a simple forker. He was a squeaky wheel that rattled against Oracle's ownership of MySQL.

But Mickos, the ever affable Finn, duly delivered the balm, calling Oracle's ownership a victory because a proprietary software company had bought into open source.

Oracle had embraced open source, he said, rather than attempting to kill it, as many assumed Oracle had been trying to do through the predatory purchase of storage engine InnoDB years before.

"Now we are in a state where Robin Hood and his men have ridden out of forest into the castle," Mickos said. Maybe. But Hood's men are about to find the responsibility of running the castle is a lot less fun and more predictable and businesslike than ambushing the enemy in the woods.

Oracle this week unveiled a grown-up roadmap for MySQL intended to make it easier to manage the database with their Oracle software.

Coming to MySQL are tools that make it a better development and runtime environment for Windows, work to boost ease-of-use and availably, and a much, much deeper relationship between MySQL and Oracle's software.

It's the kind of roadmap that - while probably justified in many ways - contains plenty that MySQLers like Widenus and Aker will reject.

I suppose it's just a matter of where you want to go and how far you want to get there. MySQL was growing under Sun. In fact, it was Sun's fastest growing software business. It just wasn't growing fast enough, so Oracle's strapping a rocket on the database's business.

One piece of work already underway at Sun and the independent MySQL that's being accelerated by Oracle is making MySQL work better with Windows.

Windows is now a top priority for a database that's been so closely allied with Linux its name forms an acronym - LAMP - with Apache and Perl/PHP/Python. It's a combo that's dominated web services and open-source programming for the best part of a decade and helped make MySQL's name.

The change under Oracle is coming because MySQL doesn't get many deployments on Windows even though it gets most of the downloads. The implication is that MySQL is being downloaded by developers or for evaluation and that it goes no further.

The reason: lack of GUI-based interface for data modeling and admin, a Windows-like development and deployment experience, and a lack of integration with Windows.

Oracle plans a unified Windows installer, similar to the installer found in SQL Server, along with a Windows Administration tool, entity framework, and connector enhancements.

The really big work order? An interface to Visual Studio, according to MySQL development vice president Tomas Ulin at OpenWorld.

"We have some work to do there. That's one of the highest priorities - to get Windows users this [integrated] experience they are used to on the Windows platform, so they will continue to use MySQL and become MySQL professionals after they've downloaded."

Improved performance is also a goal. Oracle boasted about a 1,561 per cent gain in read/write in MySQL 5.5 over 5.1

InnoDB, now MySQL's default storage engine, is getting multi-threaded purge and it will be prioritized for solid-state drives (SSD). The MySQL Enterprise Monitor will evolve into a management product, with the ability to start and stop back ups and to manage disk space.

There will be integration with Oracle's middleware and business-intelligence applications. Starting with MySQL 5.5, released as a release candidate on Sunday, Oracle's software will be certified to run on the database and therefore qualify for support from Oracle.

Customers will "soon" also be able to move data backwards and forwards between their Oracle and MySQL database following an update to Oracle's GoldenGate data-integration suite - bought by Oracle in July 2009. Currently, you can only move data from Oracle to MySQL using GoldenGate.

MySQL Enterprise Edition will be integrated with Oracle's Enterprise Manager, Audit Vault, and Secure Backup products in calendar 2011, and - again - qualify for support from Oracle.

Kicking off MySQL's serious play is full ACID compliance with MySQL 5.5. ACID guarantees reliable performance of the database and reliability of the data itself.

It's a small but important move, one that puts the database in a new place. One of MySQL's big areas of use has been on web properties like Facebook, where it's being used in a way where ACID properties aren't important.

While the addition of full ACID doesn't mean MySQL can't continue to be used in these sorts of places, it does mean MySQL can be used in the kinds of data infrastructures where Oracle has traditionally been used and were data is more valuable than just your profile on Facebook - inside the operations are of banking, retail, manufacturing,and telecoms companies.

MySQL has been a member of the NoSQL movement, thanks to where it's been deployed and because NoSQL partly defines itself by features such as a lack of ACID compliance. Asked about MySQL's place in the relation to NoSQL now, Mickos and Oracle chief software architect Edward Screven also at OpenWorld struck different tones.

Mickos reckoned the database industry is up for grabs and there'd be room for ACID-complaint and non-compliant databases as they serve different needs.

Screven was less charitable, saying there's been different data paradigms since he joined Oracle in 1986 but that it always came back to SQL. "People want a declarative approach to write queries and express equations in a comparatively algebraic style, and that's where it comes back to SQL," Screven said.

MySQL is changing, in some ways for the better with the addition of full ACID and better support for Windows. It's also changing in ways that'll excite Oracle customers but dismay supporters not tied into Oracle's information portfolio.

Also, changing is the way MySQL is built: sure, Oracle will return performance changes to the community edition, but it's decided to prioritize a roadmap delivering features that serve Oracle's software business. These features will only find their way into the Enterprise Edition of MySQL and Oracle will limit the amount of time and effort it puts into other improvements for the community edition.

Asked at OpenWorld how open-source has evolved, Mickos reckoned it's become more institutionalized - with fewer individual heroes.

"It's now driven by large orchestrated groups... for some people it will be boring because it's corporate, but for others it will be more dependable and successful," Mickos said.

We've gone from the cathedral to the castle, men. ®

Other stories you might like

  • North Korea pulled in $400m in cryptocurrency heists last year – report

    Plus: FIFA 22 players lose their identity and Texas gets phony QR codes

    In brief Thieves operating for the North Korean government made off with almost $400m in digicash last year in a concerted attack to steal and launder as much currency as they could.

    A report from blockchain biz Chainalysis found that attackers were going after investment houses and currency exchanges in a bid to purloin funds and send them back to the Glorious Leader's coffers. They then use mixing software to make masses of micropayments to new wallets, before consolidating them all again into a new account and moving the funds.

    Bitcoin used to be a top target but Ether is now the most stolen currency, say the researchers, accounting for 58 per cent of the funds filched. Bitcoin accounted for just 20 per cent, a fall of more than 50 per cent since 2019 - although part of the reason might be that they are now so valuable people are taking more care with them.

    Continue reading
  • Tesla Full Self-Driving videos prompt California's DMV to rethink policy on accidents

    Plus: AI systems can identify different chess players by their moves and more

    In brief California’s Department of Motor Vehicles said it’s “revisiting” its opinion of whether Tesla’s so-called Full Self-Driving feature needs more oversight after a series of videos demonstrate how the technology can be dangerous.

    “Recent software updates, videos showing dangerous use of that technology, open investigations by the National Highway Traffic Safety Administration, and the opinions of other experts in this space,” have made the DMV think twice about Tesla, according to a letter sent to California’s Senator Lena Gonzalez (D-Long Beach), chair of the Senate’s transportation committee, and first reported by the LA Times.

    Tesla isn’t required to report the number of crashes to California’s DMV unlike other self-driving car companies like Waymo or Cruise because it operates at lower levels of autonomy and requires human supervision. But that may change after videos like drivers having to take over to avoid accidentally swerving into pedestrians crossing the road or failing to detect a truck in the middle of the road continue circulating.

    Continue reading
  • Alien life on Super-Earth can survive longer than us due to long-lasting protection from cosmic rays

    Laser experiments show their magnetic fields shielding their surfaces from radiation last longer

    Life on Super-Earths may have more time to develop and evolve, thanks to their long-lasting magnetic fields protecting them against harmful cosmic rays, according to new research published in Science.

    Space is a hazardous environment. Streams of charged particles traveling at very close to the speed of light, ejected from stars and distant galaxies, bombard planets. The intense radiation can strip atmospheres and cause oceans on planetary surfaces to dry up over time, leaving them arid and incapable of supporting habitable life. Cosmic rays, however, are deflected away from Earth, however, since it’s shielded by its magnetic field.

    Now, a team of researchers led by the Lawrence Livermore National Laboratory (LLNL) believe that Super-Earths - planets that are more massive than Earth but less than Neptune - may have magnetic fields too. Their defensive bubbles, in fact, are estimated to stay intact for longer than the one around Earth, meaning life on their surfaces will have more time to develop and survive.

    Continue reading

Biting the hand that feeds IT © 1998–2022