MySQL Database To Get Replication Monitoring, Multiversioning Concurrency Features - InformationWeek
IoT
IoT
Software // Information Management
News
9/13/2007
09:52 PM
Connect Directly
Twitter
RSS
E-Mail
50%
50%

MySQL Database To Get Replication Monitoring, Multiversioning Concurrency Features

The 5.1 MySQL prerelease beta code will be able to detect and monitor replications of a central database and track their performance in real time.

The MySQL open source database by the end of September will offer a beta version that shows several capabilities normally associated with more sophisticated database systems, such as online database replication monitoring.

The 5.1 MySQL prerelease beta code will be able to detect and monitor replications of a central database and track their performance in real time. Its replication monitoring adviser will be able to tell MySQL central administrators whether replicated copies are synchronized and whether they are performing as expected.

The beta code will be able to partition a database into sections or multiple databases for better query performance and ease of management.

One metric for determining performance is whether the replicated system has put in the database server cache the most frequently sought data, so that it may be efficiently delivered to end users.

"It lets you monitor dozens of replicated systems," said Zack Urlocker, executive VP of products.

MySQL Proxy is software slated for 5.1 that sits between a MySQL database system and its clients, analyzing queries being submitted for their efficiency or filtering queries for potentially harmful code.

MySQL Connector/ODBC 5.1 is a new, high-performance driver for MySQL databases to provide client access through an industry-standard API.

Eighteen months ago, MySQL AB acquired Netfrastructure, a company owned by Jim Starkey, a database architect known for inventing the first multiversioning concurrency database system, InterBase. Starkey is working on a new version of MySQL, called Falcon.

Multiversioning concurrency creates time-stamped, read-only snapshots of the database that can be parceled out to many users. Users may make tentative changes, but they are added to a master database only after they have been synchronized with other time-stamped changes. The approach guarantees consistent and speedy access for read-only users and avoids forcing them to wait for locked data. Oracle and other relational systems now often include multiversioning concurrency features.

Urlocker says Falcon will be available with the release of MySQL v6 next year as a high-speed transaction system, suitable for running on multicore servers. Web site e-commerce applications with many users, who need to analyze information and execute transactions, such as those used on Internet travel sites, may need a Falcon-type database system, Urlocker said.

Falcon code is available in a preview or alpha version at www.mysql.com, Urlocker said.

Comment  | 
Print  | 
More Insights
Comments
Newest First  |  Oldest First  |  Threaded View
How Enterprises Are Attacking the IT Security Enterprise
How Enterprises Are Attacking the IT Security Enterprise
To learn more about what organizations are doing to tackle attacks and threats we surveyed a group of 300 IT and infosec professionals to find out what their biggest IT security challenges are and what they're doing to defend against today's threats. Download the report to see what they're saying.
Register for InformationWeek Newsletters
White Papers
Current Issue
Top IT Trends to Watch in Financial Services
IT pros at banks, investment houses, insurance companies, and other financial services organizations are focused on a range of issues, from peer-to-peer lending to cybersecurity to performance, agility, and compliance. It all matters.
Video
Slideshows
Twitter Feed
InformationWeek Radio
Archived InformationWeek Radio
Join us for a roundup of the top stories on InformationWeek.com for the week of November 6, 2016. We'll be talking with the InformationWeek.com editors and correspondents who brought you the top stories of the week to get the "story behind the story."
Sponsored Live Streaming Video
Everything You've Been Told About Mobility Is Wrong
Attend this video symposium with Sean Wisdom, Global Director of Mobility Solutions, and learn about how you can harness powerful new products to mobilize your business potential.
Flash Poll