Pinboard: bookmarks for rcrowley tagged 'db'

An Erlang implementation of on-disk sorted sets. The details of the format are undocumented but incredibly important - I've tried to build a similar API before while keeping the data files sorted on disk. The cascading writes that were necessary to keep the file ordered killed it. Now I need to learn Erlang.

osmos erlang db kv redis
february 2010 by rcrowley

copy to mine

Kyoto Cabinet: a straightforward implementation of DBM

A successor to TC by the same guy in C++ that's supposedly better.

tokyocabinet kyotocabinet db dbm c++
january 2010 by rcrowley

copy to mine

WTF is a SuperColumn? An Intro to the Cassandra Data Model — Arin Sarkissian

Arin's concrete walkthrough of the Cassandra data model.

cassandra db columnstore bigtable dynamo
october 2009 by rcrowley

copy to mine

firstworks: sql relay - sqlrelay persistent database connection pool pooling proxy load balance balancing odbc oracle mysql msql postgresql sybase db2 interbase sqlite access c++ perl DBD DBI python php zope ruby tcl java jni unix linux persistant

Like MySQL-Proxy but (importantly) not.

mysql sqlrelay mysqlproxy db loadbalancer
september 2009 by rcrowley

copy to mine

fault-tolerance.png (PNG Image, 784x393 pixels)

All I want for Christmas is a SQL database with no JOINs, secondary indexes, UNIONs, views, character sets or anything else. Just exact and range primary key lookups, GROUP BY, ORDER BY, LIMIT and SQL_CALC_FOUND_ROWS.

sql db erlang comic humor
august 2009 by rcrowley

copy to mine

Riak - A Decentralized Database

MOAR NOSQL

riak nosql db erlang kv dist
august 2009 by rcrowley

copy to mine

jcole’s weblog: Jeremy Cole’s take on life. » Proposal for Constraining Memory Usage

MySQL memory usage cheat sheet.

mysql db memory
august 2009 by rcrowley

copy to mine

Maatkit: A toolkit that provides advanced functionality for MySQL

mk-paralllel-dump and mk-parallel-restore

maatkit mysql backup db
july 2009 by rcrowley

copy to mine

Choosing a non-relational database; why we migrated from MySQL to MongoDB « Boxed Ice Blog

A thorough walk-through of a production MongoDB deployment and the problems they encountered moving from MySQL (until the part where he doesn't know what atomic means).

mongodb db mysql
july 2009 by rcrowley

copy to mine

Tokyo Tyrant: network interface of Tokyo Cabinet

Please to email r@rcrowley.org if you know what the fuck lcnum and bnum actually mean in tuning a Tokyo Cabinet B+Tree database.

tokyocabinet tokyotyrant db performance
july 2009 by rcrowley

copy to mine

http://faemalia.net/mysqlUtils/dbmon.pl

Probably not a bad idea to start running this.

dbmon perl db mysql monitoring
july 2009 by rcrowley

copy to mine

up and running with cassandra :: snax

This intrigues me: "unlike most key/value stores, you can query for ordered ranges of keys." In my messing around with Cassandra, it's Thrift Interface seemed to actively hinder doing anything like this.

cassandra java thrift kv db dist
july 2009 by rcrowley

copy to mine

Plurk Open Source - LightCloud - Distributed and persistent key value database

I could bolt libketama on the front of Net::Tyrant, or I could translate this to PHP.

lightcloud tokyocabinet tokyotyrant python kv db dist
june 2009 by rcrowley

copy to mine

Detailed review of Tokutek storage engine | MySQL Performance Blog

TokuDB: Good at lots of INSERTs and lots of data (efficient on-disk format). Bad at UPDATEs and anything that fits completely in memory.

tokudb mysql db
may 2009 by rcrowley

copy to mine

mySQL DBA: Walking an INNODB table Fast

Been doing about the same thing except selecting by a prefix of the binary(20) primary key.

mysql innodb db
march 2009 by rcrowley

copy to mine

Redis, my new open source project

LPUSH "Atomic appends!"

redis kv db dist
march 2009 by rcrowley

copy to mine

Anti-RDBMS: A list of distributed key-value stores | Richard Jones, Esq.

Good survey of the key-value storage landscape as of January 2009. Probably wrong by now. His findings mirror my own - memcachedb and perhaps Tokyo Tyrant look the best. Eventual consistency is the big open question for every use case except OpenDNS Stats.

memcachedb tokyocabinet tokyotyrant lastfm kv db couchdb dynamo cassandra hbase
february 2009 by rcrowley

copy to mine

Tokyo Cabinet and Tokyo Tyrant Presentation
tokyocabinet tokyotyrant bdb btree db kv
february 2009 by rcrowley

copy to mine

Tokyo Cabinet: Beyond Key-Value Store - igvita.com

Everyone speaks memcache these days.

tokyocabinet tokyotyrant bdb btree db kv
february 2009 by rcrowley

copy to mine

QDBM: Quick Database Manager
unix db dbm qdbm api
october 2008 by rcrowley

copy to mine

The Freebase Blog » Blog Archive » A Brief Tour of Graphd

I've been tagging all of this kind of stuff as "db" but the line is being crossed.

freebase graphd db
september 2008 by rcrowley

copy to mine

MySQL :: MySQL 5.0 Reference Manual :: 13.2.11 InnoDB Performance Tuning Tips

"If you can afford the loss of some of the latest committed transactions if a crash occurs, you can set the innodb_flush_log_at_trx_commit parameter to 0. InnoDB tries to flush the log once per second anyway, although the flush is not guaranteed."

Oh lord, help me.

innodb mysql performance db
september 2008 by rcrowley

copy to mine