Brian Aker, a principal engineer for MySQL at Sun, explains the Drizzle project: a new, stripped-down derivative of MySQL that relies on best-of-breed internal libraries, eliminates support for obsolete platforms, and has already attracted contributors from outside Sun.
Also huffduffed as…
Josh Lerner of Harvard Business School talks to Viv Davies about his book, co-authored with Mark Schankerman, ‘The Comingled Code: Open Source and Economic Development’. Lerner discusses the economic impact of open source software and its relationship with innovation and growth. Drawing from a new database, Lerner describes how open source and proprietary software interact and suggests how government policy should ensure that open source competes effectively with proprietary software. The interview was recorded by telephone on 14 February 2011.
Database optimisation A real life example getting more throughput with fewer queries.
Over the last year we’ve grown a database from a few hundred megabytes to just over one terabyte. The database is reported on and populated by a network of servers using PHP. As the database has grown we’ve had to look again our initial assumptions and ways of working. One table has over 2billion rows; 2.5 million rows every day are added to another table. This talk will cover how we use explain, foreign keys, normalising data without sacrificing performance, queuing and using memcache. And, how we’ve made the system run faster now than it did with a much smaller database.