- 综合排序
- 最热优先
- 最新优先
- 来自专栏技术杂记
mysql 迁移6
myisam_recover_options [testuser@slave01 etc]$ innodb_additional_mem_pool_size 也已经被弃用了,如果有要注释掉 ---- 将zabbit加入mysql 组以方便监控 [root@new-master mysql]# vim /etc/group [root@new-master mysql]# id zabbix uid=496(zabbix) gid =493(zabbix) groups=493(zabbix),492(mysql) [root@new-master mysql]# /etc/init.d/zabbix-agent restart ]# ---------- [root@zabbix-server ~]# zabbix_get -s new-master -p 10050 -k "mysql.slowlog[100,/var/lib /mysql/new-master-slow.log]" 2.98465 [root@zabbix-server ~]#
2.2K20编辑于 2022-03-21 - 来自专栏技术杂记
mysql 迁移6
myisam_recover_options [testuser@slave01 etc]$ innodb_additional_mem_pool_size 也已经被弃用了,如果有要注释掉 ---- 将zabbit加入mysql 组以方便监控 [root@new-master mysql]# vim /etc/group [root@new-master mysql]# id zabbix uid=496(zabbix) gid =493(zabbix) groups=493(zabbix),492(mysql) [root@new-master mysql]# /etc/init.d/zabbix-agent restart ]# ---------- [root@zabbix-server ~]# zabbix_get -s new-master -p 10050 -k "mysql.slowlog[100,/var/lib /mysql/new-master-slow.log]" 2.98465 [root@zabbix-server ~]#
1.9K50编辑于 2022-03-22 - 来自专栏技术杂记
mysql 迁移
前言 有了keepalived和mysql upgrade的技术作基础，可以结合两者完成无逢升级 下面分享一下我的 Best Practice Of Mysql Migration ---- 概要 -- -- 准备工作 下面步骤最好作为准备工作，提前完成，这样可以更有效进行切换，和减少窗口期 挂载NFS 安装软件包的收集(mysql,xtrabackup,keepalived) 安装keepalived Installed: nfs-utils.x86_64 1:1.2.3-64.el6 rpcbind.x86_64 0:0.2.0-11.el6 _64 0:1.4.13-4.el6 libgssglue.x86_64 0:0.1-11.el6 libtirpc.x86_64 0:0.2.1-10.el6 nfs-utils-lib.x86_64 0:1.1.5-11.el6 python-argparse.noarch 0:1.2.1-2.1.el6 Dependency Updated
3.5K30编辑于 2022-03-22 - 来自专栏技术杂记
mysql 迁移
前言 有了keepalived和mysql upgrade的技术作基础，可以结合两者完成无逢升级 下面分享一下我的 Best Practice Of Mysql Migration ---- 概要 -- -- 准备工作 下面步骤最好作为准备工作，提前完成，这样可以更有效进行切换，和减少窗口期 挂载NFS 安装软件包的收集(mysql,xtrabackup,keepalived) 安装keepalived Installed: nfs-utils.x86_64 1:1.2.3-64.el6 rpcbind.x86_64 0:0.2.0-11.el6 _64 0:1.4.13-4.el6 libgssglue.x86_64 0:0.1-11.el6 libtirpc.x86_64 0:0.2.1-10.el6 nfs-utils-lib.x86_64 0:1.1.5-11.el6 python-argparse.noarch 0:1.2.1-2.1.el6 Dependency Updated
3.4K20编辑于 2022-03-21 - 来自专栏云同步
MySQL 迁移 dm
参考链接 此处为语雀内容卡片，点击链接查看：MySQL 5.7.27 迁移 DM 8 · 语雀 迁移前准备 以下中的命名，密码都是可修改的，这里给出的就只是一个例子 创建表空间 # 创建表空间名为 dbTest tablespace "dbTest"; 授予权限 -- 授予用户 dbTest 常规权限 grant "PUBLIC","RESOURCE","SOI","SVI","VTI" to "dbTest"; 迁移 1）打开 dm 数据迁移工具 2）点击新建迁移 3）选择迁移方式 4）源数据库连接（mysql） 5）目的数据库连接（dm数据库） 6）选择迁移选项 保持对象名大小写：看情况选择，如果是大小写不敏感可以直接勾选 ，比如 列超出定义 7）勾选需要迁移的数据库 建议 目的模式 改为全大写，还是尽量 用户名，模式名 全大写并且一致 8）勾选要迁移的表 9）迁移 迁移问题 列长度超出定义 问题 解决 1） 第一种：扩大字段的长度，例如：1.5倍 2）第二种（适用于 mysql 中 varchar 字段）：将 varchar 的字段类型替换成 nvarchar 步骤 在指定表页面中，选中出问题的表，点击转换
54710编辑于 2025-08-01 - 来自专栏技术杂记
mysql 迁移9
要确保mysql 数据库的 datadir是清空的，否则会报错 [root@slave02 data]# cat restore.log nohup: ignoring input Warning: /usr/bin/innobackupex version 2.3.2 based on MySQL server 5.6.24 Linux (x86_64) (revision id: 306a2e0 ) Original data directory /var/lib/mysql is not empty! ) Original data directory /var/lib/mysql is not empty! 开头的文件 如： .bash_history .lesshst .mysql_history .viminfo 要指明删，如 rm -rf .bash_history .lesshst .mysql_history
2.1K20编辑于 2022-03-22 - 来自专栏技术杂记
mysql 迁移1
新版master上安装并启动keepalived 安装并启动keepalived [root@new-master ~]# yum -y install keepalived.x86_64 ... ... [root@new-master ~]# cd /etc/keepalived/ [root@new-master keepalived]# cp keepalived.conf keepalived.conf.bak.201512xx [root@new-master keepalived]# > k
2.7K20编辑于 2022-03-21 - 来自专栏技术杂记
mysql 迁移7
修改zabbix统计数据过期时间 [root@new-master mysql]# vim /var/lib/zabbix/percona/scripts/get_mysql_stats_wrapper.sh x86_64 has missing requires of libmysqlclient_r.so.16()(64bit) perl-DBD-MySQL-4.013-3.el6.x86_64 has of libmysqlclient.so.16(libmysqlclient_16)(64bit) php-mysql-5.3.3-40.el6_6.x86_64 has missing requires of libmysqlclient.so.16()(64bit) php-mysql-5.3.3-40.el6_6.x86_64 has missing requires of libmysqlclient.so _16)(64bit) 2:postfix-2.6.6-6.el6_5.x86_64 has missing requires of mysql-libs sysbench-0.4.12-5.el6.x86
2K30编辑于 2022-03-22 - 来自专栏技术杂记
mysql 迁移9
要确保mysql 数据库的 datadir是清空的，否则会报错 [root@slave02 data]# cat restore.log nohup: ignoring input Warning: /usr/bin/innobackupex version 2.3.2 based on MySQL server 5.6.24 Linux (x86_64) (revision id: 306a2e0 ) Original data directory /var/lib/mysql is not empty! ) Original data directory /var/lib/mysql is not empty! 开头的文件 如： .bash_history .lesshst .mysql_history .viminfo 要指明删，如 rm -rf .bash_history .lesshst .mysql_history
2.2K20编辑于 2022-03-21 - 来自专栏技术杂记
mysql 迁移2
新版master上安装并启动keepalived 安装并启动keepalived [root@new-master ~]# yum -y install keepalived.x86_64 ... ... [root@new-master ~]# cd /etc/keepalived/ [root@new-master keepalived]# cp keepalived.conf keepalived.conf.bak.201512xx [root@new-master keepalived]# > k
2.5K40编辑于 2022-03-22 - 来自专栏技术杂记
mysql 迁移7
修改zabbix统计数据过期时间 [root@new-master mysql]# vim /var/lib/zabbix/percona/scripts/get_mysql_stats_wrapper.sh x86_64 has missing requires of libmysqlclient_r.so.16()(64bit) perl-DBD-MySQL-4.013-3.el6.x86_64 has of libmysqlclient.so.16(libmysqlclient_16)(64bit) php-mysql-5.3.3-40.el6_6.x86_64 has missing requires of libmysqlclient.so.16()(64bit) php-mysql-5.3.3-40.el6_6.x86_64 has missing requires of libmysqlclient.so _16)(64bit) 2:postfix-2.6.6-6.el6_5.x86_64 has missing requires of mysql-libs sysbench-0.4.12-5.el6.x86
2.3K20编辑于 2022-03-21 - 来自专栏技术杂记
mysql 迁移10
]# chown -R mysql.mysql /var/lib/mysql/ [root@slave02 mysql]# ll total 5916780 drwx------ 2 mysql mysql ---- 2 mysql mysql 36864 Dec 9 03:57 mysqltestt_db drwx------ 2 mysql mysql 4096 Dec 9 03 drwx------ 2 mysql mysql 4096 Dec 9 02:52 ijavadb drwx------ 2 mysql mysql 12288 Dec 9 4096 Dec 9 02:45 mysql drwx------ 2 mysql mysql 4096 Dec 9 02:49 testdb drwx------ 2 mysql mysql mysql mysql 20480 Dec 9 03:08 /data/mysql/ [root@slave02 mysql]#
2.9K20编辑于 2022-03-22 - 来自专栏技术杂记
mysql 迁移4
[root@slave01 data]# cd /var/lib/mysql/ [root@slave01 mysql]# ls livedb slave01-relay-bin.000308 javadb ijavadb mysql-bin.000154 mysql-bin.000159 relay-log.info backup-my.cnf slave01-relay-bin .000309 ibdata1 wavedb mysql-bin.000155 mysql-bin.000160 functiondb mysqltest_his slave01 -relay-bin.index ib_logfile0 master.info mysql-bin.000156 mysql-bin.index test mysqltestt_db ib_logfile2 mysql mysql-bin.000158 keydb [root@slave01 mysql]# rm -rf * [root@slave01 mysql
2.1K30编辑于 2022-03-22 - 来自专栏技术杂记
mysql 迁移8
innobackupex: Backup created in directory '/data/nfs/test_full_backup/2015-12-09_00-53-03' innobackupex: MySQL binlog position: filename 'mysql-bin.000004', position 8299670 151209 02:06:09 innobackupex: Connection real 73m8.390s user 6m33.032s sys 7m44.089s [1]+ Done time nohup /usr/bin/innobackupex
2K20编辑于 2022-03-22 - 来自专栏技术杂记
mysql 迁移11
启动mysql并且开启同步 [root@slave02 mysql]# mysql -u root -p Enter password: Welcome to the MySQL monitor. .rhel6.x86_64 --nodeps wget http://mirror.centos.org/centos/6/os/x86_64/Packages/numactl-2.0.9-2.el6. x86_64.rpm rpm -ivh numactl-2.0.9-2.el6.x86_64.rpm rpm -ivh Percona-Server-client-56-5.6.27-rel75.0.el6 /get_mysql_stats_wrapper.sh yum install libev rpm -e xtrabackup-1.6.7-356.rhel6.x86_64 rpm -ivh percona-xtrabackup / cat xtrabackup_binlog_pos_innodb chown -R mysql.mysql /var/lib/mysql/ 原文地址
1.3K20编辑于 2022-03-22 - 来自专栏技术杂记
mysql 迁移11
启动mysql并且开启同步 [root@slave02 mysql]# mysql -u root -p Enter password: Welcome to the MySQL monitor. 8bb53b6 Copyright (c) 2009-2015 Percona LLC and/or its affiliates Copyright (c) 2000, 2015, Oracle Replicate_Ignore_Server_Ids: Master_Server_Id: 10 Master_UUID: a6f64eac Replicate_Ignore_Server_Ids: Master_Server_Id: 10 Master_UUID: a6f64eac hostname slave02 mysql>
1.5K30编辑于 2022-03-22 - 来自专栏技术杂记
mysql 迁移12
.rhel6.x86_64 --nodeps wget http://mirror.centos.org/centos/6/os/x86_64/Packages/numactl-2.0.9-2.el6. x86_64.rpm rpm -ivh numactl-2.0.9-2.el6.x86_64.rpm rpm -ivh Percona-Server-client-56-5.6.27-rel75.0.el6 restart zabbix_get -s new-master -p 10050 -k "mysql.slowlog[100,/var/lib/mysql/new-master-slow.log]" /get_mysql_stats_wrapper.sh yum install libev rpm -e xtrabackup-1.6.7-356.rhel6.x86_64 rpm -ivh percona-xtrabackup / cat xtrabackup_binlog_pos_innodb chown -R mysql.mysql /var/lib/mysql/ 原文地址
1.4K30编辑于 2022-03-22 - 来自专栏技术杂记
mysql 迁移5
更新slave mysql版本 [root@slave02 src]# rpm -e Percona-Server-client-51-5.1.73-rel14.11.603.rhel6.x86_64 .rhel6.x86_64 error: Failed dependencies: mysql is needed by (installed) xtrabackup-1.6.7-356.rhel6 .16()(64bit) is needed by (installed) perl-DBD-MySQL-4.013-3.el6.x86_64 libmysqlclient.so.16()(64bit ) is needed by (installed) php-mysql-5.3.3-40.el6_6.x86_64 libmysqlclient.so.16(libmysqlclient_16)(64bit (64bit) is needed by (installed) php-mysql-5.3.3-40.el6_6.x86_64 libmysqlclient_r.so.16()(64bit) is
1.4K40编辑于 2022-03-22 - 来自专栏技术杂记
mysql 迁移2
[mysql@slave02 bin]$ ps faux | grep manager mysql 27192 0.0 0.0 103244 864 pts/2 S+ 00:23 link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00 inet 127.0.0.1/8 scope host lo inet6 7c:78 brd ff:ff:ff:ff:ff:ff inet 192.168.66.123/24 brd 192.168.66.255 scope global eth0 inet6 link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00 inet 127.0.0.1/8 scope host lo inet6 7c:78 brd ff:ff:ff:ff:ff:ff inet 192.168.66.123/24 brd 192.168.66.255 scope global eth0 inet6
76620编辑于 2022-03-21 - 来自专栏技术杂记
mysql 迁移10
]# chown -R mysql.mysql /var/lib/mysql/ [root@slave02 mysql]# ll total 5916780 drwx------ 2 mysql mysql ---- 2 mysql mysql 36864 Dec 9 03:57 mysqltestt_db drwx------ 2 mysql mysql 4096 Dec 9 03 drwx------ 2 mysql mysql 4096 Dec 9 02:52 ijavadb drwx------ 2 mysql mysql 12288 Dec 9 4096 Dec 9 02:45 mysql drwx------ 2 mysql mysql 4096 Dec 9 02:49 testdb drwx------ 2 mysql mysql mysql mysql 20480 Dec 9 03:08 /data/mysql/ [root@slave02 mysql]#
65730编辑于 2022-03-22
腾讯云开发者
Copyright © 2013 - 2026 Tencent Cloud. All Rights Reserved. 腾讯云 版权所有
深圳市腾讯计算机系统有限公司 ICP备案/许可证号：粤B2-20090059 
粤公网安备44030502008569号
腾讯云计算（北京）有限责任公司 京ICP证150476号 | 京ICP备11018762号