Tag: Galera

Feed: Planet MySQL; Author: MariaDB; The MariaDB project is pleased to announce the availability of MariaDB Galera Cluster 5.5.57 as well as MariaDB Connector/C 3.0.2. See the release notes and changelogs for details. Download MariaDB Galera Cluster 5.5.57 Release Notes Changelog What is MariaDB Galera Cluster? MariaDB APT and YUM Repository Configuration Generator Download MariaDB Connector/C 3.0.2 Release Notes Changelog About MariaDB Connector/C Thanks, and enjoy MariaDB! ... Read More

Feed: Planet MySQL; Author: TwinDB; Recently, we have implemented a set of new commands in ProxySQL Tools to manage MySQL users. You can create, delete, and modify users from command line. There are commands: proxysql-tools galera user listproxysql-tools galera user create username [—-options]proxysql-tools galera user delete username proxysql-tools galera user modify username [—-options]proxysql-tools galera user set_password username You can set a user’s password can be set at time of creation with —-password option or later on with  set_password sub-command. Create user Let’s add MySQL user to ProxySQL Tools with the next params:Username: mysql_userPassword: mysql_user_passwordActive: TrueUse SSL: TrueDefault hostgroup: 10Default schema: information_schemaSchema locked: ... Read More

Feed: Planet MySQL; Author: Severalnines; When you need to work with a database that you are not 100% familiar with, you can be overwhelmed by the hundreds of metrics available. Which ones are the most important? What should I monitor, and why? What patterns in metrics should ring some alarm bells? In this blog post we will try to introduce you to some of the most important metrics to keep an eye on while running MySQL or MariaDB in production. Com_* status counters We will start with Com_* counters - those define the number and types of queries that MySQL ... Read More

Feed: Percona Database Performance Blog. Author: Krunal Bauskar. Krunal Bauskar  | July 21, 2017 |  Posted In: MySQL, Percona XtraDB Cluster PREVIOUS POST 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 in the range of 3-10x. (More details here). These optimization fixes also helped improve IST (Incremental State Transfer) performance. This blog is aimed at studying the IST impact. IST IST stands for incremental state transfer. When a node of the cluster leaves the cluster ... Read More

Feed: Planet MySQL. Author: Marco. A story around replication lag and Flow-Control.In the last few months we had 2 main actors in the the MySQL ecosystem, ProxySQL and Group-Replication (with the evolution to InnoDB Cluster). While I had extensively covered the first, my last serious work on GR, goes back to some lab version in the past years. Given the decision Oracle made to declare it GA, and the Percona decision to provide some level of support to GR, I decide it was time for me to take a look at it again.A lot of reviews were already done covering different topics ... Read More

Feed: Clustrix Blog. Author: Dave Anselmi. When people come up and ask, “Oh, so ClustrixDB is yet another MySQL-compatible database. What makes you different?” we have a terrific answer, and it’s all about horizontal scaling: ClustrixDB is the only MySQL compatible database that linearly scales-out both write and read queries. By horizontal scaling we mean each additional node added to a ClustrixDB cluster adds both linear write and read horizontal scale. This is significantly different from what MySQL can provide — as a single-node master architecture, MySQL can have multiple read slaves added, potentially providing at best only linear read ... Read More

Feed: Planet MySQL. Author: Valeriy Kravchuk. This week in Support was busy enough for me. Among other things I had to study all possible reasons (other than obvious query cache impact) for queries hanging in "query end" status and noted Bug #80652 related to binlog group commit and fixed in MySQL 5.7.17+ and 8.0.1+ only. The case I had to review was related to Galera though, and I suggest you to note that "query end" may be related to Galera replication stall. Studying this path further soon brought lp:1197771 - "Cluster stalls while distributing transaction" to my attention again, so I asked ... Read More

Feed: Planet MySQL. Author: Severalnines. In our “MySQL on Docker” blog series, we continue our quest to make Galera Cluster run smoothly in different container environments. One of the most important things when running a database service, whether in containers or bare-metal, is to eliminate the risk of data loss. We will see how we can leverage a promising feature in Kubernetes called StatefulSet, which orchestrates container deployment in a more predictable and controllable fashion. In our previous blog post, we showed how one can deploy a Galera Cluster within Docker with the help of Kubernetes as orchestration tool. However, ... Read More

Feed: Percona Database Performance Blog. Author: Krunal Bauskar. Krunal Bauskar  | July 5, 2017 |  Posted In: Insight for DBAs, MySQL, Percona XtraDB Cluster PREVIOUS POST In this blog, we’ll look at the differences in how a PREPARE statement handles errors in binary and text protocols. Introduction Since Percona XtraDB Cluster is a multi-master solution, when an application executes conflicting workloads one of the workloads gets rolled back with a DEADLOCK error. While the same holds true even if you fire the workload through a PREPARE statement, there are differences between using the MySQL connector API (with binary protocol) and the MySQL ... Read More

Feed: Planet MySQL. Author: Codership. Codership is pleased to announce a new release of Galera Cluster for MySQLconsisting of MySQL-wsrep 5.7.18, 5.6.36, 5.5.55 and Galera 3.21, wsrep APIversion 25.Changes to Repositories StructureWith the new release the repository structure is changed to allow forexistence of all of the wsrep-patched mysql versions currently supported:5.5 through 5.7.Thus the repository layout requires from the user to adjust his or herrepository configuration to accomodate those changes. In order to have theMySQL-wsrep and Galera library installed, one would need to add the followingrepositories:1. Galera-3 repository for galera library:e.g. http://releases.galeracluster.com/galera-3/DIST/Here DIST is Linux distribution (ubuntu, centos, …).The ... Read More