MySQL HeatWave Best Practices Series: Data load to HeatWave with MySQL Autopilot

In 2023, FOSDEM returned as an in-person conference after being virtual for 2 years. With this comeback, the MySQL Team once again hosted the very popular preFOSDEM MySQL Days, a side event we have been doing since 2018. It was a blast ! It was great to see so many friends of MySQL in person. […]

After having cancelled 2 editions of the preFOSDEM MySQL Days because of the pandemic, we were finally back last week in Brussels for 2 wonderful days dedicated to the Dolphin database developed by Oracle. During this event and for the first time, we, the MySQL Team, decided to reward some members of the MySQL Community […]

The winners of the MySQL Rockstar 2022 Awards

On MySQL Cluster, a shared-nothing cluster solution, the user has access to the full power of the SQL language to configure their own tables through the MySQL frontend. Not all the features of the NDB storage engine are exposed via SQL, and thus available solely through the NDB API. It is one of those features, […]

With clear examples and explanations, the article demonstrates how ChatGPT can simplify and streamline the process of creating complex MySQL queries, making it easier for users to interact with databases and retrieve the data they need.

The post Power Up Your MySQL Queries: How ChatGPT Can Help You Retrieve MySQL Data appeared first on Devart Blog.

I’m doing my best (work) each week with the OpenLampTech developer newsletter. I hope you enjoy reading them as much as I do! Thank you for giving me the chance to share the ever-changing LAMP stack ecosystem with you on each issue.

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 newsletter.

In OpenLampTech issue #64, we are exploring content covering:

Thank you for reading this post. Please share it with someone else who would enjoy it as well.

Josh Otwell has a passion to grow as …

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