Read Replica Query

rimpsaccenture
Kilo Contributor

‎06-23-2019 06:43 PM

Read Replica Query

 

Read Replica Query

1.      1.  Can query on tables can be enforced to Read replica via setting category in query.

2.       2. If a function has multiple read operations and update operations to perform, what should be the approach can category (read replica) be set to all the read query irrespective of update operation

Example

Step 1: Read User table

Step 2:  Then update read user record in step 1 one by one.

Question:

In this case can category be set in step 1 to enforce read query to Read replica  

Labels:
  • 3,313 Views
1 REPLY 1

Adarsh Krishnam
ServiceNow Employee
ServiceNow Employee

‎05-04-2020 02:35 AM - edited ‎02-13-2023 08:45 AM

From the slow query module or from the debug SQL you have to capture the complete query and add that to sys_query_category.

 

Roughly RR works like this

SQL hash -> sys_query_category (hash ->category) -> sys_db_category_pool_mtom (db_category -> db_pool) -> sys_db_pool (sys_id)

 

This is Internal and only be accessed by NOW support to make any sort of changes.