负载均衡的mariadb集群搭建[转]

2. 添加mariadb用户和组

  groupadd mariadb
  useradd -g mariadb mariadb

4. 解压并拷贝解压后的文件到/usr/local/mysql下

   root@ubuntu:/usr/src# tar -zxvf mariadb-galera-10.0.17-linux-x86_64.tar.gz
   root@ubuntu:/usr/local# cp -R mariadb-galera-10.0.17-linux-x86_64 /usr/local/mysql

   log-bin=mysql-bin
binlog_format = ROW
server-id       = 1
innodb_autoinc_lock_mode = 2
wsrep_provider = /usr/local/mysql/lib/libgalera_smm.so
wsrep_cluster_name = "my_mariadb_cluster"
wsrep_cluster_address="gcomm://"
wsrep_node_name = "cluster_node1"
wsrep_node_address = 127.0.0.1:4406

log-bin=mysql-bin
binlog_format = ROW
datadir = /usr/local/mysql/data1
server-id   = 2
innodb_autoinc_lock_mode = 2
wsrep_provider = /usr/local/mysql/lib/libgalera_smm.so
wsrep_cluster_name = "my_mariadb_cluster"
wsrep_cluster_address="gcomm://127.0.0.1:4406"
wsrep_node_name = "cluster_node2"
wsrep_node_address = 127.0.0.1:4407

    log-bin=mysql-bin
binlog_format = ROW
datadir = /usr/local/mysql/data2
server-id  = 3
innodb_autoinc_lock_mode = 2
wsrep_provider = /usr/local/mysql/lib/libgalera_smm.so
wsrep_cluster_name = "my_mariadb_cluster"
wsrep_cluster_address="gcomm://127.0.0.1:4407"
wsrep_node_name = "cluster_node3"
wsrep_node_address = 127.0.0.1:4408

./bin/mysql --host 127.0.0.1 --port 3306 -umycluster -p12345
MariaDB [test]> select * from goods;
+----+---------+
| id | name    |
+----+---------+
|  1 | iphone7 |
+----+---------+

global
        log            127.0.0.1        local0
        log            127.0.0.1        local1 notice
        #log loghost    local0 info
        maxconn         4096
        user            haproxy      #所属运行的用户
        group           haproxy      #所属运行的组
        nbproc          1
        pidfile         /usr/local/haproxy/haproxy1.pid
        #debug
        #quiet
 
defaults
        log            global
        option         tcplog
        option         dontlognull
        retries         3
        option          redispatch
        maxconn         4096
        timeout         connect  50000ms
        timeout         client   50000ms
        timeout         server   50000ms
 
listen  mariadb-galera
        bind 127.0.0.1:3399  #客户端监听端口
        mode tcp
        balance  leastconn  #最少连接的负载均衡算法
        server   db1  127.0.0.1:3306 check
        server   db1  127.0.0.1:3307 check
        server   db1  127.0.0.1:3308 check

查看更多关于负载均衡的mariadb集群搭建[转]的详细内容...