【MySQL Shell】MySQL Shell体验
摘要:二进制包下载:https://downloads.mysql.com/archives/shell/ Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> select user,h
阅读全文
posted @
2022-03-29 14:36
HelonTian
阅读(212)
推荐(0) 编辑
【GP集群重启报错】could not create semaphores: No space left on device","Failed system call was semget
摘要:20220327:15:52:00:032027 gprecoverseg:t3-tkhibdp-bdp-gp01:gpadmin-[INFO]:-Process results...20220327:15:52:00:032027 gprecoverseg:t3-tkhibdp-bdp-gp01:
阅读全文
posted @
2022-03-27 15:59
HelonTian
阅读(377)
推荐(0) 编辑
【MySQL架构】4T数据量MySQL数据库,利用slave1搭建slave2
摘要:MySQL数据库在一主一从架构下,搭建从库 利用从库1搭建从库2 1、从库2,起实例,3306端口 2、从库1,停止sql_thread线程。mysql>stop slave sql_thread; 3、将从库1的数据目录拷贝至从库2,替换到从库2的datadir 4、修改从库2 my.cnf文件,
阅读全文
posted @
2022-03-22 10:57
HelonTian
阅读(82)
推荐(0) 编辑
【MySQL8】参数文件my.cnf
摘要:[client]port = 3306socket = /u01/mysql_3306/tmp/mysql.sockmysqlx_socket = /data/mysql_3306/tmp/mysqlx.sock[mysql]#prompt="\u@mysql8 \R:\m:\s [\d]> "no
阅读全文
posted @
2022-03-21 16:08
HelonTian
阅读(722)
推荐(0) 编辑
【MySQL8】ERROR 2059 (HY000): Authentication plugin 'caching_sha2_password' cannot be loaded:
摘要:mysql8.0.24初始化,并启动数据库实例之后,登录mysql shell提示报错 $ mysql -uroot -p'xxx' -S /data/mysql_3308/tmp/mysql.sockmysql: [Warning] Using a password on the command
阅读全文
posted @
2022-03-21 15:51
HelonTian
阅读(560)
推荐(0) 编辑
【TiDB迁移】导出工具dumpling 导入工具TiDB Lightning
摘要:导出单个表: ./tidb-toolkit-v5.4.0-linux-amd64/bin/dumpling -uroot -proot -P4000 -h10.172.32.101 --filetype sql -t 8 -o /home/tidb -r 200000 -F 256MiB -T sa
阅读全文
posted @
2022-03-16 16:46
HelonTian
阅读(93)
推荐(0) 编辑
【PgSQL流复制管理】搭建备库过程错误记录
摘要:postgresql版本:12.3 搭建流复制备份的记录: $ /usr/local/pgsql/bin/pg_basebackup -h p0-primary -p 5432 -U repuser -w -Fp -Xs -Pv -R -D /data/pgsql_5432/pgdata/pg_ba
阅读全文
posted @
2022-03-11 08:57
HelonTian
阅读(807)
推荐(0) 编辑