Database News: MySQL Newsletter: March 2010

MySQL Newsletter
March 2010
mysql-newsletter@sun.com

Articles in this newsletter:

Highlights

- 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 Product Releases

- 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)

Hints & Tips

- 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

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:
https://en.oreilly.com/mysql2010/public/register#pricing

Learn More about Edward Screven's Keynote:
http://en.oreilly.com/mysql2010/public/schedule/detail/12440

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:
http://en.oreilly.com/mysql2010/public/schedule/grid

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:
http://en.oreilly.com/mysql2010/public/schedule/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:
http://forge.mysql.com/wiki/MySQL_University

-------------------------------------------------------------------

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:
http://dev.mysql.com/doc/refman/5.5/en/news-5-5-2.html

Download Now:
http://dev.mysql.com/downloads/mysql/#downloads

Read the Documentation:
http://dev.mysql.com/doc/refman/5.5/en/mysql-nutshell.html

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:
http://dev.mysql.com/doc/workbench/en/wb-news-5-2-16.html

Download Now:
http://dev.mysql.com/downloads/workbench/5.2.html

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:
http://dev.mysql.com/doc/refman/5.1/en/connector-net-news-6-3-1.html

Download Now:
http://dev.mysql.com/downloads/connector/net/6.3.html

-------------------------------------------------------------------

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:
http://dev.mysql.com/doc/refman/5.5/en/performance-schema.html

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:
http://dev.mysql.com/tech-resources/articles/mysql-based-column-database.html

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:
http://planet.mysql.com/

Submit Your Blog Feed:
http://planet.mysql.com/new

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:
http://blog.wl0.org/2010/03/the-innodb_plugin-a-pleasant-surprise/

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:
http://datacharmer.blogspot.com/2010/02/linux-mysql-distros-meeting-in-brussels.html

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:
http://thinkdiff.net/mysql/how-to-get-rank-using-mysql-query/

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:
http://ronaldbradford.com/blog/the-correct-approach-to-rolling-mysql-logs-2010-02-22/

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:
http://harrison-fisk.blogspot.com/2010/03/semi-sync-replication-testing.html

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:
http://ronaldbradford.com/blog/ineffective-concatenated-indexes-2010-02-24/

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:
http://geert.vanderkelen.org/2010/02/don-forget-commit-in-mysql.html

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:
http://serge.frezefond.free.fr/?p=335

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:
http://www.howtoforge.com/how-to-set-up-mysql-database-replication-with-ssl-encryption-on-ubuntu-9.10

-------------------------------------------------------------------

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:
http://dev.mysql.com/news-and-events/web-seminars/index.html

-------------------------------------------------------------------

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

Follow MySQL on Twitter:
http://twitter.com/mysql

Follow MySQL Community on Twitter:
http://twitter.com/mysql_community

-------------------------------------------------------------------

About the Newsletter

You can send us queries and give us feedback online.
http://dev.mysql.com/contact/

You can unsubscribe from this newsletter online:
http://dev.mysql.com/unsub?email=johandontmessup@gmail.com

Read more about the newsletter and view previous issues.
http://dev.mysql.com/news-and-events/newsletter/

--
Copyright (c) 2010, Oracle Corporation and/or its affiliates.
You are free to distribute this newsletter, as long as you don't make any changes.

Database News

Tuesday, March 9, 2010

MySQL Newsletter: March 2010

No comments:

Post a Comment

Followers

Blog Archive

About Me