Database News: July 2011

MySQL Newsletter
July 2011

Articles in this newsletter:

Highlights

- Press Release: Oracle Provides Early Access to MySQL 5.6 New Features
- Event: Oracle OpenWorld 2011 - Register Now and Get Special MySQL Discount Before July 29!
- Event: Meet the MySQL Team at GOSCON - Washington, DC (August 23)
- French Seminar: High Availability Solutions for MySQL - Paris, France (September 7)
- White Paper: Oracle VM Template for MySQL Enterprise Edition
- Podcast: New "Meet The MySQL Experts" Podcast Series
- Social Media: MySQL Facebook Page Reaches 100,000 Fans!
- Award: MySQL Wins the php|architect Impact Award for Data Management
- Live Webinar: MySQL Replication: Tips and Tricks (August 11)
- Live Webinar: Building High Performance and High Traffic PHP Applications with MySQL - Part 2: Best Practices (August 16)

New Product Releases

- New Release of MySQL Community Server 5.5.14 (GA)
- New Release of MySQL Cluster 7.1.15 (GA)
- New Release of MySQL Workbench 5.2.34 (GA)
- New Release of MySQL Connector/J 5.1.17 (GA)
- New Release of MySQL Connector/MXJ 5.0.12 (GA)
- New Release of MySQL Connector/Net 6.4.3 (GA)

Hints & Tips

- White Paper: Guide to Scaling Web Databases with MySQL Cluster
- White Paper: Unlocking New Value from Web Session Management
- PlanetMySQL Blog Posts
- PlanetMySQL Blog: Comparing Databases with mysqldbcompare
- PlanetMySQL Blog: MySQL Left Join
- PlanetMySQL Blog: FISL12 -- Open Source show with Music and Dancing in Brazil
- PlanetMySQL Blog: Performance schema, overhead tuning
- PlanetMySQL Blog: MySQL Enterprise Backup 3.6 - New backup streaming, integration with Oracle Secure Backup and other common backup media solutions
- PlanetMySQL Blog: Scaling Web Databases with MySQL Cluster
- PlanetMySQL Blog: How heartbeat is helpful for MySQL Replication
- PlanetMySQL Blog: Simpler and Safer Clustering: MySQL Cluster Manager Update
- PlanetMySQL Blog: Announcing common_schema: common views & routines for MySQL
- PlanetMySQL Blog: Automatically restarting MySQL slaves the easy way
- PlanetMySQL Blog: Finding and killing long running InnoDB transactions with Events
- PlanetMySQL Blog: Better than linear scaling is possible

Events

- Live Webinar: What's New in MySQL 5.6 - Part 1: Overview (August 18)
- Live Webinar: MySQL Workbench for ISVs and OEMs: Better MySQL Database Applications by Design (August 23)
- Live Webinar: MySQL Cluster: Scaling Web Databases with Auto-Partitioning and SQL/NoSQL Access - JAPAC (August 26)
- Live Webinar: Building High Performance and High Traffic PHP Applications with MySQL - The Fundamentals - French (August 30)
- On-Demand Webinar: MySQL Essentials Part 10 - MySQL Replication Essentials
- On-Demand Webinar: MySQL Relational Database Management Webcast

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

Highlights

Press Release: Oracle Provides Early Access to MySQL 5.6 New Features

At OSCON in Oregon, Oracle announced that early access to new features of MySQL 5.6 are available for the community to test, deploy and provide feedback.

Read the Press Release:
http://www.oracle.com/us/corporate/press/439460

Event: Oracle OpenWorld 2011 - Register Now and Get Special MySQL Discount Before July 29!

Oracle OpenWorld will be held in San Francisco, CA on October 2-6. This year, the MySQL Track will offer jam-packed sessions to get you up to speed on the latest technical innovations and community developments that are making MySQL an even better product. Use the code "MYSQL11" during registration and get $1,000 USD discount over regular price by July 29, just for the MySQL community members!

Event: Meet the MySQL team at GOSCON - Washington, DC
August 23, 2011

GOSCON, the Government Open Source Conference, and Innovation Nation Forum are co-located this year and will provide a special one day program featuring cloud, data center consolidation, cyber security, and open source. The MySQL team will showcase the latest product developments and demos running on a Sun Ray at the Exhibition Hall, and we look forward to meeting you!

French Seminar: High Availability Solutions for MySQL - Paris, France
September 7, 2011

During this free seminar, we will review the various options and technologies at your disposal to implement highly available and highly scalable MySQL infrastructures, as well as best practices in terms of architectures.

The packed agenda will include High Availability features in MySQL 5.5, MySQL Replication, MySQL Cluster, the newly released Oracle VM Template for MySQL Enterprise Edition, as well as what's new in MySQL 5.6 and MySQL Cluster 7.2, including NoSQL access methods to MySQL.

