数据迁移mysql--sr

mysql-docker安装

docker run -itd \-p 3306:3306 \-v /home/mysql/conf:/etc/mysql/conf.d \-v /home/mysql/data:/var/lib/mysql \-v /home/mysql/log:/var/log/mysql \-e MYSQL_ROOT_PASSWORD=root \-e TZ=Asia/Shanghai \--name mysql5.6 \mysql:5.6/home/mysql/conf下先准备配置文件my.cof[mysqld]
#innodb_checksum_algorithm=innodb
#innodb_log_checksum_algorithm=innodb
innodb_data_file_path=ibdata1:12M:autoextend
innodb_log_files_in_group=4
innodb_log_file_size=1048576000
#innodb_fast_checksum=false
#innodb_page_size=16384
#innodb_log_block_size=512
innodb_undo_directory=.
innodb_undo_tablespaces=0
#redo_log_version=0
#server_uuid=b386e58f-b873-11ef-b5a2-9cc2c49ea427
#master_key_id=0
server_id=1                 
log_bin=mysql-bin            
binlog_format=ROW            
expire_logs_days=30           
sync_binlog=1                

 

 

恢复后的云数据库对root用户从新添加权限

容器内进入mysql

mysql -u root

 

修改root权限和密码，

 

-- 查看当前权限

SHOW GRANTS FOR 'root'@'localhost';

 

-- 按照输出的权限，给 root@% 同样授权

GRANT ALL PRIVILEGES ON . TO 'root'@'%' IDENTIFIED BY '你的密码' WITH GRANT OPTION;

FLUSH PRIVILEGES;

 

 

 

mysql数据备份恢复-xtrabackup

 

https://docs.percona.com/percona-xtrabackup/2.4/installation/yum_repo.html

 

https://cloud.tencent.com/document/product/236/33363

 

 

Starrocks-docker安装

 

version: "3.8"services:starrocks-fe:image: starrocks/fe-ubuntu:3.3.5hostname: starrocks-fecontainer_name: starrocks-feuser: rootcommand: |bash /opt/starrocks/fe/bin/start_fe.sh --host_type FQDNports:- 8030:8030   # HTTP UI- 9020:9020   # RPC- 9030:9030   # MySQL protocolnetworks:starrocks_net:volumes:- /data/starrocks/fe/conf:/opt/starrocks/fe/conf- /data/starrocks/fe/log:/opt/starrocks/fe/log- /data/starrocks/fe/meta:/opt/starrocks/fe/metahealthcheck:test: 'mysql -u root -h starrocks-fe -P 9030 -e "SHOW FRONTENDS\G" |grep "Alive: true"'interval: 10stimeout: 5sretries: 3starrocks-be:image: starrocks/be-ubuntu:3.3.5hostname: starrocks-becontainer_name: starrocks-beuser: rootcommand:- /bin/bash- -c- |ulimit -n 65535;echo "# Enable data cache"  >> /opt/starrocks/be/conf/be.confecho "block_cache_enable = true"  >> /opt/starrocks/be/conf/be.confecho "block_cache_mem_size = 536870912" >> /opt/starrocks/be/conf/be.confecho "block_cache_disk_size = 1073741824" >> /opt/starrocks/be/conf/be.confsleep 15smysql --connect-timeout 2 -h starrocks-fe -P 9030 -u root -e "ALTER SYSTEM ADD BACKEND \"starrocks-be:9050\";"bash /opt/starrocks/be/bin/start_be.shports:- 8040:8040depends_on:starrocks-fe:condition: service_healthyhealthcheck:test: 'mysql -u root -h starrocks-fe -P 9030 -e "SHOW BACKENDS\G" |grep "Alive: true"'interval: 10stimeout: 5sretries: 3networks:starrocks_net:volumes:- /data/starrocks/be/conf:/opt/starrocks/be/conf- /data/starrocks/be/log:/opt/starrocks/be/log- /data/starrocks/be/storage:/opt/starrocks/be/storagenetworks:starrocks_net:

先从容器中复制出对应的配置到组主机的配置文件夹。

 

修改be配置：设置主键长度

https://docs.starrocks.io/zh/docs/3.3/administration/management/BE_configuration/#primary_key_limit_size

 

docker compose up -d --wait --wait-timeout 400

 

 

 

 

 

clondcanal同步

 mysql源参数