MySQL: Difference between revisions

Jump to navigation Jump to search
add setting up a replication (master-slave)
Line 8: Line 8:
Activate the binary log on the master. <code>innodb_flush_log_at_trx_commit</code> and <code>sync_binlog</code> added for greatest possibility durability and consistency in a replication setup using <span class="package">InnoDB</span> with transactions.  
Activate the binary log on the master. <code>innodb_flush_log_at_trx_commit</code> and <code>sync_binlog</code> added for greatest possibility durability and consistency in a replication setup using <span class="package">InnoDB</span> with transactions.  


<syntaxhighlight lang="kconfig">
<syntaxhighlight lang="cfg">
[mysqld]
[mysqld]
log-bin=mysql-bin
log-bin=mysql-bin
Line 14: Line 14:
innodb_flush_log_at_trx_commit=1
innodb_flush_log_at_trx_commit=1
sync_binlog=1
sync_binlog=1
</syntaxhighlight>
=== Create a user for replication ===
Grant <span class="package">REPLICATION_SLAVE</span> privilege to the new user.
<syntaxhighlight lang="mysql">
mysql> CREATE USER 'repl'@'%.mydomain.com' IDENTIFIED BY 'mypassword';
mysql> GRANT REPLICATION SLAVE ON *.* TO 'repl'@'%.mydomain.com';
</syntaxhighlight>
</syntaxhighlight>