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-amd64cp node_exporter /usr/local/bin/启动exporternohup node_exporter &查看端口信息netstat -nltp 9100Active 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.zipunzip cloud-query-all-online-latest.zipcd 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=4932501504zxpredb.__java_pool_size=16777216zxpredb.__large_pool_size=16777216zxpredb.__shared_pool_size=3573547008zxpredb.__streams_pool_size=33554432*.audit_file_dest='/

原创 mongoDB 分片集群搭建

1.搭建环境OS：centos7mem：8G2.软件版本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/datavi /etc/mongodb.conf /opt/mongodb-linux-x86_64-3.2.4/bin/mongod -f /etc/mongodb.conf2.安装mmscd /opt/wget https://down.

原创 sqlt

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

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

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

原创 MAC Vmware Fusion+redhat +Oracle10gRAC

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