MySQL Performance Blog    The release of Percona Server for MySQL . . includes the new UUID VX component, which implements UUID versions,,,,, and according to recently published RFC . UUIDs Universally Unique Identifiers are unique identifiers that can be generated independently without a central...

Oracle MySQL Group    The ’Always Free’ tier of Oracle Cloud has a new offering HeatWave MySQL. In this post, we will discuss how to spin up a new always free HeatWave MySQL instance and connect to it via an alway free compute instance.

Ivan Ma    Auditing is one of the key concerns with Security amp; Compliance for many organizations. This article is written to share a tutorial how to do audit log archiving by reading the audit log. The audit archiving process is to read the audit log using audit log read function provided to access to...

Oracle MySQL Group    On the cusp of Oracle Cloud World , we’d like to call attention to some recent enhancements that are now available for Heatwave MySQL. These enhancements deliver improvements in availability, disaster recovery, performance, manageability and operability, and developer productivity.

Marco Tusa    This long article aims to provide you with the instructions and tools to migrate your production database from your current environment to a solution based on Percona Everest MySQL . Nice. You decided to test Percona Everest and found that it is the tool you were looking for to manage your private...

Olivier Dasini    This new AI tech, called generative AI or GenAI , can dive deep into what people are saying and tell us if they’re feeling positive, negative, or neutral. Let’s see how HeatWave GenAI, can help you to enhance your understanding of customer sentiment, improve decision making, and drive business...

Oracle MySQL Group    Oracle HeatWave provides automated, integrated, and secure generative AI and machine learning in one fully managed cloud service for transactions and lakehouse scale analytics. New features are available across the HeatWave portfolio on both OCI and AWS.

Frederic Descamps    Some users, myself included, have noticed that their MySQL error log contains many lines like this one: T : : . Z Note MY Server Got packets out of order Where does that error come from The error MY is part of the Server Network issues like: ...

Alena Subotina    Read on to learn basics about invalid objects and how to identify them in SQL Server, MySQL, and Oracle databases using dbForge Edge or from the command line. The post Find Invalid Objects in Your Databases appeared first on Devart Blog.

Oracle MySQL Group    MySQL Enterprise Edition has the ability to mask and de identify data. Find out how to use it in this article

Codership    Codership will be a sponsor at DOAG in Nuremberg, Germany. There will also be Galera Cluster related talks to attend: Building a Global, High Availability Database with Galera Cluster: A Live Demo Colin Charles Codership Safe Harbor Wie der Galera Cluster ihre MySQL Datenbanken unsinkbar ...

Codership    By now you must have read our documentation on isolation levels and also our Support for Transaction Isolation Levels. It is worth noting that the default transaction isolation level in MySQL is REPEATABLE READ. Here is a simple example of this, in action you can test this on two different nodes...

Keith Hollman    Just thought I’d share a script I use daily and helps me redirect my attention if needed. This is but a mere pointer, guideline and starting point in any task. I just thought I’d share and hope someone else’s day becomes slightly easier thanks to some brief investigation and command tweaking. ...

Jean-François Gagné    I have been scratching my head about MySQL startup for some time. amp;nbsp; There is much to say about this, and many other posts will probably follow. amp;nbsp; For now, it is enough to know that with many tables millions the startup of MySQL . including . , . and . is suboptimal to...

Marco Tusa    The aim of this long article is to give you the instructions and tools to migrate your production database, from your current environment to a solution based on Percona Everest MySQL . Nice, you decided to test Percona Everest, and you found that it is the tool you were looking for to manage your...

Chandan Kumar    Check and review recommended MySQL InnoDB setting using MySQL Shell for optimal Performance. Performance of MySQL is always top priority for each organisations because data holds valuable insight into organizational productivity and proactive decision making. High performing databases help...

MySQL Performance Blog    Mysterious warning Recently, I was involved in an investigation whose goal was to find out the reason for a warning message like this: crayon e eb e The message looks clear, isn’t it Well, the problem was that this particular table had not been changed for years, and so no DDL ...

Oracle MySQL Group    This post will explain how to troubleshoot MySQL HeatWave by accessing information in the MySQL error log table and the HeatWave audit log.

