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
URL:
Keywords:
Depends on: 142
Blocks:
  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:


Attachments

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:

https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-client-side-failover.html

The API docs for C++ mention similar capabilities:

https://dev.mysql.com/doc/dev/connector-cpp/8.0/group__xapi.html#ga875629dbda3145760cc5f59dc022520e

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:

https://commitfest.postgresql.org/12/879/

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