I need some information about working of buffered data cache incase of database failure in FactorySQL. I have version 22.214.171.124 in a redundancy configuration. I am creating sotred procedure groups with OPC items and Action Items. The Action items are all expression based and no SQL queries in them.
Now could you kindly explain if the database goes down for whatever reason, will these groups buffer data in the cache while database is down.
I ran some tests by logging datetime every second via a stroed procedure group and there is a delay of about 30 seconds to data caching. Is there a way to ensure that stored procedure groups are executed in cache before being transfered to database and there is no data loss.
Also could you explain, under what conditions the data will not be buffered like if sql queries are used in groups etc?
I have 3 sets of FactorySQL Servers throughout the plant and replacing the RSSQL configurations with FactorySQL (for obvious reasons) and the group configurations are mostly stored procedure based. Data Buffering is critical in case of conenction loss with database. if there is another way in FactorySQL, kindly mention.