http://netvouz.com/falko/tag/mysql?feed=rss&pg=12 falko's bookmarks tagged "mysql" on Netvouz http://www.howtoforge.com/exim-mysql-cyrus-imapd-horde-centos5.1 This guide describes the installation and configuration of a mail system on Centos 5.1 with SELinux enabled for enhanced security. This system will be able to service HTTP, HTTPS, SMTP, TLS, SMTP-AUTH, IMAP, POP3 clients and is virtual enabled allowing more than one domain to be served from the system. falko Thu, 21 Feb 2008 11:32:31 GMT http://www.howtoforge.com/managing-multiple-mysql-servers-from-one-phpmyadmin-installation-using-ssl-encryption This tutorial explains how you can manage multiple MySQL servers from one phpMyAdmin installation. For security reasons, communication between phpMyAdmin and any remote MySQL server is using SSL encryption (this is not necessary for a local MySQL server since communication between phpMyAdmin and MySQL is not leaving the server). phpMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQL over the World Wide Web. phpMyAdmin supports a wide range of operations with MySQL. falko Thu, 20 Sep 2012 06:50:49 GMT http://www.howtoforge.com/mysql-5-master-master-replication-fedora-8 This document describes how to set up master-master replication with MySQL 5 on Fedora 8. Since version 5, MySQL comes with built-in support for master-master replication, solving the problem that can happen with self-generated keys. In former MySQL versions, the problem with master-master replication was that conflicts arose immediately if node A and node B both inserted an auto-incrementing key on the same table. The advantages of master-master replication over the traditional master-slave replication are that you do not have to modify your applications to make write accesses only to the master, and that it is easier to provide high-availability because if the master fails, you still have the other master. falko Tue, 19 Feb 2008 11:53:48 GMT http://www.howtoforge.com/multiserver-setup-with-dedicated-web-email-dns-and-mysql-database-servers-on-debian-squeeze-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 Sun, 09 Oct 2011 19:38:37 GMT http://www.howtoforge.com/preventing-mysql-injection-attacks-with-greensql-on-debian-etch GreenSQL (or greensql-fw) is a firewall for MySQL databases that filters SQL injection attacks. It works as a reverse proxy, i.e., it takes the SQL queries, checks them, passes them on to the MySQL database and delivers back the result from the MySQL database. It comes with a web interface (called greensql-console) so that you can manage GreenSQL through a web browser. This guide shows how you can install GreenSQL and its web interface on a Debian Etch server. falko Tue, 28 Oct 2008 13:14:48 GMT http://www.howtoforge.com/running-drupal-7.7-on-nginx-lemp-on-debian-squeeze-ubuntu-11.04 This tutorial shows how you can install and run a Drupal 7.7 web site on Debian Squeeze or Ubuntu 11.04 with nginx installed instead of Apache (LEMP = Linux + nginx (pronounced "engine x") + MySQL + PHP). In addition to that I will also show you how you can use the Drupal Boost plugin with nginx. nginx is a HTTP server that uses much less resources than Apache and delivers pages a lot of faster, especially static files. falko Thu, 08 Sep 2011 08:35:39 GMT http://www.howtoforge.com/running-joomla-1.7-on-nginx-lemp-on-debian-squeeze-ubuntu-11.10 This tutorial shows how you can install and run a Joomla 1.7 web site on a Debian Squeeze or Ubuntu 11.10 system that has nginx installed instead of Apache (LEMP = Linux + nginx (pronounced "engine x") + MySQL + PHP). nginx is a HTTP server that uses much less resources than Apache and delivers pages a lot of faster, especially static files. falko Thu, 15 Dec 2011 10:55:10 GMT http://www.howtoforge.com/running-question2answer-on-nginx-lemp-on-debian-squeeze-ubuntu-12.10 This tutorial shows how you can install and run a Question2Answer web site on a Debian Squeeze or Ubuntu 12.10 system that has nginx installed instead of Apache (LEMP = Linux + nginx (pronounced "engine x") + MySQL + PHP). nginx is a HTTP server that uses much less resources than Apache and delivers pages a lot of faster, especially static files. Question2Answer is a free and open source platform for Q&A sites. falko Sun, 04 Nov 2012 10:26:20 GMT http://www.howtoforge.com/running-wordpress-on-nginx-lemp-on-debian-squeeze-ubuntu-11.04 This tutorial shows how you can install and run a WordPress blog on a Debian Squeeze or Ubuntu 11.04 system that has nginx installed instead of Apache (LEMP = Linux + nginx (pronounced "engine x") + MySQL + PHP). In addition to that I will also show you how you can use the WordPress plugins WP Super Cache and W3 Total Cache with nginx. nginx is a HTTP server that uses much less resources than Apache and delivers pages a lot of faster, especially static files. falko Thu, 01 Sep 2011 08:16:52 GMT http://www.howtoforge.com/setting-up-master-master-replication-on-four-nodes-with-mysql-5-on-debian-etch This tutorial explains how you can set up MySQL master-master replication on four MySQL nodes (running on Debian Etch). The difference to a two node master-master replication is that if you have more than two nodes, the replication goes in a circle, i.e., with four nodes, the replication goes from node1 to node2, from node2 to node3, from node3 to node4, and from node4 to node1. falko Thu, 20 Nov 2008 12:47:49 GMT