Help to save MySql

Posted about 2 months ago on: 13/12/2009 - No comments
Tagged in: mysql, save, oracle, help.

The below is very important:

I, Michael "Monty" Widenius, the creator of MySQL, is asking you urgently to help save MySQL from Oracle's clutches. Without your immediate help Oracle might get to own MySQL any day now. By writing to the European Commission (EC) you can support this cause and help secure the future development of the product MySQL as an Open Source project.

Please continue reading the article.

Custom message boards at work

Posted about 3 months ago on: 16/11/2009 - No comments
Tagged in: forums, custom, work.

I'm tasked with creating a custom message board system at work. This entails re-inventing the wheel but that's cool, I'm always doing that on a day-to-day basis anyway.

Requirements

A great deal of message boards out on the web for free download are way to over spec for what we need and also do not offer the level of customisation at the data level that we require either. Most are also not set up for multi-server instances where load balancing is taking place where sessions are handled by something other than the server itself. To this end the market place has a huge gap on this front. Cloud computing might be the new buzz word, but in reality we've had it for years. It used to be called clustering and load balancing. Load balancing shapes your traffic where clustering offers redundancy; should a server go down for some reason then another takes its place. Traditionally most shared hosts, which is what a great deal of professionally written forums are designed for, have the database on the same server and although they support an external database they hardly ever support multiple instances again. You know, we might require one cluster to do the writes and one to do the reads, maybe even one cluster to deal with nothing but blobs or profiles, user access... the list goes on. To this end nothing off the shelf that I know of supports our level of infrastructure in the way we need it to. Also can you imagine some of the more popular boards dealing with 32,000+ users, they'd all crawl to a halt, I know; I've seen it before.

Custom written

To this end I need to write one from scratch, of course this has it's downfalls and potential pitfalls. I'm not daunted by that. I guess the only thing that concerns me is the potential user base (32,000+ off the bat and only likely to get bigger) and the need to load balance things, this isn't a problem until you encounter sessions, if your load balancers aren't set up correctly and do a 1-1 split on requests we soon hit an issue on storing information in a session, this then falls back to a cookie, which can also have the same problems, especially when it's set against the domain; but your DNS has the domain pointing to a firewall... The other side is integration of other services both internal and external to us. I just can here everyone screaming Sharepoint, Twitter, Facebook, the CMS, my shared drive and the like. Which poses several problems and that's data management and privacy. Whilst one person on any number of threads might want to shout to the world, just as many won't. Do I tie logins in to our network or have a separate login for forums, LDAP or Active directory? Email notifications, RSS the list goes on and on...

This task isn't small; but it will be interesting. w00t.

Phishing Attack on Twitter

Posted about 4 months ago on: 28/10/2009 - No comments
Tagged in: twitter, phishing, scam.

If you get any DM's with links to http://blogger.djhxkcs.com it seems to be a phishing scam coming from China (or a server compromised in China) - Details are:

IP: 220.164.144.202

Just add it your host files and direct it to 12.0.0.1 - If you own networks with lots of users, consider banning it on IP tables.

Simply add:

iptables -A INPUT -p all -s 220.164.144.202 -j DROP
iptables -A OUTPUT -p all -s 220.164.144.202 -j DROP

To your chains at least till the attack is over.

That craving

Posted about 4 months ago on: 27/10/2009 - 6 comments
Tagged in: craving, brain fart, hosting, development, freelance.

For the last few months I've been sounding out a few old contacts and doing various bits of freelance development again after a years hiatus from doing anything serious. Some of the folks that have known me some years know that I ran a successful email system and was a happy freelancer for a long time. I also run a hosting endeavour at the moment. The hosting works, makes money and because of my experience as a systems admin is semi-trivial and doesn't really take up a lot of time.

The fact of the matter is that I don't want to up-scale it and the reason is it doesn't financially up-scale all that well due to competition (that I can't and won't try to compete with), I've been there before and frankly I'd rather not loose sleep. Also there would come a time when I would need to make a choice, a choice I'm not in the mood to make right now because of the current financial markets.

That said... after a conversation I had earlier, I'm craving. So thanks Jake, thanks a lot... no really :-)

Also, I managed to catch up with a few people I've not spoken to in nearly six years this evening; as it's the first time I'd logged on to MSN for probably that long. WIN.