MySQL Newsletter March 2010

Articles in this newsletter:

Events

Live Webinar: Migrating from SQL Server to MySQL - EMEA (Thursday, March 11)
Live Webinar: Windows and MySQL - Part 12: Advanced MySQL Replication on Windows (Tuesday, March 16)
Live Webinar: MySQL Cluster for Web & eCommerce Applications: Growing Revenue & Enhancing Loyalty (Wednesday, March 24)

Highlights

MySQL Conference and Expo: Register Now and Save $250 by March 15th

The MySQL Conference and Expo is a deep technical conference designed to take your skills and know-how to the next level through expert-led sessions, in-depth tutorials, and face-to-face conversations with open source gurus and developers. You will also learn the current and future state of MySQL during the keynote from Edward Screven, Oracle's Chief Corporate Architect and leader of the MySQL business. Early registration discount has been extended through March 15th, so register now and save!

View Pricing »

Learn More about Edward Screven's Keynote »

MySQL Conference and Expo: Technical Sessions

Take advantage of this rare opportunity to get hands-on knowledge from MySQL experts on numerous topics, including Security, Replication, Performance Tuning, High Availability, and Scalability. Here are some session highlights:

Performance Schema
Get Your Replication On: Advanced Techniques, Tips and Tricks
High-throughput MySQL
PHP Object-Relational Mapping Libraries In Action
Introduction to InnoDB Monitoring System and Resource & Performance Tuning
Scalability and Reliability Features of MySQL Connector/J

View the current list of sessions »

MySQL Conference and Expo: MySQL Expert Speakers

MySQL Conference Speakers include both the engineers who build MySQL and leading experts who are implementing MySQL in real-world environments. Come join the following MySQL Experts:

Mark Callaghan, Facebook
Jeremy Zawodny, craigslist.org
Giuseppe Maxia, Oracle
Sheeri Cabral, The Pythian Group
Ben Black, Garmin
Roland Bouman, Strukton Rail
Alex Esterkin, Nokia
Ronald Bradford, 42SQL

View the current list of speakers »

Live Webinar: Achieving Peak Application Performance with MySQL Embedded Server

Wednesday, March 17, 2010 - 10:00am PDT

MySQL expert and trainer, Sarah Sproehnle, will discuss the major MySQL design decisions that can affect the performance of your application and with it, your customers' experience and satisfaction. Sarah will show you how to achieve top performance with MySQL Embedded Server, including choosing the right storage engine(s), identifying critical performance-related server settings, and more.

Live Webinar: Running MySQL Securely on Windows - EMEA

Thursday, March 18, 2010 - 15:00 CET

In this presentation we will demonstrate how to install and configure MySQL to run securely on Windows. We will explain how MySQL's internal security model, authentication and privileges model works. We will also look at how to secure network access to MySQL and look how to thwart common attacks on MySQL.

Upcoming MySQL University Sessions

MySQL University is a free educational online program for engineers and developers who are interested in MySQL development and internals. MySQL University sessions are open to anyone, not limited to Oracle employees. Sessions are recorded with slides and audio, so if you can't attend the live session you can review the recording anytime after the session.

View Upcoming and Previous Sessions »

New Product Releases

New Release of MySQL Server 5.5.2-m2 (Beta)

MySQL Server 5.5.2-m2, a new version of the popular Open Source Database Management System, has been released. The "-m2" suffix tells this belongs to the second milestone according to our "milestone" release model. 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.

View the complete list of changes »

Download Now »

Read the Documentation »

New Release of MySQL Workbench 5.2.16 (Beta)

We have published a new beta release of Version 5.2.16 Workbench Beta 6 build including fixes for 67 bugs.

View the complete list of changes »

Download Now »

New Release of MySQL Connector/Net 6.3.1 (Alpha)

MySQL Connector/Net 6.3.1, a new version of the all-managed .NET driver for MySQL has been released. This is an alpha release and is intended to introduce you to the new features and enhancements we are planning, including Visual Studio 2010 RC support and nested transaction scope support.

View the complete list of changes »

Download Now »

Hints & Tips

Documentation: MySQL Performance Schema

