【GP集群】基础性运维
摘要:greenplum 集群(1master 1standby master 6segments) 集群启动/关闭: gpstart -a ; gpstop -M fast 只关闭master节点: pg_ctl stop -s -m fast -D $MASTER_DATA_DIRECTORY或者 p
阅读全文
posted @
2021-12-30 20:32
HelonTian
阅读(215)
推荐(0) 编辑
【GP集群】搭建过程中,初始化过程记录
摘要:Greenplum集群初始化过程记录: [gpadmin@p0-ze-bdp-greenplum01 gpdb]$ gpinitsystem -c /gpdb/gphome/conf/gpinitsystem_config -h /gpdb/gphome/conf/hostlist -s p0-ze
阅读全文
posted @
2021-12-23 17:05
HelonTian
阅读(220)
推荐(0) 编辑
【MySQL备份恢复】innobackupex 备份过程
摘要:# innobackupex --user=root --password="root" --socket=/home/mysql/run/mysql.sock /tmpxtrabackup: recognized server arguments: xtrabackup: recognized c
阅读全文
posted @
2021-12-16 11:37
HelonTian
阅读(49)
推荐(0) 编辑
【MySQL管理】percona-toolkit工具
摘要:32个命令,可以分为7大类 一、pt-query-digest分析慢日志 $ mysql -uadmin -p -S /u01/mysql/run/mysql.sock -BNe "show variables like 'long_query_time';"Enter password: long
阅读全文
posted @
2021-12-08 15:37
HelonTian
阅读(55)
推荐(0) 编辑
【PgSQL extension】源码安装Pg,默认未安装postgres_fdw
摘要:$ psql -Vpsql (PostgreSQL) 12.3 安装postgres_fdw $ cd /usr/local/pgsql/contrib/$ ls |grep postgres_fdw/$ cd postgres_fdw/$ lsconnection.c deparse.c expe
阅读全文
posted @
2021-12-08 13:51
HelonTian
阅读(160)
推荐(0) 编辑
【MySQL备份恢复】innobackupex使用过程报错
摘要:$ innobackupex --user=admin --password="xxxxxx" --socket=/u01/mysql/run/mysql.sock /data/backup/xtrabackup: recognized server arguments: --datadir=/va
阅读全文
posted @
2021-12-06 10:50
HelonTian
阅读(1994)
推荐(0) 编辑
【MySQL管理】MySQL参数配置
摘要:[mysqld]#binlog configurationserver-id=1log-bin=/u01/mysql/logs/mysql-binbinlog_format=ROWbinlog_cache_size = 4Mmax_binlog_cache_size = 2Gmax_binlog_s
阅读全文
posted @
2021-12-05 16:54
HelonTian
阅读(70)
推荐(0) 编辑
【MySQL备份恢复】mydumper使用说明
摘要:mydumper -u admin -p 'xxx' -h 127.0.0.1 -P 27415 -C -c --trx-consistency-only -t 10 -o /data/49backup.20211203/ myloader -t 15 -v 3 -C -o -u admin -p
阅读全文
posted @
2021-12-05 16:36
HelonTian
阅读(36)
推荐(0) 编辑
【MySQL备份恢复】mydumper安装
摘要:# cat /etc/redhat-release Red Hat Enterprise Linux Server release 7.8 (Maipo) 安装MySQL数据库# yum install cmake[root@zedba mydumper-0.9.1]# cmake .-- The
阅读全文
posted @
2021-12-05 16:33
HelonTian
阅读(289)
推荐(0) 编辑
【PgSQL流复制管理】检测主备库复制状态
摘要:master: postgres=# select pid,usename,application_name,client_addr,client_port,backend_start,state,write_lsn,replay_lsn,sync_priority,sync_state from
阅读全文
posted @
2021-12-05 12:20
HelonTian
阅读(479)
推荐(0) 编辑