ActiveMq如何配置持久化消息到MySql

1.下载
地址:http://activemq.apache.org/download.html
2.运行
1、解压apache-activemq-5.15.3-bin.zip
2、执行\bin\win64\activemq.bat脚本即可启动AMQ
3.修改配置文件持久化到Mysql数据库
1.找到conf/acitveMq.xml文件,开启编辑模式
修改

<!--
     Configure message persistence for the broker. The default persistence
     mechanism is the KahaDB store (identified by the kahaDB tag).
     For more information, see:
 
     http://activemq.apache.org/persistence.html
 -->
<persistenceAdapter>
    <!--<kahaDB directory="${activemq.data}/kahadb"/>-->
    <!-- 修改持久化方式为数据库-->
    <jdbcPersistenceAdapter dataSource="#mysql-ds"/>
</persistenceAdapter>

 1 <bean id="mysql-ds" class="org.apache.commons.dbcp2.BasicDataSource" destroy-method="close">
 2     <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
 3     <property name="url" value="jdbc:mysql://localhost:3306/db_activemq?relaxAutoCommit=true"/>
 4     <property name="username" value="root"/>
 5     <property name="password" value="root"/>
 6     <property name="poolPreparedStatements" value="true"/>
 7 </bean>
 8 
 9 <!--
10     Enable web consoles, REST and Ajax APIs and demos
11     The web consoles requires by default login, you can disable this in the jetty.xml file
12 
13     Take a look at ${ACTIVEMQ_HOME}/conf/jetty.xml for more details
14 -->
15 <import resource="jetty.xml"/>

4.引入Mysql包
复制mysql-connector-java-5.1.45.jar包到\lib\目录下
5.重新运行AMQ，数据库自动生成3张表
activemq_acks：用于存储订阅关系。如果是持久化Topic，订阅者和服务器的订阅关系在这个表保存
activemq_lock：在集群环境中才有用，只有一个Broker可以获得消息，称为Master Broker
activemq_msgs：用于存储消息，Queue和Topic都存储在这个表中