- Apache2: Logging To A MySQL Database With mod_log_sql (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.
in Public bookmarks - CentOS 4.6 Server Setup - LAMP, Email, DNS, FTP, ISPConfig (a.k.a. The Perfect Server)
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.
in Public bookmarks - 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.
in Public bookmarks - Creating Advanced MySQL-Based Virtual Hosts 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.
in Public bookmarks - 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.
in Public bookmarks - 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.
in Public bookmarks - Creating Simple Virtual Hosts 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.
in Public bookmarks - 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.
in Public bookmarks - Fedora 8 Server Setup - LAMP, Email, DNS, FTP, ISPConfig (a.k.a. The Perfect Server)
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.
in Public bookmarks by 2 users - Full Mail Server Solution w/ Virtual Domains & Users (Debian Etch, Postfix, Mysql, Dovecot, DSpam, ClamAV, Postgrey, RBL)
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.
in Public bookmarks - Groupware Server With Group-Office, Postfix, Dovecot And SpamAssassin On Debian Lenny (5.0)
In this howto I will explain how you can set up a groupware server using the Debian Linux operating system, Group-Office for managing the mailboxes and groupware functions like e-mail, shared calendars, file sharing etc., Postfix with virtual accounts in MySQL, Dovecot IMAP, SpamAssassin spam filter, and a vacation perl script that will handle out-of-office replies.
in Public bookmarks - How To Back Up MySQL Databases With mylvmbackup On Ubuntu 12.10
mylvmbackup is a Perl script for quickly creating MySQL backups. It uses LVM's snapshot feature to do so. To perform a backup, mylvmbackup obtains a read lock on all tables and flushes all server caches to disk, creates a snapshot of the volume containing the MySQL data directory, and unlocks the tables again. This article shows how to use it on an Ubuntu 12.10 server.
in Public bookmarks - How To Back Up MySQL Databases Without Interrupting MySQL | HowtoForge
This article describes how you can back up MySQL databases without interrupting the MySQL service. Normally, when you want to create a MySQL backup, you either have to stop MySQL or issue a read lock on your MySQL tables in order to get a correct backup; if you do not do it this way, you can end up with an inconsistent backup. To get consistent backups without interrupting MySQL, I use a little trick: I replicate my MySQL database to a second MySQL server, and on the second MySQL server I use a cron job that creates regular backups of the replicated database.
in Public bookmarks - How To Benchmark Your System (CPU, File IO, MySQL) With sysbench
sysbench is a benchmark suite which allows you to quickly get an impression about system performance which is important if you plan to run a database under intensive load. This article explains how to benchmark your CPU, file IO, and MySQL performance with sysbench.
in Public bookmarks - How To Install A Complete LEMP (Linux - EngineX (Nginx HTTP SERVER) - Mysql - PHP) Server On Ubuntu/Debian
This HowTo will describe the setup of an efficient http server and mail server for small or medium configurations (as low as 96 mb). Why LEMP instead of LAMP? NGINX is a great replacement for Apache with very low memory footprint and great stability.
in Public bookmarks by 2 users - How To Install MySQL 5.6 On Ubuntu 12.10 (Including memcached Plugin)
According to What's New in MySQL 5.6, MySQL 5.6 will bring some performance improvements over MySQL 5.5. If you want to test out MySQL 5.6, you have to install one of the development releases from the MySQL downloads page because there is no stable release yet. This tutorial explains how to install the MySQL 5.6.8rc1 (Linux Generic) development release on an Ubuntu 12.10 server.
in Public bookmarks - How To Install Percona Server 5.5 On Ubuntu 12.10
Percona Server is a drop-in replacement for MySQL. It offers more performance and scalability than the default MySQL server coming with your Linux distribution, while it uses the same init scripts and command line tools which makes it easy to use. This tutorial explains how to install Percona Server 5.5 on Ubuntu 12.10.
in Public bookmarks - How To Set Up A Load-Balanced MySQL Cluster With MySQL 5.1
This tutorial shows how to configure a MySQL 5.1 cluster with five nodes: 1 x management, 2 x storage nodes and 2 x balancer nodes. This cluster is load-balanced by an Ultra Monkey package which provides heartbeat (for checking if the other node is still alive) and ldirectord (to split up the requests to the nodes of the MySQL cluster).
in Public bookmarks - How To Set Up Database Replication In MySQL On Ubuntu 9.10
This tutorial describes how to set up database replication in MySQL. 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. This is not a backup policy because an accidentally issued DELETE command will also be carried out on the slave; but replication can help protect against hardware failures.
in Public bookmarks - How To Set Up MySQL Database Replication With SSL Encryption On CentOS 5.4
This tutorial describes how to set up database replication in MySQL using an SSL connection for encryption (to make it impossible for hackers to sniff out passwords and data transferred between the master and slave). 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. This is not a backup policy because an accidentally issued DELETE command will also be carried out on the slave; but replication can help protect against hardware failures.
in Public bookmarks
Copyright © 2003-2010 Netvouz. All rights reserved. |
RSS Feed
|
Blog |
Contact |
Terms of use |
Cookies |
Privacy policy
RSS Feed
|
Blog |
Contact |
Terms of use |
Cookies |
Privacy policy