Register for this French Seminar:
http://www.oracle.com/webapps/events/ns/EventsDetail.jsp?p_eventId=139118&src=7314534&src=7314534&Act=37

White Paper: Oracle VM Template for MySQL Enterprise Edition

The Oracle VM Template for MySQL Enterprise Edition is engineered to address the challenges of a rapidly expanding data center, helping users to rapidly & safely deploy and manage web and cloud-based MySQL applications, with a lower TCO (Total Cost of Ownership) than other virtualization technologies in the marketplace.

Read this White Paper:
http://dev.mysql.com/why-mysql/white-papers/mysql_wp_oracle-vm-template-for-mee.php

Podcast: New "Meet The MySQL Experts" Podcast Series

We're very pleased to announce a new Oracle podcast series entitled "Meet the MySQL Experts". Once a month, we will interview an Oracle MySQL engineer to share his/her domain expertise. Mats Kindahl from the MySQL replication team was interviewed in the first edition and talked about MySQL Replication.

Listen to the Podcast:
http://feedproxy.google.com/~r/MeetTheMysqlExperts/~3/YmdGbvlatns/10232179_MySQL_Replication_071211.mp3

Social Media: MySQL Facebook Page Reaches 100,000 Fans!

Since the MySQL Facebook Page was revitalized last October, we've seen an exponential growth in our Facebook community. In just 9 months, we reached the milestone of 100,000 fans! Thank you for the support, and we will continue to post the latest MySQL news, including product releases, white papers, blog articles, upcoming webinars, worldwide events, and more.

Visit the MySQL Facebook Page:
https://www.facebook.com/mysql

Award: MySQL Wins the php|architect Impact Award for Data Management

MySQL was voted as the winner in the Data Management category in 2011 Impact Awards! Selected by the subscribers of php|architect magazine, the winners represent the projects that have had the most impact on the day-to-day lives of PHP developers.

Learn More:
http://www.phparch.com/2011/06/impact-award-winners/

Live Webinar: MySQL Replication: Tips and Tricks
Thursday, August 11, 2011 - 9:00am PT

Replication is a versatile tool to solving many problems in today's highly dynamic modern web architectures, as well as offering many ways to simplify maintenance. In this session, the MySQL replication developers will present a bag of useful tips and tricks related to the MySQL 5.5 GA and MySQL 5.6 Development Milestone Release.

Live Webinar: Building High Performance and High Traffic PHP Applications with MySQL - Part 2: Best Practices
Tuesday, August 16, 2011 - 9:00am PT

Building upon the fundamental knowledge shared in Part 1 of the 3-part Webinar series, in the second installment we will unveil some of the inner workings in MySQL PHP APIs to help you make the best choices when building your applications. Many settings are designed to be configured for your specific application to achieve better performance, and yet are not discussed very often.

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

New Product Releases

New Release of MySQL Community Server 5.5.14 (GA)

MySQL 5.5.14 is a new version of the 5.5 production release of the world's most popular open source database. MySQL 5.5.14 is recommended for use on production systems.

MySQL 5.5 includes several high-impact enhancements to improve the performance and scalability of the MySQL Database, taking advantage of the latest multi-CPU and multi-core hardware and operating systems.

View the Complete List of Changes:
http://dev.mysql.com/doc/refman/5.5/en/news-5-5-14.html

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

New Release of MySQL Cluster 7.1.15 (GA)

The binary version of MySQL Cluster 7.1.15 has now been made available for download.

View the Complete List of Changes:
http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-news-5-1-56-ndb-7-1-15.html

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

New Release of MySQL Workbench 5.2.34 (GA)

The MySQL Developer Tools team is pleased to announce the next release of its flagship product, MySQL Workbench, version 5.2.34. This is a maintenance release containing many fixes, including stability improvements on all supported platforms.

View the Complete List of Changes:
http://dev.mysql.com/doc/workbench/en/wb-news-5-2-34.html

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

New Release of MySQL Connector/J 5.1.17 (GA)

MySQL Connector/J 5.1.17, a maintenance release of the production 5.1 branch has been released. Connector/J is the Type-IV pure-Java JDBC driver for MySQL. Version 5.1.17 is suitable for use with any MySQL version including MySQL 5.1 and MySQL 5.5.

View the Complete List of Changes:
http://dev.mysql.com/doc/refman/5.1/en/cj-news-5-1-17.html

Download Now:
http://dev.mysql.com/downloads/connector/j/5.1.html

New Release of MySQL Connector/MXJ 5.0.12 (GA)

MySQL Connector/MXJ 5.0.12 is now available for download. MySQL Connector/MXJ is a Java utility package for deploying and managing a MySQL RDBMS.

MySQL Connector/MXJ may be bundled into an existing Java application and managed as a POJO (Plain Old Java Object) or launched by creating a Connector/J connection. This makes it easy for Java developers creating an application that uses JDBC through MySQL Connector/J to deploy applications by reducing installation barriers for their end users.

