Paris OpenStack Summit Voting – Percona Submits 16 MySQL Talks

Originally posted on the MySQL Performance Blog.

Paris OpenStack Summit Voting - Percona Submits 16 MySQL TalksMySQL plays a critical role in OpenStack. It serves as the host database supporting most components such as Nova, Glance, and Keystone and is the most mature guest database in Trove. Many OpenStack operators use Percona open source software including the MySQL drop-in compatible Percona Server and Galera-based Percona XtraDB Cluster as well as tools such as Percona XtraBackup and Percona Toolkit. We see a need in the community to understand how to improve MySQL performance in OpenStack. As a result, Percona, submitted 16 presentations for the Paris OpenStack Summit.

Paris OpenStack Summit presentations are chosen by OpenStack member voting. Please vote for our talks by clicking the titles below that interest you. You must be an OpenStack Foundation member to vote. If you aren’t a member, sign up here – it’s free and only takes a minute. The deadline to vote is Wednesday, August 6, 2014!

Paris OpenStack Summit MySQL Talks Submitted by Percona

OpenStack Operations

MySQL Database Operations in the OpenStack World
Speaker: Stéphane Combaudon

MySQL High Availability Options for Openstack
Speakers: Stéphane Combaudon

Host and Guest Database Backup and Recovery for OpenStack Ops
Speakers: George Lorch, David Busby

Benchmarking the Different Cinder Storage Backends
Speaker: Peter Boros

MySQL and OpenStack Deep Dive
Speakers: Peter Boros, Jay Pipes (Mirantis)

Trove Performance Tuning for MySQL
Speaker: Alexander Rubin

Schema Management: Versioning and Automation with Puppet and MySQL Utilities
Speaker: Frederic Descamps

Deploying Databases for OpenStack
Speakers: Matt Griffin, Jay Pipes (Mirantis), Amrith Kumar (Tesora), Vinay Joosery (Severalnines)

Related Open Source Software Projects

Introduction to Percona XtraDB Cluster
Speaker: Kenny Gryp

Percona Server Features for OpenStack and Trove Ops
Speakers: George Lorch, Vipul Sabhaya (HP Cloud)

Products, Tools & Services

ClusterControl: Efficient and reliable MySQL Management, Monitoring, and Troubleshooting for OpenStack HA
Speakers: Peter Boros, Vinay Joosery (Severalnines)

Advanced MySQL Performance Monitoring for OpenStack Ops
Speaker: Daniel Nichter

Targeting Apps for OpenStack Clouds

Oars in the Cloud: Virtualization-aware Galera instances
Speaker: Raghavendra Prabhu

ACIDic Clusters: Review of contemporary ACID-compliant databases with synchronous replication
Speaker: Raghavendra Prabhu

Cloud Security

Security: It’s more than just your database you should worry about
Speaker: David Busby

Planning Your OpenStack Project

Infrastructure at Scale
Speaker: Michael Coburn

The Paris OpenStack Summit will offer developers, operators, and service providers with valuable insights into OpenStack. The Design Summit sessions will be filled with lively discussions driving OpenStack development including sessions defining the future of Trove, the DBaaS (database as a service) component near and dear to Percona’s heart. There will also be many valuable presentations in the main Paris OpenStack Summit conference about operating OpenStack, utilizing the latest features, complimentary software and services, and real world case studies.

Thank you for your support. We’re looking forward to seeing many Percona software users at the Paris OpenStack Summit in November.

‘Open Source Appreciation Day’ draws OpenStack, MySQL and CentOS faithful

Originally posted on the MySQL Performance Blog.

Open Source Appreciation Day Brings Together OpenStack, MySQL, and CentOS Communities
210 people registered for the inaugural “Open Source Appreciation Day” March 31 in Santa Clara, Calif. The event will be held each year at Percona Live henceforth.

To kick off the Percona Live MySQL Conference & Expo 2014, Percona held the first “Open Source Appreciation Day” on Monday, March 31st. Over 210 people registered and the day’s two free events focused on CentOS and OpenStack.

The OpenStack Today event brought together members of the OpenStack community and MySQL experts in an afternoon of talks and sharing of best practices for both technologies. After a brief welcome message from Peter Zaitsev, co-founder and CEO of Percona, Florian Haas shared an introduction to OpenStack including its history and the basics of how it works.

Jay Pipes delivered lessons from the field based on his years of OpenStack experience at AT&T, at Mirantis, and as a frequent code contributor to the project. Jay Janssen, a Percona managing consultant, complemented Jay Pipes’ talk with a MySQL expert’s perspective of OpenStack. He also shared ways to achieve High Availability using the latest version of Galera (Galera 3) and other new features found in the open source Percona XtraDB Cluster 5.6.

Amrith Kumar’s presentation focused on the latest happenings in project Trove, OpenStack’s evolving DBaaS component, and Tesora’s growing involvement. Amrith also won quote of the day for his response to a question about the difference between “elastic” and “scalable.” Amrith: “The waistband on my trousers is elastic. It is not scalable.” Sandro Mazziotta wrapped up the event by sharing the challenges and opportunities of OpenStack from both an integrator as well as operator point of view based on the customer experiences of eNovance.

OpenStack Today was made possible with the support of our sponsors, Tesora and hastexo. Here are links to presentations from the OpenStack Today event. Any missing presentations will soon be added to the OpenStack Today event page.

Open Source Appreciation DaySpeakers in the CentOS Dojo Santa Clara event shared information about the current status of CentOS, the exciting road ahead, and best practices in key areas such as system administration, running MySQL, and administration tools. Here’s a rundown of topics and presentations from the event. Any missing presentations will soon be added to the CentOS Dojo Santa Clara event page.

  • Welcome and Housekeeping
    Karsten Wade, CentOS Engineering Manager, Red Hat
  • The New CentOS Project
    Karsten Wade, CentOS Engineering Manager, Red Hat
  • Systems Automation and Metrics at Pinterest
    Jeremy Carroll, Operations Engineer, Pinterest
  • Software Collections on CentOS
    Joe Brockmeier, Open Source & Standards, Red Hat
  • Two Years Living Your Future
    Joe Miller, Lead Systems Engineer, Pantheon
  • Running MySQL on CentOS Linux
    Peter Zaitsev, CEO and Co-Founder, Percona
  • Notes on MariaDB 10
    Michael Widenius, Founder and CTO, MariaDB Foundation
  • Happy Tools
    Jordan Sissel, Systems Engineer, DreamHost

Thank you to all of the presenters at the Open Source Appreciation Day events and to all of the attendees for joining.

I hope to see you all again this November 3-4  at Percona Live London. The Percona Live MySQL Conference and Expo 2015 will also return to the Hyatt Santa Clara and Santa Clara Convention Center from April 13-16, 2015 – watch for more details in the coming months!

Explosive OpenStack growth at the Percona Live MySQL Conference & Expo

Originally posted on the MySQL Performance Blog.

The Percona Live MySQL Conference and Expo 2014 runs April 1-4  at the Santa Clara Convention Center and Santa Clara Hyatt – but be sure to get there a day early for the inaugural Open Source Appreciation Day on March 31 – this event is free but because space is limited I suggest registering now to reserve your spot.

Interest is particularly high in OpenStack and its intersection with MySQL and Open Source Appreciation Day and the conference sessions and events reflect this. Last year, the Percona Live MySQL Conference included 4 talks with Trove (“Red Dwarf” at the time) as the principal topic. This year there are 14 OpenStack-related talks and events:

  • OpenStack Today on Monday, March 31 features 6 talks devoted to discussing the intersection of MySQL and OpenStack
  • 2 keynote talks
  • 4 breakout sessions
  • 1 Birds of a Feather session
  • 1 tutorial

In addition to Trove, sessions will focus on operating OpenStack clouds, the MySQL core, and hybrid deployments.

