With the successful deployment of MySQL Enterprise Edition, Lina One has improved telemarketing productivity across its call centers and set a new standard for efficiency and security in the insurance industry. Read the blog.

Tagging is an essential practice in managing and organizing cloud resources. In Oracle Cloud Infrastructure (OCI), tagging is an integral part of the OCI Identity and Access Management service(IAM) which provides a systematic way to categorize and manage resources effectively, such as cost tracking, cloud resource searching, filtering and logical organization.

In this blog post, we will explore how to use cost tags to correlate the cost associated with a particular HeatWave MySQL DB System.

MySQL 8.4 and newer have extended the Global Transaction ID (GTID) functionality with a new “tag” option.

Refresher on GTID

A GTID is a unique ID that is assigned to a transaction. This is used if gtid_mode is set to ON. The benefit of this is that a transaction can be uniquely identified in a MySQL replication setup with multiple levels. Among others this makes it easier to refactor a replication tree as a MySQL replica knows which transactions it has seen and can use this to find the right position to start replicating from a new source.

The format of GTIDs is documented here.

Before GTID was used replication worked based on a file and offset (e.g. file=binlog.000001,offset=4), which is unique to every server.

A GTID without tag looks like …

I am writing this quick post to share what I think is a problematic new behavior of Offline Mode in MySQL 9.  Basically, the new default behavior in MySQL 9 is to write the username of the user which set offline_mode to ON.  I think this behavior has not been considered from a security point of view because it leaks a root username in the error message presented to the users.

My

MySQL Shorts is a playlist on the MySQL YouTube channel dedicated to short form tutorials that focus on a single feature or solution to a problem. This video series covers a variety of different topics. For this post, we will sumamrize all the ‘Shorts’ that highlight HeatWave MySQL. Episode 52 For Episode 52 of MySQL Shorts, we […]

The latest episode of MySQL Shorts is now available.

Managing cloud resources is a continuous challenge for enterprises. Many organizations move to the cloud to reduce operational costs and enhance business agility. Early adopters often allowed their business units to deploy infrastructure quickly to become more agile and better serve their customers. However, this approach has led to a rapid spread of data and […]

As part of the Advent calendar of content for this year, we are going to take a stroll down memory lane into the history of MySQL. In this first post, we will highlight some of the major milestones of the early years.

The latest Episode of MySQL Shorts is now available! Check out Episode 79 on the MySQL YouTube Channel to learn how to convert non-ISO conforming date formats into conforming ISO dates.

Next year, MySQL will celebrate its 30th anniversary. I started using MySQL in 2001 when I landed my first job as a web developer. Since that time, I have always had at least one project in production that used MySQL to store and retrieve data on the backend. For this year’s Advent Calendar of Content, we are […]