Hello. I have initial config with 2 servers
+--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname | port | gtid_port | status | weight | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 1 | XXXX.1 | 3307 | 0 | ONLINE | 1 | 0 | 1000 | 10 | 0 | 0 | |
| 1 | XXXX.2 | 3307 | 0 | ONLINE | 1 | 0 | 1000 | 10 | 0 | 0 | |
+--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
select * from runtime_mysql_replication_hostgroups;
+------------------+------------------+------------+---------+
| writer_hostgroup | reader_hostgroup | check_type | comment |
+------------------+------------------+------------+---------+
| 1 | 2 | read_only | |
+------------------+------------------+------------+---------+
On server XXXX.2 i have read_only and now i see in runtime table
select * from runtime_mysql_servers;
+--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname | port | gtid_port | status | weight | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 1 | XXXX.1 | 3307 | 0 | ONLINE | 1 | 0 | 1000 | 10 | 0 | 0 | |
| 2 | XXXX.1 | 3307 | 0 | ONLINE | 1 | 0 | 1000 | 10 | 0 | 0 | |
| 2 | XXXX.2 | 3307 | 0 | ONLINE | 1 | 0 | 1000 | 10 | 0 | 0 | |
+--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
But after restart proxysql service i see only 2 records in runtime
select * from runtime_mysql_servers;
+--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname | port | gtid_port | status | weight | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 1 | XXXX.1 | 3307 | 0 | ONLINE | 1 | 0 | 1000 | 10 | 0 | 0 | |
| 2 | XXXX.2 | 3307 | 0 | ONLINE | 1 | 0 | 1000 | 10 | 0 | 0 | |
+--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
And it do not change in time.
But if i set read_only on server XXXX.1 for some seconds and remove it back - i see 3 servers in runtime again. And it do not change till next restart.