I am seriously considering moving our MySQL infrastructure over to Percona XtraDB Cluster. However one of the statements in the limitations documentation concerns me: “DDL statements are problematic and may stall cluster.”
What kind of problems are actually seen? We have a unusually large structure on the order of 50,000+ tables so DDL statements occur on a rather frequent basis. Any input would be appreciated.
If a DDL statement simple pauses the cluster for a brief interval that is completely acceptable, however if it behaves in an unexpected fashion with the potential to hang the cluster entirely that is not.