ITPub博客

OGG延迟云上和云下同步方案；版本：Oracle GoldenGate 19.1 for MySQL 5.7

1.create mysql user/usr/sbin/groupadd  -g 601 mysql/usr/sbin/useradd -u 701 -g mysql mysql2.create data directory and permissions and attributesmkdir -p /mysql/data/3307/{data,binlog,tmp}mkdir -p /mysql/data/3308/{data,binlog,tmp}mkdir -p /mysql/data/3309/{data,binlog,tmp}chmod 755...

Using AUTO_INCREMENT CASEAUTO_INCREMENT CASE EXPLAINhttp://dev.mysql.com/doc/refman/5.6/en/example-auto-increment.html 1.create case table and insert into datamysql> CREATE TABLE animals (    ->      id MEDIUMINT NOT NULL AUTO_INCREMENT,    ->  ...

MYSQLDUMP TABLE1.What is mysqldump ?mysqldump is a sql based dump, data is dumped then loaded and all indexes are recreated. During mysqldump, all the tables would be locked and will not be accessible for queries.2.Create test table doudou01 and doudou02mysql> select * from doudou01;+----+...

MYSQL TABLE CHANGE STORAGE ENGINE1.create table and set storage engineCREATE TABLE `doudou01` (  `i` bigint(20) NOT NULL AUTO_INCREMENT,  PRIMARY KEY (`i`)) ENGINE=MyISAM DEFAULT CHARSET=gbk;## default storage engine is innodb## check table statusmysql> show table status like 'do...

Mysql  date_format  与  Oracle to_char(date,’format’) 以上2种方法均属于把事件类型的列，转换成你所需要的时间格式的函数。Oracle:   select to_char(zatime,'yyyymmdd hh24:mi:ss...