MySQL Newsletter
August 2011
Articles in this newsletter:
Highlights
- DevZone Article: MySQL 5.6 Early Access Features - InnoDB and Replication!
- Event: Oracle Showcases MySQL at Innovation Nation & GOSCON 2011 - Washington, DC (August 23)
- Event: OTN Developer Day: MySQL - Washington, DC (August 24)
- Event: MySQL Community Reception at Oracle OpenWorld - San Francisco, CA (October 4)
- Blog: MySQL 5.6 Feedback
- Demo: MySQL Enterprise Edition
- Live Webinar: What's New in MySQL 5.6 - Part 1: Overview (August 18)
- Live Webinar: MySQL Essentials for ISVs & OEMs, Part 1: Faster Development and Better Applications with MySQL Workbench (August 23)
New Product Releases
- New Release of MySQL Community Server 5.5.15 (GA)
- New Release of MySQL Installer 5.5.14.1 (RC)
Hints & Tips
- Developer Interview: Globalizing MySQL - Interview with Alexander "Bar" Barkov
- PlanetMySQL Blog Posts
- PlanetMySQL Blog: InnoDB Full-Text Search Tutorial
- PlanetMySQL Blog: Difference between InnoDB FTS and MyISAM FTS
- PlanetMySQL Blog: Binlog Group Commit Experiments
- PlanetMySQL Blog: About InnoDB: Shortened warm-up times with a preloaded InnoDB buffer pool
- PlanetMySQL Blog: MySQL 5.6 Replication - New Early Access Features
- PlanetMySQL Blog: How to Easily See Who's Connected to Your MySQL Server
- PlanetMySQL Blog: Inserting Data into MySQL with Perl
- PlanetMySQL Blog: Scaling Web Databases, Part 3: SQL & NoSQL Data Access
- PlanetMySQL Blog: Improvements for PHP application portability in PHP.next
Events
- Seminar: Oracle Enterprise-Ready Open Source Software Seminar - Hong Kong & Beijing (August 18 & 30)
- Live Webinar: MySQL Cluster: Scaling Web Databases with Auto-Partitioning and SQL/NoSQL Access - APAC (August 26)
- Live Webinar: Building High Performance and High Traffic PHP Applications with MySQL - The Fundamentals - French (August 30)
- Seminar: High Availability Solutions for MySQL - Paris, France (September 7)
- Live Webinar: MySQL Replication Essentials - German (September 29)
-------------------------------------------------------------------
Highlights
DevZone Article: MySQL 5.6 Early Access Features - InnoDB and Replication!
Rob Young
MySQL 5.5 has been widely acknowledged to be the best release in the history of MySQL. And, in April 2011, we raised the bar again with Development Milestone Release (DMR) and Early Access features of MySQL 5.6. At OSCON 2011, we are delivering more early access features for InnoDB and Replication. These features are focused on better scalability, performance and flexibility. We look forward to community testing and feedback.
Read this Article:
http://dev.mysql.com/tech-resources/articles/mysql56-labs-july2011.html
Event: Oracle Showcases MySQL at Innovation Nation & GOSCON 2011 - Washington, DC
Tuesday, 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 there!
Learn More about GOSCON/Innovation Nation:
http://www.oracle.com/webapps/events/ns/EventsDetail.jsp?p_eventId=140023&src=7314534&src=7314534&Act=78
Learn More about Sun Ray:
http://www.oracle.com/us/technologies/virtualization/061984.html
Event: OTN Developer Day: MySQL - Washington, DC
Wednesday, August 24, 2011
The MySQL Developer Day is a one-stop shop for you to learn all the essential MySQL skills. In this free, one-day seminar, we will cover everything you need to know to successfully design, develop, and manage your MySQL databases. You'll also learn the guidelines and best practices in performance tuning and scalability. Space is limited so RSVP now!
Register Now:
http://www.oracle.com/webapps/events/ns/EventsDetail.jsp?p_eventId=139866&src=7328803&Act=8&evite=8
Event: MySQL Community Reception at Oracle OpenWorld - San Francisco, CA
Tuesday, October 4, 2011
Come celebrate the growth of the MySQL community with Oracle's MySQL team! Whether you are attending the MySQL Track at Oracle OpenWorld, a member of local MySQL user groups, a MySQL user in the San Francisco Bay Area, or simply interested in MySQL technology, you're all invited to Oracle's MySQL Community Reception. Don't forget to register for Oracle OpenWorld and enjoy 40+ MySQL sessions!
RSVP Now for the MySQL Community Reception:
http://www.oracle.com/webapps/events/ns/EventsDetail.jsp?p_eventId=140041&src=7314534&src=7314534&Act=83&evite=83
View the MySQL Sessions at Oracle OpenWorld via Content Catalog:
https://oracleus.wingateweb.com/scheduler/eventcatalog/eventCatalog.do
Register for Oracle OpenWorld:
http://www.oracle.com/openworld/register/packages/index.html
Blog: MySQL 5.6 Feedback
Keith Larson
The MySQL Community Team would like your feedback about MySQL 5.6! What are you excited to see and test? What have you tested and benchmarked? Did you previously see the advantages of going to MySQL 5.5 and now eager to try 5.6?
Read this Blog Post:
http://sqlhjalp.blogspot.com/2011/08/mysql-56-feedback.html
Demo: MySQL Enterprise Edition
In only 3 minutes, this demo helps you understand how Oracle's MySQL Enterprise Edition reduces the risk, cost and time required in developing, deploying and managing business-critical MySQL applications.
Watch the Demo:
http://www.oracle.com/pls/ebn/swf_viewer.load?p_shows_id=10146324
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 and Early Access Features.
Register for this Webinar:
http://dev.mysql.com/news-and-events/web-seminars/display-650.html?p=EnNL
Live Webinar: MySQL Essentials for ISVs & OEMs, Part 1: Faster Development and Better Applications with MySQL Workbench
Tuesday, August 23, 2011 - 9:00AM PT
MySQL Workbench is a visual database modeling and design tool, a SQL editor, and an administrative tool. MySQL Workbench can help you create and validate your schema for your new MySQL databases, optimize existing physical MySQL databases with reverse/forward engineering and change management functions, resulting in faster development and time-to-market, better product quality and performance, and easier as-needed administration.
Register for this Webinar:
http://dev.mysql.com/news-and-events/web-seminars/display-653.html?p=EnNL
-------------------------------------------------------------------
New Product Releases
New Release of MySQL Community Server 5.5.15 (GA)
MySQL 5.5.15 is a new version of the 5.5 production release of the world's most popular open source database. MySQL 5.5.15 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. In addition, with release 5.5, InnoDB is now the default storage engine for the MySQL Database, delivering ACID transactions, referential integrity and crash recovery by default.
View the Complete List of Changes:
http://dev.mysql.com/doc/refman/5.5/en/news-5-5-15.html
Download Now:
http://dev.mysql.com/downloads/mysql/
New Release of MySQL Installer 5.5.14.1 (RC)
MySQL Installer 5.5.14.1 RC4 has been released. This is the final release candidate before GA so your feedback is greatly appreciated.
MySQL Installer is the all-in-one installation solution for all your MySQL software needs. It comes with the latest MySQL Server and related components (MySQL Workbench, Connectors, and documentation) and includes wizards to help with the installation and configuration.
Learn More:
http://dev.mysql.com/tech-resources/articles/mysql-installer-for-windows.html
Download Now:
http://dev.mysql.com/downloads/installer/
-------------------------------------------------------------------
Hints & Tips
Developer Interview: Globalizing MySQL - Interview with Alexander "Bar" Barkov
We interviewed Alexander "Bar" Barkov to discuss the recent improvements in MySQL globalization that enable MySQL users around the world to use the database system more easily and naturally.
Read the Interview:
http://dev.mysql.com/tech-resources/interviews/alexander-barkov.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: InnoDB Full-Text Search Tutorial
John Russell
The InnoDB full-text search capability is an exciting feature. The full-text search itself is generally useful to have in an RDBMS. If an application is using all InnoDB tables except for one that is used for full-text searches, now that last table can be switched to InnoDB. If putting the full-text data in a MyISAM table led to scalability problems, duplication, or a less-than-ideal schema design, now those issues can be addressed.
Read the PlanetMySQL BlogPost:
http://blogs.innodb.com/wp/2011/07/innodb-full-text-search-tutorial/
PlanetMySQL Blog: Difference between InnoDB FTS and MyISAM FTS
Jimmy Yang
With the latest MySQL 5.6 feature preview, InnoDB now has its own Fulltext Search (FTS) support. People might wonder how different is this FTS comparing with that of MyISAM. From the usage standpoint, they seem very similar with no apparent difference. However, in the underlying FTS engine, the difference is huge, since two are built on different storage engines with totally different design.
Read the PlanetMySQL BlogPost:
http://blogs.innodb.com/wp/2011/07/difference-between-innodb-fts-and-myisam-fts/
PlanetMySQL Blog: Binlog Group Commit Experiments
Mats Kindahl
It was a while ago since I talked about binary log group commit. Since then, Kristian has released a version of binary log group commit that seems to work well. However, for a few reasons that will be outlined below, we decided to do experiments ourselves using the approach that I have described earlier.
Read the PlanetMySQL BlogPost:
http://mysqlmusings.blogspot.com/2011/07/binlog-group-commit-experiments.html
PlanetMySQL Blog: About InnoDB: Shortened warm-up times with a preloaded InnoDB buffer pool
Simon Mudd
This comment is in regard to this InnoDB blog post. The page talks about a new feature which allows you to save on shutdown an InnoDB buffer pool and to load this on startup, ensuring that once loaded the database will perform with this "hot" cache. That sounds interesting as I have seen on numerous occasions that if the buffer pool is not warm then the performance can be a magnitude worse.
Read the PlanetMySQL BlogPost:
http://blog.wl0.org/2011/07/about-innodbs-shortened-warm-up-times-with-a-preloaded-innodb-buffer-pool/
PlanetMySQL Blog: MySQL 5.6 Replication - New Early Access Features
Mat Keep
At OSCON 2011, Oracle delivered more early access features for MySQL 5.6 replication. These features are focused on better integration, performance and data integrity, built on the significant replication enhancements announced as part of the MySQL 5.6.2 Development Milestone Release back in April.
Read the PlanetMySQL BlogPost:
http://blogs.oracle.com/MySQL/entry/mysql_5_6_replication_new
PlanetMySQL Blog: How to Easily See Who's Connected to Your MySQL Server
Shlomo Priymak
If you have servers which have multiple application servers connected to them, you often need to see things like who's connected, how many connections they have, and which users.
Read the PlanetMySQL BlogPost:
http://blog.shlomoid.com/2011/08/how-to-easily-see-whos-connected-to.html
PlanetMySQL Blog: Inserting Data into MySQL with Perl
Tony Darnell
In the two previous posts, we looked at simply connecting to a MySQL database via Python and Perl. In this post, we will use an insert statement to input data into a MySQL table via Perl, and use a select statement to view the same data to confirm our results.
Read the PlanetMySQL BlogPost:
http://scriptingmysql.wordpress.com/2011/08/05/inserting-data-into-mysql-with-perl/
PlanetMySQL Blog: Scaling Web Databases, Part 3: SQL & NoSQL Data Access
Mat Keep
Supporting successful services on the web means scaling your back-end databases across multiple dimensions. This blog focuses on scaling access methods to your data using SQL and/or NoSQL interfaces.
Read the PlanetMySQL BlogPost:
http://blogs.oracle.com/MySQL/entry/scaling_web_databases_part_3
PlanetMySQL Blog: Improvements for PHP application portability in PHP.next
Johannes Schlüter
I was writing about PHP.next before, and many things have improved there meanwhile. Most notably we have a committed version number: the next PHP release will be called PHP 5.4. The topic I want to talk about today is "Improved application portability" which covers multiple small changes which aim at making it simpler for developers to write applications working on any PHP setup.
Read the PlanetMySQL BlogPost:
http://schlueters.de/blog/archives/156-Improvements-for-PHP-application-portability-in-PHP.next.html
-------------------------------------------------------------------
Events
Seminar: Oracle Enterprise-Ready Open Source Software Seminar - Hong Kong & Beijing
Join us at this executive seminar where you will learn how Oracle can offer you a Complete Open Source Technology Stack. Oracle continues its long track record of contributions to the open source community and we are pleased to share its latest technology on Oracle Linux, MySQL, and Oracle VM.
Register for the Seminar in Hong Kong on August 18:
http://www.oracle.com/webapps/events/ns/EventsDetail.jsp?p_eventId=139871&src=7314534&src=7314534&Act=70
Register for the Chinese Seminar in Beijing, China on August 30:
http://www.oracle.com/go/?&Src=7314534&Act=68&pcode=WWMK11042736MPP035
Live Webinar: MySQL Cluster: Scaling Web Databases with Auto-Partitioning and SQL/NoSQL Access - APAC
Friday, August 26, 2011 - 13:00 Singapore 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.
Register for this Webinar:
http://dev.mysql.com/news-and-events/web-seminars/display-649.html?p=EnNL
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.
Register for this French Webinar:
http://dev.mysql.com/news-and-events/web-seminars/display-646.html?p=EnNL
Seminar: High Availability Solutions for MySQL - Paris, France
Wednesday, September 7, 2011
During this free French seminar, we will review 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.
Register for this French Seminar:
http://www.oracle.com/webapps/events/ns/EventsDetail.jsp?p_eventId=139118&src=7314534&src=7314534&Act=37
Live Webinar: MySQL Replication Essentials - German
Thursday, September 29, 2011 - 15:00 CET
In this webinar 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.
Register for this German Webinar:
http://dev.mysql.com/news-and-events/web-seminars/display-652.html?=EnNL
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-08.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.
DB2 Query Management Facility V10 for z/OS
