xiaoenxiaoen的专栏

原创 prometheus 监控MySQL数据库

1、MySQL数据库安装exporter 安装mysqld_exporter 由于mysqld_exporter需要连接到MySQL，创建用户并赋予所需的权限 GRANT REPLICATION CLIENT,PROCESS ON *.* TO 'mysql_monitor'@'localhost' identified by 'mysql_monitor'; GRANT SELECT ON *.* TO 'mysql_monitor'@'localhost'; 修改配置文件 [client]

原创 prometheus 监控linux主机

1、配置node节点 tar -zxvf node_exporter-1.0.1.linux-amd64.tar.gz cd node_exporter-1.0.1.linux-amd64 cp node_exporter /usr/local/bin/ 启动exporter nohup node_exporter & 查看端口信息 netstat -nltp 9100 Active Internet connections (only servers) Proto Recv-Q

原创 开源的数据库监控平台

原创 可替代阿里云DMS的cloudquery

1、安装部署 可在线安装 wget https://cloudquery-community-onilne-1253210854.cos.ap-shanghai.myqcloud.com/cloud-query-all-online-latest.zip unzip cloud-query-all-online-latest.zip cd cloudquery-all/ chmod +x cloudquery-community.sh ./cloudquery-community.sh insta

原创 ProxySQL

wget https://github.com/sysown/proxysql/releases/download/v2.0.13/proxysql-2.0.13-1-centos7.x86_64.rpm [root@mysqldb2 ~]# rpm -ivh proxysql-2.0.13-1-centos7.x86_64.rpm warning: proxysql-2.0.13-1-centos7.x86_64.rpm: Header V4 RSA/SHA256 Signature, key...

原创 mysql5.7-centos7-MHA部署

1、实验环境介绍 OS：CentOS Linux release 7.6.1810 (Core) db:5.7.30 MySQL Community Server (GPL) ip hostname 172.168.1.178 mysqldb1 master Node 172.168.1.179 mysqldb2 slave1 Node 172.168.1.180 mysqldb3 slave2 ...

原创 Oracle 10g 手动建库（非dbca）

1.写参数文件 [oracle@oracle-s001 dbs]$ cat initzxpredb.ora zxpredb.__db_cache_size=4932501504 zxpredb.__java_pool_size=16777216 zxpredb.__large_pool_size=16777216 zxpredb.__shared_pool_size=3573547008 zxpredb.__streams_pool_size=33554432 *.audit_file_dest='/

原创 mongoDB 分片集群搭建

1.搭建环境 OS：centos7 mem：8G 2.软件版本 mongodb-linux-x86_64-3.2.22 端口规划 ip port mongos 127.0.0.1 28017 config 镜像 127.0.0.1 28018 镜像 127.0.0.1 28019 镜像 127.0.0.1 28020 shard1 p 127.0.0.1 28021 ...

原创 mongoDB Ops Manager

1.安装mongo库 tar -zxvf mongodb-linux-x86_64-3.2.4.tgz mkdir -p /data/mongodbdata_config/logs/ mkdir -p /data/mongodbdata_config/data vi /etc/mongodb.conf /opt/mongodb-linux-x86_64-3.2.4/bin/mongod -f /etc/mongodb.conf 2.安装mms cd /opt/ wget https://down.

原创 sqlt

Install SQLT https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=g9m3m73u5_9&_afrLoop=16958946259376 sqlplus / as sysdba SQL> create tablespace SQLT datafile '/u01/app/oracle/oradata/dsidb/sqlt01.dbf' size 50M; SQL> cre..

原创 完全显示crs_stat命令结果中的列

现状如下 [grid@rac2 ~]$ crs_stat -t Name Type Target State Host ------------------------------------------------------------ ora....SM1.asm application ONLINE ONLINE rac1 ora....C1.lsnr application ONLIN

原创 MAC Vmware Fusion+redhat +Oracle10gRAC

环境配置 虚拟机共享磁盘 更改虚拟机源文件 #shared disks configure disk.locking="false" diskLib.dataCacheMaxSize="0" diskLib.dataCacheMaxReadAheadSize="0" diskLib.DataCacheMinReadAheadSize="0" diskLib.dataCachePageSize="4096" diskLib.maxUnsyncedWrites="0" scsi0:1.d.