MySQL Replicatie: Revision history

Jump to navigation Jump to search

Diff selection: Mark the radio buttons of the revisions to compare and hit enter or the button at the bottom.
Legend: (cur) = difference with latest revision, (prev) = difference with preceding revision, m = minor edit.

5 April 2022

  • curprev 09:3409:34, 5 April 2022Eric talk contribs 2,727 bytes +2,727 Created page with "=Setup Master Server= You'll need this in your my.cnf on your server: log-bin server-id = 1 log bin turns on logging and server-id (which must be unique on your network) is requried for replication to work. I made the master in this case #1. Then, setup the replication user (assumes you're running mysql 4. mysql> GRANT REPLICATION SLAVE ON *.* TO repl@"%" IDENTIFIED '<password>'; restart your mysql server, if necessary do a: Get a snapshot of current data fo..."