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.