When you run a simple write, …it may look simple, but under the hood, MySQL’s InnoDB engine kicks off a pretty complex sequence to ensure your data stays safe, consistent, and crash-recoverable. In the top-left corner of the diagram, we see exactly where this begins — the moment the query is executed: [crayon-68cab7db11592789242838/] The log […]

Announcing the release of MySQL AI, an option to MySQL Enterprise Edition, that provides built-in predictive and generative AI capabilities and a vector store.

Begin your hands-on MySQL adventure! This post guides newcomers through accessing and exploring their databases using MySQL Shell. Clear instructions, friendly guidance, and practical tips ensure a confident start for any data explorer eager to interact with tables and data in real time.

Create a chatbot in LangChain using HeatWave GenAI

I’m working on sharing MySQL tips, tricks, and other related tech topics in my MySQL podcast. It’s a bit of a challenge to stay consistent, but I’m pushing through. Finally…

The post MySQL Podcast: InnoDB Cluster Group Replication first appeared on Change Is Inevitable.

Customers need to analyze MySQL audit logs for compliance, monitoring, and troubleshooting, but managing large volumes in MySQL can be costly. An archival system addresses this by extracting logs and storing them in a cost-effective repository. OCI Object Storage offers durability, scalability, and easy integration. Once archived, logs can be analyzed using OCI Logging Analytics or third-party tools. This blog shows how to build such an archival pipeline using OCI Data Integration (OCI-DI).

Today’s developers strive for agility without sacrificing security or performance, especially when building data-driven apps and AI solutions. That’s why we’re excited to introduce the MySQL HeatWave REST Service (MRS), a fully managed, integrated solution that lets you create RESTful API endpoints instantly, directly from your MySQL HeatWave databases. There’s no need for backend coding, middleware, or third-party frameworks to provide streamlined and secure access to your data over HTTPS.

Right now, you’re probably hoping someone else will deal with this MySQL 8.0 end-of-life situation. Maybe your team can squeeze another few months out of it. Maybe Oracle will extend support. Maybe it won’t be as bad as everyone says. We get it.  You’ve got enough things going on without adding “major database upgrade” to […]

Regional Indicator Symbols

in Unicode are the codes starting at U+1F1E6 to U+1F1FF. If you combine two of them in a valid ISO-3166-1 alpha-2

codes, they produce the flag corresponding to that code.

We want a function flag_emoji() that takes such a two-letter code and emits the appropriate Unicode codepoint:

SELECT flag_emoji('GB') AS gb, flag_emoji('us') AS us, flag_emoji('de') AS de \G
gb: 🇬🇧
us: 🇺🇸
de: 🇩🇪
1 row in set (0.00 sec)

MySQL

For that, we define a helper function unichar() that makes us a Unicode character from a codepoint …

How to use MySQL HeatWave’s vector store as a knowledge base when using OCI’s Generative AI Agent Service