This article is the second of the new series dedicated on how a DBA can find the info he needs with MySQL Database Service in Oracle Cloud Infrastructure.
The first article was dedicated on Backups, this one is about Disk Space Utilization.
This time we have two options to retrieve useful information related to disk space:
Metrics
In the OCI Web Console, there is a dedicated metric for the disk usage:
As for the backup, we can create Alarms for …
[Read more]In this new series of articles we will explore the different sources of information available when using MySQL Database Service on OCI to effectively perform your daily DBA job.
Of course there is way less things to take care of, like backups, upgrades, operating system and hardware maintenance, …
But as a serious DBA, you want to know the status of all this and maintain some control.
Some information is available on OCI’s webconsole and some in
Performance_Schema and Sys.
If you use MySQL Shell for Visual Studio Code, you have the possibility to see an overview of your server using the Performance Dashboard:
But today we will take a look at the backup, a very important responsibility of the DBA.
When you use MySQL Database Service on OCI, you can define the backup policy at the DB Instance’s creation. You can always modify it later:
In …
[Read more]The latest MySQL release has been published on January 17th, 2023. MySQL 8.0.32 contains some new features and bug fixes. As usual, it also contains contributions from our great MySQL Community.
I would like to thank all contributors on behalf of the entire Oracle MySQL team !
MySQL 8.0.32 contains patches from Facebook/Meta, Alexander Reinert, Luke Weber, Vilnis Termanis, Naoki Someya, Maxim Masiutin, Casa Zhang from Tencent, Jared Lundell, Zhe Huang, Rahul Malik from Percona, Andrey Turbanov, Dimitry Kudryavtsev, Marcelo Altmann from Percona, Sander van de Graaf, Kamil Holubicki from Percona, Laurynas Biveinis, Seongman Yang, Yamasaki Tadashi, Octavio Valle, Zhao Rong, Henning Pöttker, Gabrielle Gervasi and Nico Pay.
Here is the …
[Read more]Recently Jack asked me for a Sysbench package for OL9.
In this post, you can find the RPM packages of Sysbench 1.1.0 build for Oracle Linux 9, RedHat Enterprise 9 and any RPM compatible system.
Sysbench’s binary is linked with
libmysqlclient.so.21 and
libssl.so.3.
Here are the two files, one for x86_64 and one for aarch64 (ARM):
sysbench-1.1.0-2.el9.x86_64Download
…
[Read more]Oracle recently released Read Replica for MySQL Database Service (also known as MySQL HeatWave, with or without the use of HeatWave accelerator for OLTP and OLAP).
Read Replicas are read-only copies of the MySQL DB system in the same region. When you add Read Replicas, they are automatically distributed accross Availability Domains and/or Fault Domains.
Each MySQL DB instance can have up to 18 read replicas.
Read Replicas use MySQL Asynchronous Replication with parallel workers. And when you create the first Read Replica, a Read Replica Load Balancer is created, which distributes read traffic among the read replicas.
Not all shapes are compatible with Read Replicas, the …
[Read more]More and more people are requesting how they could connect to MySQL without using a password but using a SSL certificate. Known as X509.
CA Certificate
A CA certificate is a digital certificate issued by a certificate authority (CA). It’s used by clients to verify the SSL certificates sign by this CA.
Such certificates is usually paid and needs to be manually installed with MySQL Server. But by default, MySQL generates a self-signed certificate and provides its own CA.
For obvious reason, I will use the certificates that have been auto-generated by MySQL on my system. However, for production, I encourage you to have a real CA signed certificate.
The CA certificate is called ca.pem and is
located in MySQL’s datadir (/var/lib/mysql/ca.pem on
Oracle Linux, RHEL, Fedora, CentOS, …).
In case you don’t know where your ca.pem is located, you can …
[Read more]Next week, November 16th, I will participate to the MySQL Innovation and Cloud Virtual Day in French.
My colleagues will present what’s new in MySQL 8.0.31 and also summarize all the big news that was announced at Oracle Cloud World in Las Vegas.
Attendees will learn about the MySQL HeatWave offering in OCI.
I will be presenting something that is only available in MySQL on-prem and in OCI as a managed service: MySQL Document Store.
The event is in French and attendees will have the opportunity to discuss and chat with MySQL experts (included Olivier!!) during the event.
Registration is required to attend this free event: Register Here.
On se voit la semaine prochaine !
Recently, I wrote three articles on how to analyze queries and generate a slow query log for MySQL Database Service on OCI:
In these post, we were generating a slow query log in text or JSON directly in Object Storage.
Today, we will see how we can generate …
[Read more]
With the latest MySQL release (8.0.31), MySQL adds support for the SQL
standard INTERSECT and EXCEPT table operators.
Let’s have a look how to use them.
We will use the following table:
CREATE TABLE `new` (
`id` int NOT NULL AUTO_INCREMENT,
`name` varchar(20) DEFAULT NULL,
`tacos` int DEFAULT NULL,
`sushis` int DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB
For our team meeting, we will order tacos and sushi’s.
Each record represent the order of each team member:
select * from new;
+----+-------------+-------+--------+
| id | name | tacos | sushis | …[Read more]
Once again, the latest version of MySQL 8.0 includes several contributions from the MySQL Community.
MySQL 8.0.31 was released on October 11th 2022.
I would like to thank all contributors on behalf of the entire Oracle MySQL team !
This new release contains patches from Facebook/Meta, Dennis Gao, Lou Shuai, Caza Zhang, Zhang Simon from Tencent, Dimitry Kudryavtsev, Rahul Malik from Percona, Alex Xing, Marcelo Altmann from Percona, Matthew Steeples, Adam Croot, Luis Pinto and Evgeniy Patlan from Percona for all his patches on MySQL Shell.
Here is the list of the above contributions and related bugs:
Replication