Tag: Percona Server

Feed: Planet MySQL; Author: MySQL Performance Blog; Bronwyn Campbell | September 19, 2018 |  Posted In: Events and Announcements, MariaDB, MongoDB, MySQL, Percona Live, Percona Monitoring and Management, PMM, PostgreSQL PREVIOUS POST Percona has revealed the line-up of in-depth tutorials for the Percona Live Europe 2018 Open Source Database Conference, taking place November 5–7, 2018 at the Radisson Blu Hotel in Frankfurt, Germany. Secure your spot now with Advanced Registration prices. Be sure to buy your tickets soon as tickets prices will only head up, not down! Sponsorship opportunities for the conference are still available. Percona Live Europe 2018 Open Source Database Conference is the premier open source ... Read More

Feed: Planet MySQL; Author: Colin Charles; Colin Charles | September 21, 2018 |  Posted In: MariaDB, MongoDB, MySQL, open source databases, Percona Server for MongoDB, Percona XtraDB Cluster, PostgreSQL PREVIOUS POST Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. This week is clearly what I’d call a “MariaDB week” — plenty of announcements coming from MariaDB Corporation and MariaDB Foundation. It started with Alibaba Cloud and MariaDB Announce the Launch of ApsaraDB RDS for MariaDB TX, which makes Alibaba Cloud the first public cloud to offer the enterprise offering of MariaDB, MariaDB ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Dmitriy Kostiuk | September 20, 2018 |  Posted In: Events and Announcements, MySQL, Percona Server for MySQL, Percona XtraDB Cluster, ProxySQL PREVIOUS POST ProxySQL 1.4.10, released by ProxySQL, is now available for download in the Percona Repository along with an updated version of Percona’s proxysql-admin tool. ProxySQL is a high-performance proxy, currently for MySQL and its forks (like Percona Server for MySQL and MariaDB). It acts as an intermediary for client requests seeking resources from the database. René Cannaò created ProxySQL for DBAs as a means of solving complex replication topology issues. The ProxySQL 1.4.10 source and binary ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Jericho Rivera | September 17, 2018 |  Posted In: MySQL, Percona Server for MySQL, Security PREVIOUS POST This is the first of a two-part series on using the keyring_vault plugin with Percona Server for MySQL 5.7. The second part will walk you through on how to use Percona Xtrabackup to backup from this instance and restore to another server and set it up as a slave with keyring_vault plugin. What is the keyring_vault plugin? The keyring_vault is a plugin that allows the database to interface with a Hashicorp Vault server to store and secure encryption keys ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Dmitriy Kostiuk | September 13, 2018 |  Posted In: Events and Announcements, MariaDB, MongoDB, MySQL, Percona Server for MongoDB, Percona Server for MySQL, Percona Toolkit PREVIOUS POST Percona announces the release of Percona Toolkit 3.0.12 on September 13, 2018. Percona Toolkit is a collection of advanced open source command-line tools, developed and used by the Percona technical staff, that are engineered to perform a variety of MySQL®, MongoDB® and system tasks that are too difficult or complex to perform manually. With over 1,000,000 downloads, Percona Toolkit supports Percona Server for MySQL, MySQL®, MariaDB®, Percona Server for MongoDB and ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Ceri Williams | September 14, 2018 |  Posted In: MySQL, Percona Server for MySQL, Security PREVIOUS POST In my last post I compared data at-rest encryption features available for MySQL and MariaDB. As noted at the time, some of the features available for Percona Server for MySQL were in development, and the latest version (5.7.23) sees two of them released as ALPHA quality. Encrypting the InnoDB system tablespace The first of the new features is InnoDB system tablespace encryption via innodb_sys_tablespace_encrypt, which would provide encryption of the following data: the change buffer, which caches changes to ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Borys Belinsky and Dmitriy Kostiuk | September 12, 2018 |  Posted In: Events and Announcements, MySQL, Percona Server for MySQL, Percona Software PREVIOUS POST Percona announces the release of Percona Server for MySQL 5.7.23-23 on September 12, 2018 (downloads are available here and from the Percona Software Repositories). This release merges changes of MySQL 5.7.23, including all the bug fixes in it. Percona Server for MySQL 5.7.23-23 is now the current GA release in the 5.7 series. All of Percona’s software is open-source and free. New Features The max_binlog_files variable is deprecated, and the binlog_space_limit variable should be used instead of it. The ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; David Bennett | September 12, 2018 |  Posted In: Backups, InnoDB, MySQL, MySQL 8.0, Percona Server for MySQL, Percona XtraBackup PREVIOUS POST Experimental Build of Percona XtraBackup 8.0 released An experimental alpha version of Percona XtraBackup 8.0.1 is now available in the Percona experimental software repositories. A few things to note about this release: We removed the deprecated innobackupex in this release Due to the new MySQL redo log and data dictionary formats the Percona XtraBackup 8.0.x versions will only be compatible with MySQL 8.0.x and the upcoming Percona Server for MySQL 8.0.x For experimental migrations from ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Dmitriy Kostiuk | September 8, 2018 |  Posted In: Amazon RDS, AWS, Database Monitoring, Events and Announcements, MongoDB, MySQL, Percona Monitoring and Management, Percona Server for MongoDB, Percona Server for MySQL, PMM PREVIOUS POST Percona Monitoring and Management (PMM) is a free and open-source platform for managing and monitoring MySQL® and MongoDB® performance. You can run PMM in your own environment for maximum security and reliability. It provides thorough time-based analysis for MySQL® and MongoDB® servers to ensure that your data works as efficiently as possible. We’re releasing hotfix 1.14.1 to address two issues found post-release of 1.14.0: PMM-2963: Upgrading ... Read More

Feed: Planet MySQL; Author: Jean-François Gagné; A colleague brought an article to my attention.  I did not see it on Planet MySQL where I get most of the MySQL news (or it did not catch my eye there).  As it is interesting replication stuff, I think it is important to bring it to the attention of the MySQL Community, so I am writing this short post.The surprising part for me is that it uses my 4-year-old work for online migration to GTID with MySQL 5.6.  This is a completely unforeseen use case of my work as I never thought that my ... Read More