Tab Sweep – 7 August 2017

Not quite a “tab sweep”, this is me dumping out my OmniFocus todos!

  • QOTD: “Yesterday, you said tomorrow.” – Nike
  • Do you think about using MariaDB ColumnStore? Back in January, there was an interesting Twitter thread. It is in French, and things have improved, but this is a colourful description.
  • A PostgreSQL response to Uber is the Hacker News discussion, slides from Christophe Pettus presented at Percona Live Santa Clara 2017. Well worth reading, this wasn’t an easy talk to get on the agenda, and the commentary is also particularly interesting.

Tab Sweep – 5 August 2017

Goodbye box at a data centre

August 1 2017 marks the day I stop colocating a box at a data centre.

[byte@hogwarts ~]$ uptime

22:07:55 up 522 days, 19:40, 1 user, load average: 0.02, 0.01, 0.00

This particular box has been in the data centre from 2008. It survived one data centre bankruptcy (Jaring), moved along to another, and now I feel the box is to be replaced by a few instances at Linode, Digital Ocean, and also DreamHost.

This marks my last CentOS 5 box. This marks the last time I will deal with MySQL 5.0.95.

The box wasn’t too bad either (though woefully out of warranty). It was a Dell 1U box. Intel(R) Xeon(R) CPU X3210 @ 2.13GHz, 4 cores. Paltry 4GB of RAM. Did mail, web, DNS, and a few other bits, quite well. 2 spinning disks, RAID setup, 500GB storage. Its still healthy ([UU] in /proc/mdstat).

As soon as I get it back, I’ll spin it up at the office, pop on some newer version of Linux and see how long it continues serving!

Evernote + Instapaper search tip

I use Evernote a lot. And I also love the read-it-later service Instapaper. When I power through my Instapaper queue, I occasionally like articles (though I mostly archive articles). When I like articles, they get saved to Evernote automatically, in full-text, parsed via Instapaper (so its pretty text and images, no junk ads, etc.).

What do you do with all the notes that accumulate in your Evernote inbox? Run the search: You'll find everything relevant, and you can move it to another notebook.

If for some reason it doesn't work, try running and saving this search on the web interface, and then sync, to execute locally on the Mac client.

When your Mac’s display out stops working

I landed in San Francisco at around 10pm, hit the hotel in Santa Clara by 11.30pm, crashed, and woke up to give my tutorial at 9am. By 8.45am, I couldn’t get my 12″ MacBook to display out via HDMI or VGA to the projector, so I ran back to the room to get my 15″ rMBP instead.

Later on, I ran the Apple Hardware Test. Or what it’s called now, Apple Diagnostics. Everything came back just fine, which seemed odd.

The best fix seemed to then be resetting the NVRAM. That didn’t improve things, so I had to reset the System Management Controller (SMC), and voila! everything seemed to work thereafter.

In the years of using Apple hardware, I have to think this is the first time I’ve had to do this. I guess the presentation pro-tip here is always carry a backup presentation device (I might going forward get the relevant dongles for the iPad to run a presentation too).

CFP for Percona Live Europe Dublin 2017 closes July 17 2017!

I’ve always enjoyed the Percona Live Europe events, because I consider them to be a lot more intimate than the event in Santa Clara. It started in London, had a smashing success last year in Amsterdam (conference sold out), and by design the travelling conference is now in Dublin from September 25-27 2017.

So what are you waiting for when it comes to submitting to Percona Live Europe Dublin 2017? Call for presentations close on July 17 2017, the conference has a pretty diverse topic structure (MySQL [and its diverse ecosystem including MariaDB Server naturally], MongoDB and other open source databases including PostgreSQL, time series stores, and more).

And I think we also have a pretty diverse conference committee in terms of expertise. You can also register now. Early bird registration ends August 8 2017.

I look forward to seeing you in Dublin, so we can share a pint of Guinness. Sláinte.