AMOEBA+keepalive mysql高可用配置实例

最新推荐文章于 2021-01-18 19:43:03 发布

原创最新推荐文章于 2021-01-18 19:43:03 发布 · 219 阅读

0 ·

CC 4.0 BY-SA版权

本文介绍使用AMOEBA结合Keepalived实现MySQL读数据库负载均衡的方法。通过配置多个MySQL从库并利用AMOEBA进行连接池管理和负载策略设定，配合Keepalived保证服务高可用。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

keepalived结合AMOEBA对mysql的几台slave（读）数据库进行负载均衡，配置如下！

AMOEBA安装见：amoeba安装手册

MASTER 10.60.185.16

[root@blog conf]# cat dbServers.xml

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE amoeba:dbServers SYSTEM "dbserver.dtd">
<amoeba:dbServers xmlns:amoeba="http://amoeba.meidusa.com/">

<dbServer name="abstractServer" abstractive="true">
  <factoryConfig class="com.meidusa.amoeba.mysql.net.MysqlServerConnectionFactory">
   <property name="manager">${defaultManager}</property>
   <property name="sendBufferSize">64</property>
   <property name="receiveBufferSize">128</property>

   
   <property name="port">3306</property>

   
   <property name="schema">whole51_89ds8fa7f_new</property>

   
   <property name="user">chonggou_read</property>


   <property name="password">123456</property>

</factoryConfig>

<dbServer name="server1" parent="abstractServer">
  <factoryConfig>
   
   <property name="ipAddress">10.252.14.86</property>
  </factoryConfig>
</dbServer>

<dbServer name="server2" parent="abstractServer">
  <factoryConfig>
   
   <property name="ipAddress">10.252.14.87</property>
  </factoryConfig>
</dbServer>
  <dbServer name="server3" parent="abstractServer">
  <factoryConfig>
   
   <property name="ipAddress">10.252.14.88</property>
  </factoryConfig>
</dbServer>
  <dbServer name="server4" parent="abstractServer">
  <factoryConfig>
   
   <property name="ipAddress">10.60.185.14</property>
  </factoryConfig>
</dbServer>
  <dbServer name="server5" parent="abstractServer">
  <factoryConfig>
   
   <property name="ipAddress">10.60.185.15</property>
  </factoryConfig>
</dbServer>
<dbServer name="multiPool" virtual="true">
  <poolConfig class="com.meidusa.amoeba.server.MultipleServerPool">
   
   <property name="loadbalance">1</property>

   
   <property name="poolNames">server1,server2,server3,server4,server5</property>
  </poolConfig>
</dbServer>

</amoeba:dbServers>

[root@blog conf]# cat amoeba.xml
<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE amoeba:configuration SYSTEM "amoeba.dtd">
<amoeba:configuration xmlns:amoeba="http://amoeba.meidusa.com/">

<proxy>

  
  <service name="Amoeba for Mysql" class="com.meidusa.amoeba.net.ServerableConnectionManager">
   
   <property name="port">8066</property>

   

   <property name="ipAddress">10.60.185.20</property>


   <property name="manager">${clientConnectioneManager}</property>

   <property name="connectionFactory">
    <bean class="com.meidusa.amoeba.mysql.net.MysqlClientConnectionFactory">
     <property name="sendBufferSize">128</property>
     <property name="receiveBufferSize">64</property>
    </bean>
   </property>

   <property name="authenticator">
    <bean class="com.meidusa.amoeba.mysql.server.MysqlClientAuthenticator">

     <property name="user">chonggou_read</property>

     <property name="password">123456</property>

     <property name="filter">
      <bean class="com.meidusa.amoeba.server.IPAccessController">
       <property name="ipFile">${amoeba.home}/conf/access_list.conf</property>
      </bean>
     </property>
    </bean>
   </property>

  </service>

  
  <service name="Amoeba Monitor Server" class="com.meidusa.amoeba.monitor.MonitorServer">
   
   
   
   <property name="ipAddress">10.60.185.20</property>
   <property name="daemon">true</property>
   <property name="manager">${clientConnectioneManager}</property>
   <property name="connectionFactory">
    <bean class="com.meidusa.amoeba.monitor.net.MonitorClientConnectionFactory"></bean>
   </property>

  </service>

  <runtime class="com.meidusa.amoeba.mysql.context.MysqlRuntimeContext">
   
   <property name="readThreadPoolSize">20</property>

   
   <property name="clientSideThreadPoolSize">30</property>

   
   <property name="serverSideThreadPoolSize">30</property>

   
   <property name="statementCacheSize">500</property>

   
   <property name="queryTimeout">60</property>
  </runtime>

