Getting started with authentication_oci There is a new means of connecting seamlessly to a MySQL Database Service instance in the Oracle Cloud Infrastructure. It is a method that does not require passwords, and can utilize the public key found in a OCI user’s account profile, without anyone needing to access that profile directly . It derives its access… Read More »
May
20
2022
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]
Apr
27
2022
I could have also called this article When Pandas meet Dolphins in MySQL Shell.
Some time ago, I wrote a post related on how to collect initial relevant data when trying to seek help for MySQL.
Since then, the MySQL Shell engineering team implemented another powerful native utility that collect all the essential information and more and store them in a single zip file.
This zip archive contains TSV and YAML files that, for example, the MySQL Support Team could use to solve your eventual issue.
For more information regarding MySQL Shell’s
util.debug.collectDiagnostics(), I encourage you to
check the manual.
This tool is …
[Read more]
Apr
22
2022
In the last quarter of 2021, AWS released Aurora version 3. This new version aligns Aurora with the latest MySQL 8 version, porting many of the advantages MySQL 8 has over previous versions.
While this brings a lot of new interesting features for Aurora, what we are going to cover here is to see how DDLs behave when using the ONLINE option. With a quick comparison with what happens in MySQL 8 standard and with Group Replication.
Tests
All tests were run on an Aurora instance r6g.large with a secondary availability zone. The test was composed of:
Four connections
-
- #1 to perform DDL
- #2 to perform insert data in the table I am altering
- #3 to perform insert data on a different table
- #4 checking the other node operations
In the Aurora instance, a …
[Read more]
Apr
18
2022
Ingress is a resource that is commonly used to expose HTTP(s) services outside of Kubernetes. To have ingress support, you will need an Ingress Controller, which in a nutshell is a proxy. SREs and DevOps love ingress as it provides developers with a self-service to expose their applications. Developers love it as it is simple to use, but at the same time quite flexible.
High-level ingress design looks like this:
- Users connect through a single Load Balancer or other Kubernetes service
- Traffic is routed through Ingress Pod (or Pods for high
availability)
- There are multiple flavors of Ingress Controllers. Some use nginx, some envoy, or other proxies. See a curated list of Ingress Controllers here.
- Based on HTTP headers traffic is routed …
Apr
12
2022
Last month I performed a review of the Percona Operator for MySQL Server which is still Alpha. That operator is based on Percona Server for MySQL and uses standard asynchronous replication, with the option to activate semi-synchronous replication to gain higher levels of data consistency between nodes.
The whole solution is composed as:
Additionally, Orchestrator (https://github.com/openark/orchestrator) is used to manage the topology and the settings to enable on the replica nodes, the semi-synchronous flag if required. While we have not too much to say when using standard Asynchronous replication, I want to write a few words on the needs …
[Read more]
Apr
07
2022
Apache Airflow is an open-source workflow management platform for data engineering pipelines.
Today we will see how we can deploy very easily Apache Airflow on a Compute instance in Oracle Cloud Infrastructure (OCI) using MySQL HeatWave Database Service (MDS).
I am sharing Terraform modules you can use to deploy in your architecture:
Architectures
With the modules you can deploy architectures like these:
with a single MDS instancewith MDS High Availabilitywith HeatWave Cluster
We will use the exact same modules built into a stack for OCI’s Resource Manager. This will allow us to deploy the architecture just in few clicks.
Deployment
We open in a browser the following GitHub repository: …
[Read more]
Apr
06
2022
Amazon Web Services (AWS) very recently(March 02, 2022) announced
the GA of its new RDS feature “Readable standby with Multi-AZ
deployments” for MySQL. Yes !! you heard it right you can now
use the standby instances created with Multi-AZ deployments for
failover as well as for Read-scaling starting with version 8.0.26
and later for MySQL in RDS
Launching a MultiAZ Cluster
Now let us see how to launch this readable-Multi AZ cluster?
Region Availability: As this is a new feature now it is currently limited to the regions US-EAST-1 (N.Virginia), US-WEST-1 (Oregon), and EU-WEST-1 (Ireland), this list would be extended progressively
VPC requirement:
Before launching the instance, you should have SUBNET created for 3 AZ(Availability Zone) within the VPC since the cluster instances would be spawn across 3AZ by default
Hereunder the “Engine Option” …
[Read more]
Apr
05
2022