[err]ORA-00942:table or view does not exist
将一张的数据插入另外一张新表时,手动建表可能会出现的这个错误。
新建表用create table table1 as SELECT id,memo from table2
mybatis foreach 报错,sql语句过长。
需要在配置加上&allowMultiQueries=true
docker run -p 33060:3306 --name mysql -v /root/mysql/conf:/etc/mysql/conf.d -v /root/mysql/logs:/logs -v /root/mysql/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=root -d mysql:5.7
use mysql;
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'root';
FLUSH PRIVILEGES;
select user,host from user;
SHOW VARIABLES LIKE 'log_bin';
主数据库打开binlog
配置文件
server-id=1
log_bin=/var/log/mysql/mysql-bin.log
log-bin=master-bin
创建slave账号
grant replication slave on *.* to '001'@'XXX.XXX.X.XX' identified by 'root';
查看主数据状态
show master status;
+-------------------+----------+--------------+------------------+-------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+-------------------+----------+--------------+------------------+-------------------+
| master-bin.000002 | 154 | testmaster | | |
+-------------------+----------+--------------+------------------+-------------------+
从数据库
log-bin=mysql-bin
binlog-format=Row
replicate-do-table=testmaster.test
server-id=2 #Id不能跟主数据库一样
执行指令
change master to master_host='XXX.XXX.X.XX',master_port=XXXX,master_user='001',master_password='X',master_log_file='mysql-bin.000002',master_log_pos=154;
连接主数据库,连接信息及读取log 为master显示内容
开启链接
start slave;
检查链接状态
show slave status\G;
显示以下两项则成功
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
关闭连接
stop slave;