ActiveMq数据持久化进Mysql

最新推荐文章于 2021-08-05 19:41:07 发布

窦再兴

最新推荐文章于 2021-08-05 19:41:07 发布

阅读量194

点赞数

分类专栏：技术贴文章标签： mq activemq linux boot

本文链接：https://blog.csdn.net/qq_16116549/article/details/104808364

版权

技术贴专栏收录该内容

119 篇文章 8 订阅

订阅专栏

1.activeMq配置文件/usr/local/activemq/conf/activemq.xml 下方注意红色修改

<bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
 <property name="locations">
 <value>file:${activemq.conf}/credentials.properties</value>
 </property>
 </bean>

<bean id="logQuery" class="io.fabric8.insight.log.log4j.Log4jLogQuery"
 lazy-init="false" scope="singleton"
 init-method="start" destroy-method="stop">
 </bean>

<broker xmlns="http://activemq.apache.org/schema/core" brokerName="localhost" dataDirectory="${activemq.data}">

<destinationPolicy>
 <policyMap>
 <policyEntries>
 <policyEntry topic=">" >
 <!-- The constantPendingMessageLimitStrategy is used to prevent
 slow topic consumers to block producers and affect other consumers
 by limiting the number of messages that are retained
 For more information, see:

http://activemq.apache.org/slow-consumer-handling.html

-->
 <pendingMessageLimitStrategy>
 <constantPendingMessageLimitStrategy limit="1000"/>
 </pendingMessageLimitStrategy>
 </policyEntry>
 </policyEntries>
 </policyMap>
 </destinationPolicy>

<!--
 The managementContext is used to configure how ActiveMQ is exposed in
 JMX. By default, ActiveMQ uses the MBean server that is started by
 the JVM. For more information, see:

http://activemq.apache.org/jmx.html
 -->
 <managementContext>
 <managementContext createConnector="false"/>
 </managementContext>

<persistenceAdapter>
 <jdbcPersistenceAdapter dataDirectory="${activemq.data}" cleanupPeriod="0" dataSource="#mysql-ds" />
 </persistenceAdapter>

<systemUsage>
 <systemUsage>
 <memoryUsage>
 <memoryUsage percentOfJvmHeap="70" />
 </memoryUsage>
 <storeUsage>
 <storeUsage limit="100 gb"/>
 </storeUsage>
 <tempUsage>
 <tempUsage limit="50 gb"/>
 </tempUsage>
 </systemUsage>
 </systemUsage>

<transportConnectors>
 
 <transportConnector name="openwire" uri="tcp://douzi8:61616?maximumConnections=1000&wireFormat.maxFrameSize=104857600"/>
 <transportConnector name="amqp" uri="amqp://douzi8:5672?maximumConnections=1000&wireFormat.maxFrameSize=104857600"/>
 <transportConnector name="stomp" uri="stomp://douzi8:61613?maximumConnections=1000&wireFormat.maxFrameSize=104857600"/>
 <transportConnector name="mqtt" uri="mqtt://douzi8:1883?maximumConnections=1000&wireFormat.maxFrameSize=104857600"/>
 <transportConnector name="ws" uri="ws://douzi8:61614?maximumConnections=1000&wireFormat.maxFrameSize=104857600"/>
 </transportConnectors>

<shutdownHooks>
 <bean xmlns="http://www.springframework.org/schema/beans" class="org.apache.activemq.hooks.SpringContextHook" />
 </shutdownHooks>

</broker>

<bean id="mysql-ds" class="org.apache.commons.dbcp2.BasicDataSource" destroy-method="close">
 <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
 <property name="url" value="jdbc:mysql://localhost:3306/persistence_mq?relaxAutoCommit=true"/>
 <property name="username" value="root"/>
 <property name="password" value="123456"/>
 <property name="initialSize" value="5" />
 <property name="maxTotal" value="100" />
 <property name="maxIdle" value="30" />
 <property name="maxWaitMillis" value="10000" />
 <property name="minIdle" value="1" />
 </bean>
 <!--
 Enable web consoles, REST and Ajax APIs and demos
 The web consoles requires by default login, you can disable this in the jetty.xml file

Take a look at ${ACTIVEMQ_HOME}/conf/jetty.xml for more details
 -->
 <import resource="jetty.xml"/>

</beans>

2./usr/local/activemq/lib/ 下放mysql-connector-java-5.1.47.jar

3.mysql中建立persistence_mq数据库

4.执行程序，只发不接即可看到数据库activemq_msgs中存在数据了。

5.spring boot 项目使用

