public marks

PUBLIC MARKS with tags mysql & replication

April 2006

March 2006

Tutoriel de réplication sous MySQL

by benoit
Après avoir cherché pas mal de solutions pour sauvegarder mes bases de données MySQL et pouvoir automatiquement les réinjecter en cas de problèmes, je me suis finalement tourné vers le système de réplication offert par la base de données open source en standard. La réplication permet d'avoir une copie directe des données. Elle fonctionne selon le principe maître - esclave. L'esclave se connecte à intervalles réguliers sur le maître afin de maintenir à jour sa propre base de données.

February 2006

How To Set Up Database Replication In MySQL | HowtoForge - Linux Howtos and Tutorials

by camel & 1 other
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 though.

December 2005

How To Set Up Database Replication In MySQL | HowtoForge - Linux Howtos and Tutorials

by camel & 4 others
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 though.

September 2005

現場指向のレプリケーション詳説

by KoshigoeBushou
MySQLのレプリケーション; 技術評論社刊『WEB+DB PRESS Vol.22』のWWW版

July 2005

Terry Burton's Blog: MySQL Secure Replication over SSL on Debian Sarge

by camel (via)
All versions of MySQL currently shipped with Debian Sarge lack support OpenSSL due to licensing issues. In order to enable support for SSL connections it is necessary recompile MySQL from source.

ZATAZ.net Documentation ZATAZ : Réplication MySQL

by camel
La réplication MySQL est apparue avec la version 3.23.15 de MySQL et est à sens unique, c'est-à-dire que vous ne pouvez répliquer les données que dans un sens (La réplication bi-directionnelle est aussi envisageable pour des tables ne contenant pas de clés primaires, d'index, et de champ auto-incrémentable).

PUBLIC TAGS related to tag mysql

ajax +   apache +   austin +   austinblogger +   austincast +   backup +   blogs +   centos +   cluster +   code +   css +   database +   debian +   dev +   development +   firefox +   guide +   howto +   html +   install +   java +   lamp +   linux +   mail +   opensource +   perl +   php +   postfix +   programming +   python +   reference +   replication +   resources +   ruby +   script +   server +   software +   springnet +   sxsw +   texas +   tips +   tools +   tutorial +   tutorials +   ubuntu +   walhus +   web +   webdesign +   windows +   xml +