Ideas, releases, practical guides, and perspectives from the people building with MySQL.
“How can we replicate without using binary logs” just a thought popped up in my brain during a casual discussion. This blog post is a brain dump of the possible…
The post How to replicate without binary logs in MySQL first appeared on Change Is Inevitable.
On July 18th, Oracle released its first pair of MySQL LTS and Innovation releases. (For more, check out A Quick Peek at MySQL 8.0.34 and MySQL 8.1.0.) These releases were announced several months ago and gradually detailed closer to the release date. Today, we know from Oracle’s official blog post what to expect, as well as what the cadence and scope of the upcoming releases will be.
So, the next immediate question that comes to mind is: Is Percona going to follow the same release pattern as “upstream“ MySQL?
The short answer is “yes.”
We are proud to say that over the last several years, Percona delivered on its promise of providing the MySQL community a …
[Read more]First Principles dives into cloud innovations that power MySQL HeatWave Lakehouse, allowing customers to process and query half a petabyte of data in object storage with record performance and cost savings.
This is a Quick Peek at what Oracle delivered with MySQL 8.0.34 and 8.1.0 on July 17th, 2023. MySQL previously released software quarterly as part of a continuous delivery system where new features were made available. Many people loved access to the new features even if they could be risky, but others wanted stability and bug fixes only. Now there is a long-term support (LTS) version for the more conservative and the risk-averse folk that will have a roughly two-year lifespan between major releases.
The release with the new features will be called the Innovation series, and MySQL 8.1.0 is the first of these releases. And the LTS will be based on 8.0.34. Please note that comments in italics are mine and do not reflect the views of Percona and possibly not anyone else.
Quick reminder
The End of Life for MySQL 8.0 is in April of 2026, and the …
[Read more]In a MySQL database, fragmentation can occur over time as data is inserted, updated, and deleted. Fragmentation refers to the inefficient storage and organization of data within database objects, such…
The post MySQL fragmentation and how to defragment first appeared on Change Is Inevitable.
It is necessary to have a reliable and efficient way to transfer data from databases to the BI tool. MySQL, one of the most popular open-source relational database management systems, comes in here. This article will explore how to connect MySQL to Tableau and share data seamlessly between the two.
The post How to Connect MySQL to Tableau: A Guide for BI Professionals appeared first on Devart Blog.
In this blog post, we will describe the improvements to Percona XtraBackup 8.0.33-28 (PXB), which significantly reduces the time to prepare the backups before the restore operation. This improvement in Percona XtraBackup significantly reduces the time required for a new node to join the Percona XtraDB Cluster (PXC).
Percona XtraDB Cluster uses Percona XtraBackup to do SST (State Snapshot Transfer) from one node to another. When a new node joins the cluster, SST is performed to receive the data from DONOR to the JOINER. JOINER uses PXB to stream the data directory from DONOR. JOINER must prepare the backup before using it. It is observed that when the DONOR has a huge number of tablespaces (one million), XtraBackup on JOINER …
[Read more]Integrating MySQL with Excel can offer several advantages, including analyzing data in real-time and creating powerful reports. This article will show several methods to connect MySQL to Excel and import data into Excel.
The post How to Connect MySQL to Excel – A Guide to Importing MySQL Data into Excel appeared first on Devart Blog.
When it comes to backups, there are several options for saving backup files. You can choose to save them locally on the same server, stream them to different servers, or store them in object storage. Percona XtraBackup facilitates streaming through the use of an auxiliary tool called xbcloud.
STDOUT Datasink
This diagram displays the process of streaming a backup to object storage utilizing the current STDOUT datasink:
MySQL, a widely-used database management system, may show the warning “[Warning] Connection attributes of length 571 were truncated” in its error log. In this blog, we will explore the reasons…
The post How to Fix Connection attributes of length xxx were truncated first appeared on Change Is Inevitable.