# activeMq配置
#spring.activemq.broker-url=failover:(tcp://douzi8:61616)
spring.activemq.broker-url=tcp://douzi8:61616
spring.activemq.user=admin
spring.activemq.password=admin
spring.activemq.in-memory=true
# true表示使用连接池
spring.activemq.pool.enabled=false
# 连接池最大连接数
spring.activemq.pool.max-connections=10
# 空闲的连接过期时间，默认为30秒
spring.activemq.pool.idle-timeout=30000
# 强制的连接过期时间，与idleTimeout的区别在于：idleTimeout是在连接空闲一段时间失效，而expiryTimeout不管当前连接的情况，只要达到指定时间就失效。默认为0，never
spring.activemq.pool.expiry-timeout=0
# 当有"JMSException"时尝试重新连接
spring.activemq.pool.reconnect-on-exception=true
# 在空闲连接清除线程之间运行的时间。当为负数时，没有空闲连接驱逐线程运行。
spring.activemq.pool.time-between-expiration-check=-1ms
# 是否只使用一个MessageProducer
#spring.activemq.pool.use-anonymous-producers=true

queue.sync=douzi-queue

import javax.jms.Queue;

import org.apache.activemq.ActiveMQConnectionFactory;
import org.apache.activemq.command.ActiveMQQueue;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.jms.annotation.EnableJms;
import org.springframework.jms.config.DefaultJmsListenerContainerFactory;
import org.springframework.jms.config.JmsListenerContainerFactory;

/**
* ActiveMQConfig Description: activemq配置
* @author douzi
* DATE 2020年3月10日上午10:27:22
*/
@Configuration
@EnableJms
public class ActiveMQConfig {
 @Value("${queue.sync}")
 private String syncQueue;
 @Value("${spring.activemq.user}")
 private String usrName;

@Value("${spring.activemq.password}")
private String password;

@Value("${spring.activemq.broker-url}")
private String brokerUrl;

    @Bean
    public Queue syncQueue(){
        return new ActiveMQQueue(syncQueue);
    }

    @Bean
    public ActiveMQConnectionFactory connectionFactory() {
        return new ActiveMQConnectionFactory(usrName, password, brokerUrl);
    }

@Bean
 public JmsListenerContainerFactory<?> jmsListenerContainerQueue(ActiveMQConnectionFactory connectionFactory){
 DefaultJmsListenerContainerFactory factory = new DefaultJmsListenerContainerFactory();
 factory.setPubSubDomain(false);
 factory.setConnectionFactory(connectionFactory);
 // 开启持久化
// factory.setSubscriptionDurable(true);
 return factory;
 }

@Bean
 public JmsListenerContainerFactory<?> jmsListenerContainerTopic(ActiveMQConnectionFactory connectionFactory){
 DefaultJmsListenerContainerFactory bean = new DefaultJmsListenerContainerFactory();
 //设置为发布订阅方式, 默认情况下使用的生产消费者方式
 bean.setPubSubDomain(true);
 bean.setConnectionFactory(connectionFactory);
 // 开启持久化
// bean.setSubscriptionDurable(true);
 return bean;
 }
}

生产者:

import java.util.Random;
import java.util.concurrent.ThreadPoolExecutor;
import java.util.stream.IntStream;

import javax.jms.Queue;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.CommandLineRunner;
import org.springframework.jms.core.JmsMessagingTemplate;
import org.springframework.stereotype.Component;

import com.wondertek.moms.common.utils.MyThreadPool;

import lombok.extern.slf4j.Slf4j;

@Slf4j
//@Component
public class ProducerTest implements CommandLineRunner {

@Autowired
private JmsMessagingTemplate jmsMessagingTemplate;

   @Autowired
   private Queue syncQueue;

   private final static Random r = new Random(System.currentTimeMillis());

   @Override
   public void run(String... args) throws Exception {
       log.info("Message was sent to the Queue");

for (int j = 0; j < 5; j++) {
 new Thread(() ->forData(), "t" + j).start();
 }
 }

 public void forData() {
 for (int i = 0; i < 10000; i++) {
 try {
 Thread.sleep(r.nextInt(100));
 } catch (InterruptedException e) {
 e.printStackTrace();
 }
 send("douzi " + Thread.currentThread().getName() + " " + i);
 }
 }

   public void send(String msg) {
       try {
           Thread.sleep(10);
       } catch (InterruptedException e) {
           e.printStackTrace();
       }
       this.jmsMessagingTemplate.convertAndSend(this.syncQueue, msg);
   }

}

消费者：

import org.springframework.jms.annotation.JmsListener;
import org.springframework.stereotype.Component;

import lombok.extern.slf4j.Slf4j;

//@Component
@Slf4j
public class ConsumerTest {

   @JmsListener(destination = "${queue.sync}")
   public void receiveQueue(String text) {
       log.info("------- 1:" + text);
   }

   @JmsListener(destination = "${queue.sync}")
   public void receiveQueue1(String text) {
       log.info("------- 2:" + text);
   }
}