Showing entries 11 to 20 of 43781
« 10 Newer Entries | 10 Older Entries »
Taking Galera Cluster Enterprise Edition (EE) Non-Blocking Operations (NBO) for a spin

Galera Cluster Enterprise Edition (EE) has had support for Non-Blocking Operations (NBO) schema upgradesever since the first release of Galera Cluster Enterprise Edition (EE). It is reasonably well documented, and we think more people will benefit from using it, of course. Schema changes tend to always remain a daunting task when you have large databases to manage.

To compare between Total Order Isolation (TOI), the default, with NBO that is available in Galera Cluster Enterprise Edition (EE), we create a test table:

CREATE TABLE large;
USE large;

CREATE TABLE test_table (
    id INT PRIMARY KEY AUTO_INCREMENT,
    data VARCHAR(255),
    num1 INT,
    num2 INT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

Then we …

[Read more]
Top 10 Ways to Optimize MySQL Performance with ProxySQL

MySQL is a widely used database management tool; however, as your application grows, maintaining optimal performance may become more challenging. 

Thankfully, ProxySQL provides many features that can help optimize MySQL performance and functions as a high-performance MySQL proxy. Let us understand the scope of improvement and how you can optimize MySQL performance using the powerful ProxySQL.

The Challenge of MySQL Performance

MySQL can face performance challenges under heavy load or complex query workloads. Conventional optimization techniques often reach their limits, necessitating additional strategies. Under such circumstances, ProxySQL can address these challenges and significantly enhance MySQL performance.   

ProxySQL is a high-performance open-source SQL proxy that organizations can use to optimize the MySQL database performance.

10 Ways ProxySQL Can Optimize …

[Read more]
MySQL 8.0 vs. 5.7: Are the Newer Versions More Problematic?

There has been much discussion recently about the stability and performance of the latest MySQL releases. Many database professionals are voicing concerns, especially after encountering several issues in the newer versions. Issues with MySQL 8.0.38 Let’s start with some important news from Marco Tusa. In one of his blog posts, Marco strongly advised against upgrading […]

Announcing the MySQL Implementation Oracle Certified Associate Exam

MySQL Implementation Oracle Certified Associate Exam

Introducing RHEL9-Certified Builds for Percona MySQL: Ensure Maximum Compatibility and Compliance

Historically, Percona has been providing our customers with enterprise-grade solutions for MySQL that meet the highest standards of compatibility and compliance. To follow this commitment, Percona now offers RHEL9-certified builds for the users of Percona software for MySQL. These builds have been rigorously tested and are available as rpm packages, ensuring seamless integration with your […]

Migrating SQL Server to MySQL Heatwave Service
All UUID Functions in Percona Server for MySQL: RFC 9562 Implemented

The release of Percona Server for MySQL 8.4.0 includes the new UUID_VX component, which implements UUID versions 1, 3, 4, 5, 6, and 7 according to recently published RFC 9562. UUIDs (Universally Unique Identifiers) are unique identifiers that can be generated independently without a central authority or coordination with other parties. Unlike sequential integer identifiers, which […]

Creating and Connecting to A HeatWave MySQL Always Free Instance

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.

MySQL/HeatWave Audit Archive and Dump to Object Storage

Auditing is one of the key concerns with Security & 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 the audit.   The data once is archived to Table "audit_archive.audit_data" and the table is renamed to "audit_data_<timestamp>" accordingly.  The table is dumped to OCI Object Storage bucket using mysql shell utility.  The tutorial is for demo purpose only.   

MySQL Enterprise Audit is the feature allowing audit to be implemented.   For managed service of "MySQL", namely HeatWave Service on Oracle Cloud Infrastructure,  Enterprise Audit is installed.   If running MySQL Enterprise Edition on your compute VM, please refer to the documentation on how to install MySQL …

[Read more]
HeatWave MySQL – New Capabilities for OLTP Workloads

On the cusp of Oracle Cloud World 2024, 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.

Showing entries 11 to 20 of 43781
« 10 Newer Entries | 10 Older Entries »