// archives

Technology

This category contains 12 posts

XtraDB Cluster on CentOS 7

Setting up XtraDB Cluster (aka Galera) is straight forward…or so I was told. To do this correctly, there are some tricks. Some published. Some disparate. I’m going to save you HOURS of Googling for answers and break down the process here. Just know that from version to version, dependency changes have a HUGE impact. I […]

Finding duplicate rows in MySQL

I saw this question online reading “How do I identify duplicate rows in MySQL” and it’s been gnawing at me so here’s my approach: Make a duplicate of your subject matter CREATE TABLE a2 LIKE a1; INSERT INTO a2 SELECT * FROM a1; Add a ‘checksum’ column to the new table ALTER TABLE a2 ADD […]

I started making this iOS game with Sprite Kit

Side benefits of jet lag + general insomnia include lots of time to learn new things. I decided it was time to learn Sprite Kit by making a game for my 2-year old to play on my iPhone. I call it “Say Shapes” – Here’s progress after 4 total hours. Like this:Like Loading…

Apple’s One Timezone planet

At midnight, the world timeclock gets label panic. Don’t ask me how I know… Like this:Like Loading…

Yahoo! mail fail

We’re Sorry. Like this:Like Loading…

Facebook Actively Inactive :-(

You have activity! You have no activity?!? Like this:Like Loading…

LinkedIn lost its data link

Like this:Like Loading…

2 Fails, 1 Page – AT&T and Facebook Fail

Fail #1 – AT&T Hacked Fail #2 – Facebook flapping 3 fails, if you count the facial on the video still… Like this:Like Loading…

Getting the mysqldump you always hoped for.

Dumping data from MySQL might be seem like a covered topic, but just so it’s clear, you aren’t stuck outputting SQL. There’s at least 3 options for outputting data. Option 1: The SQL way Good’ole fashioned structured query language output of your whole database in a single file. mysqldump -u root -p -f your_schema_name_here > […]

%d bloggers like this: