mongodb从库的登陆执行命令不用每次输入slaveOk
从库执行命令提示找不到masterError: listDatabases failed:{ "note" : "from execCommand", "ok" : 0, "errmsg" : "not master" }解决办法:rs.slaveOk()要想不用每次输入该命令,可以修改如下文件-bash-4.2$ find / -name .mongorc.js./.mongorc.js在文件里面添加一行:rs.slaveOk();一般这个文件都是空的,直接加...
单节点的es添加另外一个节点组成主从集群
环境:OS:Centos 7DB:6.5.0192.168.1.135:19200 现有的单节点192.168.1.134:19200 准备新添加的节点--------新节点(192.168.1.134)安装es---------------1.安装跟现有版本一致的es我这里的版本是6.5.0[root@localhost hxlmiao]# tar -xvf elasticsearch-6.5.0.tar.gz[root@localhost hxlmiao]# mv elasticsearc...
ssdb双主部署
-------------ssdb双主部署---------------------------环境:OS: centos7ip:192.168.1.134192.168.1.135-------------------下面先在192.168.1.134上面安装----------------------------1.下载安装介质[root@localhost soft]# wget --no-check-certificate https://github.com/ideawu/ssdb/archive/master.zip...
threaded_execution参数开启的情况下导致ogg无法注册
GGSCI (localhost.localdomain as c##goldengate@ora12c/CDB$ROOT) 59> dblogin userid c##goldengate, password goldengateSuccessfully logged into database CDB$ROOT.GGSCI (localhost.localdomain as c##goldengate@ora12c/CDB$ROOT) 60> register extract ext database container (ora12cpdb1)2019-08-19 09:4...
cratedb备份迁移到新的机器
1.在原主机上进行备份create repository mysnapdata type fs with (location='/cratedb/snapdata', compress=true);注意这里的location='/cratedb/snapdata',需要在cratedb的配置文件(crate.yml)参照中指定,如下path.repo: /cratedb/snapdata创建快照create snapshot mysnapdata.snapshot_all0815 all with (wait_fo...
cratedb备份和恢复
1.修改参数文件-bash-4.2$ cd /cratedb/crate-3.2.0/configvi crate.yml 修改如下项path.repo: /cratedb/snapdata2.创建目录mkdir -p /cratedb/snapdata3.创建仓库mysnapdatacreate repository mysnapdata type fs with (location='/cratedb/snapdata', compress=true);4.创建快照create snapshot mysnapdata...
es备份迁移到另外的机器
1.在原来的机器上进行备份(我这里备份只保留2天,所以多了些处理脚本)##创建备份仓库目录curl -H "Content-Type: application/json" -XPUT http://192.168.1.136:19200/_snapshot/esbackup -d'{ "type": "fs", "settings": { "location": "/home/yeemiao/...
双从循环例子
#!/bin/bashnow_date=`date +%Y%m%d%H:%m:%s`cd /home/oracle/go_programnow_date=`date +%Y%m%d%H:%m:%s`cd /home/oracle/go_programip_list=(192.168.1.22 192.168.1.113 192.168.1.130 192.168.1.131 192.168.1.8 192.168...
获取rds的cpu和内存使用情况
python版本:2.7.12 点击(此处)折叠或打开#!/usr/bin/env python#coding=utf-8import timeimport os, json, urllib, datetime, shutilfrom aliyunsdkcore.client import AcsClientfrom aliyunsdkcore.acs_ex...