Oracle MySQL Gets NoSQL-Savvy Upgrade - InformationWeek
Software // Information Management
12:20 PM
Connect Directly
How Upwork Cut Zero-Day File Attacks by 70%
Oct 05, 2017
Upwork has millions of clients and freelancers that have to upload and download many files to and ...Read More>>

Oracle MySQL Gets NoSQL-Savvy Upgrade

Oracle promises faster performance, improved scaling, and Memcached API access to NoSQL databases.

12 Top Big Data Analytics Players
12 Top Big Data Analytics Players
(click image for larger view and for slideshow)
Plenty of telcos have embraced Oracle's MySQL Cluster edition for its combination of scalability, performance, and reliability. Now Oracle is increasing the appeal to Web-based businesses with performance upgrades and built-in support for linking to NoSQL databases.

MySQL Cluster 7.2, released on Wednesday, packs a long list of performance upgrades, but the key new feature aimed at Web businesses is a built-in integration option to NoSQL databases via the popular Memcached application programming interface. The API enables the many Web businesses embracing NoSQL databases, such as Couchbase, to speed read and write operations of frequently accessed data. Oracle also released a new NoSQL option of its own last month.

Many Web businesses maintain their master data in MySQL but use Memcached to cache frequently accessed data, explained Tomas Ulin, Oracle's vice president of MySQL Engineering. Until now, using the two products together required proprietary integration work. "We're making it easier for people to work with these two products together by integrating them out of the box," Ulin said.

[ Read our latest, in-depth research: 2012 State Of Databases: Pricey And In Flux. ]

Plenty of Web businesses use MySQL Standard and Enterprise editions, but Ulin said the convergence of telecom and Web infrastructure is increasing demands for the high-availability, online scaling, and low-latency capabilities of the MySQL Cluster edition. "Cluster is designed for 99.999% uptime, so just a few minutes of downtime per year, and it doesn't have any single points of failure, so you can take down nodes, add nodes, make schema changes, or upgrade hardware or software while still serving," Ulin said.

The list of performance upgrades to 7.2 is topped by an adaptive query localization feature that reportedly delivers 70 times higher performance than the previous Cluster edition when handling complex queries.

On the scalability front the upgrade supports multi-site clusters whereby individual nodes can be located in separate data centers, with databases automatically sharded between different locations. Synchronous replication ensures consistency among sites, with fast, automated failover and recovery features, according to Oracle. The 7.2 is also said to enhance active/active replication in a way that simplifies conflict detection and resolution across multiple active clusters while eliminating requirements for a timestamp column within applications.

Since taking control of MySQL through its acquisition of Sun Microsystems two years ago, Oracle has steadily made the open source database more compatible with other Oracle assets. For example, MySQL Cluster 7.2 is Oracle VM certified, so it can take advantage of that virtualization platform for cloud deployment. MySQL was already certified on Oracle Linux and Oracle Solaris.

Oracle has positioned MySQL as a low-cost competitor to Microsoft SQL Server. MySQL Standard edition subscriptions start at $2,000 per server for one year of support. MySQL Enterprise adds tools for backup, monitoring, modeling, development, and administration and starts at $5,000 per server for one year of support. MySQL Cluster adds high-availability and performance features and is $10,000 per server for one year of support.

More than 700 IT pros gave us an earful on database licensing, performance, NoSQL, and more. That story and more--including a look at transitioning to Win 8--in the new all-digital Database Discontent issue of InformationWeek. (Free registration required.)

Comment  | 
Print  | 
More Insights
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
Digital Transformation Myths & Truths
Transformation is on every IT organization's to-do list, but effectively transforming IT means a major shift in technology as well as business models and culture. In this IT Trend Report, we examine some of the misconceptions of digital transformation and look at steps you can take to succeed technically and culturally.
Twitter Feed
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