Skip to content

Shyhhy Records

The newly launched Shyhhy Records website is so good I'm editing this page by hand instead of getting off my arse and fixing^wreplacing wordpress.

Ps. I am also getting cows.

MySQL replication failover for good…

This is more a note to myself then anything else. I’m throwing it up here on the offchance it is useful to someone else.

Let’s say you have a bunch of MySQL servers, some replication, everything is groovy, then your master dies. Eek! It turns out the actual failover is easy and very scriptable, see for example
Switching Masters During Failover on the MySQL docs in the MySQL docs.

Once you have failed over and had a nice cup of tea and a sitdown then you can ponder the situation.

If you are really really sure you won’t want to restore your old master to it’s rightful place, and in fact you want your new master to forget that once upon a time it was a lowly slave; then try the following incantations:


$ mysql --vertical -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1234 to server version: 5.0.34-beardybeardy

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.

mysql> SHOW SLAVE STATUS;
#
# snip a whole pile of crap which really shouldn’t be there anymore
#
1 row in set (0.00 sec)

mysql> RESET SLAVE;
Query OK, 0 rows affected (0.50 sec)

mysql> CHANGE MASTER TO MASTER_HOST=”;
Query OK, 0 rows affected (0.90 sec)

mysql> SHOW SLAVE STATUS;
Empty set (0.00 sec)

mysql> SELECT “Ah, that’s better” as lovely;
*************************** 1. row ***************************
lovely: Ah, that’s better
1 row in set (0.00 sec)

Be careful though!

And you will know my name is the Grep…

The path of the righteous Man is beset on all sides by the inequities
of the selfish and the tyranny of retarded and inept men. Blessed is
he who in the name of non-disclosure and strife shepherds the weak
through the valley of darkness, for he is truly his zeroday’s keeper
and the finder of lost buffer overflows. And I will strike down upon
thee with great vengeance and furious regexps those who attempt to
poison and destroy my niggas. And you will know my name is the Grep
when I lay my vengeance upon thee.

Amen.

– posted by lmh on daily-dave

Anyone who is remotely interested in computer security really should read Daily Dave, it is ridiculously low in traffic. You should probably have Matsano log in your feed reader as well.
Still alive. All well in foreign, busy like a busy thing in work. Good Times etc.

iPony^h^h^wiPhone

I got to play with an iPhone today for the first time (I know bit behind the times). Boy is it shiney.

I got a Blackberry Curve 3 months ago when I moved over here and I have been very pleased with it. While it’s missing some of the Nokia style UI / usability polish it’s by far the best phone I’ve had.

Up until this afternoon I thought that a decent theme for the UI, a better Camera and built in GPS was all it needed to be perfect.

Playing with an iPhone has changed all that.

It doesn’t have Exchange integration (which *cough* is actually pretty sweet and works well on the Curve), it is missing a bunch of other practical things from the curve but “frivolous” things like the touch control, the screen and Safari on the iPhone make the curve look 5 years old.

In fact the iPhone is so shiney the only reason I’m not going to pick an iPhone up when I visit the Apple Store in Chicago next month is because the main GSM operator up here in Canada makes Vodafone and O2 back home look good.

At the minute I pay $90 per month for a couple of hundred evening and weekend minutes and 200Megs of data. I pay to receive calls. I pay to make non local calls. Voicemail and CallerID and a pile of other “options” are all chargeable extras.

Up here in the north having a “cell” means handing my wallet to the telco and bending over. My bill would be even more ridiculous with an unlocked iPhone.

Shame because damn it’s shiney.

Is this thing on?

Cough. I may have left a slightly odd index page here for the last 4 months or so promising a fix to a bungled up wordpress upgrade any day now. Cough. Sorry about that. Ahem.

I can’t quite remember what I did to break wordpress all that time ago, amazingly an update to the latest wordpress coupled with a dist-upgrade seems to have fixed things.

Sorry it took so long I have been busy with a few other things like moving to Vancouver.

More on the move and Vancouver soon…

For now I’ll just point you to the Vice Guide to Vancouver

oops?

I did it again?

Eircom pwned… LOLZ !!111!eleven

Via Seamus this hilarious “h4x” of the Eircom site:

0wned by psych@

Here’s a mirror just in case someone notices and actually fixes it.

Yahoo Pipes scratching a boing boing itch…

I use rawdog as my feed reader. It is a simple web based rss reader written in python which uses Mark Pilgrims feedparser. It’s not for everyone but I quite like it.

It also has a number of useful plugins. One in particular I use very heavily is feedgrep. This lets me grep / filter rss feeds so I only read what I want to read. This works especially well with boingboing which as Bernard said recently gets more annoying day by day. There are still some interesting nuggets on bingboing and filtering any posts written by Cory Doctorow or Xeni Jardin makes them much easier to spot and stops me grumbling.

(If you need to ask why I filter boingboing read this - Cory Doctorow visits a Radio Shack)

Yahoo Pipes launched recently so I decided to put my new flickr mandated Yahoo ID to good use and created boingless. It’s a published version of my personal view point on boingboing, no posts from Cory or Xeni. Enjoy!

Applemas

Dear Steve,

Please can I have an iPony for MacWorld next year?

Thanks,

Michael (aged 26 and 3/4s) .

Generic Blog Post

OMG WIIIII…

I managed to get my hands on a Wiiii (along with Raving Rabbids, an extra controller and Wii-Play) just before Xmas. Initial impressions are woo! I spent most of Xmas in my folks or in my in-laws so I haven’t played with it much yet. My son loves it and has already gotten over the scatological jokes.
Gesture based mini games which exercise the wii-mote are starting to get a bit boring. I’ve nicked the office copy of Zelda so I guess I’ll report back in a few days when I’ve played a “proper” game for a few hours.

OMG TVP…

I also got a Venice Project invite over xmas. It wasn’t much use to me down in the country with minimal GPRS coverage and a creaky old iBook. I installed it on my work machine at lunchtime today. So far it seems pretty neat. Very Appley interface even if there is no Mac port.

OMG Comment Spam!1! …

Amazingly given the complete lack of actual content and a paltry handful of inbound links I managed to get some real live comment spam over the holidays. Nothing compared to the volume of real live e-mail spam I got, but I was rather pleased to be recognised as a blog worth spamming.

OMG teh Christmas!!1!…

It was our sons first big christmas. It was also the first time in ten years I was excited to get up early(ish) and open gifts instead of waiting until after Midnight on Christmas Eve to open gifts and then try and have a lie in. It was definitely one of the highlights of 2006, the only thing which topped it was getting married.

OMG teh end of year memes…

Actually, scratch that.

Opera Mini - thumbs up

I have an evil BlackBerry for work. It sucks at pretty much everything apart from delivering automated problem alerts from servers at 3am just as I’m about to drift off to sleep.

I spotted Opera Mini 3.0 on digg or reddit or somewhere a few weeks ago and decided to give it a shot. So far it’s great. They do a really good job of transcoding things at their end so browsing on normal (non pda optimized) sites works well and it has a minimal but usable RSS feed reader.

Now I can use it to read news headlines on the bus my BlackBerry is not quite so evil. Except at 3am…