Support of Cluster MySQL connections (Read & Write Ports)

Is your feature request related to a problem? Please describe.

We have slowness issues depending on which locaiton our primary database lives in. We use a database cluster and have multiple sites and multiple databases. Depending on where we run Phpmyadmin, if the Primary database is in another location, queries are much slower.

Describe the solution you'd like

We'd like to ask that PhpMyAdmin starts to support a read and a write "Port" instead of a single "Port". This would make use of MySQL's "router" application that sends the "Reads" to a secondary MySQL instead of sending all queries to the Primary. And only the "Writes" over the "Write Port" would be sent to the Primary database for inserting, updating and deleting.

Settings would look something like:

$cfg['Servers'][$i]['read-port'] <-- All Select queries
$cfg['Servers'][$i]['write-port'] or write's could just use the default: $cfg['Servers'][$i]['port'] <-- All Insert, Update & Delete

MySQL Router install page for reference with the read and write ports: https://dev.mysql.com/doc/mysql-installer/en/mysql-installer-workflow-nonserver-products.html

Describe alternatives you've considered

I haven't found another solution

Start by tracing how the existing single $cfg['Servers'][$i]['port'] connection setting is used for query execution. Review the linked MySQL Router documentation and determine how read versus write routing would affect SELECT, INSERT, UPDATE, and DELETE operations. Done means defining and implementing a safe configuration and routing design, with coverage for both ports.