planet.mysql.com Open in urlscan Pro
2a02:26f0:3100:787::2e31  Public Scan

Form analysis
0 forms found in the DOM

Text Content

 * Login  |  Register

Planet MySQL
 * Close
   Home
 * Meta
 * FAQ
 * Language
   * English
   * Deutsch
   * Español
   * Français
   * Italiano
   * 日本語
   * Русский
   * Português
   * 中文
 * Aggregate feed


Showing entries 1 to 10 of 43769
10 Older Entries »
Sep
18
2024
Taking Galera Cluster Enterprise Edition (EE) Non-Blocking Operations (NBO) for
a spin
Posted by Codership on Wed 18 Sep 2024 13:55 UTC
Tags:
Blog, schema, mysql high availability, schema change, Planet OpenStack, Galera
Cluster for MySQL, NBO, Galera Cluster Enterprise Edition, Galera NBO Non
Blocking Operations, Non-Blocking Operations

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]
Sep
18
2024
Top 10 Ways to Optimize MySQL Performance with ProxySQL
Posted by ProxySQL on Wed 18 Sep 2024 13:08 UTC
Tags:
Tech Blog Post, Release announcement

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]
Sep
17
2024
MySQL 8.0 vs. 5.7: Are the Newer Versions More Problematic?
Posted by MySQL Performance Blog on Tue 17 Sep 2024 14:13 UTC
Tags:
Insight for DBAs, MySQL, Database Trends, mysql-and-variants

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 […]

Sep
16
2024
Announcing the MySQL Implementation Oracle Certified Associate Exam
Posted by Oracle MySQL Group on Mon 16 Sep 2024 15:32 UTC


MySQL Implementation Oracle Certified Associate Exam

Sep
16
2024
Introducing RHEL9-Certified Builds for Percona MySQL: Ensure Maximum
Compatibility and Compliance
Posted by MySQL Performance Blog on Mon 16 Sep 2024 13:29 UTC
Tags:
Percona Software, MySQL, Percona Server for MySQL

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 […]

Sep
16
2024
Migrating SQL Server to MySQL Heatwave Service
Posted by Chandan Kumar on Mon 16 Sep 2024 05:01 UTC


Sep
13
2024
All UUID Functions in Percona Server for MySQL: RFC 9562 Implemented
Posted by MySQL Performance Blog on Fri 13 Sep 2024 14:28 UTC
Tags:
Insight for DBAs, Percona Software, MySQL, UUID, mysql-and-variants

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
[…]

Sep
13
2024
Creating and Connecting to A HeatWave MySQL Always Free Instance
Posted by Oracle MySQL Group on Fri 13 Sep 2024 04:00 UTC


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.

Sep
12
2024
MySQL/HeatWave Audit Archive and Dump to Object Storage
Posted by Ivan Ma on Thu 12 Sep 2024 10:31 UTC


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]
Sep
10
2024
HeatWave MySQL – New Capabilities for OLTP Workloads
Posted by Oracle MySQL Group on Tue 10 Sep 2024 16:59 UTC


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 1 to 10 of 43769
10 Older Entries »


TOP AUTHORS

Alena Subotina (7)
Frederic Descamps (7)
Jean-François Gagné (3)
Olivier Dasini (3)
Chandan Kumar (2)
Daniel Nichter (2)
Keith Hollman (2)
Kristian Köhntopp (2)
Dimitri Kravtchuk (1)
Ivan Ma (1)
Marco Tusa (1)
Ronald Bradford (1)
RoseHosting (1)
Vlad Mihalcea (1)


ORACLE MYSQL BLOGS

Oracle's MySQL Blog (40)


VENDOR BLOGS

Percona (26)
Codership (6)
PlanetScale (6)
ProxySQL (1)


MYSQL LINKS

MySQL Downloads
MySQL Docs
MySQL Bugs
MySQL Forums
Planet MySQL © 1995, 2024, Oracle Corporation and/or its affiliates   Legal
Policies | Your Privacy Rights | Terms of Use |
Cookie-Einstellungen
Content reproduced on this site is the property of the respective copyright
holders. It is not reviewed in advance by Oracle and does not necessarily
represent the opinion of Oracle or any other party.