4,348
edits
MySQL: Difference between revisions
add setting up a replication (master-slave)
→List all database without the border: add List all database without the border |
add setting up a replication (master-slave) |
||
| Line 1: | Line 1: | ||
__FORCETOC__ | <!--__FORCETOC__--> | ||
== Setting up a Replication (Master-Slave) == | |||
=== Setting the replication master config === | |||
* ''Last tested on Ubuntu 14.04.05 LTS (trusty)'' | |||
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"> | |||
[mysqld] | |||
log-bin=mysql-bin | |||
server-id=1 | |||
innodb_flush_log_at_trx_commit=1 | |||
sync_binlog=1 | |||
</syntaxhighlight> | |||
== List all database without the border == | == List all database without the border == | ||