generate random rows in MySQL is to use the ORDER BY RAND() clause. This can work fine for small table... name ;
mysql> CREATE USER 'user'@'%' IDENTIFIED BY 'secret';
mysql> grant all privileges on db_nam... sql>
CREATE USER 'backup'@'localhost' IDENTIFIED BY 'password';
REVOKE ALL PRIVILEGES ON *.* FROM
Get a listing of binary log files on the primary by running **SHOW BINARY LOGS**.
* Go to each repl... .
* Find the earliest log file still being read by a replica. No log files before this one will be n... e sql>
CREATE USER 'replication-slave' IDENTIFIED BY 'secret';
GRANT REPLICATION SLAVE ON *.* to 'repl
