Tag: Galera

Feed: Planet MySQL; Author: Serge Frezefond; Comparing Oracle MySQL Group Replication and Galera Cluster through a probability perpective seems quite interesting.At commit time both use a group certification process that requires network round trips. The required time for these network roundtrips is what will mainly determined the cost of a transaction. Let us try to compute an estimate of the certification process cost. The duration of these network roundtrips duration can be model by random variable with an associated probability distribution law. For Galera all nodes take part in the process so the time taken is dimensioned by the worst ... Read More

Feed: Planet MySQL; Author: Codership; Join Galera Cluster team!  Both jobs are key positions at Codership. You will influence a great deal to Galera Cluster user experience.  We have thousands of users.Galera Cluster QA EngineerThe QA Engineer/release manager will be responsible for working with the development team at Codership and create and execute tests, make builds of Galera Cluster and develop and extend test automation frameworks.You will be also working closely with MariaDB development and quality assurance teams to prioritize software bug fixes.TasksContinuously refine the QA process to improve product qualityTroubleshoot and work with the development team to isolate issuesCreate ... Read More

Feed: Percona Database Performance Blog. Author: Yves Trudeau. Yves Trudeau  | September 15, 2017 |  Posted In: High-availability, Maxscale, MySQL, ProxySQL PREVIOUS POST This post is the third of a series focusing on the MySQL high availability solutions available in 2017. The first post looked at the elders, the technologies that have been around for more than ten years. The second post talked about the adults, the more recent and mature technologies. In this post, we will look at the emerging MySQL high availability solutions. The “baby” MySQL high availability solutions I chose for the blog are group replication, proxies and distributed storage ... Read More

Feed: Planet MySQL; Author: Severalnines; While many of our customers utilize ClusterControl on-premise to automate and manage their open source databases, several are deploying ClusterControl alongside their applications in the cloud. Utilizing the cloud allows your business and applications to benefit from the cost-savings and flexibility that come with cloud computing. In addition you don’t have to worry about purchasing, maintaining and upgrading equipment. Along the same lines, ClusterControl offers a suite of database automation and management functions to give you full control of your database infrastructure. With it you can deploy, manage, monitor and scale your databases, securely and ... Read More

Feed: Planet MySQL; Author: René Cannaò; ProxySQL is a high performance, high availability, protocol aware proxy for MySQL, with a GPL license! Today I am excited to announce the release of ProxySQL 1.4.2, the second stable release of series 1.4.x . Binaries are available here . This release introduce several bug fixes and enhancements compared to previous version: introduced experimental native Cluster solution fixes random failure in handling PREPARE #1169 don't use connections from connection pool for fast_forward users #1157 reset SQL_MODE and TIME_ZONE when a connection is reset #1160 added reload command in init script #1154 several improvements to ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . MariaDB Galera Cluster is MariaDB plus the MySQL-wsrep patch from Codership. It is currently available on Unix platforms only. In MariaDB 5.5 and MariaDB 10.0, MariaDB Galera Server is a separate package installed instead of the standard MariaDB Server package. Since MariaDB 10.1, the MariaDB Server and MariaDB Galera Server packages have been combined and Galera packages and their dependencies get installed automatically when installing MariaDB. The Galera parts remain dormant until configured, like a plugin or storage engine. The most recent release of MariaDB 10.2 is:MariaDB 10.2.8 Stable (GA) Download Now The ... Read More

Feed: Planet MySQL; Author: Severalnines; Building high availability, one step at a time When it comes to database infrastructure, we all want it. We all strive to build a highly available setup. Redundancy is the key. We start to implement redundancy at the lowest level and continue up the stack. It starts with hardware - redundant power supplies, redundant cooling, hot-swap disks. Network layer - multiple NIC’s bonded together and connected to different switches which are using redundant routers. For storage we use disks set in RAID, which gives better performance but also redundancy. Then, on the software level, we ... Read More

Feed: Planet MySQL; Author: Severalnines; Since it was originally published more than 63,000 people (to date) have leveraged the MySQL for Galera Cluster Tutorial to both learn about and get started using MySQL Galera Cluster. Galera Cluster for MySQL is a true Multi-master Cluster which is based on synchronous replication. Galera Cluster is an easy-to-use, high-availability solution, which provides high system uptime, no data loss and scalability to allow for future growth. Severalnines was a very early adopter of the Galera Cluster technology; which was created by Codership and has since expanded to include versions from Percona and MariaDB.   ... Read More

Feed: Planet MySQL; Author: Severalnines; Galera Cluster is a synchronous multi-master replication plugin for InnoDB or XtraDB storage engine. It offers a number of outstanding features that standard MySQL replication doesn’t - read-write to any cluster node, automatic membership control, automatic node joining, parallel replication on row-level, and still keeping the native look and feel of a MySQL server. This plug-in is open-source and developed by Codership as a patch for standard MySQL. Percona and MariaDB leverage the Galera library in Percona XtraDB Cluster (PXC) and MariaDB Server (MariaDB Galera Cluster for pre 10.1) respectively. We often get the question ... Read More

Feed: Planet MySQL; Author: Severalnines; Galera Cluster is a true multi-master cluster solution for MySQL and MariaDB, based on synchronous replication. Galera Cluster is easy-to-use, provides high-availability, as well as scalability for certain workloads. ClusterControl provides advanced deployment, management, monitoring, and scaling functionality to get your Galera clusters up-and-running using proven methodologies. Here are just some of the great resources we’ve developed for Galera Cluster over the last few years... Tutorials Galera Cluster for MySQL Galera allows applications to read and write from any MySQL Server. Galera enables synchronous replication for InnoDB, creating a true multi-master cluster of MySQL servers ... Read More