Does MySQL supports Synchronous Replication. Post: 302374171

Sponsored Content

Top Forums Web Development MySQL DevZone RSS Does MySQL supports Synchronous Replication. Post 302374171 by Neo on Monday 23rd of November 2009 04:10:28 PM

11-23-2009

Administrator

You can find your answers at the MySQL web site. For MySQL 5.4:

Quote:

Replication enables data from one MySQL database server (called the master) to be replicated to one or more MySQL database servers (slaves). Replication is asynchronous - your replication slaves do not need to be connected permanently to receive updates from the master, which means that updates can occur over long-distance connections and even temporary solutions such as a dial-up service. Depending on the configuration, you can replicate all databases, selected databases, or even selected tables within a database.

Neo

View Public Profile for Neo

Visit Neo's homepage!

Find all posts by Neo

6 More Discussions You Might Find Interesting

1. Solaris

Processor and memory supports

HI i'am Giancarlo D. Jabon student from AMA Computer University is anyone among all of you who knows the maximum processor and memory supports in Sun Solaris 10 Thanks !!!!

2. UNIX for Advanced & Expert Users

capturing synchronous signals

hi, i created 2 threads in which one thread is dedicated to capture signals and handle them. i used the following functions: sigfillset for filling the signal set to be blocked by other threads sigwait for waiting on particular signals pthread_sigmask to mask block the signals. I...

3. Web Development

MySQL Replication Issues: Duplicate Key Error

Lately my attention has been focused on distributed MySQL database replication to other web servers. All was going well, but then I noticed the replication would stop and there were there "Duplicate Primary Key" errors in SHOW SLAVE STATUS; I started to trace these down and noticed that this...

4. Shell Programming and Scripting

Strategical Shell Scripting For MySql Replication

Hi to all guyz , As i'm new to Shell scripting i was been working out to write a shell script for mysql Replication for multiple slave master architecture.i have done the process up with a script of 200 lines but still there are some things which can make my script more effective so i want your...

5. Linux

Mysql replication

Need to recover a replication broken error on the mysql slave server. I want to force it to resend the binlog file from the begining. What is the correct value for the: MASTER_LOG_POS ? 0, 1 or 107 ?

6. UNIX Desktop Questions & Answers

How can I replicate master master and master master MySQL databse replication and HA?

I have an application desigend in PHP and MySQl running on apache web server that I is running on a Amazon EC2 server Centos. I want to implement the master-master and master slave replication and high availability disaster recovery on this application database. For this I have created two...

LEARN ABOUT DEBIAN

replication

REPLICATIION(1) 					      General Commands Manual						   REPLICATIION(1)

NAME

       Replication - Example of using QuantLib

SYNOPSIS

       Replication

DESCRIPTION

       Replication is an example of using the QuantLib derivative modeling framework.

       Replication uses the CompositeInstrument class to statically replicate a down-and-out barrier options.

SEE ALSO

       The  source code Replication.cpp, BermudanSwaption(1), Bonds(1), CallableBonds(1), CDS(1), ConvertibleBonds(1), DiscreteHedging(1), Equity-
       Option(1),  FittedBondCurve(1),	FRA(1),  MarketModels(1),  Repo(1),  SwapValuation(1),	the  QuantLib	documentation	and   website	at
       http://quantlib.org.

AUTHORS

       The QuantLib Group (see Authors.txt).

       This manual page was added by Dirk Eddelbuettel <edd@debian.org>, the Debian GNU/Linux maintainer for QuantLib.

QuantLib							    07 Jul 2006 						   REPLICATIION(1)