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
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
The replication slave server has the Physical memory 3.6 GB and the my.cnf
file is as below :
[client]
port= 3306
socket = /var/lib/mysql/mysql.sock
[mysqld]
datadir = /data1/mysql
basedir = /
port= 3306
socket = /var/lib/mysql/mysql.sock
s
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
15 matches
Mail list logo
