Sunday Sep 30, 2012

Attending MySQL Connect? Your Opinion Matters.

Take the MySQL Connect 2012 Survey

Thanks to everyone who is at the first ever MySQL Connect Conference in San Francisco this weekend! Don't forget to take your Conference and Session Surveys. Your opinions help shape next year's conference.

  • Take a survey for each of the sessions you attend and be entered into a drawing for one prize for $200 American Express Gift Certificate.
  • Fill in the daily conference survey and be entered into a drawing for one prize for a $500 American Express Gift Card
  • Surveys are located here.

Make your opinion count! Take the survey now.

Congratulations to Robin Schumacher from DataStax as he is the winner of the Saturday survey!

Thursday Sep 27, 2012

2 Days to Go before MySQL Connect - Focus on Hands-On Labs

The Oracle MySQL team is very eager to meet all MySQL community members, users, customers and partners gathering this weekend in San Francisco for MySQL Connect!

Eight different Hands-On Labs will give you the opportunity to get hands-on experience on the following topics. All taking place in Plaza Room A.


11.30 am
Developing Applications with MySQL and Java—Mark Matthews, Oracle

1.00 pm (2.5 hours long)
Getting Started with MySQL—Gillian Gunson and Alfredo Kojima, Oracle

4.00 pm
Getting Started with MySQL Cluster—Santo Leto, Oracle

5.30 pm
Improving Performance with the MySQL Performance Schema—Jesper Krogh, Oracle


10.15 am (2.5 hours long)

Focus on MySQL Replication—Sven Sandberg and Luis Soares, Oracle

1.15 pm

MySQL Utilities—Charles Bell, Oracle

2.45 pm

Performance Tuning with MySQL Enterprise Monitor—Mark Matthews, Oracle

4.15 pm

MySQL Security: Authentication and Audit—Jonathon Coombes, Oracle

Not registered yet? You can still save US$ 300 off the on-site fee! Attending Oracle openWorld or JavaOne? Add MySQL Connect to your registration for only US$100!

Register Now!

Wednesday Sep 26, 2012

MySQL Connect Starting in 3 Days - New Keynote Announced

We're very pleased to announce a new keynote that will take place on Saturday morning at 10.00 am:

"Community Perspective - Why Upgrade to MySQL 5.6"

Sarah Novotny will lead a lively panel discussion with several MySQL Community members. They will share their opinions and debate about the new MySQL Database features they’re excited about.

Moderator: Sarah Novotny, CIO, Meteor Entertainment


Sheeri Cabral, Database Admin/Architect, Mozilla

Giuseppe Maxia, QA Director, Continuent

Domas Mituzas, Database Performance Team, Facebook

Mark Leith, Software Development Senior Manager, Oracle

This new keynote will follow the State of the Dolphin address by Oracle's Chief Corporate Architect Edward Screven and VP of MySQL Engineering Tomas Ulin. An exciting kick-off for MySQL Connect!

Not registered yet? You can still save US$ 300 off the on-site fee – Register Now!

Friday Sep 21, 2012

MySQL Connect 8 Days Away - Replication Sessions

Following on from my post about MySQL Cluster sessions at the forthcoming Connect conference, its now the turn of MySQL Replication - another technology at the heart of scaling and high availability for MySQL.

Unless you've only just returned from a 6-month alien abduction, you will know that MySQL 5.6 includes the largest set of replication enhancements ever packaged into a single new release:

- Global Transaction IDs + HA utilities for self-healing cluster..(yes both automatic failover and manual switchover available!)

- Crash-safe slaves and binlog

- Binlog Group Commit and Multi-Threaded Slaves for high performance

- Replication Event Checksums and Time-Delayed replication

- and many more

There are a number of sessions dedicated to learn more about these important new enhancements, delivered by the same engineers who developed them. Here is a summary

Saturday 29th, 13.00

Replication Tips and Tricks, Mats Kindahl

In this session, the developers of MySQL Replication present a bag of useful tips and tricks related to the MySQL 5.5 GA and MySQL 5.6 development milestone releases, including multisource replication, using logs for auditing, handling filtering, examining the binary log, using relay slaves, splitting the replication stream, and handling failover.

Saturday 29th, 17.30

Enabling the New Generation of Web and Cloud Services with MySQL 5.6 Replication, Lars Thalmann

This session showcases the new replication features, including

• High performance (group commit, multithreaded slave)

• High availability (crash-safe slaves, failover utilities)

• Flexibility and usability (global transaction identifiers, annotated row-based replication [RBR])

• Data integrity (event checksums)

Saturday 29th, 1900

MySQL Replication Birds of a Feather

