http://thedailywtf.com/Articles/The-AntiSQL-Coalition-.aspx “There is a small coalition of developers at the office who are vehemently anti-database,” writes Bob, “naturally, this faction also doesn’t value ‘experience’ — mostly, because they have none. At least, not outside their university studies. They’ll often liken a database server to a file system, and suggest that it’s just a convenient way [...]
Filed under: Uncategorized by arjen on Tuesday, November 22, 2011
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 »
http://www.moserware.com/2009/09/stick-figure-guide-to-advanced.html Jeff Moser on software development
Filed under: Software and tools, Uncategorized by arjen on Wednesday, August 24, 2011 | Social tagging: database > encryption
No Comments »
Some of you already know since you helped us move, we recently shifted Open Query’s main office to Fifth Avenue, next door to Elizabeth’s. The new place is comfortable, I really like it so far. Anna is also happy with her new admin space and cat Figaro has found an empty spot on a bookshelf [...]
Filed under: Uncategorized by arjen on Friday, April 1, 2011 | Social tagging: mariadb > mysql
No Comments »
As you may know Open Query uses PayPal for some of its financial transactions. I filed the following question with PayPal support. Note that with this question I regard it as completely immaterial whether one supports of Julien Assange or WikiLeaks actions or not. Naturally companies have the right to choose which clients to serve, [...]
Filed under: Uncategorized by arjen on Tuesday, December 7, 2010 | Social tagging: paypal > wikileaks
1 Comment »
The following quirky dynamic SQL will scan each index of each table so that they’re loaded into the key_buffer (MyISAM) or innodb_buffer_pool (InnoDB). If you also use the PBXT engine which does have a row cache but no clustered primary key, you could also incorporate some full table scans. To make mysqld execute this on [...]
Filed under: Uncategorized by arjen on Wednesday, December 1, 2010 | Social tagging: cache > failover > init-file > mariadb > master > mysql > preload > replication > slave
2 Comments »
A catchy headline, and I believe more accurate than Oracle Puts the Squeeze on SMBs with MySQL Price Hike (Network World) and MySQL price hikes reveal depth of Oracle’s wallet love [MySQL Jacking up MySQL Prices] (The Register). Slightly more realistic is Oracle kills low-priced MySQL support (again The Register). First, let’s review what Oracle [...]
Filed under: Uncategorized by arjen on Friday, November 5, 2010 | Social tagging: enterprise > enterprise basic > enterprise silver > gpl > mariadb > mysql > oracle > service > support > upstarta
6 Comments »
Unless you set sync_binlog = 1, a system crash on the master will likely fail any slave with an “Client requested master to start replication from impossible position” error. Generally, this kind of situation requires manual intervention. When we see this, we make sure things indeed failed “past the end” of a binlog (i.e. the [...]
Filed under: Uncategorized by arjen on Friday, September 3, 2010 | Social tagging: mysql mariadb replication maatkit recovery sync_binlog fsync
No Comments »