il.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.t
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
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
Terry Riley wrote:
- Original Message -
Terry Riley wrote:
I'm running 4.1.13 on Linux as master, with 4.1.12 on XP as slave (in
house test setup).
This vaguely duplicates what is set up on the live servers, except
that the slave is 4.1.3 on NT4.
On the test setup, if the logs a
- Original Message -
> Terry Riley wrote:
> > I'm running 4.1.13 on Linux as master, with 4.1.12 on XP as slave (in
> > house test setup).
> >
> > This vaguely duplicates what is set up on the live servers, except
> > that the slave is 4.1.3 on NT4.
> >
> > On the test setup, if the l
Terry Riley wrote:
I'm running 4.1.13 on Linux as master, with 4.1.12 on XP as slave (in
house test setup).
This vaguely duplicates what is set up on the live servers, except that
the slave is 4.1.3 on NT4.
On the test setup, if the logs are flushed on the master, the bin log is
rotated to
I'm running 4.1.13 on Linux as master, with 4.1.12 on XP as slave (in
house test setup).
This vaguely duplicates what is set up on the live servers, except that
the slave is 4.1.3 on NT4.
On the test setup, if the logs are flushed on the master, the bin log is
rotated to the next number, after
So, ran into a problem with using mysqlhotcopy to build a backup capable
of starting a new replicant. The current option (record_log_pos)
attempts to get master info from show master status, regardless of
whether running on master or slave. It also uses show slave status to
see where the slav
DVP
Dathan Vance Pattishall http://www.friendster.com
> -Original Message-
> From: Sanjeev Sagar [mailto:[EMAIL PROTECTED]
> Sent: Thursday, December 02, 2004 4:04 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Cc: Sanjeev Sagar
> Subject: Binlog quest
Hello everyone,
I have a question on how MySQL database write to binlogs in replication
environment. My table type is MyISAM. MySQL version is 4.0.21.
I have a replication farm. Let's suppose I am running a ALTER TABLE
statement on central master and had a syntax error in table name.
Replic
Dear all,
Normally one would replicate from 1 master server, onto several slave
servers. However, my situation is quite different, and I have found
myself unable to figure out a way to solve it. I very much hope you can
help me with this matter. All replies are appreciated.
In short, I want se
"Arnoud Witt (Marktplaats)" <[EMAIL PROTECTED]> wrote:
> We are using Mysql with one master and several slaves.
>
> In some INSERT and UPDATE queries we use Mysql functions like CURDATE() =
> and
> RAND() .
>
> The problem that now occurs is that if a slave is reading the queries =
> from
> the b
We are using Mysql with one master and several slaves.
In some INSERT and UPDATE queries we use Mysql functions like CURDATE() and
RAND() .
The problem that now occurs is that if a slave is reading the queries from
the binary log, the resulting data is different from that on the master,
because o
age-
-->From: Ilia Kantor [mailto:[EMAIL PROTECTED]
-->Sent: Sunday, November 02, 2003 1:11 PM
-->To: [EMAIL PROTECTED]
-->Subject: replication setup
-->
-->Hello,
-->
-->I'm not so newbie to mysql yet have troubles setting up the
-->replication.. Could you advise a way out
Hello,
I'm not so newbie to mysql yet have troubles setting up the
replication.. Could you advise a way out ?
I set up slave, master and rerun them.
But when I type
LOAD DATA FROM MASTER
on slave server - I see
ERROR 1218: Error connecting to master: Access denied for user:
'[EMAIL PROTECTED]'
I have set up a master and slave whose versions are (using 'show =
variables') S: 3.23.47-nt, M: 3.23.47-nt-log. They were both installed =
from the same distribution zip. I can't get replication going even =
though the server and client status seem ok (slave running and file and =
position informa
> > I've set up replication with a master and two slaves, all running
> > 3.23.43, and it works like a charm. Except for...
> >
> > When the master goes down, the slave tries to reconnect after 60
> > seconds, but just once.
>
> That shouldn't be.
I have the same problem here with the same versio
On Thu, Nov 15, 2001 at 09:32:56AM +0100, Jure Koren wrote:
> Hello!
>
> I've set up replication with a master and two slaves, all running
> 3.23.43, and it works like a charm. Except for...
>
> When the master goes down, the slave tries to reconnect after 60
> seconds, but just once.
That shou
Hello!
I've set up replication with a master and two slaves, all running
3.23.43, and it works like a charm. Except for...
When the master goes down, the slave tries to reconnect after 60
seconds, but just once. I expected it to retry until it can connect,
because when the master comes up again,
On Wednesday 31 October 2001 20:06, you wrote:
> On Wed, Oct 31, 2001 at 07:30:12AM -0800, Kyle Hayes wrote:
> > Has anyone used LVM to create snapshots on a master in order to set
> > up replication? We have specialized scripts that are getting harder
> > and harder to maintain as we find weird
On Wed, Oct 31, 2001 at 07:30:12AM -0800, Kyle Hayes wrote:
>
> Has anyone used LVM to create snapshots on a master in order to set
> up replication? We have specialized scripts that are getting harder
> and harder to maintain as we find weird edge cases and other
> annoying bits. Jeremy Zawodn
Has anyone used LVM to create snapshots on a master in order
to set up replication? We have specialized scripts that are getting
harder and harder to maintain as we find weird edge cases
and other annoying bits. Jeremy Zawodny's 'myrepl' script locks
our larger tables for too long.
So, we're l
>
> * It'd be handy to create a compressed tar file (.tar.gz). I'll
> probably add that.
great ;) but i'll transfer it compressed with scp, so it's no big problem for
me. But a "-z"-switch would probably be useful for lots of people.
> * It'd be nice to specify which databases/tab
If you've been reading all the mail I've been generating about
replication recently, you know what this is. If not, read on...
WHAT IS IT?
---
myrepl is a Perl script which helps to setup replication for the
first time on a MySQL master server. myrepl will do all of its
work
24 matches
Mail list logo
