Showing posts with label apparmor. Show all posts
Showing posts with label apparmor. Show all posts

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.