Archive Post

Home / 数据库运维
zhangyunhao 0 comments

MySQL8 1396错误处理

Last_SQL_Errno: 1396 Last_SQL_Error: Coordinator stopped because there were error(s) in…
Read More
zhangyunhao 0 comments

MySQL8 2061错误的处理

Last_IO_Errno: 2061 Last_IO_Error: error connecting to master 'repl@210.14.75.1:3306' - retry-time:…
Read More
zhangyunhao 0 comments

mysql 执行sql替换操作

UPDATE wp_posts SET post_content = REPLACE(post_content, '旧字符', '新字符') WHERE post_type…
Read More
zhangyunhao 0 comments

MySQL8.0 执行脚本恢复报错@@GLOBAL.GTID_PURGED cannot be changed: the added gtid set must not overlap with @@

从线上 dump 出 sql 脚本，恢复到本地新建数据库报错。 在复制后执行sql导入数据库的时候，报错:@@GLOBAL.GTID_PURGED cannot be changed: the…
Read More
zhangyunhao 0 comments

MySQL中CHANGE REPLICATION FILTER 语句详解

以下列表显示了 CHANGE REPLICATION FILTER 选项及其与 --replicate-* 服务器选项的关系： REPLICATE_DO_DB：根据数据库名包含更新。相当于 --replicate-do-db。 REPLICATE_IGNORE_DB：根据数据库名排除更新。相当于…
Read More
zhangyunhao 0 comments

mysql 8同步问题的解决方案

问题一、 主从复制报错2061：Authentication plugin 'caching_sha2_password' reported error:Authentication require secure connection 原因：在MySQL8.0之前，身份验证的插件是mysql_native_password，在MySQL…
Read More
zhangyunhao 0 comments

mysql 5 同步问题解决方法

Last_IO_Error: The replication receiver thread cannot start because the master…
Read More
zhangyunhao 0 comments

docker 安装ms sqlserver

docker pull mcr.microsoft.com/mssql/server:2022-latest docker run -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=sun3@123" -e…
Read More
zhangyunhao 0 comments

oracle运维——安装11gR2

LANG=C;rpm -q binutils compat-libcap1 compat-libstdc++-33 gcc gcc-c++ glibc glibc-devel ksh…
Read More
zhangyunhao 0 comments

oracle运维——查看各种命中率和性能统计数据

1.buffer 命中率:select round((1-(physical.value-direct.value-lobs.value)/logical.value)*100,2) "buffer cache hit ratio" from v$sysstat physical,v$systat…
Read More