Personal blog of Yzmir Ramirez

Percona Toolkit is one of our most mature open source applications. Derived from Maatkit and Aspersa, Percona Toolkit has evolved significantly over the years. The software now contains 32 tools, over 4,000 tests, and has been downloaded over 250,000 times. Anyone who manages a database – from DBAs to system administrators to even software developers – benefits from Percona Toolkit’s ability to perform a variety of MySQL server and system tasks that are too difficult or complex to perform manually.

We continue to make Percona Toolkit better each month. Over the last 9 months alone Percona has had 6 releases and resolved nearly 50 issues.

While Percona team members in Support, Consulting, and Managed Services are big drivers of identifying bugs and new features (driven mostly by Percona customer needs), the community of Percona Toolkit users plays a significant role in making the open source software what it is today.

We’d like to learn how we can make Percona Toolkit even better for your needs. Please take a brief survey so we can learn how you actually use the software. As a thank you for taking the survey, we are randomly giving away five $50 Amazon.com gift cards to participants. It’s a small token but one that we hope you’ll appreciate.

Recent additions to Percona Toolkit have included better Percona XtraDB Cluster support as well as multiple fixes and improvements to pt-online-schema-change, pt-kill, pt-query-digest, pt-stalk, and preparation for the MySQL 5.7 GA. Help us continue to improve Percona Toolkit by taking part in our survey. If you use Percona Toolkit and are attending Percona Live next month, please keep a look out for me. I’d like to hear about your experiences.

The post Calling all MySQL DBAs: How do you use Percona Toolkit? appeared first on MySQL Performance Blog.

Percona has submitted seven talks for the next OpenStack Summit in Vancouver this May. And as with all OpenStack Summit events, the community decides the content. Voting ends February 23, and if you aren’t already an OpenStack Foundation member (required to vote), you can join now for free here.

Percona’s Vancouver OpenStack Summit proposals

Percona’s proposals include collaborations with top contributors across a variety of OpenStack services including Trove and Swift. You can vote for our talks by clicking the titles below that interest you.

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

Deep Dive into MySQL Replication with OpenStack Trove, and Kilo
Speakers: George Lorch, Amrith Kumar (Tesora)

MySQL on Ceph Storage: Exploring Design, Challenges and Benefits
Speakers: Yves Trudeau, Kyle Bader (Red Hat)

Core Services MySQL Database Backup & Recovery to Swift
Speakers: Kenny Gryp, Chris Nelson (SwiftStack)

Smart MySQL Log Management with Swift
Speakers: Matt Griffin, Chris Nelson (SwiftStack)

Discovering Better Database Architectures For Core Services In OpenStack
Speakers: Kenny Gryp, Matt Griffin

Upgrading your OpenStack Core Services On The Database Side: Nova, Neutron, Cinder…
Speakers: Kenny Gryp, Matt Griffin

Other interesting proposals

Here are a few proposals from other organizations that look particularly interesting. Please consider them as well.

Exploration into OpenStack Trove, customer use cases, and the future of Trove for the community
Speakers: Amrith Kumar (Tesora), Brad Topol (IBM), Mariam John (IBM)

The Entrepreneur’s Challenge: The Realities of Starting an OpenStack Company
Speakers: Simon Anderson (Dreamhost, Inktank), Ken Rugg (Tesora), Josh McKenty (Pivotal, Piston Cloud), Jesse Proudman (BlueBox), Joe Arnold (SwiftStack)

Making a Case for Your OpenStack Deployment: How Vendor’s Can Help
Speaker: Ryan Floyd (Storm Ventures)

Real World Experiences with Upgrading OpenStack at Time Warner Cable
Speakers: Clayton ONeill (Time Warner Cable), Matt Fischer (Time Warner Cable)

Percona & OpenStack

According to the most recent OpenStack User Survey in November 2014, Percona’s database software is a popular choice for OpenStack operators needing high availability.

Percona XtraDB Cluster, the top Galera-based MySQL cluster solution for production OpenStack deployments, incorporates the latest version of MySQL 5.6, Percona Server 5.6, Percona XtraBackup, and Galera. This combination delivers top performance, high availability, and critical security coverage with the latest features and fixes. Additionally, Percona Server is a popular guest database option with unique features designed for cloud operators offering DBaaS.

In addition to sharing our open source software with the OpenStack community, Percona is sharing our expertise in services like Trove, projects like the HA Guide update, extensive benchmark testing activities, and upcoming events like OpenStack Live 2015. The inaugural OpenStack Live Conference, April 13-14 in Santa Clara, California, will be a user-focused event. The program will cover database-related on topics like Trove as well as other OpenStack services and feature multiple 3-hour hands-on tutorials.

Percona is a proud supporter of OpenStack and we hope to see you in both Santa Clara in April and Vancouver in May. And in the meantime, don’t forget to vote!

The post Percona submits 7 talks for Vancouver OpenStack Summit (voting ends Feb. 23) appeared first on MySQL Performance Blog.

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.

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

Speakers 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!

The post ‘Open Source Appreciation Day’ draws OpenStack, MySQL and CentOS faithful appeared first on 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 post Explosive OpenStack growth at the Percona Live MySQL Conference & Expo appeared first on MySQL Performance Blog.