<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[木生的博客]]></title><description><![CDATA[致力于廉价机的大数据快速存取]]></description><link>https://blog.youkuaiyun.com/John_Chang11</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; John_Chang11]]></copyright><item><title><![CDATA[Error executing DDL "create table hibernate_sequence (next_val bigint) engine=InnoDB" via JDBC State]]></title><link>https://blog.youkuaiyun.com/John_Chang11/article/details/104510260</link><guid>https://blog.youkuaiyun.com/John_Chang11/article/details/104510260</guid><author>John_Chang11</author><pubDate>Wed, 26 Feb 2020 09:18:17 +0800</pubDate><description><![CDATA[spring boot启动报错：

org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "create table hibernate_sequence (next_val bigint) engine=InnoDB" via JDBC Statement
 at org.hibernat...]]></description><category></category></item><item><title><![CDATA[MySQL查看binlog日志]]></title><link>https://blog.youkuaiyun.com/John_Chang11/article/details/79562079</link><guid>https://blog.youkuaiyun.com/John_Chang11/article/details/79562079</guid><author>John_Chang11</author><pubDate>Wed, 14 Mar 2018 23:31:15 +0800</pubDate><description><![CDATA[本文本转载自：http://blog.youkuaiyun.com/nuli888/article/details/52106910mysql的binlog日志位置可通过show variables like '%datadir%';查看，直接打开无法查看，要看其内容2个办法：1、登录到mysql查看binlog只查看第一个binlog文件的内容mysql&amp;gt; show binlog events;查看指...]]></description><category></category></item><item><title><![CDATA[mysqldump中master-data和dump-slave的区别]]></title><link>https://blog.youkuaiyun.com/John_Chang11/article/details/79530228</link><guid>https://blog.youkuaiyun.com/John_Chang11/article/details/79530228</guid><author>John_Chang11</author><pubDate>Mon, 12 Mar 2018 17:33:50 +0800</pubDate><description><![CDATA[本文转载自：http://blog.chinaunix.net/uid-451-id-3143431.html[mysql@db2 ~]$ mysqldump -A --master-data=2 &amp;gt; master2.sql[mysql@db2 ~]$ mysqldump -A --dump-slave=2 &amp;gt; slave2.sql[mysql@db2 ~]$ mysqldump -A...]]></description><category></category></item><item><title><![CDATA[JAVA 与 MyCat（6） MyCat配置文件类图]]></title><link>https://blog.youkuaiyun.com/John_Chang11/article/details/79171427</link><guid>https://blog.youkuaiyun.com/John_Chang11/article/details/79171427</guid><author>John_Chang11</author><pubDate>Fri, 26 Jan 2018 14:51:51 +0800</pubDate><description><![CDATA[通过mycat来学习java了^^。





接前一篇：http://blog.youkuaiyun.com/john_chang11/article/details/78905478




通过前的文章介绍，可以理解MyCat是如果加载XML文件的配置信息。经过rule.xml, schema.xml, server.xml三个配置文件加载后，最终在JVM形成如下所示的类关系图：]]></description><category></category></item><item><title><![CDATA[JAVA 与 MyCat（5） 类的加载 Java内省/反射机制 注解Annotation 详解]]></title><link>https://blog.youkuaiyun.com/John_Chang11/article/details/78905478</link><guid>https://blog.youkuaiyun.com/John_Chang11/article/details/78905478</guid><author>John_Chang11</author><pubDate>Tue, 02 Jan 2018 16:54:04 +0800</pubDate><description><![CDATA[通过mycat来学习java了^^。





接前一篇：http://blog.youkuaiyun.com/john_chang11/article/details/78734051




上一篇了解了XML解析的四种方式，并对MyCat的源码进行了修改，这一篇接着往下看：


dtd = XMLRuleLoader.class.getResourceAsStream(dtd]]></description><category></category></item><item><title><![CDATA[JAVA 与 MyCat（4） XML解析详解]]></title><link>https://blog.youkuaiyun.com/John_Chang11/article/details/78734051</link><guid>https://blog.youkuaiyun.com/John_Chang11/article/details/78734051</guid><author>John_Chang11</author><pubDate>Fri, 08 Dec 2017 13:48:55 +0800</pubDate><description><![CDATA[通过mycat来学习java了^^。





接前一篇：http://blog.youkuaiyun.com/john_chang11/article/details/78715228




前一篇讲到了load方法：

private void load(String dtdFile, String xmlFile) {
		InputStream dtd = null;]]></description><category></category></item><item><title><![CDATA[JAVA 与 MyCat（3） 关于getResourceAsStream(fileName)的文件位置]]></title><link>https://blog.youkuaiyun.com/John_Chang11/article/details/78715228</link><guid>https://blog.youkuaiyun.com/John_Chang11/article/details/78715228</guid><author>John_Chang11</author><pubDate>Tue, 05 Dec 2017 11:42:16 +0800</pubDate><description><![CDATA[通过mycat来学习java了^^。





