MySQL: Difference between revisions

Jump to navigation Jump to search
→‎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 ==