Skip navigation.
Home
FromDual

Languages
Home

cluster

user warning: Unknown column 'f.nid' in 'on clause' query: SELECT n.nid, n.title, f.filename, f.filepath FROM node n LEFT JOIN files f ON n.nid = f.nid WHERE n.status = 1 AND n.type = 'image' AND LOWER(n.title) = LOWER('http://www.fromdual.com/sites/default/files/external_locking.png') LIMIT 1 in /home/shinguz/public_html/drupal-6.19/sites/all/modules/pearwiki_filter/pear_override/render/Xhtml/Image.php on line 58.

Active/active fail over cluster with MySQL Replication

Submitted by Shinguz on Fri, 2008-09-05 16:00

Electing a slave as new master and aligning the other slaves to the new master

In a simple MySQL Replication set-up you have high-availability (HA) on the read side (r). But for the master which covers all the writes (w) and the time critical read (rt) there is no HA implemented. For some situations this can be OK.

»

MySQL Cluster restore

Submitted by Shinguz on Thu, 2007-03-22 19:05

Recently the question came up if it is faster to restore a MySQL cluster when all nodes are up or only ONE node from each node group during restore.

The answer from our gurus was: All nodes up during restore! I wanted to find out why. So I set up the following cluster and started to measure:

MySQL Cluster set up

Cluster setup

MySQL Cluster backup

»

MySQL Active - Active Clustering

Submitted by Shinguz on Tue, 2007-03-13 12:06

It is possible to use an active - active shared-disk cluster in MySQL in some cases. For doing this you have to fulfil the following requirements:

  • Works with MyISAM tables only.
  • POSIX-locking compliant cluster file system on the device (such as OCFS2 or GFS).
  • External locking must be enabled.
  • The MySQL query cache must be turned off.
  • The MySQL delay key write must be turned off.
  • OS where file locking is supported in MySQL.

external_locking.png

Interested?

»
Syndicate content