<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/cpseh68048</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; cpseh68048]]></copyright><item><title><![CDATA[PXC（Percona XtraDB Cluster）集群安装]]></title><link>https://blog.youkuaiyun.com/cpseh68048/article/details/100317355</link><guid>https://blog.youkuaiyun.com/cpseh68048/article/details/100317355</guid><author>cpseh68048</author><pubDate>Sun, 03 Apr 2016 23:00:58 +0800</pubDate><description><![CDATA[Percona XtraDB Cluster简介

Percona XtraDB Cluster是MySQL高可用性和可扩展性的解决方案,Percona XtraDB Cluster完全兼容MySQL和Percona Serve...]]></description><category></category></item><item><title><![CDATA[Paramiko模块安装与使用]]></title><link>https://blog.youkuaiyun.com/cpseh68048/article/details/100317352</link><guid>https://blog.youkuaiyun.com/cpseh68048/article/details/100317352</guid><author>cpseh68048</author><pubDate>Sun, 03 Apr 2016 22:34:24 +0800</pubDate><description><![CDATA[Paramiko介绍

Paramiko遵循SSH2协议的python类库，支持以加密和认证的方式，可以进行远程服务器的连接。其中ansible也是通过Paramiko来进行ssh连接的。用它做远程管理时仅需要在本地上安装相应的...]]></description><category></category></item><item><title><![CDATA[使用screen管理远程会话]]></title><link>https://blog.youkuaiyun.com/cpseh68048/article/details/100317411</link><guid>https://blog.youkuaiyun.com/cpseh68048/article/details/100317411</guid><author>cpseh68048</author><pubDate>Fri, 18 Mar 2016 14:16:29 +0800</pubDate><description><![CDATA[DBA、系统管理员经常需要SSH 或者 telent 远程登录到 Linux 服务器执行一些操作。通常我们会为一些执行时间长的任务开一个远程终端，但是在这些任务执行完毕前，我们不能关掉窗口或者断开连接，否则这个任务就会被杀...]]></description><category></category></item><item><title><![CDATA[使用rsync同步数据]]></title><link>https://blog.youkuaiyun.com/cpseh68048/article/details/100317350</link><guid>https://blog.youkuaiyun.com/cpseh68048/article/details/100317350</guid><author>cpseh68048</author><pubDate>Fri, 18 Mar 2016 14:15:23 +0800</pubDate><description><![CDATA[rsync介绍


	Rsync(Remote Synchronize)是一个远程资料同步工具，可通过LAN/WAN快速同步多台主机，Rsync使用所为的“Rsync演算法”来使本地主机和远程主机之间达到同步，这个演...]]></description><category></category></item><item><title><![CDATA[Linux lsof命令解析]]></title><link>https://blog.youkuaiyun.com/cpseh68048/article/details/100317351</link><guid>https://blog.youkuaiyun.com/cpseh68048/article/details/100317351</guid><author>cpseh68048</author><pubDate>Sun, 06 Mar 2016 23:10:37 +0800</pubDate><description><![CDATA[lsof简介


	lsof(list open files)是一个列出当前系统打开文件的工具。在linux环境下，任何事物都以文件的形式存在，通过文件不仅仅可以访问常规数据，还可以访问网络连接和硬件。所以如传输控制...]]></description><category></category></item><item><title><![CDATA[percona 5.6 审计功能]]></title><link>https://blog.youkuaiyun.com/cpseh68048/article/details/100317349</link><guid>https://blog.youkuaiyun.com/cpseh68048/article/details/100317349</guid><author>cpseh68048</author><pubDate>Sun, 06 Mar 2016 23:09:23 +0800</pubDate><description><![CDATA[Percona Audit Log Plugin介绍
		
		
			Percona审计日志插件提供了数据库执行的连接和查询活动的监控记录，相关的信息将被记录在XML文件中，每一个...]]></description><category></category></item><item><title><![CDATA[MyCAT安装使用及简单测试]]></title><link>https://blog.youkuaiyun.com/cpseh68048/article/details/100317345</link><guid>https://blog.youkuaiyun.com/cpseh68048/article/details/100317345</guid><author>cpseh68048</author><pubDate>Sun, 06 Mar 2016 23:08:15 +0800</pubDate><description><![CDATA[MyCAT安装
		
		
			mycat运行依赖于jre环境，需要首先安装jdk7以上版本
		
