RE: Replication setup hep

2012-08-02 Thread Rick James
1 Master replicationg to 3 Slaves.
You can use any of the Slaves for readonly (online), or you can not use them 
(offline).
All writes go to the Master.  It will be online for writes, and optionally 
online for reads.

> -Original Message-
> From: Ananda Kumar [mailto:anan...@gmail.com]
> Sent: Wednesday, August 01, 2012 11:20 PM
> To: Pothanaboyina Trimurthy
> Cc: mysql
> Subject: Re: Replication setup hep
> 
> if the server is offline , what kind of operation happens on it.
> 
> On Thu, Aug 2, 2012 at 11:31 AM, Pothanaboyina Trimurthy <
> skd.trimur...@gmail.com> wrote:
> 
> > Hi everyone
> >  i have 4 mysql servers out of those one server will
> > be online always and the remaining will be offline and online. the
> > operations takes place at the offline servers i want to replicate the
> > data from the offline servers to the online server. for this can any
> > one help me which kind of replication suits for this kind of
> > situation.
> >
> > thanks in advance
> >
> > --
> > 3murthy
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:http://lists.mysql.com/mysql
> >
> >

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql



Re: Replication setup hep

2012-08-01 Thread Ananda Kumar
if the server is offline , what kind of operation happens on it.

On Thu, Aug 2, 2012 at 11:31 AM, Pothanaboyina Trimurthy <
skd.trimur...@gmail.com> wrote:

> Hi everyone
>  i have 4 mysql servers out of those one server will
> be online always and the remaining will be offline and online. the
> operations takes place at the offline servers i want to replicate the
> data from the offline servers to the online server. for this can any
> one help me which kind of replication suits for this kind of
> situation.
>
> thanks in advance
>
> --
> 3murthy
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql
>
>


Replication setup hep

2012-08-01 Thread Pothanaboyina Trimurthy
Hi everyone
 i have 4 mysql servers out of those one server will
be online always and the remaining will be offline and online. the
operations takes place at the offline servers i want to replicate the
data from the offline servers to the online server. for this can any
one help me which kind of replication suits for this kind of
situation.

thanks in advance

-- 
3murthy

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql