CODEWITHSUNDEEP
mysqlsequelize.jsgoogle-cloud-sqlfailoverautomatic-failover
Bradley Kovacs
Bradley Kovacs

Reputation: 119

Sequelize connecting to fail over write replica

I am using Sequelize 4.38.0. After reading the docs, I have setup a master write database with 2 read replicas. I am trying to add a fail over for the master write database for high availability. Does sequelize support this? Within the config options, in 'replications' you can pass an array of hosts to read, but not to write =\

Upvotes: 1

Views: 541

Answers (1)

Vadim
Vadim

Reputation: 5126

In Cloud SQL, the failover replica automatically replicates from the master and remains read only until a failover is needed. After a failover, the failover replica becomes the master and starts accepting writes. From the application's point of you, it's connecting to the same IP address.

Upvotes: 0

Related Questions