Percona's MySQL & InnoDB performance and scalability blog
91k followers 7 cikk/hét
Partial Data Archiving and Schema Change

Starting from Percona Toolkit 3.6.0, pt-online-schema-change supports the option –where, so you can not only alter your table definition live but copy only rows that satisfy certain criteria. It may happen that you may not need to copy all the data when changing table definition. For example, if the table is too big and you […]

Wed Jun 19, 2024 00:01
How to Run Percona Everest Locally in a Dev Environment From Source

Percona Everest is the first open source, cloud-native platform for automated database provisioning and management. It supports PostgreSQL, MongoDB, and MySQL clusters. It enables multi-database and multi-cluster configurations and can be deployed on any Kubernetes infrastructure in the cloud or on-premises. Featuring a user-friendly web UI and API...

Tue Jun 18, 2024 17:00
Can Oracle Save MySQL?

I got quite a response to my article on whether Oracle is Killing MySQL, including a couple of great write-ups on The Register (1, 2)  on the topic.  There are a few questions in this discussion that I think are worth addressing.  AWS and other cloud vendors compete, without giving anything back, what else would […]

Mon Jun 17, 2024 17:04
Resume Your Failed pt-online-schema-change Job

Starting from Percona Toolkit 3.6.0, you can resume pt-online-schema-change if it was interrupted. This blog describes the prerequisites and usage of the new –resume option. To restart the job, you need to know where it failed. This is why the first option you must use is –history. It instructs pt-online-schema-change to store its progress in […]

Fri Jun 14, 2024 16:56
Sakila, Where Are You Going?

At Percona, we monitor our users’ needs and try to accommodate them. One aspect we monitor is the MySQL version distribution/utilization. Observing that, we identified a very interesting trend: the lack of migration from 5.7 to 8.x, or better yet, the need of many to remain on 5.7.  That observation has triggered several actions from […]

Thu Jun 13, 2024 16:28
What’s New in Percona Toolkit 3.6.0

Percona Toolkit 3.6.0 has been released on June 12, 2024. The most important updates in this version are: The possibility to resume pt-online-schema-change if it is interrupted. eu-stack support in pt-pmp that significantly improves this tool’s performance and decreases the load it causes on production servers. New tool pt-eustack-resolver Packages...

Wed Jun 12, 2024 21:00

Készítse el saját hírfolyamát

Készen áll, hogy kipróbálja?
Indítson egy 14 napos próbaverziót, ehhez nincs szüksége bankártyára.

Fiók létrehozása