Beyond the OpenStack sessions, the Percona Live conference features a total of 9 keynotes, 13 tutorials, 112 breakout sessions, 8 Birds of a Feather sessions, and two great networking receptions. There is also the Open Source Appreciation Day on Monday featuring the OpenStack Today and CentOS Dojo Santa Clara events.

The OpenStack Today event is free but as I mentioned above preregistration is required and space is limited. Visit the event page to learn more and to register.

The full conference schedule is available by visiting the Percona Live site. Take advantage of the full conference slate of activities by registering now. Use discount code “OpenStack-Today” to receive $200 off your registration.

The full list of OpenStack events at the Percona Live MySQL Conference and Expo 2014 is:

Monday, March 31

1:00 pm to 6:00 pm – As part of Open Source Appreciation Day, Percona is holding OpenStack Today. This is a chance for members of both MySQL and OpenStack communities to interact and learn. This event is sponsored by Tesora and hastexo.

Speakers and topics include:

  • Florian Haas, CEO, Principal Consultant, hastexo: “What is OpenStack, and what’s in it for DBAs?”
  • Jay Pipes, Principal Technical Architect, Mirantis: “Tales from the Field: Backend Data Storage in OpenStack Clouds”
  • Jay Janssen, Principal Consultant, Percona: “Percona XtraDB Cluster in OpenStack”
  • Amrith Kumar, Founder and CTO, Tesora: “An Elastic Parallel Data-as-a-Service (DaaS) platform with OpenStack Trove and Tesora”
  • Sandro Mazziotta, Senior Director, Product Management, eNovance: “Challenges and lessons learned with OpenStack deployments and MySQL”
  • Sebastian Stadil, Founder, Scalr: “Autoscaling, replication, and failover: cloud native MySQL on OpenStack”

Tuesday, April 1

1:30 pm to 4:30 pm
Hands On Trove: Database as a Service in OpenStack (for MySQL)
Florian Haas, CEO, Principal Consultant, hastexo

Wednesday, April 2

3:50 pm to 4:40 pm
Virtually Available MySQL, or How to Stop Worrying and Love the Cloud
Robert Hodges, CEO, Continuent

6:00 pm to 7:00 pm
BOF: Running A Successful Trove’d OpenStack Installation
Michael Basnight, Sr. Software Developer, Rackspace
Amrith Kumar, Founder & CTO, Tesora (formerly ParElastic)

Thursday, April 3

9:35 am to 10:00 am
Keynote: MySQL, Private Cloud Infrastructure and OpenStack
Sean Chighizola, Senior Director Database Administration, Big Fish Games

Friday, April 4

9:35 am to 10:10 am
Keynote: OpenStack Coopetition, A View From Within
Boris Renski, Co­Founder and CMO, Mirantis, Member of OpenStack Board of Directors

11:00 am to 11:50 am
OpenStack Trove – Database as a Service
Vipul Sabhaya, Lead Software Developer, HP
Michael Basnight, Sr. Software Developer, Rackspace
Patrick Galbraith, Senior Systems Engineer, Hewlett Packard

12:50 pm to 1:40 pm
Avoiding Pain When Running MySQL in the Cloud
Neil Armitage, Deployment and Support Engineer, Continuent

1:50 pm to 2:40 pm
Building Globally Available Storage Layers
Art van Scheppingen, Head of database engineering, Spil Games

I look forward to seeing you next week in Santa Clara!

The benefits of a drop-in compatible MySQL alternative

Originally posted on the MySQL Performance Blog.

Percona Server provides users with a variety of powerful benefits including enterprise-grade features, high performance in demanding use cases, rich diagnostics, and access to unique Percona XtraBackup capabilities, all for free and open source. In addition, Percona Server is a drop-in MySQL replacement. Compatibility with MySQL has important ramifications (as well as some risks) as Giuseppe Maxia highlighted in a recent blog post about MySQL alternatives. Our commitment to drop-in compatibility with MySQL has important benefits for Percona Server users and drives our development process as I’ll describe.

