The FEDERATED MySQL Storage Engine

The FEDERATED MySQL storage engine is the coolest thing EVER! Seriously. It’s already saved me from having to do a whole bunch of synchronization coding. I can only imagine how it’ll come in useful in the future.

So, here’s my situation. I have two mysql servers sitting behind a firewall at “location 1”. People at “location 2” need to write some software to connect to both mysql servers at location 1. However, MyODBC gets confused when connecting to the same hostname on two different tcp ports, or so I’m told.

Anyway, since I was basically told that there’s no way to connect to two seperate mysql servers behind one firewall, I got to thinking. So, I set off searching google for method for mirroring data in MySQL and came across the FEDERATED storage engine.

Now, the servers at location 1 are on a VPN with the network at location 3, my location. So, my network (at location 3) can see the network at location 1 without the firewall getting in the way. Since that’s the case here, I can connect to the default mysql port, 3306, on both servers because I can see their LAN IP, where the people at location 2 can’t (no VPN).

So, we’ve got the network flow figured out, now we can go about getting the FEDERATED storage engine in MySQL working. First, you’ll need MySQL 5.x. I chose MySQL 5.0.24 as it’s the latest stable 5.x release.

To enable the FEDERATED storage engine in mysql 5, you must pass the –with-federated-storage-engine option when running configure. That’s pretty much all that’s required to start using the FEDERATED storage engine. Most linux distributions probably have a mysql 5 package that comes with the FEDERATED engine on already, although Slackware does not currently. Continue reading “The FEDERATED MySQL Storage Engine”

0

CSS Optimization Tools

Optimization can drastically change the way your websites load. Poorly optimized sites load slowly and aren’t very nice to look at for the users. Well optimized sites load quickly and provide the user with the content they need. There’s lots of different ways to optimize site performance. You can optimize apache, mysql, PHP, and even your HTML code.

One thing people often overlook when optimizing a site is the CSS. Blogging Pro takes a look at four different CSS optimization tools. I, for one, have never really thought of optimizing CSS. I just don’t think it’s really ever occurred to me, I need to work on learning CSS before I get into optimization. But, there’s tools to do the optimizing for you, go check out the article at Blogging Pro.

0

WordPress 2.0 Final is Here

I just did an update on my local WordPress subversion trunk and noticed the version had been updated to 2.0. No more release candidate, this is the final 2.0 WordPress release. Not many changes between 2.0-Final and RC3. I think there were maybe a total of 15 files that had any changes to them, if that many.

The WordPress.org site is down for the time being, displaying a message:

Switching servers, please check back in about a half hour. Thanks! – Matt

Probably getting ready to announce WordPress 2.0 on the site. Congratulations to the WordPress team on another fine release.

0

WordPress 2.0-RC3

So, I didn’t post for WordPress 2.0-RC2, although there was a far greater number of changes in RC2 than there is in RC3. But, RC2 is history now, so screw it. Sounds like this could be the final release candidate before WordPress 2.0 is officially out of beta and ready for “production” use.

The next release of WordPress is drawing near. Please help us shake out any last remaining bugs by downloading and testing the 2.0 Release Candidate. If all goes well, the Release Candidate will become 2.0 final. We’re almost there. Download, test, and head over to the Beta Forum to let us know if the Release Candidate is ready for prime time.


I’ve got release candidate 3 running here right now, no problems at all. On a related note, Spam Karma 2.0 informed me of 2.1 being in beta. Can’t seem to find a link to it now though.

0

Apache httpd 2.2.0

The Apache httpd server version 2.2.0 has been released. You can see the official announcement in the mailing list archives.

The Apache Software Foundation and The Apache HTTP Server Project are pleased to announce the release of version 2.2.0 of the Apache HTTP Server (“Apache”).

We consider this release to be the best version of Apache available, and encourage users of all prior versions to upgrade.

Apache HTTP Server 2.2.0 is available for download from:
http://httpd.apache.org/download.cgi

Apache 2.2 offers numerous enhancements, improvements, and performance boosts over the 2.0 codebase. For an overview of new features introduced since 2.0 please see:
http://httpd.apache.org/docs/2.2/new_features_2_2.html


The upgrade went very well for me. I was already running 2.0.55 though. The only thing I had to do was recompile PHP, which wasn’t a problem. I haven’t noticed any problems at all so far, as expected.

0