This post is the twelfth one of a series of articles on extending MySQL with the Component Infrastructure:
It is essential to upgrade MySQL to the most recent version. Do you believe it’s tough to test and upgrade to a newer version?
For a variety of reasons, including new features, performance advantages, bug corrections, and so on, databases with obsolete versions are vulnerable. Major version upgrades, on the other hand, can be problematic if they haven’t been extensively tested with your application, as the procedure may break it, prevent it from functioning properly, or result in performance concerns.
Let’s go through a few useful tools that can assist you with MySQL upgrades.
The tool helps you run application SELECT queries and generates reports on how each query pattern performs on the servers across the different versions of MySQL we tested.
Knowing the first and last day of a given month can help you figure out other information relevant and important data. You can determine these values using select MySQL date functions. Learn how in this Medium post I’m resharing here for any interested readers…
Get tailored articles with Refind delivered each day in your inbox. Refind is part of my daily reading habit. Make it part of yours by using my referral link. At no additional cost to you, I will be eligible for a premium subscription with more sign-ups from my link. “The essence of the web, every morning in your inbox. Subscribe for free“
The Newsletter for PHP and MySQL Developers
Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the …
[Read more]Not only do I share the weekly OpenLampTech newsletter, but I’m also publishing some articles outside of the publication, directly to my Substack page. I’m resharing the last 2 I’ve posted over on my Substack for any interested readers…
Do you need to learn MySQL? Just starting and confused about how to query a table and get the data you need? I am creating premium MySQL Beginners content for this specific reason. To help those who want to learn the basics of MySQL but don’t know where to start. Learn more about the premium blog posts as I develop and release them.
MySQL SHOW TABLES – Two Variations
This post is an excerpt from some premium content I am creating here on my blog for beginners wanting to learn MySQL.
Read the full substack article: …
[Read more]Percona XtraBackup delivers the xbcloud binary – an auxiliary tool to allow users to upload backups to different cloud providers directly.
Today we are glad to announce the support of the Azure Blob storage to xbcloud.
This new feature will allow you to upload/download backups to Azure Blob storage. You would need an Azure storage account and access key. Check out this blog post on how to get one through the Azure portal.
This new functionality is available in the release of Percona XtraBackup 8.0.27 and will be available in Percona XtraBackup …
[Read more]Rollback is an operation, which changes the current state of the transaction to the previous state. Undo logs are generally required if we want to roll back any of the uncommitted transactions and it plays a major role in Isolation.
For any changes made during a transaction, it must be stored priorly, because they are required if we choose to roll back the transaction.
Entries are made in undo logs when data modifications are done. If a transaction modifies data with SQL commands, It will create discrete undo logs for each operation. Once a transaction is committed MySQL is free to purge the undo logs created in that transaction.
To know more about undo logs, you can check our previous blogs on overview to undo logs.
Usually, the Rollback process will take more time than the original operation. Because …
[Read more]Hey hey! Glad you are here for this week’s issue of OpenLampTech, the newsletter for PHP/MySQL developers. You are going to love what’s in this publication. I’m sharing some of my personal Developer stories which have never been published online anywhere else before. Enjoy!
Do you need to learn MySQL? Just starting and confused about how to query a table and get the data you need? I am creating premium MySQL Beginners content for this specific reason. To help those who want to learn the basics of MySQL but don’t know where to start. Learn more about the premium blog posts as I develop and release them.
[Read more]In the first part of this short series, we went through the build of a full Clusterset architecture, which included 2 full clusters (3 members each) and an additional cluster with one member, which can serve different purposes. With the MySQL ClusterSet, there are new capabilities with the router instances. These features enable valuable options for users of… Read More »
Percona XtraDB Cluster (PXC) offers a great deal of flexibility when it comes to the state transfer (SST) options (used when a new node is automatically provisioned with data). For many environments, on-the-fly compression capability gives great benefits of saving network bandwidth during the process of sending sometimes terabytes of data. The usual choice for compression here is a built-in Percona XtraBackup compress option (using qpress internally), or options compressor/decompressor for the compression tool of choice. In the second case, the popular option is the gzip or its …
[Read more]If you want to set up a MySQL database to store data for websites, blogs, or applications, you can use a Docker container. It’s relatively simple to do. And like shuffling a deck of cards, reversing a string in Python, or writing a recursive function, it’s a suitable exercise for beginners just starting out with MySQL and backend web development.
Let’s take a look at exactly what a Docker container is, and how you can use it to set up MySQL.
Image by VLADGRIN on Shutterstock
What Is a Docker Container?
A Docker container is a self-contained software development environment that includes all of the necessary …
[Read more]