Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Investigate possible bug related to replication lag #475

Closed
renecannao opened this issue Feb 15, 2016 · 1 comment
Closed

Investigate possible bug related to replication lag #475

renecannao opened this issue Feb 15, 2016 · 1 comment
Assignees
Milestone

Comments

@renecannao
Copy link
Contributor

Investigate this output:

mysql> select hostgroup,srv_host,status from stats.stats_mysql_connection_pool;
+-----------+--------------+-------------------------+
| hostgroup | srv_host     | status                  |
+-----------+--------------+-------------------------+
| 1         | 172.30.4.169 | SHUNNED_REPLICATION_LAG |
| 1         | 172.30.4.171 | SHUNNED_REPLICATION_LAG |
| 1         | 172.30.4.169 | ONLINE                  |
| 1         | 172.30.4.171 | ONLINE                  |
| 0         | 172.30.4.36  | ONLINE                  |
+-----------+--------------+-------------------------+
@renecannao renecannao self-assigned this Feb 15, 2016
@renecannao renecannao added this to the Truls milestone Feb 15, 2016
@krzysztof-ksiazek
Copy link
Contributor

  1. UPDATE mysql_servers SET max_replication_lag=5; LOAD MYSQL SERVERS TO RUNTIME;
  2. Induce lag so nodes will be shunned
  3. while nodes are shunned, UPDATE mysql_servers SET max_replication_lag=0; LOAD MYSQL SERVERS TO RUNTIME;

This also seems to impact proxy's ability to lag-shun slaves which happened to be duplicated.

renecannao added a commit that referenced this issue Feb 16, 2016
This is MYSQL_SERVER_STATUS_SHUNNED_REPLICATION_LAG
Should fix issue #475
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants