【攻城小组】读写分离改造上线计划

标签： +

1.10月12日组织所有人修改的代码指向master并且提交所有fisheye，并完成stage环境的配置文件修改和代码审查

日期	发版人	发版项目	需要新增的配置
10月15日	何泉	user-notification-center	spring.datasource.slave.type=com.alibaba.druid.pool.DruidDataSource spring.datasource.slave.driverClassName=com.mysql.jdbc.Driver spring.datasource.slave.url= spring.datasource.slave.username= spring.datasource.slave.password= spring.datasource.slave.filters=stat spring.datasource.slave.maxActive=20 spring.datasource.slave.initialSize=10 spring.datasource.slave.maxWait=60000 spring.datasource.slave.minIdle=1 spring.datasource.slave.timeBetweenEvictionRunsMillis=60000 spring.datasource.slave.minEvictableIdleTimeMillis=300000 spring.datasource.slave.testWhileIdle=true spring.datasource.slave.testOnBorrow=true spring.datasource.slave.testOnReturn=false spring.datasource.slave.poolPreparedStatements=true spring.datasource.slave.maxOpenPreparedStatements=20 spring.datasource.slave.validationQuery=SELECT 1
	张洁	vis-account-center	spring.datasource.slave.type=com.alibaba.druid.pool.DruidDataSource spring.datasource.slave.driverClassName=com.mysql.jdbc.Driver spring.datasource.slave.url= spring.datasource.slave.username= spring.datasource.slave.password= spring.datasource.slave.filters=stat spring.datasource.slave.maxActive=20 spring.datasource.slave.initialSize=10 spring.datasource.slave.maxWait=60000 spring.datasource.slave.minIdle=1 spring.datasource.slave.timeBetweenEvictionRunsMillis=60000 spring.datasource.slave.minEvictableIdleTimeMillis=300000 spring.datasource.slave.testWhileIdle=true spring.datasource.slave.testOnBorrow=true spring.datasource.slave.testOnReturn=false spring.datasource.slave.poolPreparedStatements=true spring.datasource.slave.maxOpenPreparedStatements=20 spring.datasource.slave.validationQuery=SELECT 1
	王树雨	enterprise-wechat-center	spring.datasource.slave.type=com.alibaba.druid.pool.DruidDataSource spring.datasource.slave.driverClassName=com.mysql.jdbc.Driver spring.datasource.slave.url= spring.datasource.slave.username= spring.datasource.slave.password= spring.datasource.slave.filters=stat spring.datasource.slave.maxActive=20 spring.datasource.slave.initialSize=10 spring.datasource.slave.maxWait=60000 spring.datasource.slave.minIdle=1 spring.datasource.slave.timeBetweenEvictionRunsMillis=60000 spring.datasource.slave.minEvictableIdleTimeMillis=300000 spring.datasource.slave.testWhileIdle=true spring.datasource.slave.testOnBorrow=true spring.datasource.slave.testOnReturn=false spring.datasource.slave.poolPreparedStatements=true spring.datasource.slave.maxOpenPreparedStatements=20 spring.datasource.slave.validationQuery=SELECT 1 spring.datasource.master.type=com.alibaba.druid.pool.DruidDataSource spring.datasource.master.driverClassName=com.mysql.jdbc.Driver spring.datasource.master.url= spring.datasource.master.username= spring.datasource.master.password= spring.datasource.master.filters=stat spring.datasource.master.maxActive=20 spring.datasource.master.initialSize=10 spring.datasource.master.maxWait=60000 spring.datasource.master.minIdle=1 spring.datasource.master.timeBetweenEvictionRunsMillis=60000 spring.datasource.master.minEvictableIdleTimeMillis=300000 spring.datasource.master.testWhileIdle=true spring.datasource.master.testOnBorrow=true spring.datasource.master.testOnReturn=false spring.datasource.master.poolPreparedStatements=true spring.datasource.master.maxOpenPreparedStatements=20 spring.datasource.master.validationQuery=SELECT 1 原连接池配置可删除
	王树雨	employee-center	spring.datasource.slave.type=com.alibaba.druid.pool.DruidDataSource spring.datasource.slave.driverClassName=com.mysql.jdbc.Driver spring.datasource.slave.url= spring.datasource.slave.username= spring.datasource.slave.password= spring.datasource.slave.filters=stat spring.datasource.slave.maxActive=20 spring.datasource.slave.initialSize=10 spring.datasource.slave.maxWait=60000 spring.datasource.slave.minIdle=1 spring.datasource.slave.timeBetweenEvictionRunsMillis=60000 spring.datasource.slave.minEvictableIdleTimeMillis=300000 spring.datasource.slave.testWhileIdle=true spring.datasource.slave.testOnBorrow=true spring.datasource.slave.testOnReturn=false spring.datasource.slave.poolPreparedStatements=true spring.datasource.slave.maxOpenPreparedStatements=20 spring.datasource.slave.validationQuery=SELECT 1 spring.datasource.master.type=com.alibaba.druid.pool.DruidDataSource spring.datasource.master.driverClassName=com.mysql.jdbc.Driver spring.datasource.master.url= spring.datasource.master.username= spring.datasource.master.password= spring.datasource.master.filters=stat spring.datasource.master.maxActive=20 spring.datasource.master.initialSize=10 spring.datasource.master.maxWait=60000 spring.datasource.master.minIdle=1 spring.datasource.master.timeBetweenEvictionRunsMillis=60000 spring.datasource.master.minEvictableIdleTimeMillis=300000 spring.datasource.master.testWhileIdle=true spring.datasource.master.testOnBorrow=true spring.datasource.master.testOnReturn=false spring.datasource.master.poolPreparedStatements=true spring.datasource.master.maxOpenPreparedStatements=20 spring.datasource.master.validationQuery=SELECT 1 原连接池配置可删除
	刘舰	yh-oa-center	加： jdbc.driverClassName=com.mysql.jdbc.Driver jdbc.url= jdbc.url.slave= jdbc.username=yhhy_stage jdbc.password=Ho5E9G3p96bo 删：原连接池配置可删除
