amoeba mysql的安装配置实例

Amoeba是一个以MySQL为底层数据存储,并对应用提供MySQL协议接口的proxy,它集中地响应应用的请求,依据用户事先设置的规则,将SQL请求发送到特定的数据库上执行,下面我们来看看amoeba mysql的安装配置教程.

1、配置好mysql的主从环境,服务器如下,代码如下:

master:172.16.206.129

slave:172.16.206.130

amoeba:172.16.206.131

2、amoeba配置好JDK环境

可以去oracle的官网去下载JDK,安装目录一边不是标准的命名,使用如下命令做软连接:

ln -s /usr/java/jdk1.8.0_11/ /usr/java/jdk1.8

配置JDK环境:在/etc/profile文件末尾添加以下环境参数,代码如下:

export JAVA_HOME=/usr/java/jdk1.8

export PATH=$JAVA_HOME/bin:$JAVA_HOME/jre/bin:$PATH

PS:下载的JDK需要和平台对应，uname 可以查看平台类型

3、下载amoeba

网上搜索可以去一些开源软件的网站下载

4、安装amoeba

安装路径/usr/local/amoeba

5、修改amoeba配置参数.

/usr/local/amoeba/conf/amoeba.xml 修改如下:

1. <?xmlversion=”1.0″encoding=”gbk”?>
3. <!DOCTYPEamoeba:configurationSYSTEM“amoeba.dtd”>
4. <amoeba:configurationxmlns:amoeba=”http://amoeba.meidusa.com/”>
6. <proxy>
8. <!–serviceclassmustimplementscom.meidusa.amoeba.service.Service–>
9. <servicename=”AmoebaforMysql”class=”com.meidusa.amoeba.mysql.server.MySQLService”>
10. <!–portdefault–>
11. <propertyname=”port”>8066</property>
13. <!–bindipAddress–>
14. <!–salley修改绑定IP地址–>
15. <propertyname=”ipAddress”>172.16.206.129</property>
18. <propertyname=”connectionFactory”>
19. <beanclass=”com.meidusa.amoeba.mysql.net.MysqlClientConnectionFactory”>
20. <propertyname=”sendBufferSize”>128</property>
21. <propertyname=”receiveBufferSize”>64</property>
22. </bean>
23. </property>
25. <propertyname=”authenticateProvider”>
26. <beanclass=”com.meidusa.amoeba.mysql.server.MysqlClientAuthenticator”>
27. <!–访问amoeba的账户名–>
28. <propertyname=”user”>amoeba</property>
29. <!–访问amoeba的密码–>
30. <propertyname=”password”>123456</property>
32. <propertyname=”filter”>
33. <beanclass=”com.meidusa.toolkit.net.authenticate.server.IPAccessController”>
34. <propertyname=”ipFile”>${amoeba.home}/conf/access_list.conf</property>
35. </bean>
36. </property>
37. </bean>
38. </property>
40. </service>
42. <runtimeclass=”com.meidusa.amoeba.mysql.context.MysqlRuntimeContext”>
44. <!–proxyserverclientprocessthreadsize–>
45. <propertyname=”executeThreadSize”>128</property>
47. <!–perconnectioncachepreparedstatementsize–>
48. <propertyname=”statementCacheSize”>500</property>
50. <!–defaultcharset–>
51. <propertyname=”serverCharset”>utf8</property>
53. <!–querytimeout(default:60second,TimeUnit:second)–>
54. <propertyname=”queryTimeout”>60</property>
55. </runtime>
57. </proxy>
59. <!–
60. EachConnectionManagerwillstartasthread
61. managerresponsiblefortheConnectionIOread,DeathDetection
62. –>
63. <connectionManagerList>
64. <connectionManagername=”defaultManager”class=”com.meidusa.toolkit.net.MultiConnectionManagerWrapper”>
65. <propertyname=”subManagerClassName”>com.meidusa.toolkit.net.AuthingableConnectionManager</property>
66. </connectionManager>
67. </connectionManagerList>
69. <!–defaultusingfileloader–>
70. <dbServerLoaderclass=”com.meidusa.amoeba.context.DBServerConfigFileLoader”>
71. <propertyname=”configFile”>${amoeba.home}/conf/dbServers.xml</property>
72. </dbServerLoader>
74. <queryRouterclass=”com.meidusa.amoeba.mysql.parser.MysqlQueryRouter”>
75. <propertyname=”ruleLoader”>
76. <beanclass=”com.meidusa.amoeba.route.TableRuleFileLoader”>
77. <propertyname=”ruleFile”>${amoeba.home}/conf/rule.xml</property>
78. <propertyname=”functionFile”>${amoeba.home}/conf/ruleFunctionMap.xml</property>
79. </bean>
80. </property>
81. <propertyname=”sqlFunctionFile”>${amoeba.home}/conf/functionMap.xml</property>
82. <propertyname=”LRUMapSize”>1500</property>
83. <propertyname=”defaultPool”>master</property>
84. <propertyname=”writePool”>master</property>
85. <propertyname=”readPool”>multiPool</property>
86. <propertyname=”needParse”>true</property>
87. </queryRouter>
88. </amoeba:configuration>

/usr/local/amoeba/conf/dbServer.xml修改如下:

1. <?xmlversion=”1.0″encoding=”gbk”?>
3. <!DOCTYPEamoeba:dbServersSYSTEM“dbserver.dtd”>
4. <amoeba:dbServersxmlns:amoeba=”http://amoeba.meidusa.com/”>
6. <!–
7. EachdbServerneedstobeconfiguredintoaPool,
8. IfyouneedtoconfiguremultipledbServerwithloadbalancingthatcanbesimplifiedbythefollowingconfiguration:
9. addattributewithnamevirtual=“true”indbServer,buttheconfigurationdoesnotallowtheelementwithnamefactoryConfig
10. suchas‘multiPool’dbServer
11. –>
13. <dbServername=”abstractServer”abstractive=”true”>
14. <factoryConfigclass=”com.meidusa.amoeba.mysql.net.MysqlServerConnectionFactory”>
15. <propertyname=”connectionManager”>${defaultManager}</property>
16. <propertyname=”sendBufferSize”>64</property>
17. <propertyname=”receiveBufferSize”>128</property>
19. <!–mysqlport访问MySQL的端口号–>
20. <propertyname=”port”>3306</property>
22. <!–mysqlschema访问MySQL默认的数据库–>
23. <propertyname=”schema”>test</property>
25. <!–mysqluser访问MySQL的账户名–>
26. <propertyname=”user”>amoeba</property>
27. <!–mysqlpassword访问MySQL的密码–>
28. <propertyname=”password”>123456</property>
29. </factoryConfig>
31. <poolConfigclass=”com.meidusa.toolkit.common.poolable.PoolableObjectPool”>
32. <propertyname=”maxActive”>500</property>
33. <propertyname=”maxIdle”>500</property>
34. <propertyname=”minIdle”>1</property>
35. <propertyname=”minEvictableIdleTimeMillis”>600000</property>
36. <propertyname=”timeBetweenEvictionRunsMillis”>600000</property>
37. <propertyname=”testOnBorrow”>true</property>
38. <propertyname=”testOnReturn”>true</property>
39. <propertyname=”testWhileIdle”>true</property>
40. </poolConfig>
41. </dbServer>
43. <dbServername=”master”parent=”abstractServer”>
44. <factoryConfig>
45. <!–mysqlip–>
46. <propertyname=”ipAddress”>172.16.206.129</property>
47. </factoryConfig>
48. </dbServer>
50. <dbServername=”slave”parent=”abstractServer”>
51. <factoryConfig>
52. <!–mysqlip–>
53. <propertyname=”ipAddress”>172.16.206.130</property>
54. </factoryConfig>
55. </dbServer>
57. <dbServername=”multiPool”virtual=”true”>
58. <poolConfigclass=”com.meidusa.amoeba.server.MultipleServerPool”>
59. <!–Loadbalancingstrategy:1=ROUNDROBIN,2=WEIGHTBASED,3=HA–>
60. <propertyname=”loadbalance”>1</property>
62. <!–Separatedbycommas,suchas:server1,server2,server1–>
63. <propertyname=”poolNames”>master,slave,slave</property>
64. //开源代码phpfensi.com
65. </poolConfig>
66. </dbServer>
68. </amoeba:dbServers>

启动amoeba:/usr/local/amoeba/bin/launcher &

关闭amoeba:/usr/local/amoeba/bin/shutdown

amoeba不支持存储过程、不支持大数据量查询,这个比较讨厌,所以我最后还是没有用amoeba.