Can BIX extract process be run on a read replica database instance?
Hi, Can Pega BIX extracts be run on a read replica of master DB instead of master itself?
***Edited by Moderator: Pallavi to update platform capability tags***
Posted: 1 year ago
Posted: 1 year ago
Can you please find out from the BIX product team, if this is a possibility and whether Pega would support this? Thank you!
Posted: 1 year ago
As Nick has pointed out, BIX doesn't just extract the data - it also updates certain book-keeping tables with historical information. It uses this information when running subsequent extracts.
So, BIX working off a replica db is possible only if the dbuser that BIX is using, has insert/update permissions on these book-keeping tables.
Posted: 1 year ago
Any update on this request?
From an agent, I don't think so. But, if you run it from command line and point to the replica database... And assuming this replica database is an exact replica of master DB, it may work. The BIX command line process would need to be able to successfully start the engine using the data in the replica DB. You would just need to configure the command line process to point to the replica DB. One problem I can think of is that this will update tables in the replica database. For example, the extract will write to a table in order to track the last time the extract ran. If the DB user in use does not have permission to update tables, I'm not certain what the outcome would be.