Using symbolic links for MySQL data files

Over a year ago, we had several servers configured for high traffic websites. A mispartioning resulted in /var becoming obscenely small, and it was only after MySQL crashed that we remembered this. We couldn’t afford more downtime if we dealt with the partition size problem, so I thought of quickly moving the data files into /home/mysql/{dbname} from /var/lib/mysql/{dbname} and create the symlink /var/lib/mysql/{dbname} -> /home/mysql/{dbname}.

I was not certain of the performance implications to this. I heard from a fellow Linux junkie here that there may be a slight penalties in terms of access speed, since /home was meant for generic read/write, whereas /var was accessed in a very quick manner. Gotta verify this. But for now, I dwell in the power of symbolic links.

Comments

Family Visits Singapura

My parents and in-laws traveled to Singapore last September and it was truly memorable! I'm trying out some code to display a Google Photos album and it's quite cool that I'm able to embed the album here. Credits to Pavex for the great tool. He details out how to use it here . Check out the album below!

March was a good month. Not just because it's my birthday month, but I've been able to do more physical exercises as far as I'm allowed, and I've also been able to get through my first month back in the job. For the first couple of weeks, I thought I was going to do 4 hours a day at most, and turn up the heat bit by bit until I'm able to do 100% again. But I suppose having to rest over a month does have its toll. It took significant effort to try not go all in with guns blazing on the first day back at work. LOL Anyway, I'm trying something new this year. We've migrated our applications to a better platform, and we'd like to push that to the cloud this year. It'll obviously need a lot of liaising and cooperative work with other teams and domains so I'm going to do more engagement and solutioning than the usual engineering this time. Last week, we did a platform-related hackathon and a critical refresh across clusters. There's going to be a lo

Get through your email faster with Gmail Priority Inbox

This is great for people who do not use a GTD system yet. Try it and see how fast it learns. Priority Inbox Beta Welcome to Priority Inbox! By automatically separating out your most important messages, Priority Inbox makes it easy for you to read and respond to the messages that matter. Get through your email faster Try reading and replying to the messages in the "Important and Unread" section first. Mark anything that requires follow-up with a star, then go through the "Everything Else" section. If you leave Priority Inbox, you can return to it by clicking the link next to Inbox on the side navigation of Gmail. How it works Gmail's servers look at several types of information to identify the email that's important to you, including who you email and chat with most, how often you email with these people, and which keywords appear frequently in the emails you read.

aggregated thinking

Search This Blog