MySQL Newsletter August 2011
Articles in this newsletter:
- 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)
- 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
- 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)
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.
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!
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!
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!
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?
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.
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.
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.
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.
MySQL Installer 5.5.15 GA has been released.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
More free MySQL webinars are scheduled and added between each Newsletter edition, so visit our website frequently for the most updated information.
Want to receive the latest MySQL updates and interact with the MySQL community?
Want to evaluate the advanced capabilities in the MySQL Enterprise Edition?