The Ultimate Guide to High Availability with MariaDB

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.

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.