Question
4
Replies
118
Views
Posted: January 18, 2019
Last activity: July 26, 2019
Closed
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***
Moderation Team has archived post,
Close popover
This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 2 years 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.
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.