activemq的JDBC Master Slave主从集群

master:

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

        <persistenceAdapter>
            <jdbcPersistenceAdapter dataSource="#mysql-ds" useDatabaseLock="true"/>
        </persistenceAdapter>

        <transportConnectors>
            <!-- DOS protection, limit concurrent connections to 1000 and frame size to 100MB -->
            <transportConnector name="openwire" uri="tcp://0.0.0.0:61619?maximumConnections=1000&wireFormat.maxFrameSize=104857600"/>
	</transportConnectors>

<bean id="mysql-ds" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
    <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
    <property name="url" value="jdbc:mysql://192.168.1.4:3306/BS?relaxAutoCommit=true"/>
    <property name="username" value="root"/>
    <property name="password" value="root"/>
    <property name="poolPreparedStatements" value="true"/>
</bean>

slave:

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

        <persistenceAdapter>
            <jdbcPersistenceAdapter dataSource="#mysql-ds" useDatabaseLock="false"/>
        </persistenceAdapter>

        <transportConnectors>
            <!-- DOS protection, limit concurrent connections to 1000 and frame size to 100MB -->
            <transportConnector name="openwire" uri="tcp://0.0.0.0:61617?maximumConnections=1000&wireFormat.maxFrameSize=104857600"/>
	</transportConnectors>

<bean id="mysql-ds" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
    <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
    <property name="url" value="jdbc:mysql://192.168.1.4:3306/BS?relaxAutoCommit=true"/>
    <property name="username" value="root"/>
    <property name="password" value="root"/>
    <property name="poolPreparedStatements" value="true"/>
</bean>

代码访问：

        ConnectionFactory connectionFactory;
        Connection connection = null;
        Session session;
        Destination destination;
        MessageProducer producer;
        //connectionFactory = new ActiveMQConnectionFactory(ActiveMQConnection.DEFAULT_USER, ActiveMQConnection.DEFAULT_PASSWORD, "tcp://192.168.1.9:61616");
        connectionFactory = new ActiveMQConnectionFactory("system", "manager", "failover:(tcp://192.168.1.9:61619,tcp://192.168.1.9:61617)");
        try {
            connection = connectionFactory.createConnection();
            connection.start();
            session = connection.createSession(Boolean.TRUE, Session.AUTO_ACKNOWLEDGE);
            destination = session.createQueue("xxxx");
            producer = session.createProducer(destination);
            producer.setDeliveryMode(DeliveryMode.PERSISTENT);
            sendMessage(session, producer);
            session.commit();
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            try {
                if (null != connection)
                    connection.close();
            } catch (Throwable ignore) {}
        }

注意点：

1.把 createTablesOnStartup="false" 改成 createTablesOnStartup="true" 这样activemq就会自己去创建表,表创建成功，一共三个，分别是ACTIVEMQ_ACKS、ACTIVEMQ_LOCK、ACTIVEMQ_MSGS。其中ACTIVEMQ_MSGS是存放代销费消息

2.useDatabaseLock="true"独占服务器,主服务与数据库建立连接后，从服务器就阻断在链接数据库的环节，直到主服务与数据库连接中断，从服务器就会接替主服务工作与数据库建立连接