Today’s MySQL Community Advent Calendar post is about JSON datatype. Let’s start with some info about how MySQL Document Store handles JSON documents. Document Store and CRUD We know that MySQL 8.0 Document Store handles JSON documents with CRUD operations. We can add, delete and modify those documents very easily: JS > db.mycollection.find() { "_id": […]

The Inbound Replication capabilities of MySQL HeatWave Database Service have been improved with filtering and handling of sources without GTIDs. Users now have more flexibility to configure replication Channels for hybrid deployments or straightforward live migrations from on-premises or other cloud vendors.  Using the templates under the Target DB system filter options, you can easily […]

You now have more flexibility to configure Channels in MySQL Database Service for hybrid deployments or straightforward live migrations from on-premises or other cloud vendors. There are new options to add filters and source GTID handling in Channels for inbound replication.

The MySQL HeatWave Database Service added new 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 […]

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