Archive for 'Database' Category

Skip duplicate entries in a slave with MySql

By jbayer - Last updated: Tuesday, January 10, 2012

While setting up some replication, I got a duplicate key error on the slave. Since I knew it wasn’t a problem, I just wanted to bypass it and continue with the replication. The attached script will do that. Briefly, it checks the slave status and if there is a Duplicate entry error, then it stops […]

651 views

Upgrading Existing CentOS 5 with Percona Server

By jbayer - Last updated: Saturday, December 31, 2011

Percona has fixed a number of bugs and made improvements to MySql.  If you want to upgrade your mysql server to Percona Server, the following steps are necessary to upgrade an existing CentOS 5 server.  Be sure to backup your database BEFORE doing this. Install Percona Yum repository: rpm -Uhv http://www.percona.com/downloads/percona-release/percona-release-0.0-1.x86_64.rpm Identify the mysql rpms: […]

895 views

Installing Zabbix on a CentOS/RedHat system (Updated)

By jbayer - Last updated: Friday, December 23, 2011

I needed to do several repeated installs of Zabbix, on both a CentOS 5.6 and Centos 6.1 system.  I also noted that Zabbix had been updated, along with a couple of other version changes.  This version also allows you to do upgrades on an existing system.  However, the upgrade has only been tested on installations […]

1,154 views

Monitor long MySql queries

By jbayer - Last updated: Tuesday, December 13, 2011

At work we have a very large mysql database, over 250 gig in size, and it is extremely busy.  We need to know when a query is taking too long;  the reason could be a code bug, or just a very long operation.  Regardless, these long queries have the possibility to hang the server. The […]

697 views
asd