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 …
[Read more]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 […]
MySQL NDB Cluster (NDB) is truly amazing. High availability and durability built into its design. Blazingly fast. Online scalable and upgradable. NDB serves your critical applications or infrastructure with its proven five 9’s availability. It’s capable of running millions of transactions per second – with no downtime while increasing your database size, or during upgrades. These are all reasons why […]