Posts tagged as database

Having your storage ripped from out from under your database is never good. I recently had to go through this where our iscsi storage backend powering our virtual machine vmdk's magically died and even worse, its write cache was completely clear…

When migrating from one server to another, migrating the sql database is usually advantageous. There are two ways to do this, dumping the old database to a file(s) and re-importing that file to the new server, or, copy the database files themsel…

MySQL InnoDB engine based databases support compression of table data using zlib compression algorithm. From the official documentation, it is quite easy to create or alter a table to support compression! It of course helps quite a bit with colu…

So I run multiple pastebin services. One day, a friend needed a paste from weeks ago and so to the database I went (using stikked). I needed to search the paste content, known as column “raw” and pull out the record corresponding to the content…