<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[a3470194的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/a3470194</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; a3470194]]></copyright><item><title><![CDATA[告别繁琐，一个平台搞定所有数据库查询——dbquery 深度介绍]]></title><link>https://blog.youkuaiyun.com/a3470194/article/details/159323119</link><guid>https://blog.youkuaiyun.com/a3470194/article/details/159323119</guid><author>a3470194</author><pubDate>Sat, 21 Mar 2026 21:23:30 +0800</pubDate><description><![CDATA[dbquery是一款基于Django+Bootstrap构建的轻量级数据库运维平台，支持MySQL、TiDB、PostgreSQL、Redis和MongoDB五种数据库查询。通过浏览器即可访问，无需安装客户端，提供多级权限控制和用户组管理，确保数据安全。核心功能包括跨实例数据库搜索、在线SQL编辑器（支持语法高亮和多语句执行）、实例管理及多语言界面。相比Navicat等工具，dbquery更侧重团队协作和安全性，特别适合中小团队快速部署使用。项目采用Docker一键部署，5分钟即可上线运行。]]></description><category></category></item><item><title><![CDATA[Mongo性能测试-python脚本]]></title><link>https://blog.youkuaiyun.com/a3470194/article/details/50524945</link><guid>https://blog.youkuaiyun.com/a3470194/article/details/50524945</guid><author>a3470194</author><pubDate>Fri, 15 Jan 2016 17:22:02 +0800</pubDate><description><![CDATA[单线程
500+w条数据，插入时间：1小时，13分钟。
脚本：
[root@10 hurl]# cat insert-mongo2.py 
#!/usr/bin/env python
#coding=utf-8
import time,datetime
import pymongo
from pymongo import MongoClient
client = MongoCli]]></description><category></category></item><item><title><![CDATA[ansible安装测试]]></title><link>https://blog.youkuaiyun.com/a3470194/article/details/50523861</link><guid>https://blog.youkuaiyun.com/a3470194/article/details/50523861</guid><author>a3470194</author><pubDate>Fri, 15 Jan 2016 15:15:46 +0800</pubDate><description><![CDATA[安装：
# yum install ansible 

# yum install sshpass





配置：

# vi /etc/ansible/hosts 


[mysqldb]
172.16.100.23 ansible_ssh_user=root ansible_ssh_pass=c3root
172.16.100.24 ansible_ssh_u]]></description><category></category></item><item><title><![CDATA[expect安装测试-批量用户管理]]></title><link>https://blog.youkuaiyun.com/a3470194/article/details/50523842</link><guid>https://blog.youkuaiyun.com/a3470194/article/details/50523842</guid><author>a3470194</author><pubDate>Fri, 15 Jan 2016 15:10:17 +0800</pubDate><description><![CDATA[安装：
yum list | grep expect

yum install expect




批量创建用户：

ansible mysqldb -m user -a 'name=ansible state=present'
ansible mysqldb -m raw -a 'echo 123456|passwd --stdin ansible'




]]></description><category></category></item><item><title><![CDATA[批量配置SSH 免密钥登录脚本]]></title><link>https://blog.youkuaiyun.com/a3470194/article/details/50523527</link><guid>https://blog.youkuaiyun.com/a3470194/article/details/50523527</guid><author>a3470194</author><pubDate>Fri, 15 Jan 2016 14:31:38 +0800</pubDate><description><![CDATA[[root@c3-zabbix-serv hurl]# cat sendsshkey.sh 

#!/bin/bash 

if [ -z $1 ]; then
echo -e "\033[40;31m Usage  : sh $0 username passwd \033[0m\n"
echo -e "\033[40;31m Example: sh $0 root 'passwd!@]]></description><category></category></item><item><title><![CDATA[ping测试局域网内主机是否alive]]></title><link>https://blog.youkuaiyun.com/a3470194/article/details/50523505</link><guid>https://blog.youkuaiyun.com/a3470194/article/details/50523505</guid><author>a3470194</author><pubDate>Fri, 15 Jan 2016 14:29:02 +0800</pubDate><description><![CDATA[[root@zabbix ~]# cat alivehost.sh
#!/bin/bash
#Checks to see if hosts 192.168.1.100-192.168.1.200 are alive
for n in {50..150}; do
         host=172.16.0.$n
         ping -c2 $host &>/dev/null
 ]]></description><category></category></item><item><title><![CDATA[批量ssh执行命令]]></title><link>https://blog.youkuaiyun.com/a3470194/article/details/50523459</link><guid>https://blog.youkuaiyun.com/a3470194/article/details/50523459</guid><author>a3470194</author><pubDate>Fri, 15 Jan 2016 14:23:52 +0800</pubDate><description><![CDATA[多大多大


[root@openfire1 script]# cat test.sh 
#!/bin/bash  


#本地通过ssh执行远程服务器的脚本  
for ip in `cat iplist` 
do  
    echo $1
    if [[ -z $1 ]]; then  #"-z"，如果为空 
        echo "Not find comm]]></description><category></category></item><item><title><![CDATA[通过scp批量推送文件到远程目录]]></title><link>https://blog.youkuaiyun.com/a3470194/article/details/50523416</link><guid>https://blog.youkuaiyun.com/a3470194/article/details/50523416</guid><author>a3470194</author><pubDate>Fri, 15 Jan 2016 14:18:00 +0800</pubDate><description><![CDATA[[root@openfire1 script]# cat test.sh 

#!/bin/bash  




#通过scp推送文件到远程目录

for ip in `cat iplist` 

do  

    echo $1

    if [[ -z $1 ]]; then  #"-z"，如果为空 

        echo "Not find com]]></description><category></category></item><item><title><![CDATA[expect安装测试-自动登陆脚本]]></title><link>https://blog.youkuaiyun.com/a3470194/article/details/50523376</link><guid>https://blog.youkuaiyun.com/a3470194/article/details/50523376</guid><author>a3470194</author><pubDate>Fri, 15 Jan 2016 14:11:23 +0800</pubDate><description><![CDATA[安装：
yum list | grep expect

yum install expect







参考：http://www.cnblogs.com/iloveyoucc/archive/2012/05/11/2496433.html


[devops@p2p-haproxy hurl]$ cat ssh-18.sh 
#!/usr/expect/bin/]]></description><category></category></item><item><title><![CDATA[Linux批量生成生成帐户脚本,随机密码]]></title><link>https://blog.youkuaiyun.com/a3470194/article/details/50519599</link><guid>https://blog.youkuaiyun.com/a3470194/article/details/50519599</guid><author>a3470194</author><pubDate>Thu, 14 Jan 2016 18:32:12 +0800</pubDate><description><![CDATA[此脚本应用于生产环境下生成帐户，也可生成成百上千个密码相同的帐户。脚本代码如下:

批量生成：
#!/bin/bash
for name in tom jerry joe jane
do
      useradd $name
      pwd=`cat /dev/urandom | tr -dc "a-zA-Z0-9"|head -c6`
      echo -e "user:$nam]]></description><category></category></item><item><title><![CDATA[重回博客]]></title><link>https://blog.youkuaiyun.com/a3470194/article/details/50519158</link><guid>https://blog.youkuaiyun.com/a3470194/article/details/50519158</guid><author>a3470194</author><pubDate>Thu, 14 Jan 2016 17:29:38 +0800</pubDate><description><![CDATA[自从上次因为一件事情，而停止写技术博客，到现在已经有整整一年多了，从今天开始，重新坚持写博客，记录自己的学习经历。]]></description><category></category></item><item><title><![CDATA[Mongo-JS-导出数据为insert语句]]></title><link>https://blog.youkuaiyun.com/a3470194/article/details/41948455</link><guid>https://blog.youkuaiyun.com/a3470194/article/details/41948455</guid><author>a3470194</author><pubDate>Mon, 15 Dec 2014 20:11:45 +0800</pubDate><description><![CDATA[======2014-11-14 数据提取=======
[query@query-server hurl]$ cat test.sh
tlist=`cat ./username.txt`;
for i in $tlist
do
    TEMP_LIST=$i;
   # printf "$TEMP_LIST\n";


mongo --quiet localhost:2702]]></description><category></category></item><item><title><![CDATA[UE-JS举例]]></title><link>https://blog.youkuaiyun.com/a3470194/article/details/41948371</link><guid>https://blog.youkuaiyun.com/a3470194/article/details/41948371</guid><author>a3470194</author><pubDate>Mon, 15 Dec 2014 20:07:58 +0800</pubDate><description><![CDATA[=======UE-统计字符串个数=======

var str_f = UltraEdit.getString("What string do you want to find?",1);
UltraEdit.activeDocument.top(); //把光标移至文本的最顶端


//var str_f = "test";  //要搜索的字符串
var cnt1 = 0;]]></description><category></category></item><item><title><![CDATA[UE-Alex-js-20141125]]></title><link>https://blog.youkuaiyun.com/a3470194/article/details/41948279</link><guid>https://blog.youkuaiyun.com/a3470194/article/details/41948279</guid><author>a3470194</author><pubDate>Mon, 15 Dec 2014 20:03:37 +0800</pubDate><description><![CDATA[function Trim(str)
{
//把str首尾的空格去掉
  var temp1 = str.replace(/(^\s*)|(\s*$)/g, "");
  //把str首尾的单引号去掉
  var temp2 = temp1.replace(/(^'*)|('*$)/g, "");
  //把str首尾的双引号去掉
  var temp3 = temp2.replac]]></description><category></category></item><item><title><![CDATA[UE-行文-js-20141125]]></title><link>https://blog.youkuaiyun.com/a3470194/article/details/41948107</link><guid>https://blog.youkuaiyun.com/a3470194/article/details/41948107</guid><author>a3470194</author><pubDate>Mon, 15 Dec 2014 20:01:01 +0800</pubDate><description><![CDATA[function Trim(str)
{
//把str首尾的空格去掉
  var temp1 = str.replace(/(^\s*)|(\s*$)/g, "");
  //把str首尾的单引号去掉
  var temp2 = temp1.replace(/(^'*)|('*$)/g, "");
  //把str首尾的双引号去掉
  var temp3 = temp2.replac]]></description><category></category></item><item><title><![CDATA[Oracle VM VirtualBox使用的注意事项]]></title><link>https://blog.youkuaiyun.com/a3470194/article/details/38337837</link><guid>https://blog.youkuaiyun.com/a3470194/article/details/38337837</guid><author>a3470194</author><pubDate>Fri, 01 Aug 2014 15:54:22 +0800</pubDate><description><![CDATA[Oracle VM VirtualBox使用的注意事项
Oracle VM VirtualBox 上克隆虚拟机
方法一
1.复制源虚拟里的 vdi 文件到新的目录
2.命令行进入 Oracle VM VirtualBox 的安装目录
运行 vboxmanage internalcommands sethduuid 目标路径+新的 VDI 文件全名
* 必须进入安装目录下
这样给新的虚]]></description><category></category></item><item><title><![CDATA[aix-PV(逻辑卷)]]></title><link>https://blog.youkuaiyun.com/a3470194/article/details/34077297</link><guid>https://blog.youkuaiyun.com/a3470194/article/details/34077297</guid><author>a3470194</author><pubDate>Tue, 24 Jun 2014 10:12:02 +0800</pubDate><description><![CDATA[查看pv的位置
# lsdev -Cc disk
hdisk0 Available 01-08-00 SAS Disk Drive
hdisk1 Available 01-08-00 SAS Disk Drive
hdisk2 Available 04-09-01 MPIO DS5020 Disk
hdisk3 Available 04-09-01 MPIO DS5020 Disk
h]]></description><category></category></item><item><title><![CDATA[aix-逻辑卷和文件系统的关系]]></title><link>https://blog.youkuaiyun.com/a3470194/article/details/34076981</link><guid>https://blog.youkuaiyun.com/a3470194/article/details/34076981</guid><author>a3470194</author><pubDate>Tue, 24 Jun 2014 10:09:44 +0800</pubDate><description><![CDATA[逻辑卷上不创建文件系统，则可当作 raw device 用

创建文件系统可以选择在已经有的lv上，也可以让系统自动创建lv再格式化成文件系统。

resize 文件系统则 lv 就跟着一起resize了。
 
“逻辑卷”是“设备”，可以用命令“ls /dev”来查找创建的逻辑卷是否存在。
 
物理卷：一般一块硬盘对于一个系统中的物理卷，例外的是如果你做RAID，比如pdisk0,]]></description><category></category></item><item><title><![CDATA[aix_6.1_安装中文字符集]]></title><link>https://blog.youkuaiyun.com/a3470194/article/details/34075121</link><guid>https://blog.youkuaiyun.com/a3470194/article/details/34075121</guid><author>a3470194</author><pubDate>Tue, 24 Jun 2014 10:03:07 +0800</pubDate><description><![CDATA[AIX 6.1 有 2 张系统安装碟，安装中文字符集 UTF、GB***需要 2 张系统碟交替安装进行。
步骤一
在部署一些应用程序的时候， 有时候需要用到一些系统没有安装的字符集， 这时候就需要安
装字符集，具体方法如下:
1.查看操作系统当前字符集：
# locale
2.查看操作系统已安装字符集：
# locale -a
3.安装新字符集：
放入操作系统光盘：
4. 插入]]></description><category></category></item><item><title><![CDATA[mysql-5.5 for linux源码安装]]></title><link>https://blog.youkuaiyun.com/a3470194/article/details/33392873</link><guid>https://blog.youkuaiyun.com/a3470194/article/details/33392873</guid><author>a3470194</author><pubDate>Sun, 22 Jun 2014 21:34:48 +0800</pubDate><description><![CDATA[mysql-5.5 for linux源码安装
1.使用Yum安装依赖软件包
 
# yum install -y gcc gcc-c++ gcc-g77 autoconf automake bison zlib* fiex* \
libxml* ncurses-devel libmcrypt* libtool-ltdl-devel*
 
2.安装cmake
# yum instal]]></description><category></category></item></channel></rss>