Master-Master Replication With MySQL 5 On Fedora 8

This document describes how to set up master-master replication with MySQL 5 on Fedora 8. Since version 5, MySQL comes with built-in support for master-master replication, solving the problem that can happen with self-generated keys. In former MySQL versions, the problem with master-master replication was that conflicts arose immediately if node A and node B both inserted an auto-incrementing key on the same table. The advantages of master-master replication over the traditional master-slave replication are that you don't have to modify your applications to make write accesses only to the master, and that it is easier to provide high-availability because if the master fails, you still have the other master.

Master-Master Replication With MySQL 5 On Fedora 8

This document describes how to set up master-master replication with MySQL 5 on Fedora 8. Since version 5, MySQL comes with built-in support for master-master replication, solving the problem that can happen with self-generated keys. In former MySQL versions, the problem with master-master replication was that conflicts arose immediately if node A and node B both inserted an auto-incrementing key on the same table. The advantages of master-master replication over the traditional master-slave replication are that you don't have to modify your applications to make write accesses only to the master, and that it is easier to provide high-availability because if the master fails, you still have the other master.

I was at MODM4 yesterday, and as always, great fun was had. One common recurring theme though, was getting MySQL to start automatically upon a Linux server’s restart, something which I would have thought just came pretty naturally to sys-admin types. Upon further probing, these systems were all generally CentOS or RHEL based, and it wasn’t just MySQL that gave them problems - it was anything they’d installed out of the stock packages (lighttpd was a popular Apache replacement, that suffered from the same fate).

While I didn’t recollect the exact part of the manual it was stored in, I was informing everyone to make use of the chkconfig tool. Its really as simple as making sure there exists a /etc/init.d/mysql (it must be executable - chmod +x), doing a …

Today I saw an interesting opinion posted on a mailing list. I’ll quote from the fedora-list post:

What folks say here cant be taken as Fedora toting anything. It is just some user opinions.

Some of those “user opinions” came from @redhat.com addresses, I actually don’t take any notice of @anydomain.blah posters, as they are just like I, posting a personal opinion, but when you post with @redhat.com, it is next best thing to an official comment.

And I’m wondering, is this true with all users? Does it matter if the post comes from @projectname.com or not? Are your opinions more valued if you’re employed by an open source company or the project in question?

I personally think its silly. If I make a post to mysql-list, with my @mysql.com address, I don’t expect that to be an official comment or a …

Don’t know how many of you actually have heard of, or use, Mugshot, but I just started playing with it after a long hiatus, and decided that it’s pretty cool. Something the MySQL community will probably enjoy being part of (currently, to take full advantage, you want to be a Linux or Windows XP user).

By virtue of looking for the next new community hangouts, I figure we create a MySQL Mugshot Group. And before folk wonder what Mugshot’s all about, I suggest reading the feature list. Keep in mind that Mugshot is completely open source, and its a very live social experience, in this “notification era”. Its a whole lot of fun, and from what I can tell, the signups are now open to the public so what’s keeping you?

The site has i386 …

So I got to speak to MIlton Ngan right before his closing keynote. I don’t know where we got the idea that they (Weta Digital) ran Fedora, because all they’ve had are a bunch of Red Hat 9 machines as well as a few Debian. They seemingly are moving fully to Ubuntu real soon now. As always, sticking with MySQL.

Oh, and watch out for X-Men 3, out on May 19th…

There was a request to take a gander at the $100 Laptop: One Laptop Per Child (OLPC), and reading Fedora People recently made me want to snap up the opportunity to give it a go. Here are my first impressions on the emulator, known as the OLPC SDK, by Daniel Berrange.

Installation, if instructions are followed on FC-4 work fine. There are spec files to rebuild for FC-5. During the bootup sequence, I noticed that LVM was starting up, and finding no volume groups - can’t this be disabled? There doesn’t seem to be a use for LVM on the OLPC.

Once you get past the fairly slow emulator startup (its qemu based), you’ll notice that at the heart of it, you’ve got FC-5 sitting there. Very sexy.

Looking for a terminal? While gnome-terminal isn’t supplied (and probably will never be), xterm …

In the last minute life of Colin, I managed to get a flight on Tuesday to head to Singapore for Mark Shuttleworth’s Ubuntu Asian Business Tour, pretty much in the nick of time. It was a complete rush from getting the tickets, to reaching the hotel, and getting to the Singapore Management University (arrived only five minutes past!). The LUGS meets are large - going by the numbers, it seemed larger than what we have at LUV in Melbourne, and definitely greater than the MYOSS meetups.

Mark is an excellent speaker, who told us about Ubuntu’s place in the market, and all the cool things Canonical is doing to extend its reach. Being on a tight schedule, he didn’t stick around for after-talk discussions, but quite a number of other folk did. Harish Pillay (RH’s CTA in Singapore) had a couple of boxes of Fedora Core 4 giveaways, which a lot were pleased to snap up!

So I stuck around to have some dinner, and realised something …

As Kaj has mentioned, I’ll be at Linux Asia 2006, from the 8th till the 10th of February 2006. FUDCon Delhi 2006 is happening on the 9th, and I’ll be speaking on MySQL and Fedora: A Developer’s Overview. I think this fits well with the “developer, developer, developer!” theme thats going around these days…

David Axmark is also going to be around at the main conference, both at the Intellectual Property & Open Source panel, and giving us a conference keynote on Friday.

Plan on meeting a lot of people, have a few MySQL-related meetings and am generally excited to see Greg and the rest of the Fedora crew again (we saw each other this time …

Red Hat Magazine this month (well, okay, last month, I’m clearing out my tabs), has a feature on Linux and Asia. Of interest were:

• What does open source mean in India? - an interview with Javed Tapia (Director, Red Hat India), showing why India finds OSS important (software costs too much), how localisation works, and a bit about Red Hat India.
• Asia, the questions we ask - a great read, written by Michael Tiemann about his experiences in Asia. A question of interest: “What will be Singapore’s role in the technology industry of the 21st century?” I think thats the question most countries want the answer to, be it Malaysia or Australia. Its …