- 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 - 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 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 - 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.
in Public bookmarks - 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.
in Public bookmarks - Multiserver Setup With Dedicated Web, Email, DNS & 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.
in Public bookmarks - Setting Up Master-Master Replication With MySQL 5 On 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.
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