Thu, 11 Apr 2024 23:00:03 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.2 https://www.percona.com/blog/wp-content/uploads/2023/02/cropped-percona-favicon-32x32.png 32 32 76301791 https://www.percona.com/blog/proxysql-admin-2-x-encryption-of-credential-information/ https://www.percona.com/blog/proxysql-admin-2-x-encryption-of-credential-information/#respond Fri, 18 Jun 2021 12:34:02 +0000 https://www.percona.com/blog/?p=72932 Starting with the release of proxysql-admin 2.0.15,  the proxysql-admin 2.x series can now encrypt the credentials needed to access proxysql and cluster nodes. This only applies to the proxysql-admin configuration, this does not change the ProxySQL config, so those credentials are still unencrypted.The credentials file is the unencrypted file containing the usernames, passwords, hostnames, and […]]]> https://www.percona.com/blog/proxysql-admin-2-x-encryption-of-credential-information/feed/ 0 72932 https://www.percona.com/blog/percona-xtradb-cluster-8-0-experimental-release-sst-improvements/ Fri, 04 Oct 2019 12:15:54 +0000 https://www.percona.com/blog/?p=62177 Starting with the experimental release of Percona XtraDB Cluster 8.0, we have made changes to the SST process to make the process more robust and easier to use. mysqldump and rsync are no longer supported SST methods. Support for mysqldump was deprecated starting with PXC 5.7 and has now been completely removed. MySQL 8.0 introduced […]]]> 62177 https://www.percona.com/blog/percona-xtradb-cluster-8-0-new-feature-wsrep_sst_auth-removal/ Thu, 03 Oct 2019 13:05:35 +0000 https://www.percona.com/blog/?p=62448 The problemIn PXC 5.6 and 5.7, when using xtrabackup-v2 as the SST method, the DBA must create a user with the appropriate privileges for use by Percona XtraBackup (PXB). The username and password of this backup user are specified in the wsrep_sst_auth variable.This is a problem because this username and password was being stored in […]]]> 62448 https://www.percona.com/blog/percona-xtradb-cluster-mysql-asynchronous-replication-and-log-slave-updates/ https://www.percona.com/blog/percona-xtradb-cluster-mysql-asynchronous-replication-and-log-slave-updates/#comments Tue, 20 Mar 2018 00:06:06 +0000 https://www.percona.com/blog/?p=48189 Recently, I’ve been looking into issues with the interactions between MySQL asynchronous replication and Galera replication. In this blog post, I’d like to share what I’ve learned.MySQL asynchronous replication and Galera replicationThese interactions are complicated due to the number of factors involved (Galera replication vs. asynchronous replication, replication filters, and row-based vs. statement-based replication). So […]]]> https://www.percona.com/blog/percona-xtradb-cluster-mysql-asynchronous-replication-and-log-slave-updates/feed/ 7 48189 https://www.percona.com/blog/percona-xtradb-cluster-sst-tmpdir-option/ https://www.percona.com/blog/percona-xtradb-cluster-sst-tmpdir-option/#comments Mon, 24 Apr 2017 20:46:55 +0000 https://www.percona.com/blog/?p=42911 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 location […]]]> https://www.percona.com/blog/percona-xtradb-cluster-sst-tmpdir-option/feed/ 1 42911 https://www.percona.com/blog/percona-xtradb-cluster-dh-key-too-small-error-during-an-sst-using-ssl/ Sun, 23 Apr 2017 16:16:13 +0000 https://www.percona.com/blog/?p=42908 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 backgrounddh key too small refers to the Diffie-Hellman parameters used by the SSL code that are shorter than […]]]> 42908 https://www.percona.com/blog/simplified-percona-xtradb-cluster-ssl-configuration/ https://www.percona.com/blog/simplified-percona-xtradb-cluster-ssl-configuration/#comments Fri, 21 Apr 2017 17:09:54 +0000 https://www.percona.com/blog/?p=42825 In this blog post, we’ll look at a feature that recently added to Percona XtraDB Cluster 5.7.16, that makes it easier to configure Percona XtraDB Cluster SSL for all related communications. It uses mode “encrypt=4”, and configures SSL for both IST/Galera communications and SST communications using the same SSL files. “encrypt=4” is a new encryption […]]]> https://www.percona.com/blog/simplified-percona-xtradb-cluster-ssl-configuration/feed/ 1 42825 https://www.percona.com/blog/enabling-percona-xtradb-cluster-sst-traffic-encryption/ https://www.percona.com/blog/enabling-percona-xtradb-cluster-sst-traffic-encryption/#comments Fri, 21 Apr 2017 14:48:35 +0000 https://www.percona.com/blog/?p=42821 In this blog post, we’ll look at enabling Percona XtraDB Cluster SST Traffic Encryption, and some of the changes to the SSL-based encryption of SST traffic in Percona XtraDB Cluster 5.7.16.Some backgroundPercona XtraDB Cluster versions prior to 5.7 support encryption methods 0, 1, 2 and 3: encrypt = 0 : (default) No encryption encrypt = 1 […]]]> https://www.percona.com/blog/enabling-percona-xtradb-cluster-sst-traffic-encryption/feed/ 2 42821