The MySQL Server High Availability landscape provides with a slew
of tools to help you ensure that your databases keep humming.
Such tools are Galera Cluster, however, it is worth looking at
semi-synchronous replication with failover tools, and also the
usual leader-follower asynchronous replication. Today more
workloads are moving to the cloud, and what failover options do
you get with Amazon RDS for MySQL or even Aurora? What about the
newfangled group replication and InnoDB Cluster? And let us not
forget that Galera Cluster has spawned branches too!
Join Codership, the developers and experts of Galera
Cluster, as we discuss where Galera Cluster fits in and how
to get best out of it.
EMEA webinar 9th April 10-11 AM CEST (Central European
Time)
JOIN THE EMEA WEBINAR
USA webinar 9th April …
The MySQL Server High Availability landscape provides with a slew
of tools to help you ensure that your databases keep humming.
Such tools are Galera Cluster, however, it is worth looking at
semi-synchronous replication with failover tools, and also the
usual leader-follower asynchronous replication. Today more
workloads are moving to the cloud, and what failover options do
you get with Amazon RDS for MySQL or even Aurora? What about the
newfangled group replication and InnoDB Cluster? And let us not
forget that Galera Cluster has spawned branches too!
Join Codership, the developers and experts of Galera
Cluster, as we discuss where Galera Cluster fits in and how
to get best out of it.
EMEA webinar 9th April 10-11 AM CEST (Central European
Time)
JOIN THE EMEA WEBINAR
USA webinar 9th April …
The much anticipated release of Galera 4 makes
its way first in the latest release of MariaDB Server
10.4.3 Release Candidate which you can download now. Congratulations to MariaDB
Corporation and MariaDB Foundation on this release candidate — please get testing Galera
4, and share your feedback with us via our Google Group discussion list! Do not forget that
you can always reach us via email: mailto:info@galeracluster.com
and via our contact us form.
The feature we are excited about the most, is a feature request from many users. This is none other than huge transaction …
[Read more]The short version
I created > one billion InnoDB tables in MySQL 8.0 (tables, not rows) just for fun. Here is the proof:
$ mysql -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1425329 Server version: 8.0.12 MySQL Community Server - GPL Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> select count(*) from information_schema.tables; +------------+ | count(*) | +------------+ | 1011570298 | +------------+ 1 row in set (6 hours 57 min 6.31 sec)
Yes, it took 6 hours and 57 minutes to count them all!
Why does anyone need one billion tables?
In my previous blog post, I created and tested …
[Read more]This post is a followup to my previous article https://www.percona.com/blog/2018/08/29/scaling-io-bound-workloads-mysql-cloud/
In this instance, I want to show the data in different dimensions, primarily to answer questions around how throughput scales with increasing IOPS.
A recap: for the test I use Amazon instances and Amazon gp2 and io1 volumes. In addition to the original post, I also tested two gpl2 volumes combined in software RAID0. I did this for the following reason: Amazon cap the single gp2 volume throughput to 160MB/sec, and as we will see from the charts, this limits InnoDB performance.
Also, a reminder from the previous post: we can increase gp2 IOPS by increasing volume size (to the top limit 10000 IOPS), and for io1 we can increase IOPS by paying per additional IOPS.
Scaling with InnoDB …
[Read more]Please join Percona’s Architect, Tibi Köröcz as he presents Utilizing ProxySQL for Connection Pooling in PHP on Tuesday August 14, 2018, at 8:00 am PDT (UTC-7) / 11:00 am EDT (UTC-4).
ProxySQL is a very powerful tool, with extended capabilities. This presentation will demonstrate how to use ProxySQL to gain functionality (seamless database backend switch) and correct problems (applications missing connection pooling).
The presentation will be a real-life study on how we use ProxySQL
for connection pooling, database failover and load balancing the
communication between our (third party) PHP-application and our
master-master MySQL-cluster.
Also, we will …
Amazon RDS is a managed relational database service that makes it easier to set up, operate, and scale a relational database in the cloud. One of the common questions that we get is “What is Multi-AZ and how it’s different from Read Replica, do I need both?”. I have tried to answer this question in this blog post and it depends on your application needs. Are you looking for High Availability (HA), read scalability … or both?
Before we go to into detail, let me explain two common terms used with Amazon AWS.
Region – an AWS region is a separate geographical area like US East (N. Virginia), Asia Pacific (Mumbai), EU (London) etc. Each AWS Region has multiple, isolated locations known as Availability Zones.
Availability Zone (AZ) – AZ is simply one or more data …
[Read more]Including setting up Percona XtraDB Cluster with ProxySQL and PMM
Please join Percona’s Architect, Tibi Köröcz as he presents Percona XtraDB Cluster 5.7 Tutorial Part 2 on Wednesday, June 20th, 2018, at 7:00 am PDT (UTC-7) / 10:00 am EDT (UTC-4).
Never used Percona XtraDB Cluster before? This is the webinar for you! In this 45-minute webinar, we will introduce you to a fully functional Percona XtraDB Cluster.
This webinar will show you how to install Percona XtraDB Cluster with ProxySQL, and …
[Read more]Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 5.5.58, 5.6.38, 5.7.20 and new Galera 3.22 library, wsrep API version 25.
NEW FEATURES AND NOTABLE FIXES IN THE GALERA REPLICATION LIBRARY SINCE LAST BINARY RELEASE BY CODERSHIP (3.21):
New features and notable fixes in Galera replication since last binary release
* Reporting last committed write set fixed to respect commit ordering (MW-341)
* GComm socket level error handling improved to avoid backend
thread exit
in case of unexpected input from ASIO IO service (GAL-518)
* Race condition fixed in GComm message sending codepath (GAL-520)
* Fix for EVS protocol stall due to exhausted send window
setting. This
bug could stall cluster messaging until the next keepalive was
sent by
some node, causing …
Since its creation, Galera Cluster has established itself as the most popular high availability solution for MySQL and MariaDB users worldwide.
ClusterControl is the go-to automation and management system for Galera Cluster users.
And together, we’re going to walk you through all the different aspects that make Galera Cluster such a popular high availability solution for MySQL and MariaDB and how to best manage it with ClusterControl.
We’ll hear about the latest features of Galera Cluster directly from Codership, the creators of Galera Cluster. And we’ll look at how to automate everything from deployment, monitoring (how about ASCII-art graphs?), backups, failover, recovery, rolling upgrades and scaling using the ClusterControl CLI (for a change, we also have a GUI of course).
AGENDA
Introduction
About Codership, the makers of Galera Cluster
About Severalnines, the makers of …