Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

As you can see, we appended the second SQL server after the original one "localhost" separated with a comma. Don't forget to also , e.g. "localhost,192.168.124.201"

In addition, you also need to set the failover property:

failOverReadOnly=false

(its default value was true), otherwise you will get an error "connection is read-only. Queries leading to data modification are not allowed". MS SQL and ORACLE have similar failover settings in their JDBC connection strings. In MS SQL, it is called "failoverPartner"

...