MySQL Newsletter February 2011

Articles in this newsletter:


New Product Releases

Hints & Tips



OurSQL: The MySQL Database Community Podcast

OurSQL, the MySQL database community podcast is back! These podcasts are brought to you by two well-known MySQL community members, Sheeri K. Cabral and Sarah Novotny, who provide you with regular updates on what's happening in the MySQL community.

Learn More »

Listen to the Podcasts »

PlanetMySQL Blog: Something awesome in InnoDB -- the insert buffer

Mark Callaghan

The InnoDB insert buffer significantly reduces the disk IO required to support a change intensive workload when the database does not fit in the buffer pool. Eventually I must begin calling it the change buffer as it does more in MySQL 5.5.

Read the PlanetMySQL BlogPost »

MySQL 5.5 Now Builds with CMake

Starting with MySQL 5.5, CMake has replaced the legacy autoconf/automake framework for building MySQL on all platforms. If you want to develop on MySQL or want to compile the server from source, make sure to take a look at the resources below.

Read the BlogPost "MySQL 5.5: CMake replaces autoconf/automake on all platforms" »

Read the Tutorial "How to Build MySQL Server with CMake" »

Read the Documentation "Installing MySQL from Source" »

White Paper: MySQL 5.5: Storage Engine Performance Benchmark for MyISAM and InnoDB

With the release of MySQL 5.5, InnoDB has become the default storage engine. InnoDB is designed to handle transactional applications that require crash recovery, referential integrity, high levels of user concurrency and fast response times. The purpose of this whitepaper is to directly compare performance of the latest InnoDB 1.1 release included with MySQL 5.5 and MyISAM, using a benchmark that is commonly run to measure MySQL throughput.

Read this White Paper »

Case Study: F5 Relies on MySQL to Improve Performance 1000%

F5 is the market share leader in Application Delivery Controllers, with revenues of over $882 million in 2010. F5 used MySQL with partitioning to increase performance over 1000%, which made a new real-time performance graphing product module possible. This new module became the F5 Enterprise Manager product's most compelling differentiator.

Read this Case Study »

Live Webinar: MySQL Essentials Part 7: MySQL Administration and Management Essentials

Tuesday, February 22, 2011 - 9:00am PT

MySQL is well known for being "easy to use" and "easy to manage". In Part 7 of the MySQL Essentials webinar series, we'll discuss various MySQL tools essential for a busy DBA. These tools help simplify the job and improve the effectiveness of any DBA administering and managing MySQL environments - from beginner to pro. Our discussion will span from command-line tools and scripts to graphical user interfaces. We'll share the techniques that can help you avoid costly outages, secure MySQL and assure your MySQL databases are running at the highest level of availability.

Register for this Webinar »

Live Webinar: MySQL Reference Architectures for Scalable Web Infrastructure

Thursday, February 24, 2011 - 9:00am PT

In this webinar, we present a series of Reference Architectures for small, medium and large Web properties. You will learn about the components common to most web properties including Session Management, Authentication, eCommerce and Content Management. Optimum deployment architectures and topologies are defined based on sizing and availability requirements for each environment. We will also discuss the unique requirements for Large Social Networking applications.

Register for this Webinar »

Download the White Paper "MySQL Reference Architectures for Scalable Web Infrastructure" »

New Product Releases

New Release of MySQL Connector/NET 6.3.6 (GA)

We're happy to announce the latest maintenance release of MySQL Connector/Net 6.3.6.

View the Complete List of Changes »

Download Now »

Hints & Tips

White Paper: MySQL - Powering The Online Media & Entertainment Industry

As the term "Online Media" seems to become a pleonasm, we examine the following topics in this whitepaper, including the key trends shaping the evolution of the media & entertainment industry, the implications and requirements these trends placing on the infrastructure of entertainment services providers, as well as how to leverage Oracle's MySQL technologies in order to win in the new world of media and entertainment.

Read this White Paper »

Case Study: IMS Adoption Fueled by the Open IMS Core Project and MySQL

IMS is the foundation of Next Generation Networks (NGNs), a key architectural transformation in telecommunications networks designed to deliver communications services, such as voice, data and multi-media, over converged, all-IP (Internet Protocol) networks. It is expected that IMS will become the prominent technology enabler for converging fixed, mobile and cable networks, providing seamless triple and quadruple play services.

Read this Case Study »

PlanetMySQL Blog Posts

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.

Visit PlanetMySQL »

Submit Your Blog Feed »

PlanetMySQL Blog: How to select random rows in MySQL

Ilan Hazan

The easiest way to generate random rows in MySQL is to use the ORDER BY RAND() clause. This can work fine for small tables. However, for big tables, it will have a serious performance problem, as in order to generate the list of random rows, MySQL needs to assign random number to each row and then sort them.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Multi condition UPDATE query

Shlomi Noach