MySQL Performance Schema is a feature for monitoring MySQL Server execution at a low level. This is a new feature available as of MySQL 5.5.3. Performance Schema is intended to provide access to useful information about server execution while having minimal impact on server performance.

Read the Documentation »

Article: Why Should I Check Out a MySQL-Based Column Database?

Recently, articles, blogs, analyst reports, and other media outlets have been noting the rise and usage of column-oriented databases in the areas of data warehousing, analytics, and other business intelligence/read-intensive situations. And on the MySQL front, there are a couple of column DB's that are now available for you to use.

Read this Article »

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: The innodb_plugin - a pleasant surprise!

Simon Mudd

I've heard about the innodb_plugin but not had time to put it to the test.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Linux MySQL distributions meeting in Brussels

Giuseppe Maxia

The MySQL team has organized a meeting with the Linux distributions with the intent of finding out which differences and problems they may have with each other, and to solve them by improving communication. The meeting was successful.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: How to get rank using MySQL query

Mahmud Ahsan

Some days ago I was working in a quiz project, where user will play quiz and for each correct answer they will earn points. One of the task of this quiz application was to get rank of a particular user. Now I am showing how I could solve this problem using MySQL query.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: The correct approach to rolling MySQL logs

Ronald Bradford

I say correct because there are several incorrect approaches to managing MySQL logs. In MySQL you have two important log files, the MySQL error log and the MySQL slow query log.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Semi-sync Replication Testing

Harrison Fisk

I have recently been trying out semisynchronous replication. This is a new feature added in MySQL 5.5 based on the original google patch.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Ineffective concatenated indexes

Ronald Bradford

In MySQL significant performance improvements can be achieved by the correct use of indexes. It is important to understand different MySQL index implementations and one key improvement on indexes defined on single columns is to use multiple column or more commonly known concatenated indexes.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Don't forget the COMMIT in MySQL

Geert Vanderkelen

Yes, MySQL has transactions if you use InnoDB or NDB Cluster for example. Using these transactional storage engines, you'll have to commit (or roll back) your inserts, deletes or updates.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Why do we need InnoDB per table IO statistics?

Serge Frezefond

InnoDB plugin offers an adaptive compression that is very interesting for performance. This compression works at a table level. Like most optimization techniques this is not black or white. You have to decide depending on IO patterns/CPU usage/Memory usage/disks constraints what tables are good candidates for compression.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: How To Set Up MySQL Database Replication With SSL Encryption On Ubuntu 9.10

Falko Timme

This tutorial describes how to set up database replication in MySQL using an SSL connection for encryption (to make it impossible for hackers to sniff out passwords and data transferred between the master and slave). MySQL replication allows you to have an exact copy of a database from a master server on another server (slave), and all updates to the database on the master server are immediately replicated to the database on the slave server so that both databases are in sync.

Read the PlanetMySQL BlogPost »

Events

Live Webinar: Migrating from SQL Server to MySQL - EMEA

Thursday, March 11, 2010 - 15:00 CET

In this presentation we will explore the benefits of migrating from Microsoft SQL Server to MySQL. We will also cover migration best practices, as well as, an overview of migration tools, scripts, datatype mapping and functional equivalents.

Live Webinar: Windows and MySQL - Part 12: Advanced MySQL Replication on Windows

Tuesday, March 16, 2010 - 10:00am PDT

Join us for Part 12 of the Windows and MySQL webinar series with Jimmy Guerrero and Mike Frank of the MySQL group at Oracle. In this presentation we will build upon the previous presentation and look at more advanced MySQL Replication techniques. We will cover master-master configurations, semi-synchronous replication, fail-over and resynchronization.

Live Webinar: MySQL Cluster for Web & eCommerce Applications: Growing Revenue & Enhancing Loyalty

Wednesday, March 24, 2010 - 10:00am PDT

MySQL Cluster is already proven in powering some of the most demanding, mission-critical web and communications-based services. This session discusses how MySQL Cluster can enable you to cost-effectively deploy online applications to generate new revenue streams and build vibrant user communities with continuous database availability and high performance.

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?

Follow MySQL on Twitter »

Follow MySQL Community on Twitter »