# 登录mysql Slave 服务器
[root@localhost ~]# mysql -uroot -p
Enter password:

# 执行同步SQL语句
mysql> change master to master_host='192.168.10.233',master_user='root',master_password='shopex123',master_log_file='mysql-bin.000001',master_log_pos=640;
Query OK, 0 rows affected (0.03 sec)

# 启动同步进程
mysql> start slave;
Query OK, 0 rows affected (0.00 sec)

# 主从同步检查
mysql> show slave status\G
*************************** 1. row ***************************
               Slave_IO_State: Waiting for master to send event
                  Master_Host: 192.168.10.233
                  Master_User: root
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: mysql-bin.000001
          Read_Master_Log_Pos: 640
               Relay_Log_File: localhost-relay-bin.000002
                Relay_Log_Pos: 283
        Relay_Master_Log_File: mysql-bin.000001
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes
              Replicate_Do_DB:
          Replicate_Ignore_DB:
           Replicate_Do_Table:
       Replicate_Ignore_Table:
      Replicate_Wild_Do_Table:
  Replicate_Wild_Ignore_Table:
                   Last_Errno: 0
                   Last_Error:
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 640
              Relay_Log_Space: 460
              Until_Condition: None
               Until_Log_File:
                Until_Log_Pos: 0
           Master_SSL_Allowed: No
           Master_SSL_CA_File:
           Master_SSL_CA_Path:
              Master_SSL_Cert:
            Master_SSL_Cipher:
               Master_SSL_Key:
        Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 0
                Last_IO_Error:
               Last_SQL_Errno: 0
               Last_SQL_Error:
  Replicate_Ignore_Server_Ids:
             Master_Server_Id: 1
                  Master_UUID: 4bbab569-4cb1-11e6-86f5-d4bed9a810af
             Master_Info_File: /data/mysql/3306/master.info
                    SQL_Delay: 0
          SQL_Remaining_Delay: NULL
      Slave_SQL_Running_State: Slave has read all relay log; waiting for the slave I/O thread to update it
           Master_Retry_Count: 86400
                  Master_Bind:
      Last_IO_Error_Timestamp:
     Last_SQL_Error_Timestamp:
               Master_SSL_Crl:
           Master_SSL_Crlpath:
           Retrieved_Gtid_Set:
            Executed_Gtid_Set:
                Auto_Position: 0
1 row in set (0.00 sec)
# 可以看到：Slave_IO_Running | Slave_SQL_Running两个值都是YES，说明配置成功了

# 主服务器Mysql，建立数据库，并在这个库中建表插入一条数据
mysql> create database test_db;
Query OK, 1 row affected (0.00 sec)

mysql> use test_db;
Database changed

mysql>  create table test_tb(id int(3),name char(10));
Query OK, 0 rows affected (0.00 sec)

