Institutional Knowledge

When you think you are being smart by only giving your backup user SELECT privileges, don’t forget that you also need to be able to LOCK TABLES to use some of the mysqldump features.

That is all.

[Read more →]

Wherein we read documentation and then laugh heartily.

[Read more →]

Do:

Routinely clear out old data from databases

Don’t

Let the size of your database get out of control

[Read more →]

Wherein we flush ghosts from the mysql shell.

[Read more →]

Wherein we compile php rpms with Oracle support.

[Read more →]

Wherein we tie ruby to Oracle.

[Read more →]