In my previous post, I explained how to deal with
Performance_Schema and Sys to identify
the candidates for Query Optimization but also to understand the
workload on the database.
In this article, we will see how we can create an OCI Fn Application that will generate a slow query log from our MySQL Database Service instance and store it to Object Storage.
The creation of the function and its use is similar to the one explained in the …
[Read more]
If like me you are an old experienced MySQL DBA, to analyze your
MySQL workload, you certainly have used the slow query
log with long_query_time set to
0.
The slow query log is a file that contains all the queries whose
execution time is greater than the value of
long_query_time. This file can be huge and uses up
all available disk space on busy systems.
Constantly writing to that file can also add an overhead to the server.
For those reasons, the slow query log is not available in MySQL Database Service (HeatWave) in OCI.
Plan B ?
As a DBA, what are my options for finding the queries that need to be optimized? As usual, the queries that consume the most time are the ones that need some attention
It can be a very long query or a short query executed too many times.
Currently the MySQL DBAs use …
[Read more]
Let’s continue our journey of deploying the MySQL Database System
on OCI with Terraform.
This time we will see how we can use a backup (see [1] and [2]) as a source (initial data) for a new
instance.
Within the oci_mysql_mysql_db_system it’s possible
to define a source detailing how to provision the initial
data of the db system.
Let’s deploy a new MySQL Database Instance using a manual backup we made earlier:
We can also find the backup’s ocid using the oci cli
command:
$ oci mysql backup list …
Recently I wrote an article on how to define a backup policy for
MySQL Database Service in OCI using Terraform. We saw that it
was possible to define tags (defined_tags and
freeform_tags) in the backup_policy
section of a oci_mysql_mysql_db_system resource.
However, it seems that these tags are never used for manual or automated backups in the MySQL Database Service backup process. In the strategy implemented on OCI, the backups inherit the tags from the MySQL DB system itself.
This means that if you want to have some custom tags on your backups, you need to specify them in the MySQL Database resource like this (on line 12):
resource "oci_mysql_mysql_db_system" "MDSinstance" {
admin_password = var.admin_password
admin_username = …Let’s continue the discovery of the MySQL Database Resource when deploying on Oracle Cloud Infrastructure using Terraform.
Last week, we saw how to create custom configurations and define user variables. Today we will see how we can define a backup policy and a maintenance window.
Backup Policy
In the oci_mysql_mysql_db_system resource, we will
add a new section called backup_policy like this:
backup_policy {
is_enabled = "true"
retention_in_days = "3"
window_start_time = "01:00-00:00"
freeform_tags = {"backup_defined_by"="Terraform"}
pitr_policy {
is_enabled = "true"
}
}This part of code (you can see in a working Terraform architecture sample), enables backup, sets the retention days to 3. It also defines the starting time …
[Read more]With Terraform OCI provider 4.90.0 (released August 24th, 2022), we have added the possibility to specify the value of editable configuration variables directly from Terraform.
These variables must be defined in a resource of type
oci_mysql_mysql_configuration like
this:
resource "oci_mysql_mysql_configuration" "mds_mysql_configuration" {
#Required
compartment_id = var.compartment_ocid
shape_name = var.mysql_shape
…[Read more]
In this article, we will see how you can create a MySQL DB System
from the Oracle Cloud Shell. You can also create MySQL DB System
from Oracle Cloud Infrastructure (OCI) console or from OCI
Command Line Interface (CLI).
Oracle Cloud Infrastructure (OCI) Cloud Shell is a feature
available to all OCI users and accessible from the Console. It is
a web browser-based terminal and provides a Linux shell, a
pre-authenticated command-line interface (CLI) and preinstalled
developer tools like Git, Java, Ansible, and Terraform, for
easily managing Oracle Cloud resources. You can run cli commands
without any setup. Developers can quickly get started using the
Oracle Cloud Infrastructure SDKs, such as the SDK for Python,
Java, Go, Ruby, TypeScript and JavaScript without having to
download and configure a CLI or Python or other languages on
their local machines. To know more about Oracle cloud shell,
please look …
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]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]