mysql> insert into test_tb values(001,'test');
Query OK, 1 row affected (0.00 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| test_db                |
| mysql                |
| test                 |
+--------------------+
4 rows in set (0.00 sec)

# 从服务器查看
mysql>  show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| test               |
| test_db            |
+--------------------+
5 rows in set (0.00 sec)

mysql> use test_db;
Database changed

mysql> show tables;
+-------------------+
| Tables_in_test_db |
+-------------------+
| test_tb           |
+-------------------+
1 row in set (0.00 sec)

mysql> select * from test_tb;
+------+------+
| id   | name |
+------+------+
|    1 | test |
+------+------+
1 row in set (0.00 sec)

GRANT ALL PRIVILEGES  ON *.* to 'root'@'192.168.10.229' identified by 'shopex123';

/*
|--------------------------------------------------------------------------
| Database Connections
|--------------------------------------------------------------------------
|
| Here are each of the database connections setup for your application.
| Of course, examples of configuring each database platform that is
| supported by Laravel is shown below to make development simple.
|
|
| All database work in Laravel is done through the PHP PDO facilities
| so make sure you have the driver for your particular database of
| choice installed on your machine before you begin development.
| 对应原系统: DB_*
|
*/

'connections' => array(
    #'default' => array(
    #    'driver'    => 'mysqli',
    #    'host'      => '192.168.10.233',
    #    'dbname'  => 'b2b2c',
    #    'user'  => 'root',
    #    'password'  => 'shopex123',
    #    'charset'   => 'utf8',
    #    //'collation' => 'utf8_general_ci',
    #),
    'default' => array(
        'master' => array('user' => 'root', 'password' => 'shopex123', 'host' => '192.168.10.233', 'dbname' => 'b2b2c','charset'   => 'utf8'),
        'slaves' => array(
            array('user' => 'root', 'password'=>'shopex123', 'host' => '192.168.10.234', 'dbname' => 'b2b2c','charset'   => 'utf8'),
         ),
        'driver'    => 'mysqli',
    ),
),

yum install wget -y
cd /etc/yum.repos.d/
wget http://mirrors.shopex.cn/shopex/shopex-lnmp/shopex-lnmp.repo
yum install epel-release -y

yum install redis -y

vim /etc/redis.conf
注释掉绑定127.0.0.1的访问，则所有局域网都能访问
#bind 127.0.0.1

/etc/init.d/redis start

yum install wget -y
cd /etc/yum.repos.d/
wget http://mirrors.shopex.cn/shopex/shopex-lnmp/shopex-lnmp.repo
yum install epel-release -y

yum install memcached -y

配置文件位置/etc/sysconfig/memcached
可以修改内存大小等配置

/etc/init.d/memcached start

cd /etc/yum.repos.d/
wget http://mirrors.shopex.cn/shopex/shopex-lnmp/shopex-lnmp.repo

yum install epel-release -y

yum install nfs-utils -y

#根据Centos选择安装
yum install portmap -y #（适用centos 5）
yum install rpcbind -y #（适用centos 6）

/etc/init.d/rpcbind start
/etc/init.d/nfs start

yum install ngx_openresty -y

scp -r /data/httpd/public/themes/ root@192.168.10.232:/data/httpd/
scp -r /data/httpd/public/images/ root@192.168.10.232:/data/httpd/
scp -r /data/httpd/public/app/ root@192.168.10.232:/data/httpd/

#可以使用*不限制挂载机器
#/data/httpd/themes  *(rw,sync,all_squash,anonuid=502,anongid=502)

/data/httpd/themes  192.168.10.229/24(rw,sync,all_squash,anonuid=502,anongid=502)
/data/httpd/images  192.168.10.229/24(rw,sync,all_squash,anonuid=502,anongid=502)
/data/httpd/app     192.168.10.229/24(rw,sync,all_squash,anonuid=502,anongid=502)

showmount -e 192.168.10.232
Export list for 192.168.10.232:
/data/httpd/app    192.168.10.229/24
/data/httpd/images 192.168.10.229/24
/data/httpd/themes 192.168.10.229/24

mount 192.168.10.232:/data/httpd/themes /data/httpd/public/themes
mount 192.168.10.232:/data/httpd/images /data/httpd/public/images
mount 192.168.10.232:/data/httpd/app    /data/httpd/public/app

vim /usr/local/nginx/conf/vhosts/default.conf

server {
    ...
    #在server中新增如果下配置
    location ~* \.(eot|ttf|woff)$ {
        add_header Access-Control-Allow-Origin *;
    }
    ...
}

新增 AddType

vim /usr/local/nginx/conf/mime.types

font/ttf                              ttf;
font/otf                              otf;

   /*
    |--------------------------------------------------------------------------
    | 静态资源映象站地址(js css)
    |--------------------------------------------------------------------------
    |
    | 资源映像站地址
    |
    */
    'host_mirrors' => array(
        'http://192.168.10.232',
        //'http://img2.example.com',
    ),

    /*
    |--------------------------------------------------------------------------
    | 图片映象站地址
    |--------------------------------------------------------------------------
    |
    | 图片资源映像站地址
    | 一个域名标识对应一个域名，在替换的时候域名的时候替换对应的值就可以了
    | 图片域名标识不可变，添加后慎重删除，除非确保改标识下不存在图片了
    | 如果未配置则默认使用 defaultHostMirrors 作为图片标识
    */
    'host_mirrors_img' => [
        'img0'=>'http://192.168.10.232',
        //'img1'=>'http://img2.example.com',
    ],

yum install haproxy -y

vim /etc/haproxy/haproxy.cfg(此配置不分前后台)
#以下为配置内容，根据实际情况调整

global
    log         127.0.0.1 local3
    chroot      /var/lib/haproxy
    pidfile     /var/run/haproxy.pid
    maxconn     30000
    user        haproxy
    group       haproxy
    daemon

    stats socket /var/lib/haproxy/stats

defaults
    option http-keep-alive
    mode                    http
    log                     global
    option                  httplog
    option                  dontlognull
    option accept-invalid-http-request
    option http-server-close
    option                  redispatch
    retries                 3
    timeout http-request    60s
    timeout queue           1m
    timeout http-keep-alive 60s
    timeout connect 60s
    timeout client 1m
    timeout server 1m
    timeout check 2000
    maxconn                 30000
    stats enable
    stats uri /shopexadminss
    stats auth admin:r4b7x3m7vVN3
frontend  main *:80
    default_backend             app

backend static
    balance     roundrobin
    server      static 192.168.10.229:80 check


backend app
    balance     roundrobin
    mode http
    cookie SERVERID insert nocache indirect
    server web1 192.168.10.229:80  check inter 1500 rise 1 fall 3 weight 1
    server web2 192.168.10.230:80  check inter 1500 rise 1 fall 3 weight 1
    server web3 192.168.10.231:80  check inter 1500 rise 1 fall 3 weight 1

/etc/init.d/haproxy start