List of shows 6-8/2023
Jun
01
2023
May
30
2023
This blog post serves as a work-log detailing the process of uninstalling and installing a specific version of Percona MySQL Server on CentOS. The post includes instructions for installation using…
The post Install exact version of Percona Server for MySQL on CentOS first appeared on Change Is Inevitable.
May
30
2023
A friend needed to analyze slow queries and for that he decides to use pt-query-digest tool. Though he got stuck at exporting slow queries from slow logs in RDS for…
The post MySQL Slow query log export and download in RDS first appeared on Change Is Inevitable.
May
29
2023
If you’re looking for your PHP, MySQL, and LAMP stack media source, you’ve found it in OpenLampTech. I have one massive – and excellent – newsletter for you this week. Check it out!
Custom WooCommerce and Shopify Solutions
Discover useful WooCommerce and Shopify custom solutions for your online store today at affordable prices!
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 OpenLampTech newsletter.
OpenLampTech issue #80 is sharing content on:
- WordPress …
May
25
2023
An inordinate amount of our Galera Cluster customer base is still using the MySQL 5.7 variant of Galera Cluster. Besides not being able to have access to all the new features of the Galera 4 library, MySQL 5.7 is rapidly reaching End of Life (EOL) status in October 2023. This is less than six months away, and it is also why we would like to focus on getting our users upgraded to MySQL 8.0 with Galera Cluster.
Firstly, MySQL 8 has been Generally Available (GA) since 19 April 2018. That is a whole five years, and you must by now, already know that there is a new release model, where there are new features included in minor releases. The release notes are a must read. Next, Codership released Galera Cluster 4 with MySQL 8 with MySQL 8.0.19, on …
[Read more]
May
24
2023
The post explains how to use MySQL Enterprise Data Masking and De-Identification Features.
May
22
2023
I am finalizing my Percona Live talk MySQL and Vitess (and Kubernetes) at HubSpot. In this talk, I mentioned that I like that Percona is providing better MySQL with Percona Server. This comes with a little inconvenience though: with improvements, sometimes comes regression. This post is about such regression and a workaround I implemented some time ago (I should have shared it
May
22
2023
Welcome to the OpenLampTech developer newsletter. Thank you so much for reading each week. I am bringing you the media source for PHP, MySQL, and the LAMP stack you can depend on.
Custom WooCommerce and Shopify Solutions
Discover useful WooCommerce and Shopify custom solutions for your online store today at affordable prices!
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 OpenLampTech newsletter.
I am sharing so many good articles this week in OpenLampTech issue #79. Visit those …
[Read more]
May
22
2023
MySQL Shell offers an upgrade over legacy MySQL CLI tools. One set of features that gets a boost is dumping and loading data. MySQL Shell allows users to load and dump data using a multithreaded process and to be more granular in what data is dumped and loaded than when using mysqldump. In this post we discuss how to use these utilities to dump specific tables in a schema, specific data in specific tables in a schema, one or more schemas simultaneously, and an entire MySQL instance.
May
18
2023
Explore the powerful features of Aurora Serverless V2 for MySQL in this informative blog series. Learn about read-only scaling, parameter support, and cost performance. Compare costs between Provisioned Aurora and Aurora Serverless V2. Discover key takeaways for optimizing your MySQL deployment on the cloud. Read now!
[Read more]