MySQL Newsletter July 2011
Articles in this newsletter:
- 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 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)
- 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
- 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
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.
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!
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!
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.
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.
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.
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.
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.
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.
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.
The binary version of MySQL Cluster 7.1.15 has now been made available for download.
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.
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.
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.
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
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.
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.
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.
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?
Even if you think you know everything about LEFT JOIN, I bet you will learn something or two in this post!
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.
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.
PlanetMySQL Blog: MySQL Enterprise Backup 3.6 - New backup streaming, integration with Oracle Secure Backup and other common backup media solutions
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.
The realities of today's successful web services are creating new demands that many legacy databases were just not designed to handle.
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.
Clustered computing brings with it many benefits: high performance, high availability, scalable infrastructure, etc. But it also brings with it more complexity.
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.
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.
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.
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.
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.
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.
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.
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.
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?