On May 16, 2009, at 12:28 AM, Simon J Mudd wrote:
I also, in section [mysqld]
# Begin slave config 05/14/2009
server-id = 2
master-host = ip.add.re.ss
master-user = user-replicate
master-password = xx
master-port = 3306
# End slave config
No. not necessary as the information is stored in t
On Fri, May 15, 2009 at 12:48:18AM -0700, Scott Haneda wrote:
>
> Also, how do I set the slave to be read only? I set read-only in
> my.cnf and it made all databases read only.
SET GLOBAL read_only = true;
and as you've done in the my.cnf file.
Unless the user has SUPER rights he can't chang
On Thu, May 14, 2009 at 04:45:44PM -0700, Scott Haneda wrote:
> >It's true that initial mysql replication setup is a bit fiddly, but
> >once you've done it once or twice it's not so hard.
>
> I have it set up and working in test. I will redo it again once I get
> a better handle on it. I am
On May 12, 2009, at 11:11 PM, Simon J Mudd wrote:
1. Ensure binlogging is enabled on the master.
2. Ensure you setup grant permissions so the slave can connect to
the master.
3. Configure on the slave the replication (which databases need to
be replicated)
4. Get the master and slave in syn
On May 12, 2009, at 11:11 PM, Simon J Mudd wrote:
talkli...@newgeo.com (Scott Haneda) writes:
Hello, I am confused about repliction setup. Reading a config file,
and the docs, leads me to believe this is an either code choice, pick
#1 or #2. If that is the case, why would I want to use #1 ov
Hi Scott
You may use the script below to reload replication if you can ensure that
the master db doesn't change during the dump operation. Otherwise you may
set a lock on the master manually.
Regards, Thomas
#!/bin/bash
#
# replicate-reload
#
# This is free software. There is no warranty a
replying only to the list...
On Wed, May 13, 2009 at 10:19:21AM -0700, Scott Haneda wrote:
> >3. Configure on the slave the replication (which databases need to
> >be replicated)
>
> This is where I need a little clarification, is the only thing I need
> to do is adjust my.cnf to have in the
Thanks, a few comments inline below...
On May 12, 2009, at 11:11 PM, Simon J Mudd wrote:
talkli...@newgeo.com (Scott Haneda) writes:
Hello, I am confused about repliction setup. Reading a config file,
and the docs, leads me to believe this is an either code choice, pick
#1 or #2. If that is
talkli...@newgeo.com (Scott Haneda) writes:
> Hello, I am confused about repliction setup. Reading a config file,
> and the docs, leads me to believe this is an either code choice, pick
> #1 or #2. If that is the case, why would I want to use #1 over #2?
>
> My confusion comes from several onli
Hello, I am confused about repliction setup. Reading a config file,
and the docs, leads me to believe this is an either code choice, pick
#1 or #2. If that is the case, why would I want to use #1 over #2?
My confusion comes from several online references where there is a
combination of #1
o put the mysql-bin.xxx and offset value?
Thanks in advance.
Regards
Naveen
- Original Message -
From: "Thomas Spahni" <[EMAIL PROTECTED]>
To: "Naveen C Joshi" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, August 31, 2004 9:48 PM
Su
ot;Thomas Spahni" <[EMAIL PROTECTED]>
To: "Naveen C Joshi" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, August 31, 2004 9:48 PM
Subject: Re: replication config without stopping master server
> Naveen,
>
> You don't need to shut down t
ds,
Thomas Spahni
On Tue, 31 Aug 2004, Naveen C Joshi wrote:
> Hi All :
>
> I am still waiting for the response.
>
> Thanks in advance.
>
> Regards
> Naveen
>
> - Original Message -
> From: "Naveen C Joshi" <[EMAIL PROTECTED]>
> To: &l
Hi All :
I am still waiting for the response.
Thanks in advance.
Regards
Naveen
- Original Message -
From: "Naveen C Joshi" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, August 27, 2004 4:17 PM
Subject: Re: replication config without stopping
= write_buffer=2M
[mysqlhotcopy]
interactive-timeout
Regards
Naveen
- Original Message -
From: "Naveen C Joshi" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, August 27, 2004 2:04 PM
Subject: replication config without stopping master server
Hi,
I have MySQL
Hi,
I have MySQL-4.0.5a-beta installed on my RH9.0 Linux machine. This machine is as a
replication master server. I have configured the other machine as replication slave
with same version of MySQL and OS.
Now, I want to start replication slave server without stopping the master server. Is
i
On Friday 24 August 2001 00:09, Jeremy Zawodny wrote:
> On Thu, Aug 23, 2001 at 01:15:25PM -0400, Robinson, Mike wrote:
> >
> > I just set up a master/slave replication scheme and all is well, but
> > through the procedure did get bit on the tail.
> >
> > After the setup, and after the master and
On Thu, Aug 23, 2001 at 01:15:25PM -0400, Robinson, Mike wrote:
>
> I just set up a master/slave replication scheme and all is well, but
> through the procedure did get bit on the tail.
>
> After the setup, and after the master and slave mysql servers had
> been started, I got some error messages
18 matches
Mail list logo
