This article is written to share how to setup SSL Replication
between MySQL InnoDB Cluster and Slave single node via MySQL
Router.
It is for Demo Purpose ONLY.
The video below shows the Replication working between Primary
Node failover in the MySQL InnoDB Cluster. The
Replication switches to another Primary Node via the MySQL
Router.
https://youtu.be/R0jOMfZlF8c
The General Steps as follows :
Setup as follows (Demo only)
Virtual Machine 1
1. A working MySQL InnoDB Cluster
Virutal Machine 2
2. A working MySQL Node as Slave
3. A working MySQL Router setup on Slave Node to point to the
MySQL InnoDB Cluser on VM1.
The key part is to ensure the "key files" to be the same on each
node of the MySQL InnoDB Cluster.
For the InnoDB Cluster on VM1 setup :
For example with MySQL InnoDB …
In a MySQL master-slave high availability (HA) setup, it is important to continuously monitor the health of the master and slave servers so you can detect potential issues and take corrective actions. In this blog post, we explain some basic health checks you can do on your MySQL master and slave nodes to ensure your setup is healthy. The monitoring program or script must alert the high availability framework in case any of the health checks fails, enabling the high availability framework to take corrective actions in order to ensure service availability.
MySQL Master Server Health Checks
We recommended that your MySQL master monitoring program or scripts runs at frequent intervals. Assuming that the monitoring script is running on the same server as your …
[Read more]In this post, I am going to show you how to run Orchestrator on FreeBSD. The instructions have been tested in FreeBSD 11.3 but the general steps should apply to other versions as well.
At the time of this writing, Orchestrator doesn’t provide FreeBSD binaries, so we will need to compile it.
Preparing the Environment
The first step is to install the prerequisites. Let’s start by installing git:
[vagrant@freebsd ~]$ sudo pkg update Updating FreeBSD repository catalogue... Fetching meta.txz: 100% 944 B 0.9kB/s 00:01 Fetching packagesite.txz: 100% 6 MiB 492.3kB/s 00:13 Processing entries: 100% FreeBSD repository update completed. 31526 packages processed. All repositories are up to date. [vagrant@freebsd ~]$ sudo pkg install git Updating FreeBSD repository catalogue... FreeBSD repository is up to date. All repositories are up to date. New …[Read more]
Presentation of some of the new features of MySQL 8.0.19 released on January 13, 2020.
The post MySQL 8.0.19 New Features Summary first appeared on dasini.net - Diary of a MySQL expert.
Creating a MySQL NDB Cluster is really easy when using MySQL
Cluster Manager aka "MCM".
In this blog post we will look at how to install and configure
MCM and then create a new cluster using MCM commands.
Steps to install and and setup MCM as a service is explained
here.
Once you have completed the setup of MCM next step is to install
MySQL NDB Cluster.
First step is to download latest Cluster 7.6 binaries from:
https://dev.mysql.com/downloads/cluster/
(7.6.13 as of today)
cd /tmp
wget https://dev.mysql.com/get/Downloads/MySQL-Cluster-7.6/mysql-cluster-gpl-7.6.13-linux-glibc2.12-x86_64.tar.gz
cd /opt
tar xzf /tmp/mysql-cluster-gpl-7.6.13-linux-glibc2.12-x86_64.tar.gz
mv mysql-cluster-gpl-7.6.13-linux-glibc2.12-x86_64 mysql-cluster-7.6.13Now it's time to start …
[Read more]TL;DR — If you are hosting your database server in GCE, then you have to be very cautious with capacity planning. The number of CPU cores has an impact on IOPS you get. Even if your workload is not CPU intensive, you might want to provision enough depending on the kind of IOPS you are going to need. For more details, read through one of the problems we faced and the RCA.
Problem statement:
We had a master-slave setup for one of the MySQL database servers. The MySQL server’s performance was good, we didn’t notice any performance related issues initially. But we recently noticed replication lag on the slave. and we figured out that the slave thread was very slow.
Server’s Capacity:
Both our master-slave servers are of the same size.
- 4 Core CPU
- 16GB Memory
- 2 databases are hosted
- 20GB is the database size. …
In the past year, GitHub engineers shipped GitHub Packages, Actions, Sponsors, Mobile, security advisories and updates, notifications, code navigation, and more. Needless to say, the development pace at GitHub is accelerated.
With MySQL serving our backends, updating code requires changes to the underlying database schema. New features may require new tables, columns, changes to existing columns or indexes, dropping unused tables, and so on. On average, we have two schema migrations running daily on our production servers. Some days we have a half dozen migrations to run. We’ll cover how this amounted to a significant toil on the database infrastructure team, and how we searched for a solution to automate the manual parts of the process.
At first …
[Read more]
Oracle, the world's premier database company, is hiring expert
technical support staff for MySQL - the world's most popular open
source database! By joining this proven team of MySQL
professionals, you will assist customers in the resolution of
their issues with your wide-ranging skill set. From explaining
database internals to reviewing schema design, from application
architecture review to client code analysis, from best practices
definition to defect analysis - customers will look to you for
assistance in addressing their needs in a timely, professional
manner. You will continually exercise and grow your diverse
skills as you deliver the highest quality support possible to
customers. Work location is flexible.
Job duties are varied and complex utilizing …
Friday March 6th you need to be in Pasadena, California
for the MySQL Track at the Southern California Linux Expo.
SCaLE is the biggest open source show in North
America and the only one in the great Los Angeles
area.
We have been lucky to have a MySQL track for the last
several years and this year I think we have the best lineup
ever! We start at 9:30 in room 101 with Michael Marx's
presentation on InnoDB Cluster, then switch to Building a
Database as a Service on Kubernetes by Lucy Burns and Abhi
Vaidyanatha. Next Alexander Rubin speaks
on Protecting Personal and Health Data in MySQL
before lunch.
After lunch comes Implementing MySQL
Database-as-a-Service using Open Source tools by Matthias …
This is the second part of a two-articles series. In the first part, we introduced the Common Table Expression (CTE), a new feature available on MySQL 8.0 as well as Percona Server for MySQL 8.0. In this article, we’ll present the Recursive Common Table Expression. SQL is generally poor at recursive structures, but it is now possible on MySQL to write recursive queries. Before MySQL 8.0, recursion was possible only by creating stored routines.
What is a Recursive Common Table Expression?
A recursive CTE is one having a subquery that refers to its own name. It is particularly useful in the following cases:
- To generate series
- Hierarchical or tree-structured data traversal