In this session, the MySQL Replication engineers discuss all the goodies, including global transaction identifiers (GTIDs) with autofailover; multithreaded, crash-safe slaves; checksums; and more. The team discusses the design behind these enhancements and how to get started with them. You will get the opportunity to present your feedback on how these can be further enhanced and can share any additional replication requirements you have to further scale your critical MySQL-based workloads.

Sunday 30th, 10.15

Hands-On Lab, MySQL Replication, Luis Soares and Sven Sandberg

But how do you get started, how does it work, and what are the best practices and tools? During this hands-on lab, you will learn how to get started with replication, how it works, architecture, replication prerequisites, setting up a simple topology, and advanced replication configurations. The session also covers some of the new features in the MySQL 5.6 development milestone releases.

Sunday 30th, 13.15

Hands-On Lab, MySQL Utilities, Chuck Bell

Would you like to learn how to more effectively manage a host of MySQL servers and manage high-availability features such as replication? This hands-on lab addresses these areas and more. Participants will get familiar with all of the MySQL utilities, using each of them with a variety of options to configure and manage MySQL servers.

Sunday 30th, 14.45

Eliminating Downtime with MySQL Replication, Luis Soares

The presentation takes a deep dive into new replication features such as global transaction identifiers and crash-safe slaves. It also showcases a range of Python utilities that, combined with the Release 5.6 feature set, results in a self-healing data infrastructure. By the end of the session, attendees will be familiar with the new high-availability features in the whole MySQL 5.6 release and how to make use of them to protect and grow their business.

Sunday 30th, 17.45

Scaling for the Web and the Cloud with MySQL Replication, Luis Soares

In a Replication topology, high performance directly translates into improving read consistency from slaves and reducing the risk of data loss if a master fails. MySQL 5.6 introduces several new replication features to enhance performance. In this session, you will learn about these new features, how they work, and how you can leverage them in your applications. In addition, you will learn about some other best practices that can be used to improve performance.

So how can you make sure you don't miss out - the good news is that registration is still open ;-)

And just to whet your appetite, listen to the On-Demand webinar that presents an overview of MySQL 5.6 Replication.  

Thursday Sep 20, 2012

MySQL Connect 9 Days Away – Optimizer Sessions

Following my previous blog post focusing on InnoDB talks at MySQL Connect, let us review today the sessions focusing on the MySQL Optimizer:

  • Saturday, 11.30 am, Room Golden Gate 6:

MySQL Optimizer Overview—Olav Sanstå, Oracle

The goal of MySQL optimizer is to take a SQL query as input and produce an optimal execution plan for the query. This session presents an overview of the main phases of the MySQL optimizer and the primary optimizations done to the query. These optimizations are based on a combination of logical transformations and cost-based decisions. Examples of optimization strategies the presentation covers are the main query transformations, the join optimizer, the data access selection strategies, and the range optimizer. For the cost-based optimizations, an overview of the cost model and the data used for doing the cost estimations is included.

  • Saturday, 1.00 pm, Room Golden Gate 6:

Overview of New Optimizer Features in MySQL 5.6—Manyi Lu, Oracle

Many optimizer features have been added into MySQL 5.6. This session provides an introduction to these great features. Multirange read, index condition pushdown, and batched key access will yield huge performance improvements on large data volumes. Structured explain, explain for update/delete/insert, and optimizer tracing will help users analyze and speed up queries. And last but not least, the session covers subquery optimizations in Release 5.6.

  • Saturday, 7.00 pm, Room Golden Gate 4:

BoF: Query Optimizations: What Is New and What Is Coming?

This BoF presents common techniques for query optimization, covers what is new in MySQL 5.6, and provides a discussion forum in which attendees can tell the MySQL optimizer team which optimizations they would like to see in the future.

  • Sunday, 1.15 pm, Room Golden Gate 8:

Query Performance Comparison of MySQL 5.5 and MySQL 5.6—Øystein Grøvlen, Oracle

MySQL Release 5.6 contains several improvements in the query optimizer that create improved performance for complex queries. This presentation looks at how MySQL 5.6 improves the performance of many of the queries in the DBT-3 benchmark. Based on the observed improvements, the presentation discusses what makes the specific queries perform better in Release 5.6. It describes the relevant new optimization techniques and gives examples of the types of queries that will benefit from these techniques.

  • Sunday, 4.15 pm, Room Golden Gate 4:

Powerful EXPLAIN in MySQL 5.6—Evgeny Potemkin, Oracle

The EXPLAIN command of MySQL has long been a very useful tool for understanding how MySQL will execute a query. Release 5.6 of the MySQL database offers several new additions that give more-detailed information about the query plan and make it easier to understand at the same time. This presentation gives an overview of new EXPLAIN features: structured EXPLAIN in JSON format, EXPLAIN for INSERT/UPDATE/DELETE, and optimizer tracing. Examples in the session give insights into how you can take advantage of the new features. They show how these features supplement and relate to each other and to classical EXPLAIN and how and why the MySQL server chooses a particular query plan.