View the Complete List of Changes:
http://dev.mysql.com/doc/refman/5.6/en/news-connector-mxj-5-0-12.html

Download Now:
http://dev.mysql.com/downloads/connector/mxj/5.0.html

New Release of MySQL Connector/Net 6.4.3 (GA)

MySQL Connector/Net 6.4.3, a new version of the all-managed .NET driver for MySQL has been released. This is a GA release and is intended for full production deployment. New features in version 6.4 include:

- Windows Authentication
- Table Caching
- Simple Connection Fail-over Support

Read the Documentation:
http://dev.mysql.com/doc/refman/5.1/en/connector-net.html

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

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

Hints & Tips

White Paper: Guide to Scaling Web Databases with MySQL Cluster

This Guide explores the technology that enables MySQL Cluster to deliver web-scale performance with carrier-grade availability, and provides the resources to get you started in building your next successful web service.

Read this White Paper:
http://dev.mysql.com/why-mysql/white-papers/mysql_wp_scaling_web_databases.php

White Paper: Unlocking New Value from Web Session Management

As organizations seek to enhance their users' web experience through personalization based on historic browsing and buying behaviors, session data is becoming increasingly critical. For rapidly growing web properties, it makes sense to evaluate the MySQL Cluster database.

This is a practical whitepaper featuring code samples that further discusses the challenges and solutions to session management.

Read this White Paper:
http://dev.mysql.com/why-mysql/white-papers/mysql_wp_session_mngmnt.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: Comparing Databases with mysqldbcompare
Chuck Bell

If you have two or more database servers containing the same data, how do you know if the objects are identical? Furthermore, how can you be sure the data is the same on all of the servers?

Read the PlanetMySQL BlogPost:
http://drcharlesbell.blogspot.com/2011/06/comparing-databases-with-mysqldbcompare.html

PlanetMySQL Blog: MySQL Left Join
Hazan Ilan

Even if you think you know everything about LEFT JOIN, I bet you will learn something or two in this post!

Read the PlanetMySQL BlogPost:
http://www.mysqldiary.com/mysql-left-join/

PlanetMySQL Blog: FISL12 -- Open Source show with Music and Dancing in Brazil
Dave Stokes

The MySQL Community is large, vibrant, and inquisitive. Davi Arnaut, one of our developers who lives in the North of Brazil, presented on MySQL 5.5 and 5.6 to a full room. I was in the Oracle booth answering questions about new features, Workbench and the Enterprise Edition.

Read the PlanetMySQL BlogPost:
http://dave-stokes.blogspot.com/2011/07/fisl12-open-source-show-with-music-and.html

PlanetMySQL Blog: Performance schema, overhead tuning
Marc Alff

One of the most important question users ask before deciding to use the performance schema is: what is the overhead? The underlying concern of course is to make sure deploying the performance schema does not negatively impact production. The question is simple, and yet the answer is not so simple, as it depends on so many things.

Read the PlanetMySQL BlogPost:
http://marcalff.blogspot.com/2011/06/performance-schema-overhead-tuning.html

PlanetMySQL Blog: MySQL Enterprise Backup 3.6 - New backup streaming, integration with Oracle Secure Backup and other common backup media solutions
Rob Young

All DBAs understand the importance and priority of quick, reliable database backup and recovery operations. In fact, dating back to my early days with MySQL, the most commonly requested product features from the MySQL user base have been around online, non-blocking backup solutions for running MySQL servers.

Read the PlanetMySQL BlogPost:
http://blogs.oracle.com/MySQL/entry/mysql_enterprise_backup_3_6

PlanetMySQL Blog: Scaling Web Databases with MySQL Cluster
Mat Keep

The realities of today's successful web services are creating new demands that many legacy databases were just not designed to handle.

Read Part 1 - Auto-Sharding with MySQL Cluster:
http://blogs.oracle.com/MySQL/entry/scaling_web_databases_auto_sharding

Read Part 2 - Adding Nodes, Evolving Schema with Zero Downtime:
http://blogs.oracle.com/MySQL/entry/scaling_web_databases_adding_nodes

PlanetMySQL Blog: How heartbeat is helpful for MySQL Replication
Nilnandan Joshi

Heartbeat is a project from Linux-HA. Heartbeat is helpful when we have a pair or more servers which are configured to replicate in the circular fashion.

Read the PlanetMySQL BlogPost:
http://nilinfobin.com/2011/07/how-heartbeat-helpful-for-mysql-replication/

PlanetMySQL Blog: Simpler and Safer Clustering: MySQL Cluster Manager Update
Mat Keep

Clustered computing brings with it many benefits: high performance, high availability, scalable infrastructure, etc. But it also brings with it more complexity.

