レプリカ接続確認

• MySQL

(5.6)

select @@read_only;

• Oracle

(12cR1)

select database_role from v$database;

• PostgreSQL

(9.4)

select setting
from pg_settings
where name like 'transaction_read_only';

• SQL Server

(2019)

select is_primary_replica
from sys.dm_hadr_database_replica_states
where is_local = 1
;