Will your production MySQL server survive a restart?
Do you know if your production MySQL servers will come back up when restarted? A recent support episode illustrates a number of best practices.
Do you know if your production MySQL servers will come back up when restarted? A recent support episode illustrates a number of best practices.
Since you were going to linux.conf.au 2010 in Wellington, NZ anyway in January of next year, you should submit a proposal to speak at the data storage and retrieval miniconf. If you have something to say about storage hardware, file systems, raid, lvm, databases or anything else linux or open source and storage related, please [...]
So, I’m in my hotel room and I got some sleep. Now, it is 2:15 am and Icouldn’t sleep for some reason. PRobably has something to do with me being narcoleptic, as weird as it sounds Since I can’t sleep for a bit anyway, I figured writing a blog summarising the first day of FrOSCon [...]
Looking at twitter #songsincode (just search on #songsincode tag), it appears a large chunk of geeky/nerdy world has come to a halt while spending the day expression song titles in code. So far we’ve seen most programming languages as well as CSS and SQL come by. I think it’s a nice example of how “the collective” [...]
I arrived yesterday in St. Augustin, near Bonn in Germany. After a good day of hitchhiking (weather is beautiful here) I stayed with my Pakistani Couchsurfing host and we had an extremely interesting evening talking about the gigantic cultural differences between western civilization and Pakistani civilization. It beats staying in a hotel by about a [...]
After reading Fernando Ipar’s interesting post on partial indexes for string columns, there were two things I wanted to note: First, this trick works quite well, but only if your like clauses only ever use the wildcard on the right hand side (or not at all). MySQL will not be able to use the index [...]
I’ve found that exchanging ideas and asking questions, even with people some might consider to be direct competitors, is more valuable than risky. Enter… Upstarta.biz is the home of a group of people who run, or are interested in running, their business according to a set of Principles that make them more people friendly (both [...]
Only the other day I was talking with someone who does a lot of work on the shell command line, but hadn’t used the GNUÂ screen tool, so I’d better scribble a post about it as I regard it as an absolute must-have for any remote work, for multiple reasons. First of all, what screen does. [...]
VirtualBox defaults to ignoring IDE Flush Cache commands, which may increase the risk of guest filesystem/database corruption on a host system crash.