Stored Procedures & Functions on nodes in a Galera Cluster
I am at the planning stage of a new Galera/MariaDB cluster. I can find very little info on how Stored Procedures and Functions are handled across the cluster. Am I safe to assume that a Stored Procedure or Function which is defined on one cluster node is not automatically propagated to any of the other nodes in the cluster? If so, then what are the Best Practices regarding update of Stored Procedures and Functions across the Cluster?
Answer Answered by Federico Razzoli in this comment.
All DDL statements are replicated to all nodes. So yes, you can use stored procedures and rely on them.