EmergencyEMERGENCY? Get 24/7 Help Now!

Thoughts About Column Compression, with Optional Predefined Dictionary

 | November 10, 2016 |  Posted In: InnoDB, Quality Assurance

column compression

This blog discusses column compression with an optional predefined dictionary. Compression, more compression with different algorithms, compress again, compress multiple times! 🙂 Compression is a hot topic in our lives. In general, testing new things is great if the processes are well-described and easy to follow. Let’s try to think like a QA engineer: the first […]

Read More

Database Daily Ops Series: GTID Replication

 | November 10, 2016 |  Posted In: GTID, MySQL, Percona Managed Services

GTID Replication

This post discusses ways of fixing broken GTID replication. This blog series is all about the daily stories we have in Managed Services, dealing with customers’ environments (mostly when we need to quickly restore a service level within the SLA time). One of the issues we encounter daily is replication using the GTID protocol. While there are […]

Read More

Orchestrator and ProxySQL

 | November 9, 2016 |  Posted In: MySQL, Orchestrator, ProxySQL

Orchestrator and ProxySQL

In this blog post, I am going to show you how can you use Orchestrator and ProxySQL together. In my previous blog post, I showed how to use bash scripts and move virtual IPs with Orchestrator. As in that post, I assume you already have Orchestrator working. If not, you can find the installation steps here. In the case of […]

Read More

Percona Live 2017 Call for Papers Extended Deadline: November 13th

 | November 8, 2016 |  Posted In: MariaDB, MongoDB, MySQL, Percona Live

We’ve extended the Percona Live Open Source Database Conference 2017 call for papers deadline until November 13th! If you haven’t submitted already, please consider doing so. Speaking at Percona Live is a great way to build your personal and company brands, and if selected you will receive a complimentary full conference pass! For Percona Live […]

Read More

Updating Percona XtraDB Cluster from 5.6.24-72.2 to 5.6.32-25.17

 | November 7, 2016 |  Posted In: High-availability, Percona XtraDB Cluster

wsrep-stages

This blog describes how to upgrade Percona XtraDB Cluster in place from 5.6.24-72.2 to 5.6.32-25.17. This very hands-on blog is the result of some questions such as “can I perform an in-place upgrade for Percona XtraDB Cluster” coming in. We have done these minor upgrades for Percona Managed Services customers running Percona XtraDB Cluster with lots […]

Read More

Changing the Tablespace Directory with pt-online-schema-change

and  | November 4, 2016 |  Posted In: InnoDB, MySQL, Percona Toolkit

MariaDB ColumnStore

In this blog, we’ll discuss changing the tablespace directory using pt-online-schema-change. One of the most annoying situations in the life of a DBA is realizing that the disk where the datadir resides is running out of space. If you’re lucky enough to run over an LVM volume or a RAID (depending on the level, though), it […]

Read More

Orchestrator: Moving VIPs During Failover

 | November 3, 2016 |  Posted In: High-availability, MySQL

autotokubackup

In this post, I’ll discuss how to moving VIPs during a failover using Orchestrator. In our previous post, we showed you how Orchestrator works. In this post, I am going to give you a proof-of-concept on how Orchestrator can move VIPs in case of failover. For this post, I’m assuming the Orchestrator is already installed and […]

Read More

Percona responds to CVE-2016-6663 and CVE-2016-6664

 | November 2, 2016 |  Posted In: Events and Announcements, MySQL, Percona XtraDB Cluster

CVE-2016-9962

Percona has addressed CVE-2016-6663 and CVE-2016-6664 in releases of Percona Server for MySQL and Percona XtraDB Cluster. Percona is happy to announce that the following vulnerabilities are fixed in current releases of Percona Server for MySQL and Percona XtraDB Cluster: CVE-2016-6663: allows a local system user with access to the affected database in the context of […]

Read More

Webinar Thursday November 3: The MySQL Ecosystem in 2016

 | November 2, 2016 |  Posted In: MySQL

Join Percona’s Chief Evangelist Colin Charles on Thursday, November 3, 2016, at 10 am PDT/ 1:00pm EDT (UTC-7) as he presents “The MySQL Ecosystem in 2016.” MySQL is a unique adult (now 21 years old) in many ways. It supports plugins. It supports storage engines. It is also owned by Oracle, thus birthing two branches […]

Read More