Modify .stat core services to add applicationintent=readonly for readonly SQL commands
The OECD SQL team proposed that the .stat-suite core could benefit from the SQL database replica architecture. Read-only operations could have a performance boost and avoid blocking write transactions by targeting the read-only replica of the database by including the attribute Application Intent Read-Only in the connection string.
Each time one of the .stat core services executes a SQL command, the connection settings should change dynamically to include or not the setting Application Intent Read-Only when the SQL comman is for read-only actions.
-
Each single command should be evaluated in all the .stat core services, and adjust accordingly. -
transfer-service -
nsiws -
auth-management
-
The difference with the related issue, is that in the Application Intent Read-Only is fixed for all connections at service level.
Technical notes
The issue should be addressed together with these tickets: