amoeba mysql_mysql中间件-amoeba

article/2025/9/13 13:18:50

中间件：一种提供在不同技术、不同的软件之间共享资源的程序，更大化了利用了数据库的性能，可以无限扩展(注：真实环境中并非如此)

数据库的中间件：

mysql proxy (官方版本)性能低，需要lua 脚本

atlas 性能低，响应时间长

amoeba 陈思儒研发

一、先搭建一个主从关系的服务器

在主、从服务器上安装mysql mysql-server

1. 开启二进制日志

[root@localhost ~]# vim /etc/my.cnf

...

log-bin=mysql-bin

server-id = 132...

[root@localhost ~]# vim /etc/my.cnf

...l

og-bin=mysql-bin

server-id = 134...

2. 在主服务器上授权，从服务器上保存授权信息，并开启从服务线程

mysql> grant replication slave on *.* to root@'192.168.80.134' identified by '123456';

mysql> show master status;

mysql>change master to-> master_user='root',-> master_password='123456',-> master_host='192.168.80.132',-> master_log_file='mysql-bin.000008',-> master_log_pos=260;

Query OK,0 rows affected (0.35sec)

mysql>start slave;

Query OK,0 rows affected (0.01sec)

mysql> show slave status\G;

二、配置读写分离

1. 安装 gcc 环境

[root@localhost ~]# yum -y install gcc*

2. 安装jdk

[root@localhost ~]# tar -zxvf jdk-8u231-linux-x64.tar.gz /amoeba/[root@localhost/amoeba]# ln -s jdk1.8.0_231/jdk

[root@localhost/amoeba]# vim /etc/profile

JAVA_HOME=/amoeba/jdk

export JAVA_HOME

PATH=$JAVA_HOME/bin:$PATH

export PATH

[root@localhost/amoeba]# source /etc/profile

3. 安装amoeba

[root@localhost ~]# wget https://jaist.dl.sourceforge.net/project/amoeba/Amoeba%20for%20mysql/3.x/amoeba-mysql-3.0.5-RC-distribution.zip

[root@localhost ~]# mkdir /amoeba

[root@localhost~]# unzip amoeba-mysql-3.0.5-RC-distribution.zip -d /amoeba

4. 配置amoeba

amoeba 的配置文件位于安装目录下的conf目录中，实现读写分离功能，只需修改两个配置文件，dbServers.xml和amoeba.xml。

[root@localhost /amoeba/amoeba-mysql-3.0.5-RC/conf]# cat dbServers.xml

${defaultManager}

128

3306　　#数据库端口

test　　#指定连接的数据库

root　　#登录使用的用户名

123456　　#登录使用的密码

500　　　　　　　　　　　#最大连接数

500　　　　　　　　　　#最大空闲连接数

1　　　　　　　　　　　#最下空闲连接数

600000

true

　　　　#改名字可任意命名，后续有用

192.168.80.132　　#数据库ip

192.168.80.134　　#数据库ip

　　　　#定义一个dbserver 组名

1　　　　#选择调度算法

server1　　#write组成员

server1,server2

[root@localhost /amoeba/amoeba-mysql-3.0.5-RC/conf]# catamoeba.xml<?xml version="1.0" encoding="gbk"?>

8066　　　　#amoeba监听端口，默认8066

192.168.80.133　　#amoeba安装地址

128

root　　#设置客户端连接amoeba所需的用户名和密码

123456

${amoeba.home}/conf/access_list.conf

128

500

utf8

com.meidusa.toolkit.net.AuthingableConnectionManager

${amoeba.home}/conf/dbServers.xml

${amoeba.home}/conf/rule.xml

${amoeba.home}/conf/ruleFunctionMap.xml

${amoeba.home}/conf/functionMap.xml

1500

write　　#设置amoeba默认池

write　　#设置amoeba 写池，默认注释

read　　　#设置amoeba读池，默认注释

true

5. 在主从服务器上授权

mysql> grant all on *.* to 'root'@'192.168.80.133' identified by '123456';Query OK, 0 rows affected (0.00 sec)

6. 修改jvm.properties

[root@localhost /amoeba/amoeba-mysql-3.0.5-RC]# vim jvm.properties

JVM_OPTIONS="-server -Xms1024m -Xmx1024m -Xss256k -XX:PermSize=16m -XX:MaxPermSize=96m"

7. 启动

[root@localhost /amoeba/amoeba-mysql-3.0.5-RC]# nohup bash +x /amoeba/amoeba-mysql-3.0.5-RC/bin/launcher &

[root@localhost /amoeba/amoeba-mysql-3.0.5-RC]# tail -f nohup.out2019-12-24 18:34:02,897 INFO context.MysqlRuntimeContext - Amoeba for Mysql current versoin=5.1.45-mysql-amoeba-proxy-3.0.4-BETA

log4j:WARN ip access config load completed fromfile:/amoeba/amoeba-mysql-3.0.5-RC/conf/access_list.conf2019-12-24 18:34:03,331 INFO net.ServerableConnectionManager - Server listening on /192.168.80.133:8066.

Java HotSpot(TM)64-Bit Server VM warning: ignoring option PermSize=16m; support was removed in 8.0Java HotSpot(TM)64-Bit Server VM warning: ignoring option MaxPermSize=96m; support was removed in 8.0

2019-12-24 18:59:15 [INFO] Project Name=Amoeba-MySQL, PID=7607, starting...

log4j:WARN log4j config load completed fromfile:/amoeba/amoeba-mysql-3.0.5-RC/conf/log4j.xml2019-12-24 18:59:16,333 INFO context.MysqlRuntimeContext - Amoeba for Mysql current versoin=5.1.45-mysql-amoeba-proxy-3.0.4-BETA

log4j:WARN ip access config load completed fromfile:/amoeba/amoeba-mysql-3.0.5-RC/conf/access_list.conf2019-12-24 18:59:16,669 INFO net.ServerableConnectionManager - Server listening on /192.168.80.133:8066.

[root@localhost ~]# netstat -antp |grep 8066tcp60 0 192.168.80.133:8066 :::* LISTEN 7607/java

[root@localhost ~]# firewall-cmd --zone=public --add-port=8066/tcp

[root@localhost~]# firewall-cmd --zone=public --add-port=8066/tcp --permanent

8. 测试

[root@localhost ~]# mysql -uroot -p123456 -P8066 -h192.168.80.133Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connectionid is 151281375Server version:5.1.45-mysql-amoeba-proxy-3.0.4-BETA Source distribution

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type'help;' or '\h' for help. Type '\c' to clearthe current input statement.

mysql>use test;

Database changed