Read the PlanetMySQL BlogPost:
http://blogs.oracle.com/MySQL/entry/simpler_and_safer_clustering_mysql

PlanetMySQL Blog: Announcing common_schema: common views & routines for MySQL
Shlomi Noach

Today I have released common_schema, a utility schema for MySQL which includes many views and functions, and is aimed to be installed on any MySQL server.

Read the PlanetMySQL BlogPost:
http://code.openark.org/blog/mysql/announcing-common_schema-common-views-routines-for-mysql

PlanetMySQL Blog: Automatically restarting MySQL slaves the easy way
Anders Karlsson

MySQL Replication is something that is used by many, many MySQL users, and here at Recorded Future we are no exception. In our case, the slaves are used for different purposes, and as we develop our system so much and so fast, sometimes things happen which could have been avoided.

Read the PlanetMySQL BlogPost:
http://karlssonondatabases.blogspot.com/2011/06/automatically-restarting-mysql-slaves.html

PlanetMySQL Blog: Finding and killing long running InnoDB transactions with Events
Mark Leith

I've seen a number of solutions for finding long running transactions or sessions within InnoDB/MySQL now. Every single one of them has been implemented as a script that is either invoked manually, or via some cron job, that then connects and tries to find, and possibly diagnose or kill, transactions that break some "long running" threshold. We also have a rule in MySQL Enterprise Monitor that flags this for further inspection.

Read the PlanetMySQL BlogPost:
http://www.markleith.co.uk/?p=730

PlanetMySQL Blog: Better than linear scaling is possible
Mikael Ronstrom

As part of my research for my Ph.D. thesis, I spent a lot of time understanding the impact of CPU caches on the performance of a DBMS. I concluded that in a parallel data server it is actually possible to get better than linear scaling in certain workloads.

Read the PlanetMySQL BlogPost:
http://mikaelronstrom.blogspot.com/2011/05/better-than-linear-scaling-is-possible.html

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

Events

Live Webinar: What's New in MySQL 5.6 - Part 1: Overview
Thursday, August 18, 2011 - 9:00am PT

MySQL 5.6 builds on Oracle's investment in MySQL by adding improvements to Performance, InnoDB, Replication, Instrumentation and flexibility with NoSQL (Not Only SQL) access. In the first session of this 5-part Webinar series, we'll cover the highlights of those enhancements to help you begin the development and testing efforts around the new features and improvements that are now available in the latest MySQL 5.6 Development Milestone Release.

Live Webinar: MySQL Workbench for ISVs and OEMs: Better MySQL Database Applications by Design
Tuesday, August 23, 2011 - 9:00am PT

MySQL Workbench is a visual database modeling and design tool that helps application developers create new physical data models for MySQL databases and modify existing physical MySQL databases with reverse/forward engineering and change management functions. This is particularly important for ISV's and OEM's whose products' success or failure can hinge on their data design and management.

Live Webinar: MySQL Cluster: Scaling Web Databases with Auto-Partitioning and SQL/NoSQL Access - JAPAC
Friday, August 26, 2011 - 10:30am Mumbai Time

MySQL Cluster has been deployed to support some of the most demanding transactional services in the web and telecoms domains. This webinar will discuss best practices in scaling services on-demand for high volumes of reads and writes, and provide insight on the range of NoSQL and SQL access methods available to developers.

Live Webinar: Building High Performance and High Traffic PHP Applications with MySQL - The Fundamentals - French
Tuesday, August 30, 2011 - 10:00 CET

In this webinar we will walk through the fundamentals of creating dynamic web content using MySQL and PHP. We will also discuss many of the building blocks and key considerations when you architect your PHP applications, including the frameworks, APIs, security features, and asynchronous queries.

On-Demand Webinar: MySQL Essentials Part 10 - MySQL Replication Essentials

In the final webinar of the 10-part MySQL Essentials series, we'll share the technical and business reasons for deploying MySQL Replication and give an overview of how to deploy a master/slave configuration. You'll learn the fundamentals on how to install, configure, and manage a replicated environment.

On-Demand Webinar: MySQL Relational Database Management Webcast

In this recorded webinar, Angeliki Korovesi will give you a brief introduction to MySQL and its contribution to the open source community. She will discuss the different features and services of MySQL and explain the importance of MySQL, as well as how it can be used.

Register for this On-Demand Webinar:
http://www.oracle.com/webapps/dialogue/ns/dlgwelcome.jsp?p_ext=Y&p_dlg_id=10145442&src=7300551&Act=16

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

Want to evaluate the advanced capabilities in the MySQL Enterprise Edition?

Try Now with MySQL Enterprise Edition Trial:
http://www.mysql.com/trials/

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

About the Newsletter

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

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/2011/2011-07.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, July 27, 2011

MySQL Newsletter: July 2011

Followers

Blog Archive

About Me