mysql-connector-java-5.1.21-sources.jar!/com/mysql/jdbc/ConnectionImpl.java

序本文主要研究一下mysql的树形结构存储及查询存储parent这种方式就是每个节点存储自己的parent_id信息建表及数据准备 {代码...} 查询 {代码...} 存储及修改上比较方便，就是要在sql里头查询树比较费劲，一般是加载到内存由应用自己构造存储path这种方式在存储parent的基础上，额外存储path，即从根节点到该节点的路径建...

序本文主要研究一下mysql如何用一个列来存储多个值实例用bit类型建表及数据准备 {代码...} 位运算查询 {代码...} 更新 {代码...} 用int/bigint类型建表及数据准备 {代码...} 查询 {代码...} 更新 {代码...} 用varchar类型建表及数据准备 {代码...} 查询 {代码...} 更新 {代码...} 用set类型建表及数据准备 {代码...} 查...

何为多列组合查询呢，就是查询的值不再是单个列的值，而是组合列的值。比如where (column1,column2) in ((a1,b1),(a2,b2),(a3,b3))

SpinalTap/spinaltap-model/src/main/java/com/airbnb/spinaltap/mysql/Transaction.java

SpinalTap/spinaltap-mysql/src/main/java/com/airbnb/spinaltap/mysql/event/filter/MysqlEventFilter.java

SpinalTap/spinaltap-mysql/src/main/java/com/airbnb/spinaltap/mysql/event/BinlogEvent.java

SpinalTap/spinaltap-mysql/src/main/java/com/airbnb/spinaltap/mysql/binlog_connector/BinaryLogConnectorSource.java

rocketmq-externals/rocketmq-mysql/src/main/java/org/apache/rocketmq/mysql/schema/column/ColumnParser.java

rocketmq-externals/rocketmq-mysql/src/main/java/org/apache/rocketmq/mysql/Replicator.java

rocketmq-externals/rocketmq-mysql/src/main/java/org/apache/rocketmq/mysql/binlog/EventProcessor.java

rocketmq-externals/rocketmq-mysql/src/main/java/org/apache/rocketmq/mysql/position/BinlogPositionManager.java

maxwell-1.25.1/src/main/java/com/zendesk/maxwell/producer/FileProducer.java

maxwell-1.25.1/src/main/java/com/zendesk/maxwell/scripting/Scripting.java

maxwell-1.25.1/src/main/java/com/zendesk/maxwell/recovery/Recovery.java

maxwell-1.25.1/src/main/java/com/zendesk/maxwell/producer/partitioners/MaxwellKafkaPartitioner.java

maxwell-1.25.1/src/main/java/com/zendesk/maxwell/bootstrap/BootstrapController.java

maxwell-1.25.1/src/main/java/com/zendesk/maxwell/monitoring/MaxwellDiagnostic.java

maxwell-1.25.1/src/main/java/com/zendesk/maxwell/schema/PositionStoreThread.java

maxwell-1.25.1/src/main/java/com/zendesk/maxwell/schema/MysqlPositionStore.java

maxwell-1.25.1/src/main/java/com/zendesk/maxwell/producer/MaxwellKafkaProducer.java

maxwell-1.25.1/src/main/java/com/zendesk/maxwell/util/StoppableTask.java

maxwell-1.25.1/src/main/java/com/zendesk/maxwell/replication/BinlogConnectorReplicator.java

maxwell-1.25.1/src/main/java/com/zendesk/maxwell/replication/BinlogConnectorEventListener.java

mysql-binlog-connector-java-0.20.1/src/main/java/com/github/shyiko/mysql/binlog/event/deserialization/EventDeserializer.java

mysql-binlog-connector-java-0.20.1/src/main/java/com/github/shyiko/mysql/binlog/BinaryLogFileReader.java

本文主要研究怎么在docker上搭建mysql的主从。因为在单机搭建mysql多实例然后再配主从，感觉太痛苦了，环境各有不同，配置各不大相同，从网上找搭建方法，试了半天也没成功，最后也没耐心调试下去了，浪费了好多时间。觉得还是应该用先进的技术来避免这种时间的浪费，正好docker可以用上。