Database News: MySQL Newsletter: January 2011

MySQL Newsletter
January 2011
mysql-newsletter@sun.com

Articles in this newsletter:

Highlights

- White Paper: MySQL Enterprise Monitor 2.3: What's New
- White Paper: MySQL Reference Architectures for Massively Scalable Web Infrastructure
- Case Study: Tralix Delivers High SLAs and Extreme Performance with MySQL
- Live Webinar: What's New in Managing MySQL Cluster (January 12)
- Live Webinar: What's New: MySQL 5.5 and MySQL Enterprise Edition (January 18)
- Live Webinar: MySQL Enterprise Backup - Online "Hot" Backup for MySQL (January 20)

New Product Releases

- New Release of MySQL Community Server 5.1.54 (GA)

Hints & Tips

- White Paper: A Visual Guide to Installing MySQL on Windows
- PlanetMySQL Blog Posts
- PlanetMySQL Blog: A step by step guide to upgrading to MySQL 5.5
- PlanetMySQL Blog: Some hidden goods in MySQL 5.5
- PlanetMySQL Blog: Video: MySQL Cluster Overview by Bill Papp
- PlanetMySQL Blog: InnoDB locking
- PlanetMySQL Blog: KSCOPE11 - ODTUG Conference June 2011
- PlanetMySQL Blog: Tuning InnoDB Configuration
- PlanetMySQL Blog: Looking for a hack - Passing comment-like info through the binary log
- PlanetMySQL Blog: MySQL Server and NUMA architectures
- PlanetMySQL Blog: Are you using the deadline scheduler?
- PlanetMySQL Blog: MySQL v5.5 and Python

Events

- Live Webinar: MySQL 5.5 GA: Technology Update - APAC (January 13 & 20)
- Live Webinar: MySQL Enterprise Backup - Online Hot Backup for MySQL - Italian (January 20)
- Live Webinar: What's New: MySQL 5.5 and MySQL Enterprise Edition - German (January 21)
- On-Demand Webinar: Accelerating Telecoms Transformation with Web 2.0 Data Management
- On-Demand Webinar: MySQL Essentials Part 6 - How to Develop Simple Java Applications with MySQL

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

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://dev.mysql.com/why-mysql/white-papers/mysql-wp-enterprise-whatsnew.php

Read the German White Paper:
http://dev.mysql.com/why-mysql/white-papers/mysql-wp-enterprise-whatsnew.php.de

Read the Italian White Paper:
http://dev.mysql.com/why-mysql/white-papers/mysql-wp-enterprise-whatsnew.php.it

Read the French White Paper:
http://dev.mysql.com/why-mysql/white-papers/mysql-wp-enterprise-whatsnew.php.fr

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:
http://dev.mysql.com/why-mysql/white-papers/mysql_wp_high-availability_webrefarchs.php

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:
http://dev.mysql.com/why-mysql/case-studies/mysql-cs-tralix.php

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.

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.

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.

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

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

Download now:
http://dev.mysql.com/downloads/mysql/5.1.html#downloads

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

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:
http://dev.mysql.com/why-mysql/white-papers/visual_guide_to_installing_mysql_windows.php

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: 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:
http://www.ovaistariq.net/490/a-step-by-step-guide-to-upgrading-to-mysql-5-5/

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:
http://datacharmer.blogspot.com/2010/12/some-hidden-goods-in-mysql-55.html

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:
http://palominodb.com/blog/2010/12/16/video-mysql-cluster-overview-bill-papp

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:
http://www.facebook.com/note.php?note_id=479123255932

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:
http://everythingmysql.ning.com/profiles/blogs/kscope11-odtug-conference

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:
http://www.ovaistariq.net/496/tuning-innodb-configuration/

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:
http://datacharmer.blogspot.com/2010/12/looking-for-hack-passing-comment-like.html

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:
http://mikaelronstrom.blogspot.com/2010/12/mysql-server-and-numa-architectures.html

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:
http://ralpartha.blogspot.com/2010/12/are-you-using-deadline-scheduler-part-1.html

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:
http://geert.vanderkelen.org/post/464/

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

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:
http://dev.mysql.com/news-and-events/web-seminars/display-601.html?p=newsletter

Register for the Japanese Webinar on January 13 at 18:00 JST:
http://dev.mysql.com/news-and-events/web-seminars/display-602.html?p=newsletter

Register for the English Webinar on January 20 at 14:00 Singapore Time:
http://dev.mysql.com/news-and-events/web-seminars/display-603.html?p=newsletter

Live Webinar: MySQL Enterprise Backup - Online Hot Backup for MySQL - Italian
Thursday, January 20, 2011 - 10:00 CET

Live Webinar: What's New: MySQL 5.5 and MySQL Enterprise Edition - German
Friday, January 21, 2011 - 11:00 CET

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.

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.

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?

Read Oracle's MySQL Blog:
http://blogs.oracle.com/mysql/

Join MySQL on Facebook:
http://www.facebook.com/mysql

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/

Problems reading the newsletter in your email client? View the newsletter on the web.
http://dev.mysql.com/news-and-events/newsletter/2010/2010-12.html

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

Database News

Wednesday, January 5, 2011

MySQL Newsletter: January 2011

No comments:

Post a Comment

Followers

Blog Archive

About Me