mysql 驱动方式实现读写分离
来源:互联网 发布:淘宝网货到付款购物 编辑:程序博客网 时间:2024/05/20 05:47
import java.sql.Connection;import java.sql.ResultSet;import java.util.Properties;import com.mysql.jdbc.ReplicationDriver;public class ReplicationDriverDemo { public static void main(String[] args) throws Exception { ReplicationDriver driver = new ReplicationDriver(); Properties props = new Properties(); // We want this for failover on the slaves props.put("autoReconnect", "true"); // We want to load balance between the slaves props.put("roundRobinLoadBalance", "true"); props.put("user", "foo"); props.put("password", "bar"); // // Looks like a normal MySQL JDBC url, with a // comma-separated list of hosts, the first // being the 'master', the rest being any number // of slaves that the driver will load balance against // Connection conn = driver.connect("jdbc:mysql:replication://master,slave1,slave2,slave3/test", props); // // Perform read/write work on the master // by setting the read-only flag to "false" // conn.setReadOnly(false); conn.setAutoCommit(false); conn.createStatement().executeUpdate("UPDATE some_table ...."); conn.commit(); // // Now, do a query from a slave, the driver automatically picks one // from the list // conn.setReadOnly(true); ResultSet rs = conn.createStatement().executeQuery("SELECT a,b FROM alt_table"); ....... }}
阅读全文
0 0
- mysql 驱动方式实现读写分离
- 使用Mysql新版驱动的ReplicationDriver实现MySQL读写分离
- MYSQL实现读写分离
- mysql读写分离实现
- Mysql实现读写分离
- mysql实现读写分离自带java驱动
- mysql实现读写分离自带java驱动
- Mysql读写分离实现的三种方式
- 注解方式实现读写分离
- Amoeba+mysql实现读写分离
- mysql读写分离的实现
- mysql主从+读写分离实现
- MySQL Proxy 实现读写分离
- mysql jdbc 实现读写分离
- Amoeba实现mysql读写分离
- mysql-proxy实现读写分离
- mysql 读写分离 ,mysql_proxy实现
- mysql读写分离的实现
- mysql 驱动方式实现负载均衡
- 本地登录oracle ORA-01017
- oracle 中文乱码
- Hdu 2030 汉字统计
- 公司开办细节记录
- mysql 驱动方式实现读写分离
- 浏览器内核、渲染引擎、js引擎
- win10 + linux
- 7Z和rar使用摘录
- CSDN如何查看自己的排名
- MFC之dll中调用对话框
- Web打印的解决方案之证件套打
- 零基础学java语言-中国大学慕课-翁凯老师-第六章习题-数单词长度
- pydicom读取压缩格式的DICOM图像报错的解决方案