In this blog post, we will explore how network partitions impact group replication and the way it detects and responds to failures. In case you haven’t checked out my previous blog post about group replication recovery strategies, please have a look at them for some insight. Topology: [crayon-67612d59301c8127310863/] Scenario 1: One of the GR nodes […]
Sep
25
2024
Aug
14
2024
Group replication is a fault-tolerant/highly available replication topology that ensures if the primary node goes down, one of the other candidates or secondary members takes over so write and read operations can continue without any interruptions. However, there are some scenarios where, due to outages, network partitions, or database crashes, the group membership could be broken, or we end […]
Nov
16
2022
This is a demo tutorial to show how we can create InnoDB Cluster with newly installed Certificate and having X509 certificate verification via MySQL Router connection.
Recorded Video
The full process is recorded on Youtube - showing creating InnoDB Cluster with newly installed CA, Server Certificates. The Router creation is configured with SSL Server certificate from the same CA certificate across Server nodes. The creation of User (create user my509user identified by '....' require X509) using X509 certificate PASSTHROUGH verification via Router connection.
https://www.youtube.com/watch?v=w1xgpjw0VTw
Environment
The following environment was tested
Oracle Linux Server release 8.6
MySQL Server 8.0.31
MySQL Shell 8.0.31 …
[Read more]
May
10
2022
During previous months, I’ve had some time to satisfy my
curiosity about databases in containers and I started to test a
little bit MySQL in Kubernetes.
This is how it all began…
In January I had the chance to be trained on Kubernetes attending
the Docker and Kubernetes essentials Workshop of
dbi services. So I decided to prepare a session on this topic at
our internal dbi xChange event. And as if by magic, at the
same time, a customer asked for our support to migrate a MySQL
database to their Kubernetes cluster.
In general, I would like to raise two points before going into …
[Read more]
May
10
2022
During previous months, I’ve had some time to satisfy my
curiosity about databases in containers and I started to test a
little bit MySQL in Kubernetes.
This is how it all began…
In January I had the chance to be trained on Kubernetes attending
the Docker and Kubernetes essentials Workshop of
dbi services. So I decided to prepare a session on this topic at
our internal dbi xChange event. And as if by magic, at the
same time, a customer asked for our support to migrate a MySQL
database to their Kubernetes cluster.
In general, I would like to raise two points before going into …
[Read more]
Jun
11
2020
Just recently, I have been asked to look into what a Disaster Recovery site for InnoDB Cluster would look like.
If you’re reading this, then I assume you’re familiar with what MySQL InnoDB Cluster is, and how it is configured, components, etc.
Reminder: InnoDB Cluster (Group Replication, Shell & Router) in version 8.0 has had serious improvements from 5.7. Please try it out.
So, given that, and given that we want to consider how best to fulfill the need, i.e. create a DR site for our InnoDB Cluster, let’s get started.
Basically I’ll be looking at the following scenario:
InnoDB Cluster Source site with a Group Replication Disaster Recovery Site.
Now, just before we get into the nitty-gritty, here’s the scope.
Life is already hard enough, so we want as much automated as possible, so, yes, InnoDB Cluster gets some of that done, but there are other parts we will still have to …
[Read more]
Jul
31
2019
Last time we used the New MySQL Shell to set up a sandbox instance of InnoDB Cluster in Six
Steps. Now to make that cluster function we need to start up
MySQL Router to proxy connections. And since we do
not show how to do things with Windows, we will configure Router
on that Operating System.
Cleaning Up From Last TimeIf you followed the instructions from
last time you may find you InnoDB Cluster non functional.
If you have rebooted then you will find that the component pieces
of the cluster have not been started. To clean things up
you will have to do the following:
- dba.killSandboxInstance(3310)
- dba.deleteSandboxInstance(3310)
- …
Jul
29
2019
I have not used the new InnoDB clone feature that is now part of
MySQL 8.0.17 but wanted to see how it worked. Setting a
sandbox cluster with the new shell is easy and quick. How
easy and quick?
well, it takes six commands and just a few
minutes.
The Steps
1. mysqlsh>
dba.deploySandboxInstance(3310)
A new MySQL sandbox instance will be created on this host
in
C:\Users\dstokes\MySQL\mysql-sandboxes\3310
Warning: Sandbox instances are only suitable for deploying
and
running on your local machine for testing purposes and are
not
accessible from external networks.
Please enter a MySQL root password for the new instance:
******
Deploying new MySQL instance...
Instance localhost:3310 successfully deployed and started.
Use shell.connect('root@localhost:3310'); to connect to the
instance.
…
Jun
10
2019
Por si no se hubiera visto o promocionado lo suficiente, quería compartir la lista de webcasts en Español que ya hay disponible en On Demand webinars en el apartado de News & Events en mysql.com:
https://www.mysql.com/news-and-events/on-demand-webinars/#es-20-0
Sobre 1 hora de duración cada una, aquí tenéis algunos ejemplos:
MySQL InnoDB Cluster: Una introducción y Demo
MySQL, NoSQL, JSON, JS, Python: Document Store. (+demo)
[Read more]
May
31
2019
Ok, so if you’re reading this, then I can guess you’ve got a MySQL InnoDB Cluster in an awkard shape, i.e. you need to restore a backup and add the instance back into the cluster, so we have all our instances again.
As it might be logical to think “ah, but I’ve only lost 1 instance, a read-only instance, so all I have to do is backup & restore the other read-only instance and I’m home free. Well I want to make it a little harder. So in this scenario, assume that we’ve lost both the READ-ONLY instances, so I need to backup my primary READ-WRITE instance.
I’ve got a 8.0.16 instance, on Oracle Linux 7.4. We’ll be looking at 2 hosts, ic1 & ic3.
We’ll be using the MySQL Enterprise Edition Server, that bundles MySQL Enterprise Backup with the rpm’s so we don’t need to install anything else.
I’ll assume you’ve got access to Oracle …
[Read more]