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.
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.
Comment