Last post from the MySQL Content Advent Calendar 2023 - Season's Greetings from the MySQL Community Team.

In this article we will see how we can deploy WordPress and MySQL on OKE in OCI using the MySQL Operator for Kubernetes.

I could have set MySQL between parenthesis in the title as this article is more about how to use OpenTofu to deploy on OCI.

I will explain how to install OpenTofu and how to use it to deploy on OCI. I will also mention what are the required changes be able to use my previous Terraform deployment files.

As an example, let’s use the modules to deploy WordPress with MySQL HeatWave Database Service: oci-wordpress-mds.

Installing OpenTofu

If like me you are using a RPM based Linux distro, you can find the necessary information to create the yum repository on OpenTofu’s website:

$ sudo su -
# cat >/etc/yum.repos.d/opentofu.repo <<EOF
[opentofu]
name=opentofu …

The concept of Agile software development is characterized by simplicity, collaboration, continuous delivery of working software, and sustainable development. With its new features, MySQL 8 makes using it as a database in the Agile software development process more suitable. In this post we will discuss how the relational MySQL database server is more Agile.

The efficiency of database queries in MySQL can make all the difference in the performance and responsiveness of applications. In this blog post, I’ll dig into MySQL query optimization and show how MySQL uses indexes in cases of queries using sorting and limiting. While sorting may seem simple, it’s important to understand how to do it efficiently and effectively to ensure your queries are optimized and use better indexing.

Since sorting your rows is not free, it can take a significant amount of resources and time to sort large data sets; thus, it’s important to do it cautiously. If you don’t need your rows in a certain order, don’t order them.

However, if you need to order your rows, doing it efficiently and effectively is essential to optimize your queries. You must understand how to use indexes to make sorting cheaper. 

Looking at this, can you say which is faster: LIMIT 1 or LIMIT 10? Presumably, fetching …

MySQL NDB Cluster is a distributed database that makes it possible to have more than two hundred MySQL servers operating on the same data, forming a scalable and high-performing cluster where data can be read and written by a large number of clients at the same time. Using the standard MySQL replication mechanism, data can […]

Discover the Oracle ACE Program for MySQL and meet Matthias Jung.

Key Takeaways The concept of Agile software development is characterized by simplicity, collaboration, continuous delivery of working software, and sustainable development. With its new features, MySQL 8 makes using it as a database in the Agile software development process more suitable. In this post we will discuss how the relational MySQL database server is more […]

The InnoDB buffer pool acts as a powerhouse for MySQL, caching frequently accessed data and index pages in memory to accelerate query performance. In this blog post, we will go through the process of InnoDB buffer pool resizing online, covering why it is important to monitor its progress and how to monitor it.Importance of monitoring […]

In MySQL, you cannot do this: create table t (i int primary key, j int); insert into t values (1, 1); update t set j = (select max(j) from t) + 1; The UPDATE statement will raise an error as follows: SQL Error [1093] [HY000]: You can't specify target table 't' for update in FROM … Continue reading Workaround for MySQL’s “can’t specify target table for update in FROM clause” Error →