Mysql replication - Versionsgeschichte

Grigor am 28. April 2019 um 21:18 Uhr

2019-04-28T21:18:17Z

Grigor am 28. April 2019 um 10:47 Uhr

2019-04-28T10:47:31Z

Grigor am 28. April 2019 um 10:46 Uhr

2019-04-28T10:46:56Z

Grigor am 28. April 2019 um 10:46 Uhr

2019-04-28T10:46:32Z

Grigor am 28. April 2019 um 10:46 Uhr

2019-04-28T10:46:13Z

Grigor am 28. April 2019 um 10:45 Uhr

2019-04-28T10:45:50Z

Grigor am 28. April 2019 um 10:42 Uhr

2019-04-28T10:42:09Z

Grigor: Die Seite wurde neu angelegt: „CHANGE MASTER TO MASTER_HOST = 'host_name', MASTER_USER = 'user_name', MASTER_PASSWORD = 'password', MASTER_PORT = port_num, MASTER_LOG_FILE = 'master_log_nam…“

2019-04-28T10:37:41Z

Die Seite wurde neu angelegt: „CHANGE MASTER TO MASTER_HOST = 'host_name', MASTER_USER = 'user_name', MASTER_PASSWORD = 'password', MASTER_PORT = port_num, MASTER_LOG_FILE = 'master_log_nam…“

Neue Seite

CHANGE MASTER TO
MASTER_HOST = 'host_name',
MASTER_USER = 'user_name',
MASTER_PASSWORD = 'password',
MASTER_PORT = port_num,
MASTER_LOG_FILE = 'master_log_name',
MASTER_LOG_POS = master_log_pos;

Full syntax:
CHANGE MASTER TO option [, option] ... [ channel_option ]

option:
MASTER_BIND = 'interface_name'
| MASTER_HOST = 'host_name'
| MASTER_USER = 'user_name'
| MASTER_PASSWORD = 'password'
| MASTER_PORT = port_num
| MASTER_CONNECT_RETRY = interval
| MASTER_RETRY_COUNT = count
| MASTER_DELAY = interval
| MASTER_HEARTBEAT_PERIOD = interval
| MASTER_LOG_FILE = 'master_log_name'
| MASTER_LOG_POS = master_log_pos
| MASTER_AUTO_POSITION = {0|1}
| RELAY_LOG_FILE = 'relay_log_name'
| RELAY_LOG_POS = relay_log_pos
| MASTER_SSL = {0|1}
| MASTER_SSL_CA = 'ca_file_name'
| MASTER_SSL_CAPATH = 'ca_directory_name'
| MASTER_SSL_CERT = 'cert_file_name'
| MASTER_SSL_CRL = 'crl_file_name'
| MASTER_SSL_CRLPATH = 'crl_directory_name'
| MASTER_SSL_KEY = 'key_file_name'
| MASTER_SSL_CIPHER = 'cipher_list'
| MASTER_SSL_VERIFY_SERVER_CERT = {0|1}
| MASTER_TLS_VERSION = 'protocol_list'
| MASTER_PUBLIC_KEY_PATH = 'key_file_name'
| GET_MASTER_PUBLIC_KEY = {0|1}
| IGNORE_SERVER_IDS = (server_id_list)

channel_option:
FOR CHANNEL channel

server_id_list:
[server_id [, server_id] ... ]

@@ Zeile 12: / Zeile 12: @@
   slave-skip-errors=all
   binlog-format=row</code>
 ==Commands ==
 <code>STOP SLAVE;
 </code>
 <code>
    CHANGE MASTER TO
@@ Zeile 27: / Zeile 30: @@
 START SLAVE;
 </code>
-Full syntax:
+== Full syntax ==
 CHANGE MASTER TO option [, option] ... [ channel_option ]
@@ Zeile 64: / Zeile 68: @@
 server_id_list:
      [server_id [, server_id] ... ]

@@ Zeile 2: / Zeile 2: @@
 == start.bat ==
-<code>
+<code>set path=e:\IntraSell\MySQL\mysql-5.5.28-winx64\bin;%path%
   mysqld --defaults-file="e:\IntraSell\MySQL\mysql-5.5.28-winx64\my.ini"
-pause
+ pause</code>
 == my.conf ==
-<code>
+<code>server-id=3
   log-bin=
   log-slave-updates
   slave-skip-errors=all
-  binlog-format=row
+  binlog-format=row</code>
-</code>
+==Commands ==
 <code>STOP SLAVE;
 </code>

@@ Zeile 16: / Zeile 16: @@
   binlog-format=row
 </code>
+Commands:
 <code>STOP SLAVE;
 </code>

@@ Zeile 3: / Zeile 3: @@
 == start.bat ==
 <code>
-set path=e:\IntraSell\MySQL\mysql-5.5.28-winx64\bin;%path%
+ set path=e:\IntraSell\MySQL\mysql-5.5.28-winx64\bin;%path%
-mysqld --defaults-file="e:\IntraSell\MySQL\mysql-5.5.28-winx64\my.ini"
+ mysqld --defaults-file="e:\IntraSell\MySQL\mysql-5.5.28-winx64\my.ini"
 pause
 </code>
@@ Zeile 10: / Zeile 10: @@
 == my.conf ==
 <code>
-server-id=3
+ server-id=3
-log-bin=
+ log-bin=
-log-slave-updates
+ log-slave-updates
-slave-skip-errors=all
+ slave-skip-errors=all
-binlog-format=row
+ binlog-format=row
 </code>

@@ Zeile 1: / Zeile 1: @@
 MYSQL Replcation, Cheat sheets
-my.conf
+== start.bat ==
 <code>
-STOP SLAVE;
+set path=e:\IntraSell\MySQL\mysql-5.5.28-winx64\bin;%path%
 </code>
@@ Zeile 9: / Zeile 20: @@
 STOP SLAVE;
 </code>
-<code>CHANGE MASTER TO
+<code>
    MASTER_HOST = 'host_name',
    MASTER_USER = 'user_name',