Monthly Archives - March 2016

Percona Live 2016 Community Game Night

Hello, all! Just a quick blog to remind you all about the Percona Live 2016 Community Game Night!
This awesome event is taking place on Wednesday, April 20 from 7:00 pm to 10:00 pm, after the Community Networking Reception. It’s modeled after last year’s extremely popular game night, featuring many of the same games back […]

Read more

Moving with SQL Server to Linux? Move from SQL Server to MySQL as well!

In this blog, we’ll discuss MicroSoft’s recent announcement that SQL Server will be available on Linux. If you’re going to Linux, why not move from SQL Server to MySQL?
The open source operating system Linux powers nearly one-quarter of all the servers running in Microsoft’s Azure cloud service. Until just last week, this meant nearly […]

Read more

Introduction to MySQL troubleshooting basic techniques webinar: Q & A

MySQL troubleshooting basic techniques

In this blog, I will answer questions posed in my recent introduction to MySQL troubleshooting basic techniques webinar.
Thank you for attending my March 10 MySQL troubleshooting webinar “Introduction to MySQL troubleshooting: basic techniques,” which is the second in the “MySQL Troubleshooting Webinar” series. The recording and slides for the webinar are available here. Here […]

Read more

MySQL replication primer with pt-table-checksum / pt-table-sync, part 2

pt-online-schema-change

This is the second and last tutorial blog post on how to use pt-table-checksum / pt-table-sync tools for MySQL replication.
In the first post, I showed you how to use the
pt-table-checksum  /
pt-table-sync  tools in a typical MySQL replication setup. In this post, we’ll discuss MySQL replication for more advanced topologies. I will show you how to […]

Read more

Percona Server 5.7 performance improvements

Percona Server 5.7 performance improvements

In this blog post, we’ll be discussing Percona Server 5.7 performance improvements.
Starting from the Percona Server 5.6 release, we’ve introduced several significant changes that help address performance problems for highly-concurrent I/O-bound workloads. Some of our research and improvements were re-implemented for MySQL 5.7 – one of the best MySQL releases. But even though MySQL 5.7 […]

Read more

Percona XtraBackup 2.3.4 is now available

Percona XtraBackup

Percona is glad to announce the release of Percona XtraBackup 2.3.4 on March 17th, 2016. Downloads are available from our download site or Percona Software Repositories.
Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies with large data sets and mission-critical applications that cannot tolerate long periods of downtime. […]

Read more

Percona Live featured talk with Konstantin Osipov: Tarantool – a Lua Based Database Engine and In-Memory Data Grid

Percona Live featured talk with Konstantin Osipov

Welcome to the next installment of our talks with Percona Live Data Performance Conference 2016 speakers! In this series of blogs, we’ll highlight some of the speakers that will be at this year’s conference, as well as discuss the technologies and outlooks of the speakers themselves. Make sure to read to the end to get a special […]

Read more

Change user password in MySQL 5.7 with “plugin: auth_socket”

change user password in MySQL

In this blog, we’ll discuss how to use “plugin: auth_socket” to change user password in MySQL 5.7. In
In Debian/Ubuntu it is pretty common to install MySQL/Percona Server with an empty password for the root user. After everything is configured and tested, then a password is set. This is not a good practice in production […]

Read more

Update for Percona Live 2016 Attendees: Fun Events, Don’t Miss Out!

12 Days Until Percona Live

The Percona Live Data Performance Conference 2016 is approaching quickly! If you haven’t registered yet, click here to pick up your tickets. There are several options: full registration, 101 Crash Courses, Keynote passes, etc. Register now!
For the people already going, we wanted to update you on some of the events that are going to […]

Read more