- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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 22-Jun-2020 07:24:53
- Related Questions & Answers
- What are the prerequisites for starting writing and using MySQL stored procedure?
- What are the differences between Stored procedures and functions?
- How are actions that take place inside stored procedure and functions replicated?
- What are the special security requirements for using stored procedures and functions together with replication?
- What are the limitations of JavaScript?
- What is the difference between MySQL stored procedure and function?
- What are the advantages and limitations of JDBC PreparedStatement?
- What are MySQL stored functions and how can we create them?
- What is stored procedure and how can we create MySQL stored procedures?
- What are the different modes of parameters used by MySQL stored procedure?
- What are the limitations of MySQL ENUMs?
- What are the limitations of data mining?
- What are the Limitations of Ratio Analysis?
- What are importance and limitations of financial ratios?
- What is STORED PROCEDURE in a DB2? How will you create a new stored procedure?
Advertisements