接前一篇：http://blog.youkuaiyun.com/john_chang11/article/details/78679867




前一篇文章介绍了单例模式创建了MycatServer单实例，下面一起看看MycatServer初始化方法的内容：


private MycatServer() {

		// 读取文件配]]></description><category></category></item><item><title><![CDATA[JAVA 与 MyCat（2） 单例模式]]></title><link>https://blog.youkuaiyun.com/John_Chang11/article/details/78679867</link><guid>https://blog.youkuaiyun.com/John_Chang11/article/details/78679867</guid><author>John_Chang11</author><pubDate>Mon, 04 Dec 2017 00:31:08 +0800</pubDate><description><![CDATA[通过mycat来学习java了^^。



接前一篇：http://blog.youkuaiyun.com/john_chang11/article/details/78668667


MycatServer server = MycatServer.getInstance();

获取MyCat实例，其实就是读取配置文件，并验证正确性等。]]></description><category></category></item><item><title><![CDATA[JAVA 与 MyCat（1） System.getProperty()]]></title><link>https://blog.youkuaiyun.com/John_Chang11/article/details/78668667</link><guid>https://blog.youkuaiyun.com/John_Chang11/article/details/78668667</guid><author>John_Chang11</author><pubDate>Thu, 30 Nov 2017 18:02:44 +0800</pubDate><description><![CDATA[通过mycat来学习java了^^。]]></description><category></category></item><item><title><![CDATA[通过 XtraBackup 实现不停机不锁表搭建MySQL主从同步]]></title><link>https://blog.youkuaiyun.com/John_Chang11/article/details/74010880</link><guid>https://blog.youkuaiyun.com/John_Chang11/article/details/74010880</guid><author>John_Chang11</author><pubDate>Fri, 30 Jun 2017 17:22:12 +0800</pubDate><description><![CDATA[Xtrabackup是由 Percona 开发的一个开源软件，可实现对 InnoDB 的数据备份，支持在线热备份（备份时不影响数据读写）。备份时，Xtrabackup 会将 Master 的 binlog 信息记录在 xtrabackup_slave_info 文件中，通过此信息可以方便的搭建主从复制。

XtraBackup 有两个工具：xtrabackup 和 innobackupex：]]></description><category></category></item><item><title><![CDATA[mysql.sock文件被删除后，如何本地登录mysql的]]></title><link>https://blog.youkuaiyun.com/John_Chang11/article/details/74002383</link><guid>https://blog.youkuaiyun.com/John_Chang11/article/details/74002383</guid><author>John_Chang11</author><pubDate>Fri, 30 Jun 2017 15:49:58 +0800</pubDate><description><![CDATA[socket文件消失后，本地登录mysql会报以下错误：
[mysql@ceshi-redis-mysql mysql]$ mysql -uroot -p
Enter password: 
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock']]></description><category></category></item><item><title><![CDATA[数据节点空闲检查流程图]]></title><link>https://blog.youkuaiyun.com/John_Chang11/article/details/72677565</link><guid>https://blog.youkuaiyun.com/John_Chang11/article/details/72677565</guid><author>John_Chang11</author><pubDate>Wed, 24 May 2017 16:37:12 +0800</pubDate><description><![CDATA[数据节点空闲检查的目的是清除关闭的连接、关闭多余空闲连接、创建不足连接。]]></description><category></category></item><item><title><![CDATA[mycat心跳任务流程图]]></title><link>https://blog.youkuaiyun.com/John_Chang11/article/details/72639559</link><guid>https://blog.youkuaiyun.com/John_Chang11/article/details/72639559</guid><author>John_Chang11</author><pubDate>Tue, 23 May 2017 14:38:41 +0800</pubDate><description><![CDATA[Mycat启动时，在MycatServer里会启动心跳任务：
scheduler.scheduleAtFixedRate(dataNodeHeartbeat(), 0L, system.getDataNodeHeartbeatPeriod(),
TimeUnit.MILLISECONDS);

关于dataNodeHeartbeat()的执行流程如下图：]]></description><category></category></item><item><title><![CDATA[mycat后台连接调用关系]]></title><link>https://blog.youkuaiyun.com/John_Chang11/article/details/72377356</link><guid>https://blog.youkuaiyun.com/John_Chang11/article/details/72377356</guid><author>John_Chang11</author><pubDate>Thu, 18 May 2017 16:31:53 +0800</pubDate><description><![CDATA[一，第一步
mycat第一次建立后端连接是在启动时的MycatServer.java类里：


