Syntax error What are the limitations for replicating stored procedure and functions?

What are the limitations for replicating stored procedure and functions?

Followings are the limitations for replicating stored procedure and functions −

  • Type of Action − Actually the replication of stored procedure and functions depends upon the type of action. If the action, embedded in stored procedures, is nondeterministic (random) or time-based then it may not replicate properly. By their very nature, randomly produced results are not predictable and cannot be exactly reproduced, and therefore, random actions replicated to a slave will not mirror those performed on a master.
  • Type of transaction − non-transactional tables for which errors occur during large DML actions (such as bulk inserts) may experience replication issues in that a master may be partially updated from DML activity, but no updates are done to the slave because of the errors that occurred.
Updated on: 2020-06-22T07:24:53+05:30

257 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements