by Colin Charles | Aug 10, 2017 | MariaDB, MongoDB, MySQL, Percona Events
Welcome to a new weekly column on the Percona blog. My name is Colin Charles, Percona Chief Evangelist, and I have been involved in MySQL, MariaDB Server and the open source community for over a decade. Now I am at Percona, and this is my weekly column. When you start...
by Nik Vyzas | Aug 9, 2017 | Cloud, MySQL
In this blog post, we’ll look at some tips on how to configure Aurora parameters on Amazon RDS. I was recently deploying a few Aurora RDS instances, a process very similar to configuring a regular RDS instance. I noticed a few minor differences in the way you...
by Shahriyar Rzayev | Aug 8, 2017 | Insight for DBAs, MySQL
This blog discusses newly added options for Percona XtraBackup 2.4.8 and how they can impact your database backups. To avoid issues with MySQL 5.7 skipping the redo log for DDL, Percona XtraBackup has implemented three new options ( xtrabackup --lock-ddl, xtrabackup...
by Emily Ikuta | Aug 7, 2017 | MongoDB, Security, Webinars
Join Percona’s Senior Technical Services Engineer, Adamo Tonete as he presents MongoDB Security: Making Things Secure by Default on Wednesday, August 9, 2017 at 11:00 am PDT / 2:00 pm EDT (UTC-7). Register Now MongoDB security breaches have regularly been in the news....
by Peter Zaitsev | Aug 4, 2017 | MariaDB, MongoDB, MySQL, Percona Software
One of the new graphs added to Percona Monitoring and Management (PMM) is saturation metrics. This blog post explains how to use the information provided by these graphs. You might have heard about Brendan Gregg’s USE Method (Utilization-Saturation-Errors) as a way...
by Dave Avery | Aug 3, 2017 | Insight for DBAs, Insight for Developers, MariaDB, MongoDB, MySQL, Percona Live
We are excited to announce that the sneak peek schedule for the Percona Live Open Source Database Conference Europe 2017 is up! The Percona Live Open Source Database Conference Europe 2017 is September 25 – 27, at the Radisson Blu Royal Hotel. The theme of Percona...
by Alexey Zhebel | Aug 2, 2017 | MongoDB, MySQL, Percona Events, Percona Software
Percona announces the release of Percona Toolkit 3.0.4 on August 2, 2017. Percona Toolkit is a collection of advanced command-line tools that perform a variety of MySQL and MongoDB server and system tasks too difficult or complex for DBAs to perform manually. Percona...
by Alexey Zhebel | Aug 2, 2017 | MongoDB, Percona Events, Percona Software
Percona announces the release of Percona Server for MongoDB 3.4.6-1.7 on August 2, 2017. Download the latest version from the Percona web site or the Percona Software Repositories. Percona Server for MongoDB is an enhanced, open source, fully compatible,...
by Borys Belinsky | Aug 1, 2017 | MySQL, Percona Events
Percona is glad to announce the release of Percona Server for MySQL 5.6.36-82.1 on August 1, 2017 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.6.36, including all the bug fixes in it, Percona Server for MySQL 5.6.34-79.1...
by Marco Tusa | Aug 1, 2017 | Insight for DBAs, MySQL, Percona Software
In this blog, we’ll look at group replication and how it deals with flow control (FC) and replication lag. Overview In the last few months, we had two main actors in the MySQL ecosystem: ProxySQL and Group-Replication (with the evolution to InnoDB Cluster). ...
by Dave Avery | Jul 31, 2017 | MariaDB, MongoDB, MySQL, Percona Events, Percona Services, Percona Software
Upstream platform vendors have announced the general end of life (EOL) for Red Hat Enterprise Linux 5 (RHEL 5) and its derivatives, as well as Ubuntu 12.04 LTS. With this announcement comes some implications to support for Percona software running on these operating...
by Dave Avery | Jul 31, 2017 | MySQL, Security, Webinars
Join Percona’s, Senior Architect, Matthew Boehm as he presents MySQL Disk Encryption with LUKS on Wednesday, August 2, 2017, at 1:00 pm PDT / 4:00 pm EDT (UTC-7). Register Now Clients require strong security measures for PCI, HIPAA or PHI. You must encrypt MySQL...
by Borys Belinsky | Jul 28, 2017 | MySQL, Percona Events
Percona is glad to announce the GA release of Percona Server for MySQL 5.7.18-16 on July 28, 2017 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.7.18, including all the bug fixes in it, Percona Server for MySQL 5.7.18-16 is...
by Alexey Zhebel | Jul 28, 2017 | MongoDB, Percona Events, Percona Software
Percona announces the release of Percona Server for MongoDB 3.4.6-1.6 on July 27, 2017. Download the latest version from the Percona web site or the Percona Software Repositories. Percona Server for MongoDB is an enhanced, open source, fully compatible,...
by Alexey Zhebel | Jul 26, 2017 | MongoDB, Percona Events, Percona Software
Percona announces the release of Percona Server for MongoDB 3.2.15-3.5 on July 26, 2017. Download the latest version from the Percona web site or the Percona Software Repositories. Percona Server for MongoDB is an enhanced, open-source, fully compatible, highly...
by Manjot Singh | Jul 26, 2017 | MySQL
I was recently discussing innodb_autoinc_lock_mode with some colleagues to address issues at a company I was working with. innodb_autoinc_lock_mode This variable defines the lock mode to use for generating auto-increment values. The permissible values are 0, 1 or 2...
by Dave Avery | Jul 25, 2017 | Insight for DBAs, MySQL, Webinars
Join Percona’s, Architect, Manjot Singh as he presents Database Backup and Recovery Best Practices (with a Focus on MySQL) on Thursday, July 27, 2017 at 11:00 am PDT / 2:00 pm EDT (UTC-7). Register Now In the case of a failure, do you know how long it will take to...
by Hrvoje Matijakovic | Jul 24, 2017 | MySQL, Percona Events, Percona Software
Percona announces the GA release of Percona XtraBackup 2.4.8 on July 24, 2017. You can download it from our download site and apt and yum repositories. Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies with large...
by Hrvoje Matijakovic | Jul 24, 2017 | Percona Events, Percona Software, Storage Engine
Percona announces the release of Percona XtraBackup 2.3.9 on July 24, 2017. 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...
by Krunal Bauskar | Jul 21, 2017 | MySQL, Percona Software
In this blog, we’ll look at how improvements to Percona XtraDB Cluster improved IST performance. Introduction Starting in version 5.7.17-29.20 of Percona XtraDB Cluster significantly improved performance. Depending on the workload, the increase in throughput is...