Buy Percona ServicesBuy Now!

Linux OS Tuning for MySQL Database Performance

 | July 3, 2018 |  Posted In: Insight for DBAs, MySQL, MySQL 8.0, Percona Server for MySQL, Percona XtraDB Cluster, XtraDB Cluster

Linux OS tuning for MySQL database performance

In this post we will review the most important Linux settings to adjust for performance tuning and optimization of a MySQL database server. We’ll note how some of the Linux parameter settings used OS tuning may vary according to different system types: physical, virtual or cloud. Other posts have addressed MySQL parameters, like Alexander’s blog MySQL 5.7 […]

Read More

Webinar Tues, 5/29: MySQL, Percona XtraDB Cluster, ProxySQL, Kubernetes: How they work together

 | May 25, 2018 |  Posted In: Containers, High-availability, Insight for DBAs, Insight for Developers, MySQL, Percona Server for MySQL, Percona Software, Percona XtraDB Cluster, ProxySQL, Technical Webinars, XtraDB Cluster

Please join Percona’s Principal Architect Alex Rubin as he presents MySQL, Percona XtraDB Cluster, ProxySQL, Kubernetes: How they work together to give you a highly available cluster database environment on Tuesday, May 29th at 7:00 AM PDT (UTC-7) / 10:00 AM EDT (UTC-4). Register Now   In this webinar, Alex will discuss how to deploy […]

Read More

Webinar Wednesday, April 18, 2018: Percona XtraDB Cluster 5.7 Tutorial

 | April 17, 2018 |  Posted In: High-availability, MySQL, Percona XtraDB Cluster, ProxySQL, Technical Webinars, XtraDB Cluster

Percona XtraDB Cluster Tutorial

Please join Percona’s Architect, Tibi Köröcz as he presents Percona XtraDB Cluster 5.7 Tutorial on Wednesday, April 18, 2018, at 7:00 am PDT (UTC-7) / 10:00 am EDT (UTC-4). Never used Percona XtraDB Cluster before? Come join this 45-minute tutorial where we will introduce you to the concepts of a fully functional Percona XtraDB Cluster. In this […]

Read More

This Week in Data with Colin Charles 30: Schedule for Percona Live, and Tracking Those Missing Features

 | March 2, 2018 |  Posted In: Events and Announcements, MariaDB, MySQL, Percona Monitoring and Management, Percona Toolkit, Percona XtraDB Cluster, PMM, Replication, XtraDB Cluster

Colin Charles

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. Have you registered for Percona Live already? The tutorial grid, the schedules for day 1 and day 2 are pretty amazing, and there is even an extra track being added, for a total of 10 concurrent/parallel […]

Read More

This Week in Data with Colin Charles 25: Meltdown/Spectre still dominate, FOSDEM approaches and Timescale gets funding

 | January 26, 2018 |  Posted In: Amazon Aurora, AWS, Events and Announcements, MongoDB, MySQL, MySQL 8.0, Percona Live, PostgreSQL, ProxySQL, XtraDB Cluster

Colin Charles

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. Still on Meltdown/Spectre, this time MariaDB Corporation has published Meltdown Vulnerability Impact On MariaDB Server – interesting the comparison between glibc/tcmalloc. Worthy Facebook thread about this too, with a bit of chat about MongoDB performance. […]

Read More

This Week in Data with Colin Charles 17: AWS Re:Invent, a New Book on MySQL Cluster and Another Call Out for Percona Live 2018

 | December 1, 2017 |  Posted In: Events and Announcements, MariaDB, MongoDB, MySQL, Percona Live, Percona Server for MongoDB, Percona XtraBackup, PostgreSQL, XtraDB Cluster

Colin Charles

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. The CFP for Percona Live Santa Clara 2018 closes December 22, 2017: please consider submitting as soon as possible. We want to make an early announcement of talks, so we’ll definitely do a first pass […]

Read More

Percona Live Europe Session Interview: Building Multi-Petabyte Data Warehouses with ClickHouse

 | September 27, 2017 |  Posted In: Percona Live, XtraDB Cluster

Percona Live Europe

Percona Live Europe provides open source professionals with an opportunity to discuss how various technologies get used in order to solve database problems. Alexander Zaitsev of LifeStreet/Altinity gave one such session: Building Multi-Petabyte Data Warehouses with ClickHouse. LifeStreet needed to scale their real-time ad analytics platform to multiple petabytes. They evaluated and used a number of […]

Read More

Improved wsrep-stages and related instrumentation in Percona XtraDB Cluster

 | April 24, 2017 |  Posted In: MySQL, Percona XtraDB Cluster, XtraDB Cluster

wsrep-stages

In this blog post, we’ll look at how we’ve improved wsrep-stages and related instrumentation in Percona XtraDB Cluster. Introduction When you execute a workload and need to find out what the given thread is working on, “SHOW PROCESSLIST” comes to the top of your mind. It is an effective way to track the thread status. We […]

Read More

Percona XtraDB Cluster: SST tmpdir option

 | April 24, 2017 |  Posted In: Insight for DBAs, Percona XtraDB Cluster, XtraDB Cluster

wsrep-stages

In this blog post, I’ll discuss some changes to the behavior of the Percona XtraDB Cluster SST tmpdir option in the latest versions of Percona XtraDB Cluster 5.6.35-26.20-3 and 5.7.17-29.30. Previously, we did not use the path specified by the tmpdir. From Percona XtraDB Cluster 5.6.35-26.20-3 and 5.7.17-29.20, we use the tmpdir option to specify the […]

Read More

Percona XtraDB Cluster: “dh key too small” error during an SST using SSL

 | April 23, 2017 |  Posted In: Percona XtraDB Cluster, Security, XtraDB Cluster

wsrep-stages

If you’ve tried to use SSL in Percona XtraDB Cluster and saw an error in the logs like SSL3_CHECK_CERT_AND_ALGORITHM:dh key too small, we’ve implemented some changes in Percona XtraDB Cluster 5.6.34 and 5.7.16 that get rid of these errors. Some background dh key too small refers to the Diffie-Hellman parameters used by the SSL code that are […]

Read More