http://netvouz.com/falko/tag/mysql?feed=rss&pg=13 falko's bookmarks tagged "mysql" on Netvouz http://www.howtoforge.com/mysql5_master_master_replication_debian_etch 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 Thu, 25 Oct 2007 11:37:09 GMT http://www.howtoforge.com/perfect_server_centos4.5 This tutorial shows how to set up a CentOS 4.5 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.5, but should apply to the 64-bit version with very little modifications as well. falko Mon, 04 Jun 2007 11:45:49 GMT http://www.howtoforge.com/perfect-server-centos-4.8-i386-ispconfig-2 This tutorial shows how to set up a CentOS 4.8 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. In the end you should have a system that works reliably, and if you like you can install the free webhosting control panel ISPConfig (i.e., ISPConfig runs on it out of the box). falko Thu, 10 Sep 2009 13:19:22 GMT http://www.howtoforge.com/perfect-server-centos-5.2 This tutorial shows how to set up a CentOS 5.2 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 5.2, but should apply to the 64-bit version with very little modifications as well. falko Sun, 13 Jul 2008 10:31:15 GMT http://www.howtoforge.com/perfect-server-centos-5.2-ispconfig-3 This tutorial shows how to prepare a CentOS 5.2 server for the installation of ISPConfig 3, and how to install ISPConfig 3. ISPConfig 3 is a webhosting control panel that allows you to configure the following services through a web browser: Apache web server, Postfix mail server, MySQL, MyDNS nameserver, PureFTPd, SpamAssassin, ClamAV, and many more. falko Thu, 26 Mar 2009 12:56:29 GMT http://www.howtoforge.com/perfect-server-centos-5.3-x86_64-ispconfig-2 This tutorial shows how to set up a CentOS 5.3 server (x86_64) 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. In the end you should have a system that works reliably, and if you like you can install the free webhosting control panel ISPConfig (i.e., ISPConfig runs on it out of the box). falko Thu, 16 Apr 2009 10:49:27 GMT http://www.howtoforge.com/perfect-server-centos-5.3-x86_64-ispconfig-3 This tutorial shows how to prepare a CentOS 5.3 x86_64 server for the installation of ISPConfig 3, and how to install ISPConfig 3. ISPConfig 3 is a webhosting control panel that allows you to configure the following services through a web browser: Apache web server, Postfix mail server, MySQL, MyDNS nameserver, PureFTPd, SpamAssassin, ClamAV, and many more. falko Sun, 07 Jun 2009 12:21:40 GMT http://www.howtoforge.com/perfect-server-centos-5.4-x86_64-ispconfig-2 This tutorial shows how to set up a CentOS 5.4 server (x86_64) 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 64-bit version of CentOS 5.4, but should apply to the 32-bit version with very little modifications as well. In the end you should have a system that works reliably, and if you like you can install the free webhosting control panel ISPConfig (i.e., ISPConfig runs on it out of the box). falko Thu, 29 Oct 2009 12:48:55 GMT http://www.howtoforge.com/perfect-server-centos-5.5-x86_64-ispconfig-2 This tutorial shows how to set up a CentOS 5.5 server (x86_64) 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 64-bit version of CentOS 5.5, but should apply to the 32-bit version with very little modifications as well. In the end you should have a system that works reliably, and if you like you can install the free webhosting control panel ISPConfig (i.e., ISPConfig runs on it out of the box). falko Wed, 26 May 2010 11:39:55 GMT http://www.howtoforge.com/perfect-server-centos-5.5-x86_64-ispconfig-3 This tutorial shows how to prepare a CentOS 5.5 x86_64 server for the installation of ISPConfig 3, and how to install ISPConfig 3. ISPConfig 3 is a webhosting control panel that allows you to configure the following services through a web browser: Apache web server, Postfix mail server, MySQL, BIND nameserver, PureFTPd, SpamAssassin, ClamAV, and many more. falko Sun, 30 May 2010 22:58:32 GMT