51 lines
1.7 KiB
Plaintext
51 lines
1.7 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]
|
||
drop database if exists mysqltest1;
|
||
create database mysqltest1 /*!40100 character set latin2 */;
|
||
use mysqltest1;
|
||
drop table if exists t1;
|
||
create table t1 (a varchar(255) character set latin2, b varchar(4));
|
||
SET CHARACTER SET cp1250_latin2;
|
||
INSERT INTO t1 VALUES ('ŠŒ<C5A0>Ž<EFBFBD>','80');
|
||
INSERT INTO t1 VALUES ('šœ<C5A1>žŸ','90');
|
||
INSERT INTO t1 VALUES ('£¥ª¯','A0');
|
||
INSERT INTO t1 VALUES ('³¹º¼¾¿','B0');
|
||
INSERT INTO t1 VALUES ('ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏ','C0');
|
||
INSERT INTO t1 VALUES ('ÐÑÒÓÔÕÖ×ØÙÚÛÜÝÞß','D0');
|
||
INSERT INTO t1 VALUES ('àáâãäåæçèéêëìíîï','E0');
|
||
INSERT INTO t1 VALUES ('ðñòóôõö÷øùúûüýþÿ','F0');
|
||
select "--- on master ---";
|
||
--- on master ---
|
||
--- on master ---
|
||
select hex(a),b from t1 order by b;
|
||
hex(a) b
|
||
A9A6ABAEAC 80
|
||
B9B6BBBEBC 90
|
||
A3A1AAAF A0
|
||
B3B1BAA5B5BF B0
|
||
C0C1C2C3C4C5C6C7C8C9CACBCCCDCECF C0
|
||
D0D1D2D3D4D5D6D7D8D9DADBDCDDDEDF D0
|
||
E0E1E2E3E4E5E6E7E8E9EAEBECEDEEEF E0
|
||
F0F1F2F3F4F5F6F7F8F9FAFBFCFDFEFF F0
|
||
include/sync_slave_sql_with_master.inc
|
||
use mysqltest1;
|
||
select "--- on slave ---";
|
||
--- on slave ---
|
||
--- on slave ---
|
||
select hex(a),b from t1 order by b;
|
||
hex(a) b
|
||
A9A6ABAEAC 80
|
||
B9B6BBBEBC 90
|
||
A3A1AAAF A0
|
||
B3B1BAA5B5BF B0
|
||
C0C1C2C3C4C5C6C7C8C9CACBCCCDCECF C0
|
||
D0D1D2D3D4D5D6D7D8D9DADBDCDDDEDF D0
|
||
E0E1E2E3E4E5E6E7E8E9EAEBECEDEEEF E0
|
||
F0F1F2F3F4F5F6F7F8F9FAFBFCFDFEFF F0
|
||
drop database mysqltest1;
|
||
include/sync_slave_sql_with_master.inc
|
||
include/rpl_end.inc
|