Tag: galera

Clustering, Software

Percona XtraDB Cluster 5.7.21-29.26 Is Now Available

Percona announces the release of Percona XtraDB Cluster 5.7.21-29.26 (PXC) on March 2, 2018. Binaries are available from the downloads section or our software repositories. Percona XtraDB Cluster 5.7.21-29.26 is now the current release, based on the following: Starting from now, Percona XtraDB Cluster issue tracking system is moved from launchpad to JIRA. All Percona software is …

Clustering

Updated: Become a ClusterControl DBA – SSL Key Management and Encryption of MySQL Data in Transit

Databases usually work in a secure environment. It may be a datacenter with a dedicated VLAN for database traffic. It may be a VPC in EC2. If your network spreads across multiple datacenters in different regions, you’d usually use some kind of Virtual Private Network or SSH tunneling to connect these locations in a secure …

Miscellaneous

Percona XtraDB Cluster 5.7.20-29.24 Is Now Available

  Percona announces the release of Percona XtraDB Cluster 5.7.20-29.24 (PXC) on January 26, 2018. Binaries are available from the downloads section or our software repositories. NOTE: Due to new package dependency, Ubuntu/Debian users should use apt-get dist-upgrade, apt upgrade, or apt-get install percona-xtradb-cluster-57 to upgrade. Percona XtraDB Cluster 5.7.20-29.24 is now the current release, …

Clustering

How to convert galera node to async slave and vice-versa with MariaDB Galera Cluster

Recently, I was working with one of our customer and this is what their requirement as they want to automate this process for converting galera node to async slave and make async slave to galera node without shutting down any server. ———- I’ve tested locally with my galera cluster and it’s working smoothly. But with …

Clustering, Security

How to Secure Galera Cluster – 8 Tips

  As a distributed database system, Galera Cluster requires additional security measures as compared to a centralized database. Data is distributed across multiple servers or even datacenters perhaps. With significant data communication happening across nodes, there can be significant exposure if the appropriate security measures are not taken. In this blog post, we are going …

Miscellaneous

Percona XtraDB Cluster 5.6.38-26.23 Is Now Available

  Percona announces the release of Percona XtraDB Cluster 5.6.38-26.23 (PXC) on January 24, 2018. Binaries are available from the downloads section or our software repositories. Percona XtraDB Cluster 5.6.38-26.23 is now the current release, based on the following: All Percona software is open-source and free. Fixed Bugs PXC-889: Fixed an issue where a node …

Clustering, Security

ClusterControl Tips & Tricks: Securing your MySQL Installation (Updated)

  Requires ClusterControl 1.2.11 or later. Applies to MySQL based clusters. During the life cycle of Database installation it is common that new user accounts are created. It is a good practice to once in a while verify that the security is up to standards. That is, there should at least not be any accounts …