Removing an application and its dependencies on CentOS/RHEL
By default yum remove only removes the package you specify. To also remove everything that got installed along with it, use the yum-plugin-remove-with-leaves...
Recent Posts
Thoughts on Clustering: Part 3 - Varnish Cache
Finally got my thoughts together to continue rambling about how to make life harder for yourself while cutting server load.
MySQL: setting up replication
OK. This isn’t an original article. There’s plenty like it on the internet already. I need it so I don’t have to google it every time I need a cheat sheet.
Working around the The server principal already exists message
While moving MSSQL users I got this message:
Installing Munin on CentOS
Munin is a tool for monitoring network devices with the ability to keep a history of their performance. You can view the performance graphs in a browser.
A few useful tricks for the WordPress theme functions file
WordPress is a solid platform, offering reliable development and endless customization. Working with this CMS I picked up a few useful tricks I want to share:
Copying a Parallels Virtuozzo container to a new hypervisor
In this note I want to cover how to copy/migrate a Parallels Virtuozzo container to KVM/VMware ESX/VirtualBox.
Automating Database Transfers Between MSSQL 2008 Servers
Spitting on Windows server projects again. The other day I ran into a task - needed to move a few hundred databases from one server to another.
Connecting Linked Servers on a new MSSQL
I was setting up a second MSSQL server for a client and hit a problem with configuring Linked Servers on it. The first server had two linked MSSQL instances....
A Useful Little Trick, Using the Browser Console
Some tasks get solved through the browser console (F12), with a pretty good return on effort. Still, whenever I do this, I can’t shake the feeling that I’m j...
Making a Backup of All Databases in MSSQL Server 2008
Sometimes you need to make a one-off backup of all databases (all databases) so you can move them somewhere or gather them in a separate storage location.
Using NginX behind a load balancer with correct ip addresses in the logs
If you have Varnish + NginX on the server, every visitor in the NginX logs will show up with the same ip address - 127.0.0.1. There are two options:
Thoughts on Clustering: Part 2 - Serving Static Content
I spent a while thinking about how to continue the series on clusters. In the previous article <a href="http://www.tech-notes.net/notes-about-clusters/" t...
Things you might not know about Insert in MySQL
Anyone who’s worked with MySQL databases in their code has run into the INSERT statement. Turns out not everyone, even experienced developers, knows how to u...
Magento Got Stuck on Data Reindexing
Someone reached out to me asking to check what’s wrong with their site. Said it wasn’t working.