Tag: Galera

Feed: Planet MySQL; Author: MySQL Performance Blog; Dmitriy Kostiuk | June 20, 2018 |  Posted In: Events and Announcements, High-availability, MySQL, Percona Software, Percona XtraDB Cluster, ProxySQL PREVIOUS POST Percona announces the release of Percona XtraDB Cluster 5.6.40-26.25 (PXC) on June 20, 2018. Binaries are available from the downloads section or our software repositories. Percona XtraDB Cluster 5.6.40-26.25 is now the current release, based on the following: All Percona software is open-source and free. New feature PXC-907: New variable wsrep_RSU_commit_timeout allows to configure RSU wait for active commit connection timeout (in microseconds). Fixed Bugs PXC-2128: Duplicated auto-increment values were set for the concurrent sessions on ... Read More

Feed: Planet MySQL; Author: Severalnines; RDS is a Database as a Service (DBaaS) that automatically configures and maintains your databases in the AWS cloud. The user has limited power over specific configurations in comparison to running MySQL directly on Elastic Compute Cloud (EC2). But RDS is a convenient service, as long as you can live with the instances and configurations that it offers. Amazon RDS currently supports various MySQL and MariaDB versions as well as the, MySQL-compatible Amazon Aurora DB engine. It does support replication, but as you may expect from a predefined web console, there are some limitations. Amazon ... Read More

Feed: Planet MySQL; Author: The Pythian Group; This Log Buffer edition covers Oracle, SQL Server and MySQL. Cloud: What DBAs need to know about Cloud Spanner, Part 1: Keys and indexes Introducing sole-tenant nodes for Google Compute Engine — when sharing isn’t an option A serverless solution for invoking AWS Lambda at a sub-minute frequency Amazon Aurora MySQL DBA Handbook – connection management Why you should bet on Azure for your infrastructure needs, today and in the future Oracle: The ability to make grants on objects in the database such as tables, views, procedures or others such as SELECT, DELETE, ... Read More

Feed: Planet MySQL; Author: Severalnines; What is SysBench? If you work with MySQL on a regular basis, then you most probably have heard of it. SysBench has been in the MySQL ecosystem for a long time. It was originally written by Peter Zaitsev, back in 2004. Its purpose was to provide a tool to run synthetic benchmarks of MySQL and the hardware it runs on. It was designed to run CPU, memory and I/O tests. It had also an option to execute OLTP workload on a MySQL database. OLTP stands for online transaction processing, typical workload for online applications like ... Read More

Feed: Planet MySQL; Author: Severalnines; Container orchestration tools simplify the running of a distributed system, by deploying and redeploying containers and handling any failures that occur. One might need to move applications around, e.g., to handle updates, scaling, or underlying host failures. While this sounds great, it does not always work well with a strongly consistent database cluster like Galera. You can’t just move database nodes around, they are not stateless applications. Also, the order in which you perform operations on a cluster has high significance. For instance, restarting a Galera cluster has to start from the most advanced node, ... Read More

Feed: Planet MySQL; Author: MariaDB; This blog post is rather practical. What it aims to show is how we can use a script that in turn uses MariaDB Backup to back up a MariaDB Server master, how we can create a MariaDB Server slave from this backup and then how we can script an online update to MariaDB MaxScale 2.2 to include the new MariaDB Server slave. Lets start with describing our environment. Our infrastructure We currently have one MariaDB Server master, 2 MariaDB Server slaves and one instance of MariaDB MaxScale. They are all running CentOS 7.2 and the IP ... Read More

Feed: Planet PostgreSQL. The main goals of a multi-datacenter (or multi-DC) setup — regardless of whether the database ecosystem is SQL (PostgreSQL, MySQL), or NoSQL (MongoDB, Cassandra) to name just a few — are Low Latency for end users, High Availability, and Disaster Recovery. At the heart of such an environment lies the ability to replicate data, in ways that ensure its durability (as a side note Cassandra’s durability configuration parameters are similar to those used by PostgreSQL). The various replication requirements will be discussed below, however, the extreme cases will be left to the curious for further research. Replication ... Read More

Feed: Planet MySQL; Author: Severalnines; You may have heard about the term “split brain”. What it is? How does it affect your clusters? In this blog post we will discuss what exactly it is, what danger it may pose to your database, how we can prevent it, and if everything goes wrong, how to recover from it. Long gone are the days of single instances, nowadays almost all databases run in replication groups or clusters. This is great for high availability and scalability, but a distributed database introduces new dangers and limitations. One case which can be deadly is a ... Read More

Feed: Planet MySQL; Author: MyDBOPS; The schema changes in production can cause lock at time and makes the slave to lag. It is more tedious and troublesome with PXC ( Galera ) cluster which can be made smoother with Percona online schema change. Image Courtesy : Photo by Andrew Ruiz on Unsplash Advertisements ... Read More

Feed: Planet MySQL; Author: Severalnines; Watch the replay of this webinar with Severalnines Support Engineer Bart Oles, as he walks us through what you need to know in order to migrate from standalone or a master-slave MySQL/MariaDB setup to Galera Cluster. When considering such a migration, plenty of questions typically come up, such as: how do we migrate? Does the schema or application change? What are the limitations? Can a migration be done online, without service interruption? What are the potential risks? Galera Cluster has become a mainstream option for high availability MySQL and MariaDB. And though it is now ... Read More