Handle case when Primary and Replica IP Addresses switch

[samhotep]

Problem

Sometimes, the backend database we are using switches IP addresses between the primary and one of the replicas. We should check whether the database is in read only mode, and if so, then select the actual primary from the list of databases before making a commit