E-commercre Report; Several of the most popular online merchants have struggled to cope with the heavy holiday traffic, a survey shows. Ok, that was NYTimes 2003 – what about now? This season there have already been several announcements of ecommerce snafus. Sears.com site shut down for a couple of hours and there have even [...]
Tags: hosting
Looking back it seems like most posts on this blog are helpful tips and not reports of problems we encountered. Not that we don’t have any problems but we mostly report our solutions instead of the actual problems. Of course now and again a problem comes along that doesn’t have a solution ready to copy-paste [...]
If you can’t do it with a shell script it usually ain’t worth doin’, right? Of course the number and quality of monitoring tools available to sys admins has gone up dramatically. Thanks to Nagios and other great tools it’s pretty easy to keep track of what’s going on and where and get notified pretty [...]
Tags: connections·monitoring·MySQL·shell
We are using a replication setup for our databases. The master database takes care of all the transactions and the slave database is used for hot standby, making backups and running reports. Running mysqldump for backups locks the main tables one by one (we’re using the MyISAM storage engine) and was causing user interruptions. Hence [...]
Tags: 1062·MySQL·Replication·slave
We have check_hparray plugin installed on all of our HP servers, running CentOS, for monitoring hardware raid via HP Array Configuration Utility CLI (hpacucli) tool, and we have NRPE installed as well for this check from our remote Nagios server. Yesterday we’ve setup another HP server and installed NRPE, check_hparray, and hpacucli, same process used [...]
Tags:
We encountered a situation recently where the number of connections to our MySQL database started creeping up slowly but steadily. Strangely enough all the connections were in sleep mode and the database was not being stressed. The number of connections first reached 30 where it normally stays below 20 and started triggering our monitoring scripts. [...]
