194 lines
5.0 KiB
Plaintext
194 lines
5.0 KiB
Plaintext
include/master-slave.inc
|
|
Warnings:
|
|
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
|
|
Note #### Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
|
|
[connection master]
|
|
SET @@time_zone='+00:00';
|
|
SET @@timestamp=25810.123456;
|
|
SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
|
|
CREATE TABLE t1
|
|
(
|
|
ts0 TIMESTAMP(0),
|
|
ts1 TIMESTAMP(1),
|
|
ts2 TIMESTAMP(2),
|
|
ts3 TIMESTAMP(3),
|
|
ts4 TIMESTAMP(4),
|
|
ts5 TIMESTAMP(5),
|
|
ts6 TIMESTAMP(6)
|
|
);
|
|
SET sql_mode = default;
|
|
SET @ts='2001-01-01 10:10:10.123456';
|
|
INSERT INTO t1 VALUES (@ts, @ts, @ts, @ts, @ts, @ts, @ts);
|
|
INSERT INTO t1 VALUES (NOW(), NOW(), NOW(), NOW(), NOW(), NOW(), NOW());
|
|
INSERT INTO t1 VALUES (NOW(6), NOW(6), NOW(6), NOW(6), NOW(6), NOW(6), NOW(6));
|
|
SELECT * FROM t1;
|
|
ts0 2001-01-01 10:10:10
|
|
ts1 2001-01-01 10:10:10.1
|
|
ts2 2001-01-01 10:10:10.12
|
|
ts3 2001-01-01 10:10:10.123
|
|
ts4 2001-01-01 10:10:10.1235
|
|
ts5 2001-01-01 10:10:10.12346
|
|
ts6 2001-01-01 10:10:10.123456
|
|
ts0 1970-01-01 07:10:10
|
|
ts1 1970-01-01 07:10:10.0
|
|
ts2 1970-01-01 07:10:10.00
|
|
ts3 1970-01-01 07:10:10.000
|
|
ts4 1970-01-01 07:10:10.0000
|
|
ts5 1970-01-01 07:10:10.00000
|
|
ts6 1970-01-01 07:10:10.000000
|
|
ts0 1970-01-01 07:10:10
|
|
ts1 1970-01-01 07:10:10.1
|
|
ts2 1970-01-01 07:10:10.12
|
|
ts3 1970-01-01 07:10:10.123
|
|
ts4 1970-01-01 07:10:10.1235
|
|
ts5 1970-01-01 07:10:10.12346
|
|
ts6 1970-01-01 07:10:10.123456
|
|
include/sync_slave_sql_with_master.inc
|
|
SELECT * FROM t1;
|
|
ts0 2001-01-01 13:10:10
|
|
ts1 2001-01-01 13:10:10.1
|
|
ts2 2001-01-01 13:10:10.12
|
|
ts3 2001-01-01 13:10:10.123
|
|
ts4 2001-01-01 13:10:10.1235
|
|
ts5 2001-01-01 13:10:10.12346
|
|
ts6 2001-01-01 13:10:10.123456
|
|
ts0 1970-01-01 10:10:10
|
|
ts1 1970-01-01 10:10:10.0
|
|
ts2 1970-01-01 10:10:10.00
|
|
ts3 1970-01-01 10:10:10.000
|
|
ts4 1970-01-01 10:10:10.0000
|
|
ts5 1970-01-01 10:10:10.00000
|
|
ts6 1970-01-01 10:10:10.000000
|
|
ts0 1970-01-01 10:10:10
|
|
ts1 1970-01-01 10:10:10.1
|
|
ts2 1970-01-01 10:10:10.12
|
|
ts3 1970-01-01 10:10:10.123
|
|
ts4 1970-01-01 10:10:10.1235
|
|
ts5 1970-01-01 10:10:10.12346
|
|
ts6 1970-01-01 10:10:10.123456
|
|
DROP TABLE t1;
|
|
include/sync_slave_sql_with_master.inc
|
|
CREATE TABLE t1
|
|
(
|
|
dt0 DATETIME(0),
|
|
dt1 DATETIME(1),
|
|
dt2 DATETIME(2),
|
|
dt3 DATETIME(3),
|
|
dt4 DATETIME(4),
|
|
dt5 DATETIME(5),
|
|
dt6 DATETIME(6)
|
|
);
|
|
SET @ts='2001-01-01 10:10:10.123456';
|
|
INSERT INTO t1 VALUES (@ts, @ts, @ts, @ts, @ts, @ts, @ts);
|
|
INSERT INTO t1 VALUES (NOW(), NOW(), NOW(), NOW(), NOW(), NOW(), NOW());
|
|
INSERT INTO t1 VALUES (NOW(6), NOW(6), NOW(6), NOW(6), NOW(6), NOW(6), NOW(6));
|
|
SELECT * FROM t1;
|
|
dt0 2001-01-01 10:10:10
|
|
dt1 2001-01-01 10:10:10.1
|
|
dt2 2001-01-01 10:10:10.12
|
|
dt3 2001-01-01 10:10:10.123
|
|
dt4 2001-01-01 10:10:10.1235
|
|
dt5 2001-01-01 10:10:10.12346
|
|
dt6 2001-01-01 10:10:10.123456
|
|
dt0 1970-01-01 07:10:10
|
|
dt1 1970-01-01 07:10:10.0
|
|
dt2 1970-01-01 07:10:10.00
|
|
dt3 1970-01-01 07:10:10.000
|
|
dt4 1970-01-01 07:10:10.0000
|
|
dt5 1970-01-01 07:10:10.00000
|
|
dt6 1970-01-01 07:10:10.000000
|
|
dt0 1970-01-01 07:10:10
|
|
dt1 1970-01-01 07:10:10.1
|
|
dt2 1970-01-01 07:10:10.12
|
|
dt3 1970-01-01 07:10:10.123
|
|
dt4 1970-01-01 07:10:10.1235
|
|
dt5 1970-01-01 07:10:10.12346
|
|
dt6 1970-01-01 07:10:10.123456
|
|
include/sync_slave_sql_with_master.inc
|
|
SELECT * FROM t1;
|
|
dt0 2001-01-01 10:10:10
|
|
dt1 2001-01-01 10:10:10.1
|
|
dt2 2001-01-01 10:10:10.12
|
|
dt3 2001-01-01 10:10:10.123
|
|
dt4 2001-01-01 10:10:10.1235
|
|
dt5 2001-01-01 10:10:10.12346
|
|
dt6 2001-01-01 10:10:10.123456
|
|
dt0 1970-01-01 07:10:10
|
|
dt1 1970-01-01 07:10:10.0
|
|
dt2 1970-01-01 07:10:10.00
|
|
dt3 1970-01-01 07:10:10.000
|
|
dt4 1970-01-01 07:10:10.0000
|
|
dt5 1970-01-01 07:10:10.00000
|
|
dt6 1970-01-01 07:10:10.000000
|
|
dt0 1970-01-01 07:10:10
|
|
dt1 1970-01-01 07:10:10.1
|
|
dt2 1970-01-01 07:10:10.12
|
|
dt3 1970-01-01 07:10:10.123
|
|
dt4 1970-01-01 07:10:10.1235
|
|
dt5 1970-01-01 07:10:10.12346
|
|
dt6 1970-01-01 07:10:10.123456
|
|
DROP TABLE t1;
|
|
include/sync_slave_sql_with_master.inc
|
|
CREATE TABLE t1
|
|
(
|
|
t0 TIME(0),
|
|
t1 TIME(1),
|
|
t2 TIME(2),
|
|
t3 TIME(3),
|
|
t4 TIME(4),
|
|
t5 TIME(5),
|
|
t6 TIME(6)
|
|
);
|
|
SET @t='10:10:10.123456';
|
|
INSERT INTO t1 VALUES (@t, @t, @t, @t, @t, @t, @t);
|
|
INSERT INTO t1 VALUES (CURTIME(), CURTIME(), CURTIME(), CURTIME(), CURTIME(), CURTIME(), CURTIME());
|
|
INSERT INTO t1 VALUES (CURTIME(6), CURTIME(6), CURTIME(6), CURTIME(6), CURTIME(6), CURTIME(6), CURTIME(6));
|
|
SELECT * FROM t1;
|
|
t0 10:10:10
|
|
t1 10:10:10.1
|
|
t2 10:10:10.12
|
|
t3 10:10:10.123
|
|
t4 10:10:10.1235
|
|
t5 10:10:10.12346
|
|
t6 10:10:10.123456
|
|
t0 07:10:10
|
|
t1 07:10:10.0
|
|
t2 07:10:10.00
|
|
t3 07:10:10.000
|
|
t4 07:10:10.0000
|
|
t5 07:10:10.00000
|
|
t6 07:10:10.000000
|
|
t0 07:10:10
|
|
t1 07:10:10.1
|
|
t2 07:10:10.12
|
|
t3 07:10:10.123
|
|
t4 07:10:10.1235
|
|
t5 07:10:10.12346
|
|
t6 07:10:10.123456
|
|
include/sync_slave_sql_with_master.inc
|
|
SELECT * FROM t1;
|
|
t0 10:10:10
|
|
t1 10:10:10.1
|
|
t2 10:10:10.12
|
|
t3 10:10:10.123
|
|
t4 10:10:10.1235
|
|
t5 10:10:10.12346
|
|
t6 10:10:10.123456
|
|
t0 07:10:10
|
|
t1 07:10:10.0
|
|
t2 07:10:10.00
|
|
t3 07:10:10.000
|
|
t4 07:10:10.0000
|
|
t5 07:10:10.00000
|
|
t6 07:10:10.000000
|
|
t0 07:10:10
|
|
t1 07:10:10.1
|
|
t2 07:10:10.12
|
|
t3 07:10:10.123
|
|
t4 07:10:10.1235
|
|
t5 07:10:10.12346
|
|
t6 07:10:10.123456
|
|
DROP TABLE t1;
|
|
include/sync_slave_sql_with_master.inc
|
|
include/rpl_end.inc
|