![Using MySQL Shell to Dump Data To And Read Data From OCI Storage Buckets Using MySQL Shell to Dump Data To And Read Data From OCI Storage Buckets](https://res.cloudinary.com/strozstuff/image/fetch/c_fit,w_250/https://idmqjyw9i2ib.objectstorage.us-ashburn-1.oci.customer-oci.com/n/idmqjyw9i2ib/b/blog/o/2023/mysql-shell-dump-to-oci/header.jpeg)
In a previous post, we discussed how you could use MySQL Shell to dump and load data using a multithreaded process. At the end of the post, I mentioned it was possible to dump data to and load data from cloud services such as Oracle Cloud Infrastructure (OCI). In this post, I will show you how to perform these data dumps and loads using OCI Storage Buckets.
![Multithreaded Data Dumps With MySQL Shell Multithreaded Data Dumps With MySQL Shell](https://res.cloudinary.com/strozstuff/image/fetch/c_fit,w_250/https://idmqjyw9i2ib.objectstorage.us-ashburn-1.oci.customer-oci.com/n/idmqjyw9i2ib/b/blog/o/2023/mysql-shell-threaded-dump/header.jpeg)
MySQL Shell is a powerful command line interface for connecting to and managing MySQL instances. One feature of MySQL Shell’s Admin API is being able to dump specific tables (or a subset of data in a table), dump one or more complete schemas, or dump an entire database instance and then restore those dumps as needed. It has the added benefit of doing this in a multithreaded process to make it more efficient.
![Connecting to a MySQL HeatWave Database Instance Using OpenVPN Connecting to a MySQL HeatWave Database Instance Using OpenVPN](https://res.cloudinary.com/strozstuff/image/fetch/c_fit,w_250/https://idmqjyw9i2ib.objectstorage.us-ashburn-1.oci.customer-oci.com/n/idmqjyw9i2ib/b/blog/o/2023/mds-openvpn/header.jpg)
MySQL HeatWave Database is a fully managed service on Oracle Cloud Infrastructure (OCI) that is developed, managed, and supported by the MySQL team at Oracle. When you provision a new MySQL instance under OCI, you can only connect to the database from inside the OCI network. While this is a great security feature for production services hosted in OCI, it is more challenging to share a development database among developers. In this post, we will show how you can use OpenVPN, running on an OCI Compute instance, to access a MySQL HeatWave Database instance.
![Using Aggregate Functions With MySQL Document Store Using Aggregate Functions With MySQL Document Store](https://res.cloudinary.com/strozstuff/image/fetch/c_fit,w_250/https://idmqjyw9i2ib.objectstorage.us-ashburn-1.oci.customer-oci.com/n/idmqjyw9i2ib/b/blog/o/2023/doc-store-aggregate/header.jpg)
MySQL Document Store is a JSON document storage solution built on MySQL. One of the advantages of using MySQL Document Store for JSON document storage is when we need to run complex queries for analytics or reporting we can use raw SQL to retrieve data from our JSON documents. But what if we want to view basic aggregate data, such as average, minimum, maximum, etc.? Can we get that data while still using the Document Store API? Yes, we can, and in this post, we will show you how it can be done.
![Viewing MySQL Document Store Queries in MySQL Database Services Viewing MySQL Document Store Queries in MySQL Database Services](https://res.cloudinary.com/strozstuff/image/fetch/c_fit,w_250/https://idmqjyw9i2ib.objectstorage.us-ashburn-1.oci.customer-oci.com/n/idmqjyw9i2ib/b/blog/o/2023/doc-store-under-covers-mds/header.jpeg)
In a previous post, we talked about how you can view the underlying queries that are run when we make calls to the MySQL Document Store API. While this solution works well on a local or other on-premise instance of MySQL, it is not a viable option for viewing those same queries on a MySQL Database Service (MDS) instance running in Oracle Cloud Infrastructure (OCI). We are going to talk about how to view those queries in MDS.
![Using OCI Alarms to Detect When a MySQL Instance Is Unavailable Using OCI Alarms to Detect When a MySQL Instance Is Unavailable](https://res.cloudinary.com/strozstuff/image/fetch/c_fit,w_250/https://idmqjyw9i2ib.objectstorage.us-ashburn-1.oci.customer-oci.com/n/idmqjyw9i2ib/b/blog/o/2023/oci-alarms-mds/header.jpg)
MySQL Database Service (MDS) is a fully-managed Oracle Cloud Infrastructure (OCI) service that allows you to harness the ease and power of MySQL in the cloud. Since MDS is deployed to OCI, we can take advantage of OCI Alarms to send notifications when a MySQL instance enters a state that is, shall we say, less than favorable. In this post, we will show how to set up an MDS instance and configure an alarm to send an email when the server becomes unavailable.
![Connecting to a MySQL HeatWave Database Instance Using an OCI Network Load Balancer Connecting to a MySQL HeatWave Database Instance Using an OCI Network Load Balancer](https://res.cloudinary.com/strozstuff/image/fetch/c_fit,w_250/https://idmqjyw9i2ib.objectstorage.us-ashburn-1.oci.customer-oci.com/n/idmqjyw9i2ib/b/blog/o/2023/mds-balancer/header.jpg)
MySQL HeatWave Database is a fully managed service on Oracle Cloud Infrastructure (OCI) that is developed, managed, and supported by the MySQL team at Oracle. When you provision a new MySQL instance under OCI, you can only connect to the database from inside the OCI network. While this is a great security feature for production services hosted in OCI, it is more challenging to share a development database among different developers. In this post, we will show how you can create a Network Load Balancer to allow access to a MySQL HeatWave Database instance over the internet.
![MySQL Document Store - Peeking Under the Covers MySQL Document Store - Peeking Under the Covers](https://res.cloudinary.com/strozstuff/image/fetch/c_fit,w_250/https://idmqjyw9i2ib.objectstorage.us-ashburn-1.oci.customer-oci.com/n/idmqjyw9i2ib/b/blog/o/2023/document-store-under-covers/header.jpg)
MySQL Document Store is a ‘NoSQL’ solution built on top of MySQL. Last month, I gave a talk at THAT Conference about using MySQL Document Store with Node.js. During that talk, one of the attendees asked if it was possible to see the underlying queries executed when we use the CRUD API in Document Store.
![Functional Indexes in MySQL Functional Indexes in MySQL](https://res.cloudinary.com/strozstuff/image/fetch/c_fit,w_250/https://idmqjyw9i2ib.objectstorage.us-ashburn-1.oci.customer-oci.com/n/idmqjyw9i2ib/b/blog/o/2023/functional-indexes/header.jpg)
Database indexes are used to help query performance. Database indexes typically contain information about data in a specific column of the database table. With the introduction of functional indexes in MySQL 8.0.13, we can now create indexes based on the result of an expression or function.
![Indexing JSON Data in MySQL Indexing JSON Data in MySQL](https://res.cloudinary.com/strozstuff/image/fetch/c_fit,w_250/https://idmqjyw9i2ib.objectstorage.us-ashburn-1.oci.customer-oci.com/n/idmqjyw9i2ib/b/blog/o/2023/index-json/header.jpg)
Storing JSON in a relational database is something developers have done for quite some time. There are a variety of reasons why you would want to store JSON in a database table - user preferences and configuration data are two good examples. The JSON Data Type was introduced to MySQL in version 5.7.8. This data type allows us to store valid JSON in a database column and run queries based on the values in the JSON.