MySQL Newsletter January 2011

Articles in this newsletter:

Highlights

New Product Releases

Hints & Tips

Events

Highlights

White Paper: MySQL Enterprise Monitor 2.3: What's New

MySQL is proud to announce the new release of MySQL Enterprise Monitor 2.3. This release can be used to monitor MySQL Servers that are part of a MySQL Cluster deployment. MySQL Enterprise Monitor 2.3 also improves general monitoring for MySQL and the Operating System by adding a set of new graphs for monitoring transactions and the new features available in InnoDB 1.1.

Read the English White Paper » (http://www.mysql.com/why-mysql/white-papers/mysql-enterprise-monitor-2-3-whats-new/)

Read the German White Paper » (http://www.mysql.com/why-mysql/white-papers/mysql-enterprise-monitor-2-3-neuheiten/)

Read the Italian White Paper »

Read the French White Paper » (http://www.mysql.com/why-mysql/white-papers/mysql-enterprise-monitor-2-3-nouveautes/)

White Paper: MySQL Reference Architectures for Massively Scalable Web Infrastructure

This whitepaper presents 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. The paper also discusses the unique requirements for Large Social Networking applications.

Read this White Paper »

Case Study: Tralix Delivers High SLAs and Extreme Performance with MySQL

Tralix Corporation is the e-invoicing and e-marketing market-share leader in Mexico. In January 2011, a new Mexican law will come into effect mandating that invoices over MXN 2000 (~USD160) are electronic. With MySQL as its e-invoicing products' database, hosted and appliance-based, Tralix is prepared to meet this huge increase in demand.

Read this Case Study »

Live Webinar: What's New in Managing MySQL Cluster

Wednesday, January 12, 2011 - 9:00am PT

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 Webinar »

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

Tuesday, January 18, 2011 - 9:00am PT

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. 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 this Webinar »

Live Webinar: MySQL Enterprise Backup - Online "Hot" Backup for MySQL

Thursday, January 20, 2011 - 9:00am PT

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 Webinar »

New Product Releases

New Release of MySQL Community Server 5.1.54 (GA)

MySQL Community Server 5.1.54, a new version of the popular Open Source Database Management System, has been released. MySQL 5.1.54 is recommended for use on production systems.

View the complete list of changes »

Download now »

Hints & Tips

White Paper: A Visual Guide to Installing MySQL on Windows

The following guide is meant to make getting started with MySQL easily for Windows developers, system administrators and Microsoft SQL Server DBAs that are new to MySQL. This paper will guide you through the steps and tools needed to get up and running quickly with MySQL on Windows using familiar terms, comparisons, and language.

Read this White Paper »

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: A step by step guide to upgrading to MySQL 5.5

Ovais Tariq

MySQL 5.5 has created a lot of hype and its not just hype. There are major performance enhancements not only in the MySQL server itself but in the newer InnoDB storage engine shipped with MySQL 5.5. That's exactly the reason why I have myself upgraded to MySQL 5.5. Now since I haven't come across a guide to help in upgrading to MySQL 5.5, I thought why not make one myself.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Some hidden goods in MySQL 5.5

Giuseppe Maxia

The announcement of MySQL 5.5 released as GA has outlined the improvements in this version, which indeed has enough good new features to excite any user. There are two additions, though, that were lost in the noise of the bigger features, and I would like to spend a few words for each of them.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Video: MySQL Cluster Overview by Bill Papp

Sheeri Cabral

At the December 2010 Boston MySQL User Group meeting a few days ago, Oracle/MySQL sales engineer Bill Papp gave a presentation on 'An Overview of MySQL Cluster'.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: InnoDB locking

Mark Callaghan

How well do you understand InnoDB locking? The documentation is good but would benefit from a few examples. If you want to debug contention for InnoDB then you need to understand record, gap and next-key locks, the reasons for using next-key locks and the locks used by different statements.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: KSCOPE11 - ODTUG Conference June 2011

Chris Schneider

This year I found an interesting conference that brings both Oracle and MySQL users together, KSCOPE11. This will be the second year with a dedicated MySQL track at Kscope11. There will be a clear focus on providing both developers and DBAs the right information, tools and best practices within MySQL, emphasizing scalability and performance.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Tuning InnoDB Configuration

Ovais Tariq

I had earlier written a post on tuning the MySQL server configuration which was more geared towards the MyISAM storage engine. While that is not because I didn't intend on ignoring InnoDB, but because I had planned a whole post on tuning InnoDB related configuration. So this post is the post that I had planned, and I have discussed the major configuration parameters in here that should help you out most of the times.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Looking for a hack - Passing comment-like info through the binary log

Giuseppe Maxia

I am facing an interesting problem. I need to mark somehow a statement in such a way that the comment is preserved through the binary log.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: MySQL Server and NUMA architectures

Mikael Ronstrom

When you run MySQL on a large NUMA box it is possible to control the memory placement and the use of CPUs through the use of numactl. Most modern servers are NUMA boxes nowadays.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Are you using the deadline scheduler?

Partha Dutta

There have been many posts about performance, benchmarking and the results. Many DBAs have talked in the past about the deadline scheduler, available in all modern Linux distributions. The deadline scheduler is very effective for database systems, as it tries to prevent starvation of I/O requests.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: MySQL v5.5 and Python

Geert JM Vanderkelen

MySQL v5.5 is GA, but is it working with Python? Yes, it does. Below you'll find some quick, small tests I did with MySQLdb, oursql and our own MySQL Connector/Python.

Read the PlanetMySQL BlogPost »

Events

Live 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 Webinar on January 13 at 14:00 China Time »

Register for the Japanese Webinar on January 13 at 18:00 JST »

Register for the English Webinar on January 20 at 14:00 Singapore Time »

Live Webinar: MySQL Enterprise Backup - Online Hot Backup for MySQL - Italian

Thursday, January 20, 2011 - 10:00 CET

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 Italian Webinar »

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

Friday, January 21, 2011 - 11:00 CET

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. 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 this German Webinar »

On-Demand Webinar: Accelerating Telecoms Transformation with Web 2.0 Data Management

The convergence of communication networks onto one which is IP (Internet Protocol) based is revolutionizing today's telecommunications industry. Communications Service Providers (CSPs) are challenged to deliver compelling new personalized services with greater agility and lower costs than ever before.

Attend this webinar to learn how leading Communications Service Providers, Network Equipment Manufacturers and ISVs are transforming telecommunications services with MySQL.

Register for this Webinar »

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, including installation pre-requisites and process, options in architecture and frameworks, as well as how to handle transactions.

Register for this 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 »