|
|
mysql -h controller -u keystone -pvic
. s5 O7 ^6 r- aERROR 2003 (HY000): Can't connect to MySQL server on 'controller' (111 "Connection refused")
+ Q+ o4 b' S1 c5 I) |& uERROR 2003 (HY000): Can't connect to MySQL server on 'controller' (111 "Connection refused")& o: V0 }5 \) y$ `. M! O4 s% t0 z
排查过程:
' R v1 h+ h3 Y0 f netstat -ntlp 先查看启动端口:
% k% f% L( c' Q' JActive Internet connections (only servers)
& B9 A8 N+ D5 L$ ?6 b2 v% sProto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
' t. Y, U2 x$ H. l# itcp 0 0 192.168.90.65:3306 0.0.0.0:* LISTEN 5760/mysqld
) m3 S# Z1 P9 P+ e2 C% P9 D$ rtcp 0 0 192.168.90.65:11211 0.0.0.0:* LISTEN 4894/memcached
/ Q7 ~, u- j8 A0 M查看域名解析:3 ^% ]/ t( |( T" R& a
cat /etc/hosts
' U( C5 q. r6 a5 k192.168.90.70 controller
6 C' s# _5 O, _6 A- L192.168.90.65 controller1
7 e0 B" u) X. ^" x8 j5 \192.168.90.68 compute1! Q8 i+ e( B* Z) P( y. V' E' w
. C5 a% T+ U8 e" K
偏偏这个时候的mysql 就连接不上,什么原因呢?公版的数据库用问题,这个地方设计不合理,郁闷的不行了。
% h: y" z* C* A( z7 L7 ?! O原来是因为我们配置了mysql中bind-address
: G, W/ e5 w* k$ E两个配置文件,一个是galer.cnf文件、另一个是mariadb-server.cnf 中注释掉这个/ r0 ]& l3 {) {8 V' K1 b0 E
#bind-address=192.168.90.65 - k6 k: @8 f6 F# H" h; _3 V
9 H0 p: A+ N2 E* J重启数据库,其他条件不变的情况下,
- `& _! {" f5 X* {/ X/ ~! emysql -h controller -u keystone -pvic 5 [' J, D8 B1 C- h
Welcome to the MariaDB monitor. Commands end with ; or \g.
$ d7 R7 c, W1 X+ f6 K! [, o, O- nYour MariaDB connection id is 8! O( {; r9 f3 u8 B6 G; [& q1 p/ H
Server version: 10.1.20-MariaDB MariaDB Server" u: J) S2 z% \# o7 |, c s
# T; D# L7 y; J5 @# T9 F; t
Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others., P/ `& \+ M! o* U1 K; U
9 e& z* v6 c; UType 'help;' or '\h' for help. Type '\c' to clear the current input statement.- _, w. L+ h& p$ i
7 E3 |, ]. h t) I4 n! d
MariaDB [(none)]>
H. L' u, b. V- Z& }# O% |, K: H1 x' K8 C8 m3 }
8 V# r- \6 @! c" o问题解决了,但是问题来了,如果我们装高可用版本怎么办,单独分配两台主机啥也不干,就只是提供haproxy和keepalived吗?这个资源耗损太大了吧。8 ?+ D9 z* W$ N, C
) h+ T9 u& w4 G. E: J) Y/ j% ? i8 z' H9 A H6 ?
! R8 h( N; B* Z: v. K7 k9 r4 R |
|