News

MySQL Upgrades Flagship Database, Services

Release of MySQL 6.0 is expected in mid-2008.

In its first major refresh in nearly two years, MySQL AB is set to release a new version of its flagship open source database, along with a bevy of new tools and beefed up subscription-based services.

The company launched a swath of new software and services at last month's Japanese MySQL Users Conference in Tokyo. MySQL is considered the fastest growing open source database software platform and is emerging as a key platform for Windows developers.

While the majority of MySQL databases run on Linux servers, a significant portion of the applications are developed on Windows, says Zack Urlocker, executive vice president of products at Cupertino, Calif.-based MySQL.

"Windows is our No. 2 development environment," Urlocker says. "We see a lot of people who will use MySQL on Windows for development, sometimes with Visual Studio with .NET, with Visual Basic and C#."

MySQL is emerging as the key database for public and corporate Web 2.0 applications, says RedMonk analyst Stephen O'Grady: "MySQL has done a good job in the Web tier, particularly with folks designing Web applications."

MySQL Moving Up
Central to the launch is MySQL 5.1, which will allow for partitioning of large database volumes, row-based replication and the ability to host MySQL clusters on disk, rather than just within the database memory.

All of these features are aimed at improving performance and simplifying management of large applications, according to Urlocker. The new release should show a 20 percent performance boost over its predecessor, MySQL 5.0, he says.

Also new is the significantly updated MySQL Enterprise service, a fee-based support offering that includes regular updates, patches and fixes for deployments. Also included in the service is MySQL Enterprise Monitor, which continuously monitors database servers to give administrators and developers awareness of 600 various conditions.

Included with Enterprise Monitor is the new Replication Monitor. It offers more than 100 "advisor" rules and a suite of more than 20 graphs to give administrators and developers views of their distributed database environments.

"We see a lot of people who will use MySQL on Windows for development, sometimes with Visual Studio with .NET, with Visual Basic and C#."
Zach Urlocker, Executive Vice President of Products, MySQL AB
Zack Urlocker

The company is also developing MySQL Proxy-middleware that will let developers examine queries and redirect and rewrite them. "People are using that to do some interesting analysis," Urlocker says, adding that the company will be building other new capabilities over time, such as support for load balancing. "We are getting a lot of uptake for that in the open source community," he says.

For those looking to provide client access to MySQL databases, the company is also releasing its MySQL Connector/ODBC 5.1, based on the widely supported ODBC standard API.

Finally, the company has released an alpha version of its Falcon Database Engine as a preview version of the next major release, MySQL 6.0. The company is designing Falcon for large-memory, multithreaded and multicore applications, notably large Web sites. MySQL 6.0 is slated for the middle of next year, Urlocker says.

About the Author

Jeffrey Schwartz is editor of Redmond magazine and also covers cloud computing for Virtualization Review's Cloud Report. In addition, he writes the Channeling the Cloud column for Redmond Channel Partner. Follow him on Twitter @JeffreySchwartz.

comments powered by Disqus

Featured

  • Compare New GitHub Copilot Free Plan for Visual Studio/VS Code to Paid Plans

    The free plan restricts the number of completions, chat requests and access to AI models, being suitable for occasional users and small projects.

  • Diving Deep into .NET MAUI

    Ever since someone figured out that fiddling bits results in source code, developers have sought one codebase for all types of apps on all platforms, with Microsoft's latest attempt to further that effort being .NET MAUI.

  • Copilot AI Boosts Abound in New VS Code v1.96

    Microsoft improved on its new "Copilot Edit" functionality in the latest release of Visual Studio Code, v1.96, its open-source based code editor that has become the most popular in the world according to many surveys.

  • AdaBoost Regression Using C#

    Dr. James McCaffrey from Microsoft Research presents a complete end-to-end demonstration of the AdaBoost.R2 algorithm for regression problems (where the goal is to predict a single numeric value). The implementation follows the original source research paper closely, so you can use it as a guide for customization for specific scenarios.

  • Versioning and Documenting ASP.NET Core Services

    Building an API with ASP.NET Core is only half the job. If your API is going to live more than one release cycle, you're going to need to version it. If you have other people building clients for it, you're going to need to document it.

Subscribe on YouTube