We have a cluster of 3 Galera-MariaDB boxes, using InnoDB as an engine. Cluster's in sync, and reporting all good as far as I can see.

Much to my surprise, the size of the InnoDB data files differ quite a lot between the 3 boxes; some tables even are twice as big on some boxes.

That remains the case even after nuking the data from the box with the largest data files and letting it do a full SST to rejoin the cluster.

Any ideas what could explain this?


I found an explanation here:


Because it's logical replication, rewriting transactions rather than physically copying blocks, the data file sizes won't necessarily match 1:1

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.