http://netvouz.com/falko/tag/mysql?feed=rss&pg=2 falko's bookmarks tagged "mysql" on Netvouz http://www.howtoforge.com/how-to-set-up-mysql-database-replication-with-ssl-encryption-on-ubuntu-9.10 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. falko Tue, 09 Feb 2010 01:47:30 GMT http://www.howtoforge.com/setting-up-webdav-with-mysql-authentication-on-apache2-debian-etch This guide explains how to set up WebDAV with MySQL authentication (using mod_auth_mysql) on Apache2 on a Debian Etch server. WebDAV stands for Web-based Distributed Authoring and Versioning and is a set of extensions to the HTTP protocol that allow users to directly edit files on the Apache server so that they do not need to be downloaded/uploaded via FTP. Of course, WebDAV can also be used to upload and download files. falko Thu, 19 Jun 2008 09:40:38 GMT http://www.howtoforge.com/installing-a-multiserver-setup-with-dedicated-web-email-dns-and-mysql-database-servers-on-debian-5.0-with-ispconfig-3 This tutorial describes the installation of an ISPConfig 3 multiserver setup with dedicated web, email, database and two DNS servers all managed trough a single ISPConfig 3 control panel. The setup described below uses five servers and can be extended easily to to a higher number of servers by just adding more servers. E.g. if you want to have two mailservers, do the setup steps from chapter 2 on both of these servers. If you want to set up more web servers, then install ISPConfig on all other web servers in expert mode except of the first one. falko Thu, 19 Aug 2010 16:43:45 GMT http://www.howtoforge.com/installing-a-web-email-and-mysql-database-cluster-on-debian-6.0-with-ispconfig-3 This tutorial describes the installation of a clustered web, email, database and DNS server to be used for redundancy, high availability and load balancing on Debian 6 with the ISPConfig 3 control panel. MySQL Master/Master replication will be used to replicate the MySQL client databases between the servers and Unison will be used to Sync the /var/www (websites) and /var/vmail (email account data) folders. falko Thu, 16 Feb 2012 11:54:34 GMT http://www.howtoforge.com/installing-apache2-with-php5-and-mysql-support-on-centos-5.3-lamp LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on a CentOS 5.3 server with PHP5 support (mod_php) and MySQL support. falko Tue, 18 Aug 2009 09:54:11 GMT http://www.howtoforge.com/installing-apache2-with-php5-and-mysql-support-on-centos-5.5-lamp LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on a CentOS 5.5 server with PHP5 support (mod_php) and MySQL support. falko Tue, 22 Feb 2011 13:41:41 GMT http://www.howtoforge.com/installing-apache2-with-php5-and-mysql-support-on-centos-5.6-lamp LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on a CentOS 5.6 server with PHP5 support (mod_php) and MySQL support. falko Thu, 16 Jun 2011 08:26:26 GMT http://www.howtoforge.com/installing-apache2-with-php5-and-mysql-support-on-centos-6.0-lamp LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on a CentOS 6.0 server with PHP5 support (mod_php) and MySQL support. falko Fri, 15 Jul 2011 11:03:31 GMT http://www.howtoforge.com/installing-apache2-with-php5-and-mysql-support-on-centos-6.2-lamp LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on a CentOS 6.2 server with PHP5 support (mod_php) and MySQL support. falko Sun, 18 Mar 2012 10:45:48 GMT http://www.howtoforge.com/installing-apache2-with-php5-and-mysql-support-on-centos-6.3-lamp LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on a CentOS 6.3 server with PHP5 support (mod_php) and MySQL support. falko Tue, 07 Aug 2012 10:46:18 GMT