MySQL requires maintenance

Even if you’re running on a tiny VPS or on a huge server when you have a LAMP stack your biggest memory consumer will probably be MySQL. Some even prefer running it on a different machine when it comes to high traffic web apps. But, as your apps are put…
Tips & Tricks

TIP: Make Postfix use less SQL connections

When you manage Postfix mail servers using SQL connections to find informations about usernames, mailbox/maildir locations on the disk you probably have in your main.cf something like : virtual_alias_maps = mysql:/etc/postfix/mysql_virtual_alias_maps.cf virtual_mailbox_domains = mysql:/etc/postfix/mysql_virtual_domains_maps.cf virtual_mailbox_maps = mysql:/etc/postfix/mysql_virtual_mailbox_maps.cf relay_domains = mysql:/etc/postfix/mysql_relay_domains_maps.cf But, this way, each process(postfix process) uses one MySQL connection.…
Tips & Tricks

Running on MariaDB

An old and good friend of mine kept telling me that MariaDB is faster and better that the good old MySQL, that wince Oracle got it, MySQL is not what it used to be. So I decided to try it. I went to MariaDB website, to “Repository Configuration Tool”, chose…
linux