DrupalDownUnder 2012 will be held in Melbourne Australia 13-15 January. A great event, I’ve been to several of its predecessors. People there don’t care an awful lot for databases, but they do realise that sometimes it’s important to either learn more about it or talk to someone specialised in that field. And when discussing general [...]
Filed under: Conferences by arjen on Wednesday, December 7, 2011 | Social tagging: database > DDU > DownUnder > drupal > mariadb > melbourne > mysql > training
No Comments »
This recent session at OSDC 2011 Canberra is based on part of an Open Query training day, and (due to time constraints) without much of the usual interactivity, exercises and further MySQL specific detail. People liked it anyway, which is nice! The info as presented is not MySQL specific, it provides general insight in how [...]
Filed under: Conferences by arjen on Thursday, November 24, 2011 | Social tagging: concurrency > database > locking > mariadb > mysql > osdc > sql > transactions > video
1 Comment »
I found Dennis the Menace, he now has a job as system administrator for a hosting company. Scenario: client has a problem with a server becoming unavailable (cause unknown) and has it restarted. MySQL had some page corruption in the InnoDB tablespace. The hosting provider, being really helpful, goes in as root and first deletes [...]
Filed under: Good practice / Bad practice by arjen on Monday, October 31, 2011 | Social tagging: destruction > helpful > hosting > InnoDB > logfile > mysql > recovery > sysadmin > tablespace
21 Comments »
In 2007, Etsy made a big bet on homegrown middleware to help with the site’s scalability. A half-year after it was taken live, the company decided to abandon it. As a senior software engineer at Etsy put it, “if you’re doing something ‘clever,” you’re probably doing it wrong.” Read the full article at Arstechnica.com I [...]
Filed under: Good practice / Bad practice by arjen on Wednesday, October 5, 2011 | Social tagging: architecture > design > enterprise > middleware > mysql > scalability > scaling > stored procedures
No Comments »
Some so-called “Green” harddisks don’t like being in a RAID array. These are primarily SATA drives, and they gain their green credentials by being able reduce their RPM when not in use, as well as other aggressive power management trickery. That’s all cool and in a way desirable – we want our hardware to use [...]
Filed under: Software and tools by arjen on Monday, September 26, 2011 | Social tagging: array > backup > Green > harddisk > hd > HDD > mariadb > mysql > raid > SAS > SATA
No Comments »
My colleagues and I are looking for extra talent – is that you? What we do:help clients prevent problems (rather than being the fire department), we work on a subscription basis although we also do some ad-hoc consulting, and training. Apart from MySQL/MariaDB query and DBA work, we do quite a bit of system administration. [...]
Filed under: Uncategorized by arjen on Thursday, September 15, 2011 | Social tagging: centos > debian > jobs > mariadb > mysql > redhat > rhel > ubuntu
No Comments »
This week, ten years ago, I was in London for MySQL AB‘s first “train the trainer” course, also meeting (for the first time) my first boss at MySQL Kaj. I’d been hired mid August as employee#25, also doing training but actually primarily as tech-writer for the MySQL documentation (taking over from Jeremy Cole, and essentially [...]
Filed under: Uncategorized by arjen on Tuesday, September 13, 2011 | Social tagging: anniversary > bluehackers > luv > mysql > pythian > sun > upstarta
No Comments »
WikiLeaks Cable Offers New Insights into Oracle-Sun Deal (PC World) Nothing too new or shocking in there, but the cable does offer some interesting insights.
Filed under: Uncategorized by arjen on Wednesday, August 31, 2011 | Social tagging: mysql > oracle > pcworld > sun > wikileaks
No Comments »
XKCD (as usual) makes a very good point – this time about password strength, and I reckon it’s something app developers need to consider urgently. Geeks can debate the exact amount of entropy, but that’s not really the issue: insisting on mixed upper/lower and/or non-alpha and/or numerical components to a user password does not really [...]
Filed under: Good practice / Bad practice by arjen on Thursday, August 11, 2011 | Social tagging: application > database > entropy > java > mariadb > mysql > password > php > python > rails > ruby > security > web > xkcd
No Comments »
I’ve done a minor update to the hdlatency tool (get it from Launchpad), it now has a –quick option to have it only do its tests with 16KB blocks rather than a whole range of sizes. This is much quicker, and 16KB is the InnoDB page size so it’s the most relevant for MySQL/MariaDB deployments. [...]
Filed under: Software and tools by arjen on Thursday, June 16, 2011 | Social tagging: hdlatency > InnoDB > iscsi > latency > mariadb > mysql > raid > SAN
2 Comments »