Thursday, October 15, 2009

New day - new tasks.

Now want to set up MySQL replication, at first from my server to Mårten's.
Also modifying MySQL setup to support multiple datbases.

Found this blog post which seems relevant:

http://blog.erichsen.net/2009/09/01/multiple-mysql-slave-instances-on-a-single-server/

Also found this page:

http://ubuntuforums.org/archive/index.php/t-1154296.html

Followed the instructions on the second link. Got bit by one thing: apparently Ubuntu runs apparmor by default, I needed to modify /etc/apparmor.d/usr.sbin.mysqld to contain:

/var/lib/mysql?/ r,
/var/lib/mysql?/** rwk,
/var/log/mysql/ r,
/var/log/mysql/** rw,
/var/run/mysqld/mysqld?.pid w,
/var/run/mysqld/mysqld?.sock w,

I now have four mysql servers on cumulus.

Repeated instructions on cirrus. Only enabled logging on master servers.

Next step is to setup cirrus to replicate databases 1 and 2 from cumulus.

No comments: