Anyone know of nodes that can assist with Database (MSSQL, MySQL, Oracle, etc) store and forward functionality?
For example it will appear I am storing data to Table1 in Database1 on Server1. If I am unable to store a record in Table1, Database1, Server1 (server down, network down, etc.) I begin storing in Table1, Database1 on Server2. When the first server or issue is resolved I continue to log to Table1, Database1, on Server1 but all data temporarily stored in Table1, Database1, Server2 is "forwarded" to Table1, Database1, Server1.
I am sure with quite a bit of code I can build this functionality. I was hoping there is a known node or set of nodes to accomplish this without much or any script code.
Edit - Please note that this functionality is similar to those found in SCADA and other client based systems.