Development:TestReplicationSetup - Revision history

76.105.157.189 at 01:46, 21 July 2007

2007-07-21T01:46:50Z

67.189.90.32 at 23:10, 19 July 2007

2007-07-19T23:10:17Z

Jason Parmer at 20:23, 19 July 2007

2007-07-19T20:23:19Z

Jason Parmer at 16:41, 19 July 2007

2007-07-19T16:41:23Z

76.105.157.189 at 08:48, 19 July 2007

2007-07-19T08:48:34Z

76.105.157.189 at 08:47, 19 July 2007

2007-07-19T08:47:38Z

Jason Parmer: New page: On till: master + slave sub servers, setup as chroot jails. the chroots live in /www/mysql-replication, under master and slaver servers respectively. chroot setup is as follows: proc...

2007-07-19T06:21:48Z

New page: On till: master + slave sub servers, setup as chroot jails. the chroots live in /www/mysql-replication, under master and slaver servers respectively. chroot setup is as follows: proc...

New page

On till:

master + slave sub servers, setup as chroot jails.

the chroots live in /www/mysql-replication, under master and slaver servers respectively.

chroot setup is as follows:
proc entries are in till's master /etc/fstab to mount the /proc filesystem in the chroots

1) Install the OS files
<pre>
sudo debootstrap --arch amd64 etch /www/mysql-replication/slave http://mirror.xmission.com/debian
</pre>

2) enter the chrooted system
<pre>
sudo chroot /www/mysql-replication/master
</pre>
3) install locales support and MySQL
<pre>
apt-get install locales-all
apt-get install mysql-server-5.0
</pre>

Master is setup on port 3307, slave on port 3308

@@ Line 31: / Line 31: @@
 <pre>
 grant replication slave on *.* to repl@localhost
 </pre>
@@ Line 37: / Line 43: @@
 change master to master_host = '127.0.0.1', master_port = 3307, master_user='repl', master_log_file = 'mysql-bin.000008', master_log_pos = 13804;
 start slave
 </pre>

@@ Line 30: / Line 30: @@
 on the master, add permission for the replication user:
 <pre>
-grant replication slave, super, reload  on *.* to 'replication'@'localhost'
+grant replication slave on *.* to repl@localhost
 </pre>
 on the slave, to start replication:
 <pre>
-change master to master_host = '127.0.0.1', master_port = 3307, master_user='replication', master_log_file = 'mysql-bin.000066', master_log_pos = 14218;
+change master to master_host = '127.0.0.1', master_port = 3307, master_user='repl', master_log_file = 'mysql-bin.000008', master_log_pos = 13804;
 start slave
 </pre>

@@ Line 28: / Line 28: @@
 Master is setup on port 3307, slave on port 3308
 <pre>
-change master to master_host = 'localhost', master_port = 3307, master_user='replication', master_log_file = 'mysql-bin.000020', master_log_pos = 13804;
+change master to master_host = '127.0.0.1', master_port = 3307, master_user='replication', master_log_file = 'mysql-bin.000066', master_log_pos = 14218;
 start slave
 </pre>

@@ Line 30: / Line 30: @@
 <pre>
-change master to master_host = 'localhost', master_port = 3307, master_user='replication', master_log_file = 'mysql-bin.000020', master_log_pos = 13804
+change master to master_host = 'localhost', master_port = 3307, master_user='replication', master_log_file = 'mysql-bin.000020', master_log_pos = 13804;
 </pre>

← Older revision		Revision as of 08:47, 19 July 2007
Line 25:		Line 25:

	Master is setup on port 3307, slave on port 3308		Master is setup on port 3307, slave on port 3308
		+
		+	<pre>
		+	change master to master_host = 'localhost', master_port = 3307, master_user='replication', master_log_file = 'mysql-bin.000020', master_log_pos = 13804
		+	</pre>

@@ Line 8: / Line 8: @@
 chroot setup is as follows:
 proc entries are in till's master /etc/fstab to mount the /proc filesystem in the chroots
+<pre>
 ) Install the OS files
 <pre>