Oracle MySQL Group    MySQL Shell offer many features to make life easier for DBAs and developers. In this post we discuss how we can add custom functionality to MySQL Shell using startup scripts.

Oracle MySQL Group    This blog post will explain how to tell whether a given MySQL server is an LTS release or not. The features described are implemented in MySQL . . the mysql upgrade history file and . . the INFO SRC extension . The features are available in on premise as well as cloud releases.

Keith Hollman    I thought I’d share some quick intro steps into how we can monitor the MySQL Router. This can be useful if we’re observing intermittent outages, network packet drops or you’re just not sure if everythings fine in your MySQL InnoDB Cluster. My scenario: The drupal servers are connecting and...

Vitess    We recently conducted a survey of how Vitess is being used by the community. This blog post summarizes what we learned. Vitess solves an existential threat for services which outgrow a single MySQL database. Horizontal sharding helps us scale quickly, and the new generation execution plan, Gen ,...

MySQL Performance Blog    At Percona, we have always prioritized database performance as a critical factor in selecting database technologies. Recently, we have observed a concerning trend in the community edition of MySQL, where performance appears to be declining across major releases, specifically MySQL versions . , . ...

Oracle MySQL Group    Stewardship of a community is easy for new and emerging technology. After years, MySQL has become one of the most used and trusted open source databases by millions of users worldwide.

Oracle MySQL Group    MySQL Shell offer many features to make life easier for DBAs and developers. In this post we discuss how we can add custom functionality to MySQL Shell using startup scripts.

Oracle MySQL Group    This post will explain how you can start and stop your MySQL Heatwave and compute instances from the command line using Oracle’s Command Line Interface tool.

Vitess    We are excited to announce that Vitess now supports recursive Common Table Expressions CTEs , marking another significant step in our journey to fully align with MySQL’s capabilities. Recursive CTEs, often a critical feature for complex query handling, allow for the execution of recursive queries...

Oracle MySQL Group    A work around for partitioning MySQL tables with foreign keys is described in this article.

Alena Subotina    Take a look at the most convenient and user friendly MySQL GUI tools clients that help you tackle a variety of database development, management, and administration tasks on macOS. The post Best MySQL GUI Clients for macOS appeared first on Devart Blog.

Oracle MySQL Group    OpenTelemetry Metrics provided by MySQL Telemetry provides insight into the performance, behavior, and health of your MySQL database exposing up to unique MySQL internal metrics

Oracle MySQL Group    This is a quick guide on how to use the Oracle Cloud Shell on the Oracle Cloud Infrastructure console to access MySQL HeatWave via MySQL Shell.

Oracle MySQL Group    MySQL Metups, Sep Nov

MySQL Performance Blog    Percona Operator for MySQL, based on Percona XtraDB Cluster PXC , provides configuration to expose the ProxySQL, HAProxy, and the PXC instances themselves so that you can use Percona Toolkit to connect to MySQL from these endpoints externally. However, you can also create Kubernetes pods to run...

Alena Subotina    This article explains the SIGNED and UNSIGNED integer data types in MySQL and provides examples to illustrate when and how to use these integer data types effectively. The post MySQL INT INTEGER Data Types with Different Examples appeared first on Devart Blog.

Alena Subotina    The article covers the basic syntax of the MySQL INSERT statement and explains how to work with the INSERT command in the MySQL table using dbForge Studio for MySQL. The post MySQL INSERT Statement Inserting Rows Into a Table appeared first on Devart Blog.

Kedar Vaijanapurkar    In current times, there is a high degree of focus on ensuring the availability and recovery of your production data. This can be challenging at times when using DBaaS solutions in the public cloud space, for example, when using AWS Aurora. Relying solely on a single cloud provider for database...

Codership    Well, that is more a catchy headline, than the reality: XA transactions work in your Galera Cluster Enterprise Edition EE . This has been supported since our very first release with . . Enterprise, right up till now, in . . Enterprise. If you try to run an XA transaction in your regular...

Oracle MySQL Group    list of MySQL conferences ,