Ideas, releases, practical guides, and perspectives from the people building with MySQL.
In MySQL Server 8.0.32, Oracle fixed Bug #105761:
“mysqldump make a non-consistent backup with ‐‐single-transaction option” (this commit)
which caused a wave of complaints from users who could no longer do backups with the mysqldump utility because of the lack of the required privileges.
…
[Read more]You might want to use binlog compression with MySQL/Percona Server for MySQL, but it can come with drawbacks. This article discusses the need for using binlog compression and the potential issues it may cause.
Binlog compression is a technique used to reduce the size of binary log files, which can become quite large over time. This can be especially important in situations where disk space is limited. However, it’s important to be aware that using binlog compression can also cause issues with replication.
Consider the following scenario: you have restored a backup that was taken from a replica node using Percona XtraBackup. Once the restoration is complete, you want to set up replication using the information from the xtrabackup_slave_info …
[Read more]For this third article of the series dedicated on how a DBA can find the info he needs with MySQL Database Service in Oracle Cloud Infrastructure, we will see how we can find the error log. When using MySQL DBAAS, the DBA doesn’t have direct access to the files on the filesystem. Hopefully, with MySQL […]
The fourth edition of the MySQL Cookbook, solutions for database developers and administrators, Sveta Smirnova, Alkin Tezuysal, O’Reilly, 2022, is a huge book: 938 pages ! And the least we can say is that you get what you pay for ! This book is an excellent resource for anyone working with MySQL, whether you’re a […]
Although MySQL 8 was released back in 2018, a significant share of MySQL servers out there are still running MySQL 5.x. MySQL 5 had a lengthy run from its release in 2005, and thus many organizations still have databases that were built on 5.x. But Oracle has been phasing out MySQL 5.7 support for various platforms over the past few years and end of life for MySQL 5.7 is slated for October 2023.
If you’re still running a database on MySQL 5.7, it’s time to seriously consider upgrading. You'll get several new features that give you performance improvements and security enhancements, so it is important that you do this soon — especially with the imminent end-of-life of MySQL 5.7, which means there will be no further security updates. Fortunately, this process is usually pretty straightforward, but there are several changes you may have to make. This article will cover many of the things that you should look out for when …
[Read more]Learn what you should look out for when upgrading an existing database from MySQL 5.7 to 8 and how to change your database to be compatible with the new version.
Machine learning has become pervasive, and businesses are scrambling to introduce machine learning and AI based functionality in their products. The biggest challenge is shortage of people with technical knowledge to deliver a machine learning based project. Now, with the interactive console for machine learning in MySQL HeatWave (aka MySQL HeatWave AutoML), even business analysts […]
Interactive console for MySQL HeatWave is an integrated environment which provides users the ability to manage the database schema objects, run interactive queries, monitor performance, and use machine learning capabilities such that a business analyst can easily develop applications, manage data objects, and machine learning models.
MySQL HeatWave on AWS – New and upcoming capabilities in March and April 2023 HeatWave Scale Out Data Management MySQL HeatWave on AWS now provides an optimized storage layer built on S3 to store the HeatWave in-memory hybrid columnar representation of the data. This allows data to be reloaded to each HeatWave node independently […]
Introducing new MySQL HeatWave features for lower cost and better performance Customers with various sizes of workloads want to use MySQL HeatWave for query acceleration. MySQL HeatWave is addressing the wide spectrum of MySQL workloads with the following new features: HeatWave can now address workloads from less than 50GB to 64TB with the best […]