这段代码的意思是：取出所有的dataHost节点，用每一个dataHost里的当前写节点建立minCon个物理数据库连接。
dataHosts变量里存在着schema.xml文件里配置的所有dataHost节点信息，一个PhysicalDBPool对应着一个dataHosts节点，一个Phys]]></description><category></category></item><item><title><![CDATA[SLF4J和log4j]]></title><link>https://blog.youkuaiyun.com/John_Chang11/article/details/55209607</link><guid>https://blog.youkuaiyun.com/John_Chang11/article/details/55209607</guid><author>John_Chang11</author><pubDate>Wed, 15 Feb 2017 15:11:48 +0800</pubDate><description><![CDATA[SLF4J：即简单日志门面（Simple Logging Facade for Java），不是具体的日志解决方案，它只服务于各种各样的日志系统。按照官方的说法，SLF4J是一个用于日志系统的简单Facade，允许最终用户在部署其应用时使用其所希望的日志系统。

    在使用SLF4J的时候，不需要在代码中或配置文件中指定你打算使用那个具体的日志系统，SLF4J提供了统一的记录日志的接口，只]]></description><category></category></item><item><title><![CDATA[Java DOM解析XML的几个例子]]></title><link>https://blog.youkuaiyun.com/John_Chang11/article/details/55097506</link><guid>https://blog.youkuaiyun.com/John_Chang11/article/details/55097506</guid><author>John_Chang11</author><pubDate>Tue, 14 Feb 2017 13:34:33 +0800</pubDate><description><![CDATA[Sample1：

1：新建XML文档 books.xml，放到项目的根目录下。

xml version="1.0" encoding="GB2312"?>    books  count="3"        xmlns="http://test.org/books">                book id="1">            name>Thinking in JA]]></description><category></category></item><item><title><![CDATA[MySQL出现Waiting for table metadata lock的原因以及解决方法]]></title><link>https://blog.youkuaiyun.com/John_Chang11/article/details/54312055</link><guid>https://blog.youkuaiyun.com/John_Chang11/article/details/54312055</guid><author>John_Chang11</author><pubDate>Tue, 10 Jan 2017 11:15:54 +0800</pubDate><description><![CDATA[MySQL在进行alter table等DDL操作时，有时会出现Waiting for table metadata lock的等待场景。而且，一旦alter table TableA的操作停滞在Waiting for table metadata lock的状态，后续对TableA的任何操作（包括读）都无法进行，因为他们也会在Opening
 tables的阶段进入到Waiting for t]]></description><category></category></item><item><title><![CDATA[mycat中文乱码-解决方案]]></title><link>https://blog.youkuaiyun.com/John_Chang11/article/details/54288482</link><guid>https://blog.youkuaiyun.com/John_Chang11/article/details/54288482</guid><author>John_Chang11</author><pubDate>Mon, 09 Jan 2017 14:13:09 +0800</pubDate><description><![CDATA[乱码问题可能出现的三个地方



1．程序连接的编码要设置



jdbc:MySQL://192.168.1.1:8066/TESTDB?useUnicode=true&characterEncoding=utf8

2． mysql数据库的编码要设置

1)       查看mysql server级别的编码集

              首先进入mysql使用命]]></description><category></category></item><item><title><![CDATA[mysq字段类型转换]]></title><link>https://blog.youkuaiyun.com/John_Chang11/article/details/53739113</link><guid>https://blog.youkuaiyun.com/John_Chang11/article/details/53739113</guid><author>John_Chang11</author><pubDate>Mon, 19 Dec 2016 14:20:30 +0800</pubDate><description><![CDATA[1.将字符的数字转成数字，比如'0'转成0可以直接用加法来实现
例如：将pony表中的d 进行排序，可d的定义为varchar，可以这样解决
select * from pony order by (d+0)
2.在进行ifnull处理时，比如
 ifnull(a/b,'0') 这样就会导致 a/b成了字符串，因此需要把'0'改成0，即可解决此困扰
3.比较数字和varchar时，比如a]]></description><category></category></item><item><title><![CDATA[MySQL多实例安装配置]]></title><link>https://blog.youkuaiyun.com/John_Chang11/article/details/53437187</link><guid>https://blog.youkuaiyun.com/John_Chang11/article/details/53437187</guid><author>John_Chang11</author><pubDate>Fri, 02 Dec 2016 18:21:24 +0800</pubDate><description><![CDATA[1.环境



OS: CentOS 6.5 x64

MySQL: 5.6 for Linux (x86_64)




2.源码安装MySQL

可以参考：linux 6.5下 MySQL 5.6 源码安装




3.初始化一个新加的数据库实例（3306实例已存在）

# mkdir /u01/mysql/data3307    #创建数据库数据目录]]></description><category></category></item></channel></rss>