</proxy>


<connectionManagerList>
  <connectionManager name="clientConnectioneManager" class="com.meidusa.amoeba.net.MultiConnectionManagerWrapper">
   <property name="subManagerClassName">com.meidusa.amoeba.net.ConnectionManager</property>
   
  </connectionManager>
  <connectionManager name="defaultManager" class="com.meidusa.amoeba.net.MultiConnectionManagerWrapper">
   <property name="subManagerClassName">com.meidusa.amoeba.net.AuthingableConnectionManager</property>

   
  </connectionManager>
</connectionManagerList>

  
<dbServerLoader class="com.meidusa.amoeba.context.DBServerConfigFileLoader">
  <property name="configFile">${amoeba.home}/conf/dbServers.xml</property>
</dbServerLoader>

<queryRouter class="com.meidusa.amoeba.mysql.parser.MysqlQueryRouter">
  <property name="ruleLoader">
   <bean class="com.meidusa.amoeba.route.TableRuleFileLoader">
    <property name="ruleFile">${amoeba.home}/conf/rule.xml</property>
    <property name="functionFile">${amoeba.home}/conf/ruleFunctionMap.xml</property>
   </bean>
  </property>
  <property name="sqlFunctionFile">${amoeba.home}/conf/functionMap.xml</property>
  <property name="LRUMapSize">1500</property>
  <property name="defaultPool">multiPool</property>

<property name="readPool">multiPool</property>

[root@blog conf]# cat /etc/keepalived/keepalived.conf
global_defs {
notification_email {
153333333@qq.com
223333333@qq.com
}
notification_email_from keepalived@domain.com
smtp_server 127.0.0.1
smtp_connect_timeout 30
router_id LVS_DEVEL
}
vrrp_script chk_http_port {
script "/etc/keepalived/amoeba_vip.sh"
interval 2
weight 2
}
vrrp_instance VI_1 {
state MASTER
interface eth0
virtual_router_id 100
mcast_src_ip 10.60.185.16
priority 101
advert_int 1
authentication {
auth_type PASS
auth_pass 1111
}
track_script {
chk_http_port
}
virtual_ipaddress {
10.60.185.20
}
}

[root@blog conf]# cat /etc/keepalived/amoeba_vip.sh
#!/bin/bash
A=`ip a |grep 10.60.185.20 |awk '{print $2}'|awk -F/ '{print $1}'|wc -l`
if [ $A -eq 1 ];then
/usr/local/amoeba/bin/amoeba start > /dev/null 2>1&
echo `ps -efl |grep amoeba` >> /tmp/amoeba.txt
elif [ $A -eq 0 ];then
B=`ps -C java --no-header |awk '{print $1}'`
/bin/kill -9 $B
#/usr/local/amoeba/bin/amoeba stop
fi

Slave 10.60.185.13

dbServers.xml amoeba.xml同上

[root@wholesale-dress conf]# cat /etc/keepalived/keepalived.conf
global_defs {
notification_email {
1523333333@qq.com
2283333333@qq.com
}
notification_email_from keepalived@domain.com
smtp_server 127.0.0.1
smtp_connect_timeout 30
router_id LVS_DEVEL
}
vrrp_script chk_http_port {
script "/etc/keepalived/amoeba_vip.sh"
interval 2
weight 2
}
vrrp_instance VI_1 {
state BACKUP
interface eth0
virtual_router_id 100
mcast_src_ip 10.60.185.13
priority 99
advert_int 1
authentication {
auth_type PASS
auth_pass 1111
}
track_script {
chk_http_port
}
virtual_ipaddress {
10.60.185.20
}
}