You can check out the full program here as well as in the September edition of the MySQL newsletter.

Not registered yet? You can still save US$ 300 over the on-site fee – Register Now!

Wednesday Sep 19, 2012

MySQL Connect Only 10 Days Away - Focus on InnoDB Sessions

Time flies and MySQL Connect is only 10 days away!

You can check out the full program here as well as in the September edition of the MySQL newsletter.

Mat recently blogged about the MySQL Cluster sessions you’ll have the opportunity to attend, and below are those focused on InnoDB. Remember you can plan your schedule with Schedule Builder.

  • Saturday, 1.00 pm, Room Golden Gate 3:

10 Things You Should Know About InnoDB—Calvin Sun, Oracle

InnoDB is the default storage engine for Oracle’s MySQL as of MySQL Release 5.5. It provides the standard ACID-compliant transactions, row-level locking, multiversion concurrency control, and referential integrity. InnoDB also implements several innovative technologies to improve its performance and reliability. This presentation gives a brief history of InnoDB; its main features; and some recent enhancements for better performance, scalability, and availability.

  • Saturday, 5.30 pm, Room Golden Gate 4:

Demystified MySQL/InnoDB Performance Tuning—Dimitri Kravtchuk, Oracle

This session covers performance tuning with MySQL and the InnoDB storage engine for MySQL and explains the main improvements made in MySQL Release 5.5 and Release 5.6. Which setting for which workload? Which value will be better for my system? How can I avoid potential bottlenecks from the beginning? Do I need a purge thread? Is it true that InnoDB doesn't need thread concurrency anymore? These and many other questions are asked by DBAs and developers. Things are changing quickly and constantly, and there is no “silver bullet.” But understanding the configuration setting’s impact is already a huge step in performance improvement. Bring your ideas and problems to share them with others—the discussion is open, just moderated by a speaker.

  • Sunday, 10.15 am, Room Golden Gate 4:

Better Availability with InnoDB Online Operations—Calvin Sun, Oracle

Many top Web properties rely on Oracle’s MySQL as a critical piece of infrastructure for serving millions of users. Database availability has become increasingly important. One way to enhance availability is to give users full access to the database during data definition language (DDL) operations. The online DDL operations in recent MySQL releases offer users the flexibility to perform schema changes while having full access to the database—that is, with minimal delay of operations on a table and without rebuilding the entire table. These enhancements provide better responsiveness and availability in busy production environments. This session covers these improvements in the InnoDB storage engine for MySQL for online DDL operations such as add index, drop foreign key, and rename column.

  • Sunday, 11.45 am, Room Golden Gate 7:

Developing High-Throughput Services with NoSQL APIs to InnoDB and MySQL Cluster—Andrew Morgan and John Duncan, Oracle

Ever-increasing performance demands of Web-based services have generated significant interest in providing NoSQL access methods to MySQL (MySQL Cluster and the InnoDB storage engine of MySQL), enabling users to maintain all the advantages of their existing relational databases while providing blazing-fast performance for simple queries. Get the best of both worlds: persistence; consistency; rich SQL queries; high availability; scalability; and simple, flexible APIs and schemas for agile development. This session describes the memcached connectors and examines some use cases for how MySQL and memcached fit together in application architectures. It does the same for the newest MySQL Cluster native connector, an easy-to-use, fully asynchronous connector for Node.js.

  • Sunday, 1.15 pm, Room Golden Gate 4:

InnoDB Performance Tuning—Inaam Rana, Oracle

The InnoDB storage engine has always been highly efficient and includes many unique architectural elements to ensure high performance and scalability. In MySQL 5.5 and MySQL 5.6, InnoDB includes many new features that take better advantage of recent advances in operating systems and hardware platforms than previous releases did. This session describes unique InnoDB architectural elements for performance, new features, and how to tune InnoDB to achieve better performance.

  • Sunday, 4.15 pm, Room Golden Gate 3:

InnoDB Compression for OLTP—Nizameddin Ordulu, Facebook and Inaam Rana, Oracle

Data compression is an important capability of the InnoDB storage engine for Oracle’s MySQL. Compressed tables reduce the size of the database on disk, resulting in fewer reads and writes and better throughput by reducing the I/O workload. Facebook pushes the limit of InnoDB compression and has made several enhancements to InnoDB, making this technology ready for online transaction processing (OLTP). In this session, you will learn the fundamentals of InnoDB compression. You will also learn the enhancements the Facebook team has made to improve InnoDB compression, such as reducing compression failures, not logging compressed page images, and allowing changes of compression level.

Not registered yet? You can still save US$ 300 over the on-site feeRegister Now!


Get the latest updates on products, technology, news, events, webcasts, customers and more.




« September 2012 »