一个轻量级 读写分离 的技术组件，基于Mybatis-3.4.2 + 插件技术 + Druid-1.0.29 + mysql-connector-java-5.1.41。

产品简介

1)设置数据源格式

<property name="url"
                    value="jdbc:mysql://{1.1.1.1:3306,2.2.2.2:3306,3.3.3.3:3306}/ambari?zeroDateTimeBehavior=convertToNull" />

第1个IP:Port为master,剩下的是slave

2)读写规则

2.1）开启事务--->走master

2.2) 未开启事务

2.2.1)增/修/删 --->走master

2.2.2)查询,指定hint /FORCE_MASTER/ --->走master

2.2.3)查询，未指定hint ---> 走slave,轮询每个slave,取第1个可用的connection

代码片段

1)事务片段

package transaction;

import org.apache.ibatis.session.SqlSession;
import com.freedom.mysql.myrwsplit.bean.Role;
import com.freedom.mysql.myrwsplit.helper.LoggerHelper;
import com.freedom.mysql.myrwsplit.interfaces.RoleMapper;
import com.freedom.mysql.myrwsplit.runnable.MyRwSplitTransactionRunnable;

public class MyRwSplitWithTransactionAdvanced {
    private static LoggerHelper LOGGER = LoggerHelper.getLogger(MyRwSplitWithTransactionAdvanced.class);

    public static void main(String[] args) {
        // 初始化时，请设定你需要的参数，比如:Executor类型,是否自动提交,事务级别
        Role result = new MyRwSplitTransactionRunnable<Role>() {
            @Override
            public Role execute(SqlSession sqlSession) {
                // 从这里,开始写任何你需要的的业务代码,
                // 处于一个事务里，事务相关的东西，业务不需要关心,框架已经做好了
                RoleMapper userMapper = sqlSession.getMapper(RoleMapper.class);// 获得mapper
                // delete
                Role role = new Role();
                role.setId(13);
                userMapper.deleteRole(role);
                // insert
                role.setId(13);
                role.setTitle("xxx");
                role.setAuthor("yyy");
                userMapper.insertRole(role);
                // select
                role = userMapper.getRole0(11);
                return role;
            }
        }.run();
        //
        LOGGER.debug("" + result);
    }
}

2)非事务片段

package notransaction;

import com.freedom.mysql.myrwsplit.bean.Role;
import com.freedom.mysql.myrwsplit.helper.LoggerHelper;
import com.freedom.mysql.myrwsplit.helper.MapperUtils;
import com.freedom.mysql.myrwsplit.interfaces.RoleMapper;

public class MyRwSplitWithNoTransactionAdvanced {
    @SuppressWarnings("unused")
    private static LoggerHelper LOGGER = LoggerHelper.getLogger(MyRwSplitWithNoTransactionAdvanced.class);

    // 在读写分离的情况下，必须重新获取mapper,才可以支持每次操作都重新判断来决定从master/slave来获取新的连接
    // 如果连续运行就会报错
    public static void main(String[] args) {
        //
        RoleMapper mapper = MapperUtils.getMapper(RoleMapper.class);
        Role role = mapper.getRole0(13);

        //
        mapper = MapperUtils.getMapper(RoleMapper.class);
        role = new Role();
        role.setAuthor("xxx");
        role.setTitle("yyy");
        mapper.insertRole(role);

    }
}