I’m building mail server

I want to build mail server on my VPS (ubuntu). What I want to have is: multiple domains and users; users’ accounts in MySQL database; Courier package to control my pop and imap access to the emails. So.. let’s do it.

MySQL said: The total number of locks exceeds the lock table size

Two days ago I checked logs of my MySQL server and saw an error: “The total number of locks exceeds the lock table size”. What’s that and how to solve the problem?

Change e-mail address of recipient for mysqlcheck on debian/ubuntu

Yes, I’m back and I need to apologize for so long downtime. However… now I will go straight to the more interesting things. Mysqlcheck is executed after each start/restart of mysql daemon. After the checking of our databases – it sends e-mail message with warning and/or errors. How to change recipient of this e-mail message?

TOra with MySQL on Ubuntu

Yeah, sometimes everybody needs to use graphic SQL editor. For example… if you want to add more advanced triggers to your database.

Database replication in MySQL :: Master – Slave

I will try to describe how to set up database replication in MySQL. Replication allows you to have an exact copy of a database from a master server on another server (slave), and all updates to the database on the master server are immediately replicated to the database on the slave server so that both databases are in sync. Today I will describe how to set up replication Master – Slave, next time – I will write about replication Master – Master. So let’s go.

Build Django+MySQL+PIL on Windows

How to build django on windows? Now I know…. it’s really possible.