数据库记录

[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;