Go back to fronty page View most popular entries View latest additions Submit tutorials to UnixTutorials.info
UnixTutorials logo

Search results for How To Set Up Database Replication In MySQL

Linux

How To Back Up MySQL Databases Without Interrupting MySQL

Post date: May 12, 2007, 23:05 Category: System Views: 4546 Comments
Tutorial quote: 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.
Openfiler

Openfiler 2.3 Active/Passive Cluster With Offsite Replication Node

Post date: February 10, 2011, 14:02 Category: Installing Views: 5457 Comments
Tutorial quote: Openfiler is a Linux based NAS/SAN application which can deliver storage over nfs/smb/iscsi and ftp. It has a web interface over that you can control these services. The cluster we build will consist of two nodes replicating each other and taking over services and storage in case of emergency. Furthermore we have an Offsite Replication Server, which ideally stands in a physically different position and replicates the configurations/storage from which ever node is active. In case of emergency this Offsite Replication Server can be used to restore the cluster and to deliver the services.
Debian

Creating Advanced MySQL-Based Virtual Hosts On Lighttpd (Debian Etch)

Post date: August 19, 2008, 10:08 Category: Software Views: 4018 Comments
Tutorial quote: 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.
Debian

Install Oracle Database XE on Debian Sarge

Post date: May 2, 2006, 15:05 Category: Installing Views: 3003 Comments
Tutorial quote: Oracle Database 10g Express Edition (Oracle Database XE) is an entry-level, small-footprint database based on the Oracle Database 10g Release 2 code base that’s free to develop, deploy, and distribute; fast to download; and simple to administer. Oracle Database XE is a great starter database for

Developers working on PHP, Java, .NET, and Open Source applications

DBAs who need a free, starter database for training and deployment

Independent Software Vendors (ISVs) and hardware vendors who want a starter database to distribute free of charge

Educational institutions and students who need a free database for their curriculum

Unix+clones

Running A MySQL-Based DNS Server: MyDNS

Post date: January 23, 2006, 15:01 Category: Network Views: 4578 Comments
Tutorial quote: In this tutorial I will describe how to install and configure MyDNS, a DNS server that uses a MySQL database as backend instead of configuration files like, for example, Bind or djbdns. This has the advantage that you can easily use web-based frontends to administrate your DNS records. You could even write your own frontend, e.g. using PHP, to interact with the MyDNS database. MyDNS simply reads the records from the database, and it does not have to be restarted/reloaded when DNS records change or zones are created/edited/deleted! This is a major advantage.
Linux

MySQL Database Tutorials

Post date: January 31, 2011, 07:01 Category: Software Views: 4829 Comments
Tutorial quote: Many people tell me they arenít very fond of scripts, because the install frightens them a bit. And itís true: creating a database, importing tables, your siteís root pathÖ if you donít know what youíre doing, this looks pretty complicated.
Luckily, it is not, once you get the hang of it.
Debian

Apache2: Logging To A MySQL Database With mod_log_sql (Debian Etch)

Post date: July 6, 2008, 09:07 Category: Installing Views: 3667 Comments
Tutorial quote: 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.
CentOS

Virtual Hosting With PureFTPd And MySQL On CentOS 5.0

Post date: July 24, 2007, 22:07 Category: Installing Views: 4931 Comments
Tutorial quote: This document describes how to install a PureFTPd server that uses virtual users from a MySQL database instead of real system users. This is much more performant and allows to have thousands of ftp users on a single machine. In addition to that I will show the use of quota and upload/download bandwidth limits with this setup. Passwords will be stored encrypted as MD5 strings in the database.
Fedora

Virtual Hosting With PureFTPd And MySQL On Fedora 9

Post date: July 27, 2008, 15:07 Category: Installing Views: 3645 Comments
Tutorial quote: This document describes how to install a PureFTPd server that uses virtual users from a MySQL database instead of real system users. This is much more performant and allows to have thousands of ftp users on a single machine. In addition to that I will show the use of quota and upload/download bandwidth limits with this setup. Passwords will be stored encrypted as MD5 strings in the database.
Fedora

Virtual Hosting With PureFTPd And MySQL On Fedora 11

Post date: September 15, 2009, 11:09 Category: Installing Views: 2974 Comments
Tutorial quote: This document describes how to install a PureFTPd server that uses virtual users from a MySQL database instead of real system users. This is much more performant and allows to have thousands of ftp users on a single machine. In addition to that I will show the use of quota and upload/download bandwidth limits with this setup. Passwords will be stored encrypted as MD5 strings in the database.
Web-based applications and online marketing solutions - LumoLink