04 2020 档案
摘要:grant select, reload, lock tables, replication client, show view, trigger on *.* to 'dbdumpuser'@'%' identified by 'aaaa#DumpData';
阅读全文
摘要:环境: OS:Centos 7 1.先安装好mysql5.6安装步骤情参考http://blog.chinaunix.net/uid-77311-id-5756583.html2.从阿里云rds下载备份集我这里下载的备份集如下:hins12503237_data_20200425055654_qp.
阅读全文
摘要:环境: OS:Centos 7 DB:12.2.0.1 准备任务:查看当前的WALLET_TYPE类型,若是自动登录类型的,需要将其修改为PASSWORD类型首先查看当前的钱包类型SQL> select * from v$encryption_wallet;WRL_TYPE WRL_PARAMETE
阅读全文
摘要:环境: OS:Centos DB:mysql 5.7 1.获取到安全审计插件可以下载mariadb后,解压找到server_audit.so我这里下载的mariadb版本是10.42.将server_audit.so 拷贝到mysql插件的路径下[root@localhost plugin]#cp
阅读全文
摘要:环境: mysql5.6 1.主库开启gtidgtid_mode=ONenforce_gtid_consistency=ONlog_slave_updates=12.发现从库报错误Last_IO_Error: The slave IO thread stops because the master
阅读全文
摘要:环境: OS:Centos 7 DB:18.0.0.0 禁用 1.停掉每个节点的crsRun "crsctl stop crs" on all nodes to stop CRS stack.2.关闭HAIPOn one node, run the following commands:在一个节点上
阅读全文
摘要:场景:模拟节点2=host02上的vip故障漂移到节点1=host01后,手工切换回到节点2=host021.查看资源情况[grid@host02 ~]$ crsctl stat res -t Name Target State Server State details Local Resource
阅读全文
摘要:1.查看mgmt在那个节点上运行su - grid[grid@host01 ~]$ oclumon manage -get masterMaster = host012.查看状态[grid@host01 ~]$ srvctl status mgmtdbDatabase is enabledInsta
阅读全文