10月16日	李傲	account-center	jdbc.slave.url= jdbc.slave.username= jdbc.slave.password=
	李傲	delivery-station-center	spring.datasource.slave.type=com.alibaba.druid.pool.DruidDataSource spring.datasource.slave.driverClassName=com.mysql.jdbc.Driver spring.datasource.slave.url= spring.datasource.slave.username= spring.datasource.slave.password= spring.datasource.slave.filters=stat spring.datasource.slave.maxActive=20 spring.datasource.slave.initialSize=10 spring.datasource.slave.maxWait=60000 spring.datasource.slave.minIdle=1 spring.datasource.slave.timeBetweenEvictionRunsMillis=60000 spring.datasource.slave.minEvictableIdleTimeMillis=300000 spring.datasource.slave.testWhileIdle=true spring.datasource.slave.testOnBorrow=true spring.datasource.slave.testOnReturn=false spring.datasource.slave.poolPreparedStatements=true spring.datasource.slave.maxOpenPreparedStatements=20 spring.datasource.slave.validationQuery=SELECT 1
	王树雨	open-trade-center	jdbc.url.slave=
	王树雨	picklist-center	jdbc.url.slave=
	李傲	partner-center	无修改
	刘舰	partner-print-center	jdbc.url.slave=
	何泉	partner-drone-center	spring.datasource.slave.type=com.alibaba.druid.pool.DruidDataSource spring.datasource.slave.driverClassName=com.mysql.jdbc.Driver spring.datasource.slave.url= spring.datasource.slave.username= spring.datasource.slave.password= spring.datasource.slave.filters=stat spring.datasource.slave.maxActive=20 spring.datasource.slave.initialSize=10 spring.datasource.slave.maxWait=60000 spring.datasource.slave.minIdle=1 spring.datasource.slave.timeBetweenEvictionRunsMillis=60000 spring.datasource.slave.minEvictableIdleTimeMillis=300000 spring.datasource.slave.testWhileIdle=true spring.datasource.slave.testOnBorrow=true spring.datasource.slave.testOnReturn=false spring.datasource.slave.poolPreparedStatements=true spring.datasource.slave.maxOpenPreparedStatements=20 spring.datasource.slave.validationQuery=SELECT 1
	张洁	thirdparty-bag-chain-center	spring.datasource.maxActive=20 spring.datasource.filters=stat spring.datasource.initialSize=10 spring.datasource.maxWait=60000 spring.datasource.minIdle=1 spring.datasource.timeBetweenEvictionRunsMillis=60000 spring.datasource.minEvictableIdleTimeMillis=300000 spring.datasource.testWhileIdle=true spring.datasource.testOnBorrow=true spring.datasource.testOnReturn=false spring.datasource.poolPreparedStatements=true spring.datasource.maxOpenPreparedStatements=20 spring.datasource.validationQuery=SELECT 1 spring.datasource.slave.type=com.alibaba.druid.pool.DruidDataSource spring.datasource.slave.driverClassName=com.mysql.jdbc.Driver spring.datasource.slave.url= spring.datasource.slave.username= spring.datasource.slave.password= spring.datasource.slave.filters=stat spring.datasource.slave.maxActive=20 spring.datasource.slave.initialSize=10 spring.datasource.slave.maxWait=60000 spring.datasource.slave.minIdle=1 spring.datasource.slave.timeBetweenEvictionRunsMillis=60000 spring.datasource.slave.minEvictableIdleTimeMillis=300000 spring.datasource.slave.testWhileIdle=true spring.datasource.slave.testOnBorrow=true spring.datasource.slave.testOnReturn=false spring.datasource.slave.poolPreparedStatements=true spring.datasource.slave.maxOpenPreparedStatements=20 spring.datasource.slave.validationQuery=SELECT 1

3.发版后读写分离的验证和业务回归测试
一、大部分项目是之前没有访问过从库的项目，发版后由dba告知从库是否开始收到了请求，并成功处理。由dba告知请求指向从库后，从库性能是否瓶颈。
二、管家项目测试请在线上对主流程进行回归测试，对应项目的发版人要对自己发版的项目进行主流程的测试（改动地方），如果对应项目没有测试同学或者自己测试困难要观察日志信息，通过日志检验自己读写分离是否成功。
三、发版，测试期间请架构组的同学协助处理可能存在的BUG