- 博客(32)
- 资源 (5)
- 收藏
- 关注
原创 redis 3.2 出现警告 [WARNING] Node 192.168.56.88:7001 has slots in importing state
os: ubuntu 16.04redis:3.2.11ruby:2.3.1redis cluster 3.2 在 set 时提示 (error) CLUSTERDOWN The cluster is down.# redis-cli -c -h 192.168.56.92 -p 7000192.168.56.92:7000> cluster nodes03c405d63a19b...
2019-03-29 16:56:42 3593 1
原创 redis cluster 4.0.9 之六: redis-trib.rb reshard
os: ubuntu 16.04redis:4.0.9ruby:2.4.4<<redis cluster 4.0.9 之四: redis-trib.rb add-node>> 添加好 master 和 slave 后,就要 reblance slots.redis-trib.rb reshard现在手动重新分配 slots# /usr/redis/redis-4...
2019-03-29 10:51:07 1233
原创 linux 如何使用 dd 命令
$ dd if=/dev/zero of=/tmp/1 bs=8192 count=1 conv=notrunc$ dd if=/dev/zero of=/tmp/2 bs=8192 seek=1 count=1 conv=notrunc更多详细的用法可以参考如下,比较详细https://www.cnblogs.com/jikexianfeng/p/6103500.htmlhttps...
2019-03-29 10:00:31 450
原创 pageinspect
os: ubuntu 16.04db: postgresql 9.6.11pageinspect 模块提供函数让你从低层次观察数据库页面的内容,这对于调试目的很有用。所有这些函数只能被超级用户使用。下载安装pageinspect 默认已经包含在 contrib 里了# su - postgres$ ls -l $PGHOME/lib |grep -i page-rwxr-xr-x 1...
2019-03-29 09:44:59 1435
原创 ubuntu 16.04 安装 mysql 的优化设置
os: ubuntu 16.04ubuntu 16.04 默认就是 mysql 5.7.采用二进制安装的会多些.apt# apt install zip unzip dos2unix pigz iftop git tree sysstat \cmake gcc g++ libreadline5 libreadline6 libreadline6-dev readline-common li...
2019-03-28 15:03:51 924
原创 redis 生成测试数据
redis cluster 只有 0号数据库.redis-cli debug# redis-cli -c -h 192.168.56.88 -p 7000127.0.0.1:7000> debug populate 10000或者# redis-cli -c -h 192.168.56.88 -p 7000 debug populate 10000shell# vi /...
2019-03-27 16:32:14 2017
原创 citus 之七 citus.enable_repartition_joins、citus.task_executor_type
os: ubuntu 16.04db: postgresql 9.6.8citus: 8.0citus 版本root@coor1:~# dpkg -l |grep -i citusii postgresql-9.6-citus 8.0.0.PGDG-1.pgdg16.04+1 amd64 shardin...
2019-03-25 16:25:49 705
原创 oracle 创建 temporary tablespace group
os: centos 7.4db: oracle 12.1.0.2oracle 可以对多个 temporary tablespace 包装成 temporary grouptemporary smallfile tablespace创建两个 temporary tablespace,在 orclpdb 下操作CREATE TEMPORARY TABLESPACE peiyb_temp01...
2019-03-19 16:21:41 778
原创 oracle 创建 undo tablespace
os: centos 7.4db: oracle 12.1.0.2permanent smallfile tablespaceselect 'alter database datafile '''||dt.file_name||''' autoextend on next 1g maxsize 30g; ', dt.*, dts.*from dba_data_...
2019-03-19 15:08:55 2378
原创 oracle 创建 temporary tablespace
os: centos 7.4db: oracle 12.1.0.2A bigfile tablespace contains only one data file or temp file, which can contain up to approximately 4 billion (2的32次方) blocks. The minimum size of the single data f...
2019-03-19 14:47:31 1954
原创 oracle 创建 permanent tablespace
os: centos 7.4db: oracle 12.1.0.2现在有 smallfile 和 bigfile 分类,详情可以参考 oracle 官方文档.smallfile 是 2 的 22 次方寻址,等于4M, 4M8K=32Gbigfile 是 2 的 32 次方寻址,等于4G, 4G8K=32Tpermanent smallfile tablespaceCREATE TABL...
2019-03-19 11:43:11 788
原创 oracle 使用 trigger 方式自动打开 pdb
os: centos 7.4db: oracle 12coracle 12c 关闭数据库,再打开始时,pdb模式是 mount 状态.这时需要使用命令打开,如下:SQL> alter pluggable database orclpdb open; 或者一次打开所有的pdb数据库SQL> alter pluggable database all open; 最好设置...
2019-03-18 14:52:53 724
原创 oracle 随机器启动的几种方式
oracle 随机器启动有几种方式/etc/rc.local单机 dbf 方式可以通过脚本启动#!/bin/bashsu - oracle -c &quot;lsnrctl start&quot;su - oracle -c &quot;sqlplus -S / as sysdba &amp;lt;&amp;lt; EOFstartup;exitEOF&quot;su
2019-03-18 10:32:03 448
原创 rhel/centos 创建用户
创建用户有时候需要在多个主机之间修改 group,user 的 id保持一致,比如oracle rac, postgreql stream replication 环境.# groupadd -g 10000 oinstall;groupadd -g 10001 dba;groupadd -g 10002 oper;groupadd -g 10003 asmadmin;groupadd...
2019-03-15 08:53:29 210
原创 postgresql 高可用 repmgr 的使用之十一 1 Primary + 3 Standby + 1 Witness
os: ubuntu 16.04db: postgresql 9.6.8repmgr: 4.2ip 规划如下192.168.56.94 witness1192.168.56.92 node1192.168.56.90 node2192.168.56.88 node3192.168.56.86 node41 Primary + 3 Standby + 1 W...
2019-03-14 17:25:42 1340 1
原创 ubuntu 16.04 安装 postgresql 的优化设置
os: ubuntu 16.04apt# apt install zip unzip dos2unix pigz iftop git tree sysstat \cmake gcc g++ libreadline5 libreadline6 libreadline6-dev readline-common libreadline-dev \python python-dev libldap...
2019-03-12 08:33:16 802
原创 ubuntu 16.04 + apt/make + postgresql 11 postgresql 10 postgresql9.6
os: ubuntu 16.04db: postgresql请参考 https://www.postgresql.org/download/linux/ubuntu/postgresql 11# ls -l /etc/apt/sources.list.d/pgdg.list# echo &amp;amp;amp;amp;quot;deb http://apt.postgresql.org/pub/repos/apt/ xenia...
2019-03-11 14:23:57 1126
原创 mysql 高可用架构 mha 之六 setup on ubuntu 16.04
os: ubuntu 16.04db: mysql 5.7.25mha: 0.58192.168.56.92 mnode1 #mha manager192.168.56.90 node1 #master192.168.56.88 node2 #slave192.168.56.86 node3 #slaveVIP = 192.168.56.100mha node 节点: ...
2019-03-08 15:42:51 1351
原创 mysql 高可用架构 mha 之五 Undefined subroutine &main::FIXME_xxx called at power_manage
os: ubuntu 16.04db: mysql 5.7.25mha: 0.58做 masterha_check_repl 时,提示错误# masterha_check_repl --conf=/etc/masterha/app1/app1.cnfFri Mar 8 15:02:58 2019 - [info] Checking shutdown script status:Fr...
2019-03-08 15:33:02 1609
原创 mysql 高可用架构 mha 之四 Error happened on checking configurations
os: ubuntu 16.04db: mysql 5.7.25mha: 0.58使用 masterha_check_repl 时一直报错Fri Mar 8 11:31:30 2019 - [error][/usr/share/perl5/MHA/MasterMonitor.pm, ln427] Error happened on checking configurations. Red...
2019-03-08 11:39:12 4245 1
原创 mysql 5.7 启动是提示 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated
os: ubuntu 16.04db: mysql 5.7.252019-03-06T03:27:26.404335Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documenta...
2019-03-06 11:37:02 22499
原创 TiDB的一些网址信息
https://www.pingcap.com/https://github.com/pingcap/tidbhttps://zhuanlan.zhihu.com/newsqlhttps://cloud.tencent.com/developer/news/206280https://www.v2ex.com/t/508094
2019-03-06 08:46:09 481
原创 mysql 5.7 开始使用 mysqld --initialize 初始化数据库
os: ubuntu 16.04db: mysql 5.7.25mysql_install_db is deprecated as of MySQL 5.7.6 because its functionality has been integrated into mysqld, the MySQL server. To initialize a MySQL installation, invo...
2019-03-05 19:28:55 29009
原创 mysql 5.7 使用 xtrabackup 添加新的slave
os: ubuntu 16.04db: mysql 5.7.25规划如下:192.168.56.92 node1 # mysql master192.168.56.90 node2 # mysql slave192.168.56.88 node3 # mysql slave添加一个新的salve 节点 node4192.168.56.86 node4 # mysql slave...
2019-03-05 19:07:34 382
原创 percona xtrabackup 之四 备份脚本
os: ubuntu 16.04db: mysql 5.7.25xtrabackup: percona-xtrabackup-24_2.4.13percona-xtrabackup-24_2.4.13# cd ~# wget https://www.percona.com/downloads/Percona-XtraBackup-2.4/Percona-XtraBackup-2.4.13...
2019-03-05 14:01:02 412
原创 mysql 5.7 group replication 之六 multi primary 模式 add node
os: ubuntu 16.04db: mysql 5.7.25规划如下:192.168.56.92 node1 # mysql192.168.56.90 node2 # mysql192.168.56.88 node3 # mysql现在添加两个节点192.168.56.86 node4 # mysql192.168.56.84 node5 # mysql不重启的情况下...
2019-03-04 11:23:42 315
原创 mysql 5.7 group replication 之五 [ERROR] Plugin group_replication reported: 'Table tmp_t0 does not hav
os: ubuntu 16.04db: mysql 5.7.25规划如下:192.168.56.92 node1 # mysql192.168.56.90 node2 # mysql192.168.56.88 node3 # mysql标题显示不全[ERROR] Plugin group_replication reported: ‘Table tmp_t0 does not h...
2019-03-04 10:01:09 961
原创 mysql 5.7 group replication 之四 [ERROR] Plugin group_replication reported: 'Member was expelled from
os: ubuntu 16.04db: mysql 5.7.25规划如下:192.168.56.92 node1 # mysql192.168.56.90 node2 # mysql192.168.56.88 node3 # mysql标题显示不全[ERROR] Plugin group_replication reported: ‘Member was expelled fro...
2019-03-04 09:59:33 6461 1
原创 mysql 5.7 group replication 之三 ERROR 3092 (HY000): The server is not configured properly to be an ac
os: ubuntu 16.04db: mysql 5.7.25规划如下:192.168.56.92 node1 # mysql192.168.56.90 node2 # mysql192.168.56.88 node3 # mysql对 multi primary 模式的三台虚拟机做了掉电重启,发现mysql 启动后,group replication 不正常.ERROR 30...
2019-03-01 16:48:49 16240
原创 mysql 5.7 group replication 之二 multi primary
os: ubuntu 16.04db: mysql 5.7.25规划如下:192.168.56.92 node1 # mysql192.168.56.90 node2 # mysql192.168.56.88 node3 # mysql基本参考 &amp;amp;lt;&amp;amp;lt;mysql 5.7 group replication 之一 single primary&amp;amp;gt;&amp
2019-03-01 15:14:56 229
原创 mysql 5.7 group replication 之一 single primary
os: ubuntu 16.04db: mysql 5.7.25规划如下:192.168.56.92 node1 # mysql192.168.56.90 node2 # mysql192.168.56.88 node3 # mysqlmysql 在5.7.17中引入了一个全新的技术,称之为 InnoDB Group Replication。目前官方MySQL 5.7.17基于Gr...
2019-03-01 14:33:24 367
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人