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 »
http://gigaom.com/cloud/lexisnexis-open-sources-code-for-hadoop-alternative/ HPCC Systems has released the open source code of its data-processing software that it’s positioning as a better version of Hadoop. The code is available on Github, and it marks the commencement of HPCC Systems’ quest to build a community of developers underneath Hadoop’s expansive shadow.
Filed under: Software and tools by arjen on Saturday, September 10, 2011 | Social tagging: cluster > database > hadoop > hpcc
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 »
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 »
A user on a linux user group mailing list asked about this, and I was one of the people replying. Re-posting here as I reckon it’s of wider interest. > [...] tens of gigs of data in MySQL databases. > Some in memory tables, some MyISAM, a fair bit InnoDB. According to my > understanding, [...]
Filed under: Good practice / Bad practice, Software and tools by arjen on Tuesday, March 29, 2011 | Social tagging: backup > mariadb > mmm > mysqldump > recovery > replication > restore > xtrabackup
No Comments »
As a big fan of new technology, we try to keep up to date with what’s happening in the industry. As such, I decided to start using drizzle on my development machine since they announced GA this week. First exercise: import a file dumped from a MySQL server I don’t have access to into drizzle. [...]
Filed under: Software and tools by Walter Heck on Thursday, March 17, 2011 | Social tagging: drizzle > mysql
3 Comments »
Open Query currently hosts a large part of our infrastructure at Linode. We are extremely happy with their performance, stability and support. Unfortunately any chain is only as strong as it’s weakest link. This week, there was a major thunderstorm near the Hurricane Electric datacenter (anyone else think that name is funny in combination with [...]
Filed under: Software and tools by Walter Heck on Tuesday, November 23, 2010 | Social tagging: disaster > mmm > replication
No Comments »
With Paul McCullagh’s PBXT storage engine getting integrated into MariaDB 5.1, it’s never been easier to it out. So we have, on a slave off one of our own production systems which gets lots of inserts from our Zabbix monitoring system. That’s possibly an ideal usage profile, since PBXT is a log based engine (simplistically [...]
Filed under: Software and tools by arjen on Thursday, May 27, 2010 | Social tagging: InnoDB > mariadb > mysql > pbxt > storage engine > XA
1 Comment »
This is a Request for Input. Dual MySQL masters with MMM in a single datacentre are in common use, and other setups like DRBD and of course VM/SAN based failover solutions are conceptually straightforward also. Thus, achieving various forms of resilience within a single data-centre is doable and not costly. Doing the same across multiple [...]
Filed under: Software and tools by arjen on Friday, May 14, 2010 | Social tagging: datacentre > DRBD > failover > mariadb > mmm > mysql > replication > resilience > SAN > VM
4 Comments »
Walter and I are giving a tutorial on Monday morning, MySQL (and MariaDB) Dual Master Setups with MMM, I believe there are still some seats available – tutorials are a bit extra when you register for the conference, so you do need to sign up if you want to be there! It’s a hands-on tutorial/workshop, we’ll be [...]
Filed under: Conferences, GRAPH engine, Software and tools by arjen on Thursday, April 8, 2010 | Social tagging: graphengine > mariadb > mmm > mysql > mysqlconf > neo4j > open query > OQGRAPH
No Comments »