Nginx + Keepalived, high available load balance

Server environment

1
2
3
4
5
6
7
8
$ cat /etc/issue
Ubuntu 14.04.5 LTS

$ nginx -v
nginx version: nginx/1.4.6 (Ubuntu)

$ apachectl -V
Server version: Apache/2.4.7 (Ubuntu)

Mysql5.7 MTS(multi-threaded slave)

Server environment

1
2
3
4
5
$ cat /etc/issue
Ubuntu 14.04.5 LTS

$ mysqld -V
mysqld Ver 5.7.20 for Linux on x86_64 (MySQL Community Server (GPL))

Build new mysql slave without stop service or locked table by Xtrabackup

Server environment

1
2
3
4
5
$ cat /etc/issue
Ubuntu 14.04.5 LTS

$ php -v
PHP 5.6.32-1+ubuntu14.04.1+deb.sury.org+2 (cli)

Mysql Slave Config With Docker

Server environment

1
2
3
4
5
6
7
8
9
10
11
12
$ cat /etc/issue
Ubuntu 14.04.5 LTS

$ docker -v
Docker version 1.6.2, build 7c8fca2

mysql> select version();
+------------+
| version() |
+------------+
| 5.7.12-log |
+------------+
Your browser is out-of-date!

Update your browser to view this website correctly. Update my browser now

×