Linux Tutorials on the topic “high-availability”

  • How To Set Up A Load-Balanced MySQL Cluster

    Author: falkoTags: , Comments: 23

    How To Set Up A Load-Balanced MySQL Cluster This tutorial shows how to configure a MySQL 5 cluster with three nodes: two storage nodes and one management node. This cluster is load-balanced by a high-availability load balancer that in fact has two nodes that use the Ultra Monkey package which provides heartbeat (for checking if the other node is still alive) and ldirectord (to split up the requests to the nodes of the MySQL cluster).

    read more... | add comment | view as pdf | print

  • How To Back Up MySQL Databases Without Interrupting MySQL

    Author: falkoTags: , , Comments: 9

    How To Back Up MySQL Databases Without Interrupting MySQL 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 don't 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.

    read more... | add comment | view as pdf | print

  • Setting Up Master-Master Replication With MySQL 5 On Debian Etch

    debian Author: falkoTags: , , Comments: 6

    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 don't 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.

    read more... | add comment | view as pdf | print

  • Merging Multiple Apache Access Logs Into One Overall Access Log

    Author: falkoTags: , , , Comments: 3

    Merging Multiple Apache Access Logs Into One Overall Access Log Let's assume you have a web application that runs of a cluster of Apache nodes. Each node generates its own Apache access log from which you can generate page view statistics with tools such as Webalizer or AWStats. Obviously you do not want to have page view statistics for each Apache node, but overall page view statistics. To achieve this, we must merge the access logs from each node into one overall access log that we can then feed into Webalizer or AWstats. There is a Perl script called logresolvemerge.pl (part of the AWStats package) that can do this for us.

    read more... | add comment | view as pdf | print