A simple question I've been asked: is it possible to merge two UPDATE queries, each on different WHERE conditions, into a single query?

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: It's about Time.

Mark Grennan

This post started with a simple question: "Does the function NOW() get executed every time a row is examined?"

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Statement-based vs Row-based Replication

Ovais Tariq

Replication as most people know it, has mostly been SQL statement propagation from master to slave. This is known as "statement-based" replication. But there is also another kind of replication that is available, the "row-based replication", and that has quite a lot of benefits. In this post I intend on highlighting the advantages and disadvantages of both types of replication to help you choose the best one. I also follow up with my own recommendation.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: The MySQL Council is up and running. We want to hear from you!

Giuseppe Maxia

The Independent Oracle User Group (IOUG) has formed the MySQL Council, with the purpose of addressing the interests and needs of MySQL users.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: A case for FORCE INDEX

Domas Mituzas

I remember various discussions in different mediums where people were building cases against the use of FORCE INDEX in SQL queries. I'll hereby suggest using it way more often, but at first I'll start with a small explanation.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Low latency distributed parallel joins

Frazer Clement

The SPJ project started around the time of the last MySQL Developers conference in Riga in September 2008. The intention at the time was to look at ways of efficiently supporting more complex queries, specifically involving table joins, reducing unnecessary data transfer, communication latencies and context switches and increasing parallelism.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Welcome New Oracle ACE's

Ronald Bradford

I am pleased to announce that the Oracle ACE program has two new MySQL inductees, Giuseppe Maxia and Patrick Galbraith. These people actively contribute to the MySQL community via a varied means in an unbiased and non commercial way.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: PHP: Transparent load balancing and sharding with mysqlnd

Ulf Wendel

Psst, you want some client-side MySQL load balancing with and without sharding for your PHP application? PHP 5.3 has something to offer for you. It is free. It requires no to very little changes to your applications.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: MySQL Makes The Cover of Oracle Magazine!

Bertrand Matthelie

In case you haven't seen it yet, MySQL made the cover of the January/February Edition of Oracle Magazine! Published 6 times per year and distributed to over half a million of IT managers, DBAs and developers, Oracle Magazine contains technology-strategy articles, sample code, tips, Oracle & partner news, and more.

Read the PlanetMySQL BlogPost »


Live Webinar: What's New: MySQL 5.5 and MySQL Enterprise Edition - EMEA

Come join us to see what we have accomplished - from the MySQL database itself and across the MySQL product suite of development, management, and monitoring tools. You'll also hear about new innovative professional support services offerings aimed at quickly improving the performance of your business-critical MySQL databases and applications.

Register for the Italian Webinar on February 17 at 10:00 CET »

Register for the French Webinar on February 28 at 10:00 CET »

On-Demand Webinar: MySQL Essentials Part 6 - How to Develop Simple Java Applications with MySQL

In Part 6 of the MySQL Essentials Webinar Series, Java and MySQL expert Mark Matthews will present the basic knowledge for you to get started developing and deploying simple Java applications with MySQL. He will guide you through the installation pre-requisites and process, discuss the options in architecture and frameworks, and show you how to handle transactions. He will also demonstrate the development steps with sample applications and share performance tips.

Register for this On-Demand Webinar »

On-Demand Webinar: MySQL Enterprise Backup - Online "Hot" Backup for MySQL

Online backup has been one of the most requested features for MySQL. With MySQL Enterprise Backup, developers and DBAs have tools they need to safely and rapidly backup and restore their databases. In this webinar we will go into the advantages of Hot "Online" backups. We will show how MySQL Enterprise Backup supports full, incremental, partial, and compressed backups that allow you to perform consistent Point-in-Time Recovery, as well as saving both time and money.

Register for this On-Demand Webinar »

On-Demand Webinar: What's New in Managing MySQL Cluster

In this webinar, we will present an overview of the three latest enhancements to provisioning, monitoring and managing MySQL Cluster - collectively serving to lower costs, enhance agility and reduce the risk of downtime caused by manual configuration errors.

Register for this On-Demand Webinar »

On-Demand Webinar: MySQL 5.5 GA: Technology Update - APAC

This online webinar will explain enhanced features introduced in MySQL 5.5 with benchmark data that proves MySQL 5.5 performance improvements. With the acquisition of Sun, Oracle continued to invest and improve MySQL - to make MySQL a better MySQL. Come join us to see what we have accomplished - from the MySQL database itself and across the MySQL product suite of development, management, and monitoring tools.

Register for the Chinese On-Demand Webinar »

Register for the Japanese On-Demand Webinar »

More free MySQL webinars are scheduled and added between each Newsletter edition, so visit our website frequently for the most updated information.

View the full list of webinars »

Want to receive the latest MySQL updates and interact with the MySQL community?

Read Oracle's MySQL Blog »

Join MySQL on Facebook »

Follow MySQL on Twitter »

Follow MySQL Community on Twitter »