When you provision a MySQL HeatWave database instance, you can only connect to the database from services inside of OCI. Using an OCI network load balancer, we can connect to a MySQL HeatWave instance from clients outside of OCI. In this post, we'll show you how to do this.

Cover image by DALL-E: “a manometer with pipe with a dolphin on a background, 3d render”

What’s the best way to store binary data in MySQL? This is a question that has multiple answers, depending on what you want to achieve. For example, if you need to optimize for the storage size, you probably need to use some compression algorithm that compresses your data efficiently. In my case, I really need the best performance, meaning the fastest response time to fetch the entire blob from MySQL.

Let’s put aside the question of whether MySQL is a good fit for storing binary data. The question here, is how to store binary data so the reads from DB are as fast as possible?

The …

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

MySQL Document Store is a 'NoSQL' solution built on top of MySQL and using MySQL database tables. In this post, we show how to turn on logging so we can see the queried MySQL uses under the covers when we use the MySQL Document Store DRUC API.

Startups and scale-ups often reach a point where they need to reconsider their applications’ data platform to effectively scale. These organizations’ initial platform typically allows them to rapidly get going and cope with unpredictable user base growth and volatile demand. However, once the product-market fit has been established and growth has reached a tipping point, it may no […]

Numerous fast-growing, cloud-native organizations have selected MySQL HeatWave as their data platform to effectively overcome their growing pains. See how four of them improved performance, scalability, security, and productivity while reducing costs by migrating to MySQL HeatWave.

The MySQL Heatwave Database Service in the Oracle Cloud Infrastructure (OCI) permits users to take automatic, periodic backups of their MySQL database systems (DB Systems). However, if the backup were configured to occur in the middle of the night and the data-altering event occurs during the middle of the day, there could be hours of […]

This blog introduces a new recovery option available for MySQL Database Systems (DB Systems) that, once enabled, permits data recovery to a specific point in time.

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. I did some poking around, […]

MySQL Database Service supports migrations from a live on-premises MySQL 5.7 database to a MySQL DB system on Oracle Cloud Infrastructure (OCI) in almost real-time using replication. Migrating the data in real time helps you achieve minimal downtime and verify that your live production data is all good. If you have not migrated to MySQL Database Service, it is high […]