0

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?

user4867444
  • 445
  • 4
  • 5

1 Answers1

1

I found an explanation here:

https://stackoverflow.com/questions/27146497/can-database-size-be-different-on-different-node-in-mairadb-galera-cluster

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

greenweeds
  • 241
  • 1
  • 5