检查jdk版本
shell&gt; java -version
java version...]]></description><category></category></item><item><title><![CDATA[MySQL表数据导入与导出]]></title><link>https://blog.youkuaiyun.com/cpseh68048/article/details/100317347</link><guid>https://blog.youkuaiyun.com/cpseh68048/article/details/100317347</guid><author>cpseh68048</author><pubDate>Sun, 28 Feb 2016 22:55:50 +0800</pubDate><description><![CDATA[LOAD DATA INFILE


	LOAD DATA INFILE语句可以快速将文本记录导入到表中， SELECT ... INTO OUTFILE可以将表中数据导入到文件中，两者的FIELDS、...]]></description><category></category></item><item><title><![CDATA[MySQL Router介绍]]></title><link>https://blog.youkuaiyun.com/cpseh68048/article/details/100317338</link><guid>https://blog.youkuaiyun.com/cpseh68048/article/details/100317338</guid><author>cpseh68048</author><pubDate>Sun, 28 Feb 2016 22:53:35 +0800</pubDate><description><![CDATA[MySQL Router介绍
	
	
		MySQL Router是一个轻量级的中间件，提供了应用程序与后端数据库的透明路由，是mysql用来实现负载均衡和高可用功能。同时router也提供了使用fabric...]]></description><category></category></item><item><title><![CDATA[Cacti安装配置]]></title><link>https://blog.youkuaiyun.com/cpseh68048/article/details/100317342</link><guid>https://blog.youkuaiyun.com/cpseh68048/article/details/100317342</guid><author>cpseh68048</author><pubDate>Thu, 16 Jul 2015 23:32:52 +0800</pubDate><description><![CDATA[Cacti介绍
	
	
		Cacti是用php语言实现的一个软件，它的主要功能是用snmp服务获取数据，然后用rrdtool储存和更新数据，当用户需要查看数据的时候用rrdtool生成图表呈现给用户。因此，...]]></description><category></category></item><item><title><![CDATA[Nagios安装配置]]></title><link>https://blog.youkuaiyun.com/cpseh68048/article/details/100317340</link><guid>https://blog.youkuaiyun.com/cpseh68048/article/details/100317340</guid><author>cpseh68048</author><pubDate>Thu, 16 Jul 2015 23:32:19 +0800</pubDate><description><![CDATA[Nagios简介
	
	
		Nagios是一款开源的电脑系统和网络监视工具，能有效监控Windows、Linux和Unix的主机状态，交换机路由器等网络设置，打印机等。在系统或服务状态异常时发出邮件或短信报...]]></description><category></category></item><item><title><![CDATA[使用zabbix自带模板监控MySQL数据库]]></title><link>https://blog.youkuaiyun.com/cpseh68048/article/details/100317337</link><guid>https://blog.youkuaiyun.com/cpseh68048/article/details/100317337</guid><author>cpseh68048</author><pubDate>Thu, 16 Jul 2015 23:31:02 +0800</pubDate><description><![CDATA[授权zabbix连接MySQL数据库
	
zabbix客户端程序会以该用户的身份启动 
mysql&gt; GRANT USAGE ON *.* TO 'zabbix'@'localhost' IDENTIF...]]></description><category></category></item><item><title><![CDATA[zabbix监控客户端安装]]></title><link>https://blog.youkuaiyun.com/cpseh68048/article/details/100317341</link><guid>https://blog.youkuaiyun.com/cpseh68048/article/details/100317341</guid><author>cpseh68048</author><pubDate>Thu, 16 Jul 2015 23:30:05 +0800</pubDate><description><![CDATA[添加zabbix用户
	
