虛IP解決程式連只讀伺服器故障漂移

2019 年 10 月 3 日
筆記

?????????????????AlWaysON?SQL 2012??? 1?4?? ???(8,14, 8.15) ?2???????????? ?????wms????????????IP????2???????2???????????????????????????????

?????

??????

?2??????????????????????????????????? ??????????IP??????????? ????????????????????????????????????????????????????????????????

?????

???????????????

1??????IP??IP??????????DNS??????

2??????MyCAT???????????????????

3????????????A10?????????

4?????SQL AlwaysON??????????????????????????

??????????????????????

1??????IP??????????????????????????????IP??????? ???????????????????????????????????????????? ??????

2?????????????????????????????????????????????????????? ??????

3???A10?????????????????? ??????

4???AlwaysON?????, ??????????????????????????????????????????????????????????????????? ??????

?????????????????????????2???????????????????????? ????????? ?????????????

??????????????????????????????????????????????

?????? ??????2????????????????????????????????? ?????????? ??????

?????????????????????????“????“????????

??????????MySQL????keepalived?MHA??MMM????????IP??CentOS????IP?????????????????Windows??????????IP?????8.15?????????????????IP

??????windows???IP???????IP?????????8.15?????8.15?IP??8.14?????????

??????

windows????????AlwaysON ????8.15??IP??8.14???????????

??????

?????8.15????????????????8.15?????????AlwaysON????IP?8.14?????

????????????????????

????????

?8.15? 8.14? ?2??????????????????????????????????AlwaysON?????IP?????????????????????????????????????????????

????????????????????????????????

??8.15?8.14???????????????????????????????IP????????????????????????????????????????

???

????????????????????????????????????????????