During my day-to-day activities, I use the Bash shell a lot. My #1 policy is to optimize the most frequently used activities as much as possible, so Iâ€ve compiled these handy bash shortcuts and hints (tested in SecureCRT on Windows and Konsole on Linux). The article only touches on the default bash mode – emacs, not vi. If you havenâ€t specifically assigned your shell mode to vi (set –o vi), youâ€re almost certainly using the emacs mode. Learn these and your shell productivity will skyrocket, I guarantee it.

Update #1: In response to a few people saying this list is too short and “[he] could've added something to it, to atleast make it look longer†(quote from one of Stumbleupon reviewers), I want to clarify something. I deliberately did not include …

How To Back Up MySQL Databases With mylvmbackup On Ubuntu 8.10

mylvmbackup is a Perl script for quickly creating MySQL backups. It uses LVM's snapshot feature to do so. To perform a backup, mylvmbackup obtains a read lock on all tables and flushes all server caches to disk, creates a snapshot of the volume containing the MySQL data directory, and unlocks the tables again. This article shows how to use it on an Ubuntu 8.10 server.

Our fiendish plot to provide advanced open source replication for MySQL and Oracle took another step forward yesterday. The Tungsten Replicator beta-3 build is available for download on our Forge site. This build is fully open source. Tungsten Replicator provides heterogeneous replication from MySQL to Oracle, seamless failover from a master to one of several slaves, event checksums, event filtering hooks, and a number of other useful replication features for MySQL and Oracle previously not offered outside of commercial products.

The beta-3 build has a number of important improvements:

• MySQL 5.1 row replication is largely working. We are still seeing problems with datetime and timestamp replication but most other datatypes work.
  
• The …

A lot of people keep asking me about the status of HSCALE so I thought it is best to just write about it.
Since I am waiting for the next GPL release of MySQL Proxy I concentrate on other things, both project-related and not project-related.

Continuous integration and test strategy enhancements

First of all there is a CI server up for almost 3 months now. Check out teamcity.hscale.org (Login as guest user). I also introduced a lint-process to discover bugs in my LUA code which arise mostly by mistyping variable names. By the way: You should definitely have a lint-like process in place if you are doing LUA programming or other languages of that type. It helps a lot.

What’s in svn trunk? Multiple backends

The current status is this: Spreading across multiple backends is fully …

You can read my conversation with Lenz Grimmer or look at other interviews conducted by the MySQL community team. 

You can read my conversation with Lenz Grimmer or look at other interviews conducted by the MySQL community team. 

• Two days in Frankfurt, two days in Munderkingen and two days in Heidelberg between December 5th and 17th. Mostly just ordinary working and travel days.
• Visited Sandro Groganz of Init Marketing in Munderkingen. Worked from Sandro's house after a nice dinner on Sunday.
• Caught up with (and was interviewed by) Rory MacDonald of Init Marketing while he was vacationing near Ulm. The interview was focused on Mozilla and should go online in the new year on http://www.initmarketing.tv
• Visited Georg Richter of …

Somehow these interviews did not pop up on PlanetMySQL this past week so I link them here for your holiday reading. These are a couple interviews by Lenz Grimmer and one by yours truly.

Interview with Lars Heill, Release Engineering Manager
Born in Northern Norway 41 years ago and Lars has lived in Trondheim for the last 22 years. He is a Physicist by education, has a master degree on semiconductor heterojunctures and has earned a PhD on high temperature superconductors. He worked briefly on nuclear power fuel optimization and petroleum related rock mechanics before joining Clustra in the year 2000, which was acquired by Sun Microsystems in 2002. Clustra was a database software vendor that specialized in clustered, high-availability databases that were required by telecoms and service providers.

…

There's any number of ways to integrate your application with Memcached to take advantage of Memcached's power. Here's a list of some of them (and because I am most familiar with PHP in this case so that's what I've listed, and by no means is it exhaustive):

1. Using the PECL PHP Memcached libraries you can write direct queries to Memcached with failover to your SQL queries.
2. Using the memcached UDFs so that you can write SQL queries into MySQL/Using the memcached storage engine
3. Using MySQL Proxy to interface with Memcached
4. Using …

During the course of my daily work I occasionally search for mysql queries which are cool and helpful. I once found the following query on http://forge.mysql.com/:

SELECT table_name article_attachment,
engine,
ROUND(data_length/1024/1024,2) total_size_mb,
ROUND(index_length/1024/1024,2) total_index_size_mb,
table_rows
FROM information_schema.tables
WHERE table_schema = ‘dbname’
ORDER BY 3 desc;

A generally  lite version is:

select table_schema, table_name, (data_length)/pow(1024,2) AS ‘Data Size in Meg’, (index_length)/pow(1024,2) AS ‘Index Size in Meg’  from tables order by 3 desc;

You can add or remove columns etc and but this query shows the table size (data wise) index size, approx number of rows, size in MB etc. If you would like to know what else is available to add to this query, just do a “desc tables” while using the …