Tag: Galera

Feed: Planet MySQL; Author: Codership; A few weeks ago, we did a Galera Cluster webinar on Managed Galera Clusters on DigitalOcean. Some of you may notice that the current version of Galera Manager is 1.6.4, and one of the major fixes we have in there is to support the new API token format of DigitalOcean. DigitalOcean has documented this here: Updated API Tokens new management features: in partnership with GitHub –Secret Scanning, Prefixes, and more! and as a consequence we needed to update to accept new API tokens, or it would fail in deployment. If you’re wondering how to create ... Read More

Feed: Planet MySQL; Author: Codership; Codership is pleased to announce a new Generally Available (GA) release of the multi-master Galera Cluster for MySQL 5.7 and 8.0, consisting of MySQL-wsrep 5.7.37 (release notes, download) and MySQL-wsrep 8.0.28 (release notes, download) with Galera replication library 3.37 (release notes, download) implementing wsrep API version 25 and Galera replication library 4.12 (release notes, download) implementing wsrep API version 26. This release incorporates all changes to MySQL 5.7.37 and 8.0.28 respectively, adding a synchronous option for your MySQL High Availability solutions. For the Galera replication library 3.37, we added a WORK_DIR parameter to garb.cnf and ... Read More

Feed: Planet MySQL; Author: Codership; The Galera Cluster Enterprise Edition Codership is pleased to announce Galera Cluster Enterprise Edition. Galera Cluster Enterprise Edition consists of an enhanced GaleraCluster server, Galera Manager and Galera Load Balancer. The enhanced Galera Cluster Server includes 1) A new Online Schema Upgrade method called Non Blocking Operations (NBO), adds more high availability to your cluster while performing schema changes. Schema changes made on all cluster nodes in the same total order sequence, with much more efficient locking compared to the Total Order Isolation (TOI) method. SET GLOBAL wsrep_OSU_method=’NBO’ Read Non Blocking Operations documentation 2) XA transactions is a standard for coordinating distributed transactions, allowing multiple databases to participate in a transaction ... Read More

Feed: Planet MySQL; Author: Codership; Codership is pleased to announce a new release of Galera Manager. This is version 1.6.1 of Galera Manager GUI. Users will notice many usability improvements, and multiple fixes for issues filed at the galera-manager-support issue tracker. The biggest user facing feature is now being able to deploy Galera Manager managed nodes on DigitalOcean, in addition to Amazon Web Services (AWS) Elastic Compute Cloud (EC2). Now with an access token, one can fully deploy a managed cluster from within Galera Manager. 3 node fully managed Galera Clusters on Digital Ocean in under 10 minutes? This is ... Read More

Feed: Planet MySQL; Author: Codership; Recently we got a question about how one can perform a minor version upgrade of a Galera Cluster, and today we just want to say that it is reasonably straightforward. While upgrades are a feature of Galera Manager that we are most excited to see come soon, today, doing it manually on the command line is quite simple! In this post, we will go through upgrading a 9-node geographically spread cluster, from MySQL 8.0.23 to 8.0.26. We also have extensive documentation: Upgrading Galera Cluster. We have 3 nodes each in Singapore, London and San Francisco, ... Read More

Feed: Planet MySQL; Author: Codership; There are plenty of articles on the Internet that tell you to setup a Galera Cluster by disabling an OS based firewall and also disabling SELinux. While we agree that this might be the fastest way to get your Galera Cluster setup, it is not necessarily good security hygiene, and we would prefer if you started 2022 with a bit more secure Galera Cluster! What is SELinux? Is is Security-Enhanced Linux that allows administrators to allow who has more control over the system. It has permissive and enforcing mode, and is turned on by default ... Read More

Feed: Planet MySQL; Author: Codership; This video tutorial describes how to install Galera Manager in 15 minutes while also deploying a Galera Cluster in Amazon Web Services (AWS), all in an automated fashion! WATCH THE VIDEO ... Read More

Feed: Planet MySQL; Author: Codership; As more people test, utilise and deploy Galera Manager, there is always room for support requests, and we see that at the Galera Manager Support Repository on Github. We encourage you to file requests, as they help with our roadmap as well! We have had a feature request to run within a Docker container, and while we work on documentation and an official solution, we do have a temporary solution. Try it with Docker! We have had a feature request to be able to support Debian 11. The main stumbling block was that Galera Cluster ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Working on a real case scenario in a five node Percona XtraDB Cluster (PXC), we were forced to use wsrep_sync_wait = 1, because the app does reads-after-write and we send reads to all the nodes. We had the idea to leave some nodes in DESYNC mode to reduce the flow control messages during peak load and expected to have a steadier write throughput keeping the read consistency. We decided to test Perconas’s new PXC Scheduler Handler which is an application that manages integration between ProxySQL and Galera/PXC (the scope is to maintain the ProxySQL ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . Overview The Galera Monitor is a monitoring module for MaxScale that monitors a Galera cluster. It detects whether nodes are a part of the cluster and if they are in sync with the rest of the cluster. It can also assign master and slave roles inside MaxScale, allowing Galera clusters to be used with modules designed for traditional master-slave clusters. By default, the Galera Monitor will choose the node with the lowest wsrep_local_index value as the master. This will mean that two MaxScales running on different servers will choose the same server ... Read More