Germany: +49 89 143 01280
France: +33 1 57 60 83 57
Italy: +39 02 249 59 120
UK: +44 207 553 8447
Join us for MySQL Sunday, a half-day technical conference packed with the latest on MySQL, where you can choose sessions covering MySQL performance tuning, InnoDB, MySQL Cluster, MySQL Enterprise Monitor, and more. You'll also hear what's new and what's next directly from Edward Screven, Oracle Chief Corporate Architect, and learn from other MySQL users. Save the date and join us!
Memory is a basic MySQL storage engine designed for in-memory operations. MySQL Cluster, which itself can be implemented as a MySQL storage engine, can perform all the same in-memory operations, and is faster, more reliable and uses less RAM for data, even on a single node.
In the performance testing, MySQL Cluster was able to deliver 30x higher throughput with 1/3 the latency of the Memory storage engine on just a single node.
The MySQL Librarian is a collection of community-generated and cross-referenced content related to MySQL. It's a place where the community collaboratively builds and maintains the MySQL content.
Plusnet upgraded their AAA (Authentication, Authorization, Accounting) platform to the FreeRADIUS server and MySQL Cluster database in order to address increased demands. Since deployment, the new MySQL Cluster and FreeRADIUS AAA platform has provided many benefits, including accurate billing and revenue assurance, accelerated time to market of new services with less cost and complexity, and new levels of flexibility to scale RADIUS servers independently of their database.
Tuesday, August 10, 2010 - 9:00am PT
Join us for the first of a two-part webinar series in which we will discuss how you can achieve immediate performance and scalability gains by enabling the free and easy InnoDB Upgrade for MySQL 5.1.
In this webinar you'll learn about new features and benefits available only in the InnoDB upgrade, performance/scalability of the InnoDB Upgrade vs. MySQL 5.1's Built-in InnoDB, and how to easily enable the InnoDB Upgrade in MySQL 5.1 for immediate use.
Thursday, August 19, 2010 - 9:00am PT
Join us for Part 3 of the MySQL Essentials series to learn the design dos and don'ts for MySQL. MySQL Product Manager and MySQL Workbench expert, Mike Frank will show you how to design, forward and reverse engineer databases including discussions on datatypes, indexes, and foreign keys for various application scenarios.
MySQL Server 5.5.5-m3, a new version of the popular Open Source Database Management System, has been released. The "-m3" suffix indicates that these releases belong to the third milestone. MySQL 5.5 includes several high-impact changes to address scalability and performance issues in MySQL Server. These changes exploit advances in hardware and CPU design and enable better utilization of existing hardware.
MySQL Community Server 5.1.49, a new version of the popular Open Source Database Management System, has been released. MySQL 5.1.49 is recommended for use on production systems.
MySQL Connector/Net 6.3.3, a new version of the all-managed .NET driver for MySQL has been released. This is a beta release and is intended to introduce you to the new features and enhancements we are planning. The new features in this release include Visual Studio 2010 RTM support and a new SQL editor.
MySQL versions 5.1.38 and above now ship with the InnoDB Upgrade for 5.1, which provides users with immediate access to performance and scalability gains while sustaining the current production-ready and stable feature set of the MySQL 5.1 server.
In this paper, we provide a technical overview of the MySQL storage engine architecture used by the InnoDB Upgrade, a review of the features, and performance and scalability gains users can expect to see when enabling the InnoDB Upgrade in MySQL 5.1.38 or later.
Netlog is one of the fastest-growing social networks in Europe. The target group is young people, 14-24 years of age, and Netlog is primarily used for communication, entertainment and sharing music and photos.
Access to MySQL Enterprise's monitoring and support services helps Netlog deliver excellent performance, security and response times on its 300 database servers. The company has 40 million registered members generating more than 6 billion page views every month.
The following blog posts are from PlanetMySQL. PlanetMySQL is an aggregation of blogs and news from MySQL developers, users and employees. It is an excellent source of all things about MySQL, including technical tips and best practices.
Back in April I wrote that MySQL 5.5.4 is very exciting and couldn't wait to start running it in production. Now here we are several months later and are using 5.5.4-m3 on all the slaves in what is arguably our most visible (and one of the busiest) user-facing cluster.
Lately I hear people questioning database software choices we made at Wikipedia, and I'd like to point out that Wikipedia database infrastructure needs are remarkably boring.
One common question I get is how to use partitioning instead of MERGE tables. The process I use involves using stored procedures to create and drop partitions. This article will go over the stored procedures I use; special thanks to Roland Bouman for taking a look and giving great feedback to optimize this process.
I came up with the idea of this article when I tried to create replication setup between MS SQL 2008 and MySQL. I was unable to do it since MS SQL provides only two non SQL Subscriptions/Publishers options. However I created the linked server through which I can access and query the MySQL databases and tables.
There is a new video available: Demonstration of installing, configuring and running MySQL Cluster (Linux) to accompany the MySQL Cluster Quick Start guides. The Flash video lasts for about 7 minutes.
There is often confusion as to how it can be claimed that MySQL Cluster delivers in-memory performance while also providing durability (the "D" in ACID). This post explains how that can be achieved as well as how to mix and match scalability, High Availability and Durability.
Oracle distributes a series of 12 RPM packages that make up the MySQL Cluster product. Lately I've been getting a lot of questions asking which of these dozen RPM packages should be installed onto which nodes.
One problem with MySQL Cluster we are starting to see quite often is to do with the current generation of Xeon processors. This post outlines the problem and how to avoid it.
One of the significant benefits of MySQL is its ease of use. Generally already installed on most Linux systems, MySQL can be installed by a single command if not yet present. On Oracle Enterprise Linux 5.4 you can use the following commands to check for MySQL, configure your yum repository and install MySQL.
When examining the execution plan of troublesome queries in MySQL, most users are aware of using EXPLAIN. However, an often overlooked, yet very helpful extension of EXPLAIN, is EXPLAIN EXTENDED coupled with the SHOW WARNINGS command.
In "Beware of implicit casting", I have outlined the dangers of implicit casting. Here's a few more real-world examples I have tackled.
Chances are, if you write Java applications using MySQL's Connector/J driver, you've run across the autoReconnect property. I remember that when I first found it, it seemed I had found the grail itself. "No more nasty connection closed error messages," I thought. Except ... it doesn't really work that way, does it?
Wednesday, August 11, 2010 - 10:00am China Time
As a result of the acquisition of Sun and Oracle, MySQL is now among Oracle's product portfolio. Oracle invests in MySQL, the world's most popular open source database, and drives its innovation further. In this webcast, we will share with you the latest updates from MySQL, including Oracle's strategy for MySQL, MySQL 5.5 beta preview, MySQL Cluster 7.1 introduction, and MySQL channel plan in Greater China Region.
Wednesday, August 25, 2010 - 9:00am PT
Delivered by the lead MySQL Cluster professional services consultant at Oracle, this session will present best practices on deploying MySQL Cluster in order to accelerate time to service with the highest levels of availability and performance to support your most critical web and telecoms applications.
More free MySQL webinars are scheduled and added between each Newsletter edition, so visit our website frequently for the most updated information.