http://netvouz.com/falko/tag/mysql?feed=rss falko's bookmarks tagged "mysql" on Netvouz http://www.howtoforge.com/apache2-logging-to-a-mysql-database-with-mod_log_sql-on-debian-etch This guide shows how you can write the Apache2 access log to a MySQL database instead of a file. To achieve this, I use the Apache2 module mod_log_sql. I am using a Debian Etch server in this tutorial. falko Sun, 06 Jul 2008 09:40:29 GMT http://www.howtoforge.com/centos-4.6-server-lamp-email-dns-ftp-ispconfig This tutorial shows how to set up a CentOS 4.6 based server that offers all services needed by ISPs and web hosters: Apache web server (SSL-capable), Postfix mail server with SMTP-AUTH and TLS, BIND DNS server, Proftpd FTP server, MySQL server, Dovecot POP3/IMAP, Quota, Firewall, etc. This tutorial is written for the 32-bit version of CentOS 4.6, but should apply to the 64-bit version with very little modifications as well. falko Thu, 10 Jan 2008 13:11:52 GMT http://www.howtoforge.com/configuring-your-lemp-system-linux-nginx-mysql-php-fpm-for-maximum-performance If you are using nginx as your webserver, you are looking for a performance boost and better speed. nginx is fast by default, but you can optimize its performance and the performance of all parts (like PHP and MySQL) that work together with nginx. Here is a small, incomprehensive list of tips and tricks to configure your LEMP system (Linux, nginx, MySQL, PHP-FPM) for maximum performance. These tricks work for me, but your mileage may vary. Do not implement them all at once, but one by one and check what effect the modification has on your system's performance. falko Sun, 23 Sep 2012 09:25:26 GMT http://www.howtoforge.com/creating-advanced-mysql-based-vhosts-on-lighttpd-debian-etch This guide explains how you can create advanced virtual hosts on a lighttpd web server on Debian Etch that are stored in a MySQL database. The method described here does not use the lighttpd mod_mysql_vhost module, and unlike mod_mysql_vhost (which allows you to store only the hostname and document root of a vhost in a database), this method allows to store individual configuration directives for each vhost in the MySQL database. falko Tue, 19 Aug 2008 10:50:14 GMT http://www.howtoforge.com/creating-advanced-mysql-based-virtual-hosts-on-lighttpd-ubuntu-12.04 This guide explains how you can create advanced virtual hosts on a lighttpd web server on Ubuntu 12.04 that are stored in a MySQL database. The method described here does not use the lighttpd mod_mysql_vhost module, and unlike mod_mysql_vhost (which allows you to store only the hostname and document root of a vhost in a database), this method allows to store individual configuration directives for each vhost in the MySQL database. falko Sun, 09 Sep 2012 08:47:30 GMT http://www.howtoforge.com/creating-mysql-backups-with-automysqlbackup-on-ubuntu-9.10 AutoMySQLBackup is a shell script that lets you take daily, weekly and monthly backups of your MySQL databases using mysqldump. It can back up multiple databases, compress the backups, back up remote databases, and email the logs. This tutorial explains how to install and use it on an Ubuntu 9.10 server. falko Fri, 19 Feb 2010 11:30:15 GMT http://www.howtoforge.com/creating-simple-vhosts-with-mod_mysql_vhost-on-lighttpd-debian-etch This guide explains how you can use mod_mysql_vhost to create simple virtual hosts on a lighttpd web server on Debian Etch. With mod_mysql_vhost, lighttpd can read the vhost configuration from a MySQL database. Currently, you can store the domain and the document root in the MySQL database which results in very simple virtual hosts. If you need more directives for your vhosts, you would have to configure them in the global section of lighttpd.conf, which means they would be valid for all vhosts. Therefore, mod_mysql_vhost is ideal if your vhosts differ only in the domain and document root. falko Thu, 07 Aug 2008 09:14:55 GMT http://www.howtoforge.com/creating-simple-virtual-hosts-with-mod_mysql_vhost-on-lighttpd-debian-squeeze This guide explains how you can use mod_mysql_vhost to create simple virtual hosts on a lighttpd web server on Debian Squeeze. With mod_mysql_vhost, lighttpd can read the vhost configuration from a MySQL database. Currently, you can store the domain and the document root in the MySQL database which results in very simple virtual hosts. If you need more directives for your vhosts, you'd have to configure them in the global section of lighttpd.conf, which means they'd be valid for all vhosts. Therefore, mod_mysql_vhost is ideal if your vhosts differ only in the domain and document root. falko Tue, 21 Aug 2012 08:35:28 GMT http://www.howtoforge.com/fedora-8-server-lamp-email-dns-ftp-ispconfig This is a detailed description about how to set up a Fedora 8 server that offers all services needed by ISPs and hosters: Apache web server (SSL-capable), Postfix mail server with SMTP-AUTH and TLS, BIND DNS server, Proftpd FTP server, MySQL server, Dovecot POP3/IMAP, Quota, Firewall, etc. This tutorial is written for the 32-bit version of Fedora 8, but should apply to the 64-bit version with very little modifications as well. falko Thu, 08 Nov 2007 16:54:17 GMT http://www.howtoforge.com/postfix_mysql_dovecot_dspam_clamav_postgrey_rbl_debian_etch This guide describes how to set up a full email solution in Debian Linux (all code is from Debian Etch). I was asked to design a secure, scalable, portable solution for a small company. While the guide references many servers, the company only had 4 physical machines, Xen was used to virtualize the entire solution. That particular aspect of the system is not discussed in this guide, although I will try to get it into the next revision. falko Wed, 31 Oct 2007 09:56:05 GMT