zabbix客户端程序会以该用户的身份启动 
shell&gt; groupadd zabbix
shell&gt; useradd -r -g zabbix zabbix
	...]]></description><category></category></item><item><title><![CDATA[zabbix源码安装]]></title><link>https://blog.youkuaiyun.com/cpseh68048/article/details/100317335</link><guid>https://blog.youkuaiyun.com/cpseh68048/article/details/100317335</guid><author>cpseh68048</author><pubDate>Thu, 02 Jul 2015 23:30:03 +0800</pubDate><description><![CDATA[zabbix 介绍
	
	
		zabbix由2部分构成，zabbix server与可选组件zabbix agent。
	
	
		
			zabbix server可以通过SNMP，zabbix ...]]></description><category></category></item><item><title><![CDATA[MySQL函数FIND_IN_SET介绍]]></title><link>https://blog.youkuaiyun.com/cpseh68048/article/details/100317339</link><guid>https://blog.youkuaiyun.com/cpseh68048/article/details/100317339</guid><author>cpseh68048</author><pubDate>Mon, 27 Apr 2015 00:31:25 +0800</pubDate><description><![CDATA[背景
	
	
		前几天面试遇见一个问题，如果一个表字段对应另一个表多个字段，问怎么用一条SQL语句实现，因为没有接触过FIND_IN_SET，当时想了其他很多办法都没有有效解决，后来发现可以使用FIND_I...]]></description><category></category></item><item><title><![CDATA[BLACKHOLE存储引擎总结]]></title><link>https://blog.youkuaiyun.com/cpseh68048/article/details/100317333</link><guid>https://blog.youkuaiyun.com/cpseh68048/article/details/100317333</guid><author>cpseh68048</author><pubDate>Mon, 27 Apr 2015 00:30:48 +0800</pubDate><description><![CDATA[BLACKHOLE安装
	
	
		使用cmake源码安装时指定-DWITH_BLACKHOLE_STORAGE_ENGINE 选项 可以启用 BLACKHOLE 存储引擎，使用默认编译项可编译BLACKHO...]]></description><category></category></item><item><title><![CDATA[MySQL审计功能]]></title><link>https://blog.youkuaiyun.com/cpseh68048/article/details/100317400</link><guid>https://blog.youkuaiyun.com/cpseh68048/article/details/100317400</guid><author>cpseh68048</author><pubDate>Mon, 27 Apr 2015 00:30:14 +0800</pubDate><description><![CDATA[MySQL审计功能介绍
	
	
		之前有同事发现数据丢失，由于MySQL自身没有提供审计功能,查找binlog可以看到操作时间与连接IP，并不显示哪个用户做的操作，询问开发同事都说没有做删除操作，也没办法定...]]></description><category></category></item><item><title><![CDATA[MySQL5.7源码安装问题汇总]]></title><link>https://blog.youkuaiyun.com/cpseh68048/article/details/100317331</link><guid>https://blog.youkuaiyun.com/cpseh68048/article/details/100317331</guid><author>cpseh68048</author><pubDate>Wed, 22 Apr 2015 11:50:20 +0800</pubDate><description><![CDATA[编译安装mysql5.7版本，想试用一下新的版本特性，发现跟之前的5.6版本编译有了一些变化，总结一下避免以后继续入坑。5.6安装方式
	
	
		cmake版本
	
	
		5.7编译cmake要求版...]]></description><category></category></item><item><title><![CDATA[PostgreSQL常用命令]]></title><link>https://blog.youkuaiyun.com/cpseh68048/article/details/100317330</link><guid>https://blog.youkuaiyun.com/cpseh68048/article/details/100317330</guid><author>cpseh68048</author><pubDate>Mon, 20 Apr 2015 22:21:53 +0800</pubDate><description><![CDATA[查看版本信息
	
mydb=# SELECT version();
                                                version               ...]]></description><category></category></item><item><title><![CDATA[Linux下PostgreSQL源码安装]]></title><link>https://blog.youkuaiyun.com/cpseh68048/article/details/100317344</link><guid>https://blog.youkuaiyun.com/cpseh68048/article/details/100317344</guid><author>cpseh68048</author><pubDate>Mon, 20 Apr 2015 22:20:32 +0800</pubDate><description><![CDATA[1、首先安装依赖包，避免在安装过程中出现问题
	
shell&gt; yum install gcc gcc-c++ automake autoconf libtool make
shell&gt; yum ...]]></description><category></category></item></channel></rss>