Hi all,

I’ve just been playing with DBeaver community and have migrated an old postgres schema to mysql with very little hassle.

After this, I’ve looked more into Dbeaver and found the following survey: https://dbeaver.com/2024/05/31/survey-results-shaping-the-future-with-customer-feedback/

Quite interesting!

Especially as one would think that a data migration task is more a DBA task. Good to know!

I also found the following links useful:

dbeaver.com/docs/dbeaver/Data-transfer

No option to dump DB without data #2176

…

In this blog, we’ll look at evaluating the performance of an SST data transfer without encryption.

A State Snapshot Transfer (SST) operation is an important part of Percona XtraDB Cluster. It’s used to provision the joining node with all the necessary data. There are three methods of SST operation available: mysqldump, rsync, xtrabackup. The most advanced one – xtrabackup – is the default method for SST in Percona XtraDB Cluster.

We decided to evaluate the current state of xtrabackup, focusing on the process of transferring data between the donor and joiner nodes tp find out if there is any room for improvements or optimizations.

Taking into account that the security of the network connections used for Percona XtraDB Cluster deployment is one of the most important factors that affects SST performance, we will evaluate SST operations in two setups: without network encryption, and in …