MySQL Newsletter March 2010
Articles in this newsletter:
- MySQL Conference and Expo: Register Now and Save $250 by March 15th
- MySQL Conference and Expo: Technical Sessions
- MySQL Conference and Expo: MySQL Expert Speakers
- Live Webinar: Achieving Peak Application Performance with MySQL Embedded Server (Wednesday, March 17)
- Live Webinar: Running MySQL Securely on Windows - EMEA (Thursday, March 18)
- Upcoming MySQL University Sessions
- New Release of MySQL Server 5.5.2-m2 (Beta)
- New Release of MySQL Workbench 5.2.16 (Beta)
- New Release of MySQL Connector/Net 6.3.1 (Alpha)
- Documentation: MySQL Performance Schema
- Article: Why Should I Check Out a MySQL-Based Column Database?
- PlanetMySQL Blog Posts
- PlanetMySQL Blog: The innodb_plugin - a pleasant surprise!
- PlanetMySQL Blog: Linux MySQL distributions meeting in Brussels
- PlanetMySQL Blog: How to get rank using MySQL query
- PlanetMySQL Blog: The correct approach to rolling MySQL logs
- PlanetMySQL Blog: Semi-sync Replication Testing
- PlanetMySQL Blog: Ineffective concatenated indexes
- PlanetMySQL Blog: Don't forget the COMMIT in MySQL
- PlanetMySQL Blog: Why do we need InnoDB per table IO statistics?
- PlanetMySQL Blog: How To Set Up MySQL Database Replication With SSL Encryption On Ubuntu 9.10
- 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)
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!
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
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
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.
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.
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.
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.
We have published a new beta release of Version 5.2.16 Workbench Beta 6 build including fixes for 67 bugs.
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.
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.
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.
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.
I've heard about the innodb_plugin but not had time to put it to the test.
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.
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.
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.
I have recently been trying out semisynchronous replication. This is a new feature added in MySQL 5.5 based on the original google patch.
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.
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.
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.
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.
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.
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.
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.