Drop-in compatibility is important for users
Percona Server’s drop-in compatibility with MySQL is a promise to our users. It is protection against vendor lock-in. And it is a commitment we make to the continued functionality of your applications as well as the interoperability with MySQL databases in your infrastructure. Organizations make large investments of time and money in their applications. We believe Percona Server’s compatibility with MySQL is vital to ensure operations are not interrupted.

Drop-in compatibility and Percona Server 5.6
Saying that Percona Server is a drop-in MySQL replacement is more than just a statement though. Users need to know how drop-in compatibility with MySQL is built into the development process and have clear expectations for how it is maintained in the future.

As with all Percona Server releases, compatibility with MySQL has been a key part of the development of Percona Server 5.6. Throughout the product’s development, Percona engineers have incorporated the latest MySQL 5.6 minor updates into Percona Server 5.6 alphas, betas, and release candidates. While sometimes requiring refactoring of Percona Server 5.5 enhancements to adopt MySQL’s approach, this practice ensures that the latest MySQL bug fixes and enhancements are promptly included in Percona Server 5.6 pre-GA releases and users can consider Percona Server as a MySQL alternative for the long term.

Looking back at past versions of Percona Server, we can see how this focus on compatibility has paid off. We’ve been able to establish a reliable pattern of releasing Percona Server minor updates around 30 days after MySQL minor updates. Today, we’re in one of those update periods where the most current version of MySQL 5.5 is 5.5.34 (released on September 20, 2013) and the Percona Server 5.5.34 release is scheduled and right around the corner.

Percona Server 5.5 minor releases compared to MySQL 5.5 minor releases
Since MySQL 5.5 GA (5.5.10), Percona Server has a reliable track record of releasing minor updates soon after MySQL 5.5 minor releases.

As you can see from this report, Percona also does a substantial amount of fixing bugs and deploying performance improvements in our minor version updates that MySQL has yet to resolve. The combination of keeping current with MySQL minor updates and deploying our own fixes and enhancements before they do ensures that Percona Server is always a drop-in MySQL replacement as well as the most up-to-date version of MySQL available.

After the release of Percona Server 5.6, this trend will continue, delivering the latest updates from MySQL in a timely and consistent manner. While Percona will always push the boundaries of database performance in the future, we will continue to maintain Percona Server’s compatibility as a drop-in MySQL replacement. Our next major release, Percona Server 5.6, is a symbol of that commitment.

Are you evaluating or using the Percona Server 5.6 Release Candidates? If so, we’d like to hear from you. Visit the Percona Server 5.6 feedback page to tell us about your experiences and the results you’ve seen in your applications.

Percona Toolkit 2.2.3 released; bug fixes include pt-online-schema-change

Originally posted on the MySQL Performance Blog.

Among all of the excellent events going on like YAPCVelocity, and Percona MySQL University, we recently released Percona Toolkit 2.2.3. It’s a small update that includes the following:

  • pt-online-schema-change did not handle the failure of the DROP TRIGGER statements correctly
  • Created pt-agent
  • pt-query-digest –output json now includes more data

Percona ToolkitThe pt-online-schema-change issue had a high importance. The bug fix is bug 1188002: pt-online-schema-change causes “ERROR 1146 (42S02): “Table ‘db._t_new’ doesn’t exist”. This happens when the tool’s triggers cannot be dropped. If that occurred, it still dropped the new table, which meant triggers were referencing a missing table, causing errors on write to the original table.

This is handled properly now: if triggers can’t be dropped, then the new table isn’t dropped either. This leaves a half-finished new table, but that’s better than write errors on the original table. Those using pt-online-schema-change should definitely upgrade.

The “pt-query-digest –output json” change now delivers more information. The previous JSON output was minimal; the output as of 2.2.3 is much more extensive and, consequently, has a new structure.  This means 2.2.3 pqd –output json is not backwards-compatible (but we warned in the first 2.2 release that –output json would be in flux).

See https://launchpad.net/percona-toolkit/+milestone/2.2.3 for the full list of bugs fixed in Percona Toolkit 2.2.3.

Visit http://www.percona.com/software/percona-toolkit to download Percona Toolkit 2.2.3; it’s also in our main repos.