<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[cucao1980的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/cucao1980</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; cucao1980]]></copyright><item><title><![CDATA[PXC5.7 安装]]></title><link>https://blog.youkuaiyun.com/cucao1980/article/details/100274088</link><guid>https://blog.youkuaiyun.com/cucao1980/article/details/100274088</guid><author>cucao1980</author><pubDate>Thu, 20 Jul 2017 17:02:42 +0800</pubDate><description><![CDATA[节点分配 

	
 


	
		
			
				
					IP 
				
			
			
				
					hostname 
				
			
			
				
					用途...]]></description><category></category></item><item><title><![CDATA[mysql MHA搭建]]></title><link>https://blog.youkuaiyun.com/cucao1980/article/details/100274087</link><guid>https://blog.youkuaiyun.com/cucao1980/article/details/100274087</guid><author>cucao1980</author><pubDate>Sun, 16 Jul 2017 11:05:50 +0800</pubDate><description><![CDATA[环境


	


	1主2从，manager放在从库


	主库：192.168.137.201


	从库（manager ）：192.168.137.202


	从库：192.168...]]></description><category></category></item><item><title><![CDATA[mysql主从同步错误Last_SQL_Errno: 1032处理分析]]></title><link>https://blog.youkuaiyun.com/cucao1980/article/details/100274085</link><guid>https://blog.youkuaiyun.com/cucao1980/article/details/100274085</guid><author>cucao1980</author><pubDate>Thu, 22 Jun 2017 10:37:52 +0800</pubDate><description><![CDATA[在MySQL DBA 日常运维工作中，主从同步失败一定是会遇到的，最常见建是1032错误。


	1032错误的主要原因是主库更新或者是删除的记录在从库上不存在引起的。


	处理此种错误一般有两种思路：...]]></description><category></category></item><item><title><![CDATA[mysql物理备份利器-xtrabackup]]></title><link>https://blog.youkuaiyun.com/cucao1980/article/details/100274084</link><guid>https://blog.youkuaiyun.com/cucao1980/article/details/100274084</guid><author>cucao1980</author><pubDate>Thu, 22 Jun 2017 10:18:44 +0800</pubDate><description><![CDATA[安装 
	


	cd /opt/ 


	tar -zxvf percona-xtrabackup-2.4.7-Linux-x86_64.tar.gz 


	ln -s /opt/pe...]]></description><category></category></item><item><title><![CDATA[mysql逻辑备份利器-mydumper]]></title><link>https://blog.youkuaiyun.com/cucao1980/article/details/100274083</link><guid>https://blog.youkuaiyun.com/cucao1980/article/details/100274083</guid><author>cucao1980</author><pubDate>Wed, 14 Jun 2017 15:20:20 +0800</pubDate><description><![CDATA[下载：
	


	Mydumper官网：http://www.mydumper.org/


	githup：https://github.com/maxbube/my...]]></description><category></category></item><item><title><![CDATA[Redis 源代码安装以及启动、停止]]></title><link>https://blog.youkuaiyun.com/cucao1980/article/details/100508829</link><guid>https://blog.youkuaiyun.com/cucao1980/article/details/100508829</guid><author>cucao1980</author><pubDate>Fri, 14 Apr 2017 10:24:16 +0800</pubDate><description><![CDATA[安装步骤：
	


	$ cd /opt


	$ wget http://download.redis.io/releases/redis-3.2.8.tar.gz


	$ tar xz...]]></description><category></category></item><item><title><![CDATA[mysql执行计划（EXPLAIN和DESCRIBE）]]></title><link>https://blog.youkuaiyun.com/cucao1980/article/details/100274081</link><guid>https://blog.youkuaiyun.com/cucao1980/article/details/100274081</guid><author>cucao1980</author><pubDate>Sat, 25 Mar 2017 16:46:57 +0800</pubDate><description><![CDATA[EXPLAIN和DESCRIBE的关系 
	


	


	The DESCRIBE and EXPLAIN statements are synonyms, used either to ob...]]></description><category></category></item><item><title><![CDATA[mysql数据库服务器性能剖析要点]]></title><link>https://blog.youkuaiyun.com/cucao1980/article/details/100274078</link><guid>https://blog.youkuaiyun.com/cucao1980/article/details/100274078</guid><author>cucao1980</author><pubDate>Fri, 03 Mar 2017 16:59:33 +0800</pubDate><description><![CDATA[一、查看慢查询 


	


	  如果确认有慢查询，那么就应该测量慢查询，而不是测量整个服务器性能


	  捕获MySQL的查询到慢日志文件，可以通过设置long_query_time为0...]]></description><category></category></item><item><title><![CDATA[本地源中有需要的rpm，yum不到的问题]]></title><link>https://blog.youkuaiyun.com/cucao1980/article/details/100274076</link><guid>https://blog.youkuaiyun.com/cucao1980/article/details/100274076</guid><author>cucao1980</author><pubDate>Thu, 02 Mar 2017 16:57:32 +0800</pubDate><description><![CDATA[1、查看光盘的版本和系统版本是否一致，32位和64位不兼容


	


	2、配置本地源之后 需要清理干净，再重新缓存加载


	


	  yum clean all


	  ...]]></description><category></category></item><item><title><![CDATA[mysql 数据文件逻辑卷组使用率100%问题处理]]></title><link>https://blog.youkuaiyun.com/cucao1980/article/details/100274079</link><guid>https://blog.youkuaiyun.com/cucao1980/article/details/100274079</guid><author>cucao1980</author><pubDate>Thu, 02 Mar 2017 16:53:59 +0800</pubDate><description><![CDATA[一、查看数据库锁住的具体原因


	tail -10000 /data/data/**001.err


	发现空间不足


	2016-11-24 19:45:24 20867 [Warning] Di...]]></description><category></category></item><item><title><![CDATA[安装 oracle GoldenGate 单向以及双向复制]]></title><link>https://blog.youkuaiyun.com/cucao1980/article/details/100274103</link><guid>https://blog.youkuaiyun.com/cucao1980/article/details/100274103</guid><author>cucao1980</author><pubDate>Thu, 02 Mar 2017 16:48:28 +0800</pubDate><description><![CDATA[参考


	http://koumm.blog.51cto.com/703525/1113773


	官网推荐路径


	/u01/app/oracle/ogg


	


	一、环境准备并...]]></description><category></category></item><item><title><![CDATA[MySQL mysqldump 从库备份]]></title><link>https://blog.youkuaiyun.com/cucao1980/article/details/100274074</link><guid>https://blog.youkuaiyun.com/cucao1980/article/details/100274074</guid><author>cucao1980</author><pubDate>Thu, 02 Mar 2017 16:26:26 +0800</pubDate><description><![CDATA[#!/bin/bash


	MYSQL_PATH=/data/bin


	export PATH=$PATH:$MYSQLPATH


	DATABASE=***


	PASSWORD=***...]]></description><category></category></item><item><title><![CDATA[在VirtualBox中安装增强功能]]></title><link>https://blog.youkuaiyun.com/cucao1980/article/details/100274077</link><guid>https://blog.youkuaiyun.com/cucao1980/article/details/100274077</guid><author>cucao1980</author><pubDate>Sun, 07 Jun 2015 16:33:49 +0800</pubDate><description><![CDATA[1、首先查看安装增强功能包的依赖包是否安装
	
	
		  操作：查看 gcc和kernel-devel是否安装
	
	
		rpm -q gcc
	
	
		
			 
		
未安...]]></description><category></category></item><item><title><![CDATA[动态性能视图创建过程探索]]></title><link>https://blog.youkuaiyun.com/cucao1980/article/details/100274072</link><guid>https://blog.youkuaiyun.com/cucao1980/article/details/100274072</guid><author>cucao1980</author><pubDate>Wed, 27 May 2015 16:37:57 +0800</pubDate><description><![CDATA[我们平时访问的动态性能视图表其实是真正视图通过V_$视图和SYNONYM同义词转变而来。

	下面通过实验以平时最常用的V$PARAMETER视图来进一步阐述
	
		
		
		
			
				
			
...]]></description><category></category></item><item><title><![CDATA[Spfile文件损坏，无spfile和pfile备份，启动数据库]]></title><link>https://blog.youkuaiyun.com/cucao1980/article/details/100274075</link><guid>https://blog.youkuaiyun.com/cucao1980/article/details/100274075</guid><author>cucao1980</author><pubDate>Thu, 14 May 2015 17:14:07 +0800</pubDate><description><![CDATA[在测试库做测试时把spfile改坏，数据库已shutdown了，重启失败，无spfile备份，也未生成pfile。


	解决方法：


	自建一个init_jzq.ora文件，在文件中添加3个参数：contr...]]></description><category></category></item></channel></rss>