peterpan104

Hi svaroqui Thank you for your quick response, proxy-servers-read-on-master=true helped me, but I still have the following issues that need assistance: Q1: When I initially start repman, I can perform...

hi ahfa92 Thank you for your reply. I think the max_replication_lag and weight settings for the writer hostgroup are not really important, as there will only be one machine. However,...

hi @ahfa92 Thank you for your patient response! The following shows my operation process and the status of proxysql. Q1:The results I get when performing maintenance on the master during...

hi @svaroqui I want to implement read-write separation through the weight parameter in mysql_servers, so that most SELECT queries will go to the slave, and only when the slave is...

Hi @ahfa92 Thank you for the reply. I think when repman operates maintenance, it should only update the status of mysql_servers without modifying other places. In this way, whether repman...

hi @ahfa92 ``` func (psql *ProxySQL) SetOfflineSoft(host string, port string) error { sql := fmt.Sprintf("UPDATE mysql_servers SET status='OFFLINE_SOFT', hostgroup_id='%s' WHERE hostname='%s' AND port='%s' AND hostgroup_id in ('%s','%s')", psql.ReaderHG, host, port,...

Hi @ahfa92 The following is a more detailed proxysql log,I'm happy to provide more information if needed. ## after HA,set the master maintenance ``` 2024-04-29 13:36:35 [INFO] Received LOAD MYSQL...

Normally, there aren't many chances to perform maintenance on the master, but I have to consider every possible scenario. The main issue now is that before triggering HA, no matter...

I'm glad this issue will be fixed. Thank you again for both of your reply!

hi @ahfa92 The issues mentioned above have not been resolved yet, and there will be the following errors after upgrading repman: ``` ERROR Failed to parse binary log datetime string....