Bug 141 - support for MySQL server failover redundancy
Summary: support for MySQL server failover redundancy
Status: NEW
Alias: None
Product: repro
Classification: Unclassified
Component: proxy (show other bugs)
Version: unspecified
Hardware: All All
: P1 enhancement
Assignee: Owner of all unassigned bugs
Depends on: 142
  Show dependency treegraph
Reported: 2019-01-15 17:40 CST by Daniel Pocock
Modified: 2019-01-15 17:50 CST (History)
0 users

See Also:


Note You need to log in before you can comment on or make changes to this bug.
Description Daniel Pocock 2019-01-15 17:40:27 CST
The current MySQL implementation uses the basic C API

The newer C++ API (MySQL X DevAPI) appears to support automatic failover, reconnecting to alternative MySQL servers.

The Java connector documentation gives a URL example:


The API docs for C++ mention similar capabilities:


In particular, look for MYSQLX_OPT_PRIORITY
Comment 1 Daniel Pocock 2019-01-15 17:50:31 CST
It looks like libpq supports this since 2016:


so PostgreSQL users may be able to do this already.  Changing from MySQL to PostgreSQL might be a suitable workaround for some users.