PUBLIC MARKS with tag replication

An interesting article from Lucid Imagination employee Mark Miller about Scaling Solr. It gives a lot of good practices and tips on how to get the best out of one indexing machine, and explains how to use Solr built-in replication system.

This tutorial explains how you can set up MySQL master-master replication on four MySQL nodes (running on Debian Etch). The difference to a two node master-master replication (which is explained here) is that if you have more than two nodes, the replication goes in a circle, i.e., with four nodes, the replication goes from node1 to node2, from node2 to node3, from node3 to node4, and from node4 to node1. 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.

Flipper is a tool for managing pairs of MySQL servers replicating to each other (commonly known as master-master replication or dual-master replication). Master-master replication is a great way of ensuring high availability for MySQL databases - it enables one half of the pair to be taken offline for maintenance work while the other half carries on dealing with queries from clients. Flipper achieves this by moving IP addresses based on a role ("read-only", "writable") between the two nodes in the master pair, to ensure that each role is available. Flipper is written in perl, and has been designed to be as portable as possible.

This short article explains how you can use a short script to check whether your MySQL master master replication is working as expected or not.

Voici quelques semaines qu’il en parlait sur les ml, alors il à fini par le coder. Ivan Voras (ivoras@) nous livre la première version d’un démon destiné à synchroniser deux systèmes de fichiers de manière plus économique et élégante que le classique rsync. Le principe est simple, basée sur kqueue (culture again), le démon adfs -c’est son nom- contrôle l’état des fichiers à répliquer et en fait une copie en “quasi” temps réel, lorsque ces derniers ont été modifiés. Bien que peu performant sur un très grand nombre de fichiers, cette application semble bien se comporter avec un petit nombre de fichiers (quelques dizaines de milliers ?!). Il est possible de récupérer la version courante du code, mais la version en ligne ne sera maintenue à jour que si des utilisateurs semblent intéressés. Avis aux amateurs.

MySQL Replication Manager est une interface Web pour surveiller une architecture maître esclave. Elle permet simplement de lancer le maître et l'esclave, de gérer les logs et de surveiller l'état de fonctionnement. Il vous faut bien sûr les droits d'administration.

Globule is a third-party module for the Apache Web server that allows a given server to replicate its documents to other Globule servers. It takes care of maintaining consistency between the replicas, of monitoring the servers, and of automatically redirecting clients to one of the available replicas. Globule also supports the replication of PHP documents. It runs on Unix and Windows systems.

Ever had to make the same change on more than one Linux/unix server? Find it annoyingly painful to keep repeating the exact same commands again and again and again? This tool addresses exactly this problem. You run a utility (cssh) providing a number of server names as parameters, and then xterms opens up to each server with an extra “console” window. Anything typed into the console is replicated into each server window (so, for examples, you can edit the same file on N machines at the same time, or run the same commands with the same parameters across those servers). It is also possible to type into the server windows directly, or temporarily disable replication to one or more of the servers through the “Hosts” menu.

mysqlslavesync entre dans la famille des automatiseurs : tous ces outils qui permettent de mettre en place une solution standardisée. Ici, il s'agit de mettre en place la réplication MySQL sur un nouvel esclave. "L'outil se connecte au maître, effectue un dump ou un mysqlhotcopy, transfert les données, installe les données, puis configure les paramètres de réplication." Et voila, c'est tout. Si vous devez multiplier rapidement les esclaves, cela sera un répit important pour vos amis administrateur.

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.

Consider the following pseudo-code: $nid = node_save($data); $node = node_load($nid); Because node_save() executes a mutator query (an INSERT or UPDATE statement) is has to be executed on the master, so the master can propagate the changes to the slaves. Because node_load() uses a read-only query, it can go to the master or any of the available slaves. Because of the lack of synchronization between master and slaves, there is one obvious caveat: when we execute node_load() the slaves might not have been updated.

This tutorial provides step-by-step instructions about how to create a highly available VMware Server environment on a Debian Etch system. With this tutorial, you will be able to create Virtual Machines that will be available on multiple systems with failover/failback capabilities.

If you publish a lot of CD or DVD content, Media Fast is a source you will want to become familiar with. They offer some of the best pricing and fastest turn times in the industry. Their customer service is stellar, and they can do Mini DVD, HD-DVD, Print, Packaging, and Authoring projects. They meet your deadlines and treat you well every time. Media Fast provides high-end CD & DVD replication and duplication services at competitive prices so that our customers can obtain the resources that they need to enhance the quality of their media projects. We have had over 30 years of experience in the industry and can consistently offer our customers high-quality products. Media Fast offers a full range of HD-DVD, Mini DVD, DVD and DVD-ROM replication and duplication services complete with printing, packaging and assembly. If you are looking for unique DVD packaging, we can assist you in finding the perfect presentation for your DVD. Media Fast also offers Mini DVD's which hold 1.4 GB of data. We provide a full range of specialty CD products to give your project the unique quality that it needs. Our CD and CD-R products are perfect for delivering rich multimedia presentations. They can be used as business cards, direct mail pieces, company product catalogs, portfolio showcases, and much more. Media Fast provides high-quality printing services to improve any media project. Whether you need booklets for CDs or entrapments for DVDs, Media Fast can provide a solution that strengthens the visual appeal of your media presentation. At Media Fast, we offer a full range of packaging from the everyday to the unique. Whether you need jewel cases, mailers, boxes, binders, clamshells, tins, or other specialty packaging solutions, we can help.

MMM (MySQL Master-Master Replication Manager) is set of flexible scripts to perform monitoring and management of MySQL Masrter-Master replication cluster configurations.

capttofu: MySQL Multi-Master Replication