The MySQL HeatWave Database Service in OCI has capabilities that enable applications to scale database read operations to millions of queries per second. Users can add and remove read replicas and load balancers to DB Systems with just a few clicks, and the service takes care of deployment, configuration, monitoring, and maintenance. Applications can connect directly to read replicas or to a read-only endpoint that automatically balances the queries across all the replicas.

UNION and UNION ALL set operators return the combined rows from 1 or more SELECT queries. CodeIgniter 4 Query Builder now supports UNION and UNION ALL queries with the $builder->union() and $builder->unionAll() methods respectively. Learn how to create these types of queries in this article.

This article and many to follow, are part of a series of articles I am writing and sharing as I learn new concepts when I learn them. I think of it as a duty in sharing the things I learn as a self-taught developer. We all need to support one another as we continue to learn and grow. #buildinpublic #learninpublic #indiehackers #developer

The Newsletter for PHP and MySQL Developers

Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech …

MySQL Advent Calendar 2022 - Day 7: how to use a backup as source for a new OCI MySQL Database Service instance with Terraform.

Percona Server for MySQL 8.0.30-22 introduces several improvements for the LDAP plugin: SASL support, support for fallback servers, and support for LDAP-based authorization. All improvements are in technical preview.

A description of the existing plugin features and usage instructions are available in the earlier blog post introducing the LDAP simple plugin, and in the Percona Server for MySQL documentation.

SASL connections

We introduced a new plugin similar to the MySQL …

What is a Delay Replica and how does it help?

MySQL Replication is useful, easy to set up, and used for very different purposes. For example:

• split reads and writes
• run data mining or reporting processes on them
• disaster recovery

To learn more, check out How Does MySQL Replication Work?

It’s important to mention that a replication server is not a backup by itself. A mistake on the source, for example, a DROP DATABASE or an UPDATE without a WHERE clause will be replicated nearly instantly to all replica servers. Simply having a replica is not going to be helpful here. How can we avoid that kind of mistake? By having a replica server that intentionally lags behind.

We can never avoid human error in database infrastructure operations. But …

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 […]

Background In databases, rows are persisted on disk and for every row, columns’ value are stored on disk. Now, if a new column is to be added or an old column is to be dropped from a table, the contents of existing rows should be changed to reflect the correct values of columns present in […]

MySQL Shell is a powerful way to connect to and manage MySQL instances. Connections can even be made to servers that are behind an SSH connection. In this post, we will discuss how to extend and customize MySQL Shell so that it is easier to initiate those connections.

Web-Konseil, is a web and digital agency based in Lyon, France.  The agency supports companies in the development of websites and e-commerce applications. Its business keeps growing with constant innovation and introduction of new services. Thanks to a partnership with Oracle, Web-Konseil already offers a hosting service for its customers on Oracle Cloud Infrastructure (OCI). […]

Web-Konseil is a web and digital agency based in Lyon, France. It develops websites and e-commerce applications for its clients using MySQL HeatWave in local Oracle data centers located in Paris and Marseille. MySQL HeatWave on OCI gives Web-Konseil a clear competitive advantage by offering their customers real time data insight.