Hi Guys
I am once again having a weird issue... well weird to me anyway.
We have a master,slave setup using mysql 5.7 and they are both
connected on the same network segment through the same switch.
During the weekend a HUGE amount of processing was done on the master,
and thus resulted
On 7/6/2015 1:39 PM, Claudio Nanni wrote:
Hi Jatin,
Say if i am using a DB instance for quiet some time on node-1 and
it has data in it. If i decide to have replication with another DB
instance , will all the data from node-1 be first replicated to
node-2's DB ? Or will it just s
On 7/5/2015 10:48 PM, Claudio Nanni wrote:
Hello Jatin,
> We are basically intending to implement High Availability for our
application. In this regard , we want to use Mysql replication for
this purpose.
Your scenario(MySQL Master/Slave with Failover/Failback procedures)
has bee
Hi All
We are basically intending to implement High Availability for our
application. In this regard , we want to use Mysql replication for this
purpose.
We would have a two-node cluster , say node-1 & node-2.
Assume that if node-1is functioning we want the DB changes on it t
- Original Message -
> From: "Néstor"
>
> I spoke to soon!!!
> Here is the error about 1.5 hours after replication has started.
> 121205 16:39:51 [ERROR] Slave: Error 'Duplicate entry '3468897'
> for
Yes, that's what you get for running SQL_SLAVE_SKIP_COUNTER without knowing
nd then I get an error on
mysql.err:
-
Now if I do the SKIP FLAG many times, I will error after error...
I do not see how replication works so well for others if I am using the
steps in the link
on top of this message.
THANKS!!!
On Wed, Dec 5, 2012 at 3:42 AM, Manuel Arostegui
Master_SSL_CA_File:
>>> Master_SSL_CA_Path:
>>> Master_SSL_Cert:
>>>Master_SSL_Cipher:
>>> Master_SSL_Key:
>>>Seconds_Behind_Master: 0
>>> 1 row in set (0.00 sec)
>>>
ot see how replication works so well for others if I am using the
steps in the link
on top of this message.
THANKS!!!
On Wed, Dec 5, 2012 at 3:42 AM, Manuel Arostegui wrote:
2012/11/30 Néstor
I am trying to set up mysql replication on 2 systems but Once I get it
going, I get the followin
rror...
I do not see how replication works so well for others if I am using the
steps in the link
on top of this message.
THANKS!!!
On Wed, Dec 5, 2012 at 3:42 AM, Manuel Arostegui wrote:
>
>
> 2012/11/30 Néstor
>
>> I am trying to set up mysql replication on 2 systems but Once
---
Now if I do the SKIP FLAG many times, I will error after error...
I do not see how replication works so well for others if I am using the
steps in the link
on top of this message.
THANKS!!!
On Wed, Dec 5, 2012 at 3:42 AM, Manuel Arostegui wrote:
2012/11/30 Néstor
I am tryin
I was about to reply with a long message of all the steps I followed to
create replication but I did my steps about an hour ago and I have not
seen the replication fail so far.
BTW, I created my replication following the info on this web page:
http://crazytoon.com/2008/01/29/mysql-how-do-you-set-u
2012/11/30 Néstor
> I am trying to set up mysql replication on 2 systems but Once I get it
> going, I get the following an error 1062,
>
>
> I have re-installed the database on the slave also to see if this fixes the
> problem
> but after a few minutes I get the same er
- Original Message -
> From: "divesh kamra"
>
> slave-skip-errors=1062 ---> in my.cnf and restart mysql
Really? Just like that? Without even knowing what it does or what the problem
is?
If you have replication errors, this kind of stuff is only going to break it
further. "It e
Hi
first check this thought application end
or
There is another way
slave-skip-errors=1062 ---> in my.cnf and restart mysql
On Sat, Dec 1, 2012 at 4:30 AM, Reindl Harald wrote:
>
>
> Am 30.11.2012 23:52, schrieb Rick James:
> > Possible causes:
> > * Someone is writing to the Slave
>
Am 30.11.2012 23:52, schrieb Rick James:
> Possible causes:
> * Someone is writing to the Slave
that is why the option "read-only" exists for my.cnf
> * The Slave was not in synch with the Master.
> * Schemas are different between Master and Slave
should not happen if the slave is properly clo
CREATE TABLE (for a table that is in trouble)
> -Original Message-
> From: Néstor [mailto:rot...@gmail.com]
> Sent: Friday, November 30, 2012 1:24 PM
> To: mysql@lists.mysql.com
> Subject: MySQL Replication Error
>
> I am trying to set up mysql replication on 2 syst
I am trying to set up mysql replication on 2 systems but Once I get it
going, I get the following an error 1062,
which is a duplicate entry and my 'slave status' shows:
Slave_IO_Running: Yes
Slave_SQL_Running: No
And this is the error on my mysql.err file:
12113
Hi ,
Can you paste the complete error log.
Regards,
KarthiK.P.R
On Wed, Aug 29, 2012 at 7:04 AM, aaron zhang
wrote:
> Hi all
>
> i use mysql database,when i use mysql replication ,the slave host do not
> replication,i check the error message,i found error message,it is 'r
Hi all
i use mysql database,when i use mysql replication ,the slave host do not
replication,i check the error message,i found error message,it is 'row is
too large', i do not understand why,please tell and help me ,thanks
e the table won't be on the Slave.
From: Claudio Nanni [mailto:claudio.na...@gmail.com]
Sent: Wednesday, May 02, 2012 10:25 AM
To: Rick James
Cc: Brown, Charles; mysql@lists.mysql.com
Subject: Re: Can the mysql replication limited to one database
I recommend to use the 'wild' mod
ct: Re: Can the mysql replication limited to one database
>
> Quoting "Brown, Charles" :
>
>
> > Can the mysql replication limited to selected schema or database?
>
> Hi, yes it can. On the master side you control what is written to the
> binlog with my.cnf entr
both is redundant.
> -Original Message-
> From: Brown, Charles [mailto:cbr...@bmi.com]
> Sent: Wednesday, May 02, 2012 11:15 AM
> To: Rick James
> Cc: mysql@lists.mysql.com
> Subject: RE: Can the mysql replication limited to one database
>
> Hello Rick,
>
Hello Rick,
What goes into your my.cnf slave ?
Given dbname1 and dbname2
-Original Message-
From: Rick James [mailto:rja...@yahoo-inc.com]
Sent: Wednesday, May 02, 2012 12:05 PM
To: Brown, Charles
Cc: mysql@lists.mysql.com
Subject: RE: Can the mysql replication limited to one
nore-db/table/wild. See the manual on replication,
> > and especially the flowchart on how those interact (sometimes in
> unexpected
> > ways).
> >
> > > -Original Message-
> > > From: Brown, Charles [mailto:cbr...@bmi.com]
> > > Sent: Wednesd
-Original Message-
> > From: Brown, Charles [mailto:cbr...@bmi.com]
> > Sent: Wednesday, May 02, 2012 8:44 AM
> > To: Rick James
> > Cc: mysql@lists.mysql.com
> > Subject: Can the mysql replication limited to one database
> >
> > Hi Gurus,
> >
&
interact (sometimes in unexpected ways).
> -Original Message-
> From: Brown, Charles [mailto:cbr...@bmi.com]
> Sent: Wednesday, May 02, 2012 8:44 AM
> To: Rick James
> Cc: mysql@lists.mysql.com
> Subject: Can the mysql replication limited to one database
>
> Hi G
Quoting "Brown, Charles" :
Can the mysql replication limited to selected schema or database?
Hi, yes it can. On the master side you control what is written to the
binlog with my.cnf entries for each DB like:
binlog-do-db=DB1
binlog-do-db=DB2
And on the slave side you use en
Hi,
> 1. flush logs on the master (only if it's accessible, of course).
>
Not really necessary if you block clients (firewall rule for new
connections to port 3306?).
Anyway, why don't you use a dual-master setup?
I find that this is a whole lot easier to administer than a master/
fallback-slav
On 22/06/2011 15:21, Matthias Urlichs wrote:
Hi,
1. flush logs on the master (only if it's accessible, of course).
Not really necessary if you block clients (firewall rule for new
connections to port 3306?).
Hi Matthias,
thank you for replying!
Isn't the flush logs command necessary in or
Hi all,
I need to document the switch between master and slave
and I want to double check if the outlined procedure is correct.
We have a simple master slave replication setup on OEL 5.5 and MySQL
5.5.13.
Original config: machineA master, machineB slave.
Target: machineB master, machineA not
Hi all,
We have a pool of 8 MySQL servers where the first one is the
master and the others 7 are slave. Yesterday we have a hard time where the
server begin with too many lag ( 1 hour ) and then slaves start to fail with
messages like this one
thd=0x38f18130
Attempting backtrace. You ca
The application is designed to work such a way that it will process the csv
files daily as part of the aggregate process to calculate some metrics.
it runs fine on the master, when it come to slave through replicaiton it
fails with the error.
i even tried upgrading the slave to latest version mys
On Mon, Dec 20, 2010 at 9:00 AM, Anand wrote:
> Hi guys,
>
> i am facing a serious issue with my replication , i tried so many things
> but no luck.
>
> my replication is running with mysql 5.0.51a in master and 5.0.90 in slave.
>
> we run LOAD DATA INFILE in master to process some csv files and
Hi Anand,
Just try 'load data local infile',it maybe work.
Eric
2010/12/20 Anand :
> Hi guys,
>
> i am facing a serious issue with my replication , i tried so many things but
> no luck.
>
> my replication is running with mysql 5.0.51a in master and 5.0.90 in slave.
>
> we run LOAD DATA INFILE in
Hi guys,
i am facing a serious issue with my replication , i tried so many things but
no luck.
my replication is running with mysql 5.0.51a in master and 5.0.90 in slave.
we run LOAD DATA INFILE in master to process some csv files and load it into
a table, it runs perfectly well in master but wh
Johan De Meersman wrote:
> On Wed, Dec 15, 2010 at 10:08 AM, Per Jessen wrote:
>
>> Per Jessen wrote:
>>
>> > Is there a way of limiting that? Alternatively, is there a way of
>> > doing "replication-on-demand", perhaps triggered by cron?
>>
>> Ignore this, problem solved. I'll let the slaves
On Wed, Dec 15, 2010 at 10:08 AM, Per Jessen wrote:
> Per Jessen wrote:
>
> > Is there a way of limiting that? Alternatively, is there a way of
> > doing "replication-on-demand", perhaps triggered by cron?
>
> Ignore this, problem solved. I'll let the slaves query the master
> regularly and jus
Per Jessen wrote:
> Is there a way of limiting that? Alternatively, is there a way of
> doing "replication-on-demand", perhaps triggered by cron?
Ignore this, problem solved. I'll let the slaves query the master
regularly and just reload the entire table.
/Per Jessen, Zürich
--
MySQL Gener
I have a need to have a number of small tables (perhaps up to 1 rows
each) replicated to a number of mysql slaves. Frequency of change is
very low, and they need not be replicated within seconds, an hour is
fine. The master server has a lot more and bigger tables, but each
slave will only hav
On Mon, Nov 22, 2010 at 2:08 PM, John Daisley wrote:
> The replicated database should not be accepting writes, if it is then you
> haven't set it up correctly
>
*shrug*
I never bother. The slave is way too useful to fuck around with
optimisations and whatnot, reporting tools tend to do useful ag
Hi,
so yes you can do that, but then I guess you cannot set the server
hosting database A as readonly (from memory this can only be set
server wide, but worht checking it out). Which might leave you a few
options to ensure data integrity, for example simply by user security
either by di
Additionally, if a user has the SUPER privilege (eg. all privileges on
*.*) they can write to a database running in read-only mode. Yet
another reason to never allow this privilege for general purpose users.
Tyler
On 11/22/10 8:08 AM, John Daisley wrote:
The replicated database should not be
The replicated database should not be accepting writes, if it is then you
haven't set it up correctly
On 22 November 2010 13:03, wrote:
> Hi,
>
> I think you are wrong, slaves will always accept writes unless you set
> readonly in the mysql config.
> Due to this, and if you dont specifically se
.
-Original Message-
From: a.sm...@ukgrid.net
To: John Daisley
Cc: Machiel Richards , mysql mailing list
Subject: Re: MySQL replication server
Date: Mon, 22 Nov 2010 13:03:38 +
Hi,
I think you are wrong, slaves will always accept writes unless you
set readonly in the mysql config.
Due
Hi,
I think you are wrong, slaves will always accept writes unless you
set readonly in the mysql config.
Due to this, and if you dont specifically set readonly on the slave
you have to be very careful in order to maintain data integrity on the
slave and also not to break repliacton. Tools
You are correct, in a master slave setup the slave does not accept writes.
John
On 22 November 2010 11:06, Machiel Richards wrote:
> Hi All
>
>sorry to bother everyone again. but now I have a question from a
> client which I am sure about my answer, however need to confirm.
>
>When
Hi All
sorry to bother everyone again. but now I have a question from a
client which I am sure about my answer, however need to confirm.
When setting up a master/slave replication set.
As I understand it, the slave server can't accept any writes,
however it will be able to ac
Dear All,
I'm trying to get SSL connections
for all mysql slave and masters.
I have one box that will not use SSL for some reason.
When I start this slave it can not connect because
it's not using SSL.
show slave status\G
*** 1. row ***
Good day all
I am hoping everyone is well.
Can someone perhaps assist me with some resources on the following
topic
one of our clients are running a MySQL 5 master/slave replication
setup.
There is a DR test schedule during next month, however they want the
slave serv
2010/6/30 Tompkins Neil :
> Hi
>
> Just one other question. With regards the replication in MySQL 5.1 - does
> it it replication the whole row of data or just the field in which the data
> has been changed for the current record ?
MySQL 5.1 supports two replication formats: row and statement-base
Hi
Just one other question. With regards the replication in MySQL 5.1 - does
it it replication the whole row of data or just the field in which the data
has been changed for the current record ?
Thanks
Neil
2010/6/24 Jaime Crespo Rincón
> 2010/6/24 Tompkins Neil :
> > Hi
> >
> > Regarding tw
2010/6/24 Tompkins Neil :
> Hi
>
> Regarding two-way replication what do you mean by "very
> controlled environment" ? What things do I need to consider ?
Control at application level that you are not going to
insert/update/delete the same record on the two servers.
Even if MySQL gives some suppo
You could have a look at the more recent 5.1 releases, those support
semi-synchronous replication iirc.
On Thu, Jun 24, 2010 at 10:50 AM, Tompkins Neil <
neil.tompk...@googlemail.com> wrote:
> Thanks for your quick response.
>
> Basically our need for replication is because our websites access a
Hi
Regarding two-way replication what do you mean by "very
controlled environment" ? What things do I need to consider ?
Cheers
Neil
2010/6/24 Jaime Crespo Rincón
> 2010/6/24 Tompkins Neil :
> > HI,
> >
> > We have set-up MySQL Community Server 5.1.46 with Master to Slave
> > replication and
Thanks for your quick response.
Basically our need for replication is because our websites access a local
MySQL database - which is fine. In our remote office, we also need to
access this MySQL database too however the connect time/ query speed is very
slow. At the moment the application in the
On 24/06/2010 09:18, Tompkins Neil wrote:
HI,
We have set-up MySQL Community Server 5.1.46 with Master to Slave
replication and everything appears to be working correctly, however I have a
couple of questions which I hope somebody can shed some light.
(1) When the network connection goes down b
2010/6/24 Tompkins Neil :
> HI,
>
> We have set-up MySQL Community Server 5.1.46 with Master to Slave
> replication and everything appears to be working correctly, however I have a
> couple of questions which I hope somebody can shed some light.
>
> (1) When the network connection goes down between
HI,
We have set-up MySQL Community Server 5.1.46 with Master to Slave
replication and everything appears to be working correctly, however I have a
couple of questions which I hope somebody can shed some light.
(1) When the network connection goes down between the master and slave
servers, it woul
Dear Nilnandan,
Thanks for the quick reply.
But this particular variable is not working in only one proc call...but
rest all procedures creating temporary tables, does not affect my
replication slaves.
So I am not able to identify the problem.
Here's the snapshot of my procedure which is
Hi Manasi,
Please try with this one.
Replicate_Wild_Ignore_Table = mydb\temp_.%
Regards,
Nilnandan Joshi
Manasi Save wrote:
Hi All,
I have kept
Replicate_Wild_Ignore_Table = mydb%.temp_%
this is temporary table which i want should not be replicated. But
still it is getting replicated an
Hi All,
I have kept
Replicate_Wild_Ignore_Table = mydb%.temp_%
this is temporary table which i want should not be replicated. But still
it is getting replicated and slave is getting crashed.
any input will be a great help.
--Thanks and Regards, Manasi Save Artificial Machines
Private Li
ement ring configuration.
> I read somewhere that this can happen when relay-log.info does not get
> updated. But did not find any reason of how to deal with it.
>
> Does anyone faced similar type of issue in MySQL Replication. Any input
> will be a great help.
Here are my su
t
updated. But did not find any reason of how to deal with it.
Does anyone faced similar type of issue in MySQL Replication. Any input
will be a great help.
Here are my suggestions.
1) Read how the replication systems of MySQL actually work. Only
completed changes to the database are writ
reason behind this behaviour of
replication.I read somewhere that this can happen when relay-log.info
does not get updated. But did not find any reason of how to deal with it.
Does anyone faced similar type of issue in MySQL Replication. Any
input will be a great help.Thanks in advance.--Regards,Manasi
Hi Manasi,
That alone is the difference in this case.
--
Thanks
Suresh Kuna
MySQL DBA
On Tue, Jan 19, 2010 at 10:36 AM, Manasi Save <
manasi.s...@artificialmachines.com> wrote:
> Dear Carlos,
>
> Thanks for the response. But I haven't gave any privileges besides
> repl_slave priv to user replic
Hi Manasi
Yes, you only need the repl_slave_priv, the show grants should give you
something like:
GRANT REPLICATION SLAVE ON *.* TO 'replication'@'%' IDENTIFIED BY
PASSWORD '...'
If thats ok, have check your binlog and relay binlog to see if them
contain the delete statements?
Im trying to
Dear Carlos,
Thanks for the response. But I haven't gave any privileges besides
repl_slave priv to user replication and replication2 respectively.
So does that amke any difference really?
Thanks in advance.
--
Regards,
Manasi Save
Quoting Carlos Proal :
I dont see anything unusual or m
I dont see anything unusual or missing on your config file and as the
only thing missing are deletes, i think that might be a permission issue.
Can you check out the grants for your replication users and see if they
have full permissions granted ?
mysql> show grants for x;
where is xxx
Hi Anand,Please find below my configuration
file of both the masters:ON MASTER 1:[mysqld]datadir=/var/lib/mysql/socket=/var/lib/mysql/mysql.sockold_passwords=1log-bin=/usr/local/mysql/bin.log#binlog-do-db= # input the database which should be
replicatedbinlog-ignore-db=mysql
# input
Hi All,I have configured MySQL Master-Master Replication
on my servers. When I am inserting or updating any data in a regular table the
data is getting replicated.But When I am doing delete on
that same table. the data is only getting deleted only on the server where I am
doing delete. but it is no
MySQL Replication: Walk-through of the new 5.1 and 6.0 features
http://forge.mysql.com/wiki/MySQL_Replication:_Walk-through_of_the_new_5.1_and_6.0_features
This Thursday (May 28th, 14:00 UTC), Lars Thalmann will give a MySQL
University session on MySQL Replication: Walk-through of the new 5.1 and
MySQL Replication: Walk-through of the new 5.1 and 6.0 features
http://forge.mysql.com/wiki/MySQL_Replication:_Walk-through_of_the_new_5.1_and_6.0_features
This Thursday (May 7th, 14:00 UTC), Lars Thalmann will give a MySQL
University session on MySQL Replication: Walk-through of the new 5.1 and
I would not compare binlog positions. I would use mk-heartbeat from
Maatkit. It tells the truth in a much simpler and more direct way.
Instead of checking things that indicate your data is being
replicated, just replicate some data and check the data itself.
--
MySQL General Mailing List
For li
I'd just write a perl script to do it and return the appropriate status
code/message to nagios. Shouldn't be hard at all. PhP or any language that
can talk to mysql would work, too. You just mentioned the position, you'll
have to compare the names of the binlog files as well: position 100 in fil
@lists.mysql.com
Subject: MySQL replication status plugin
Good morning guys, (and girls), I hope all is well. I've been given the
task to, and I quote - "Write a Nagios plugin to test the replication
status of two servers by
comparing the position on the master to that on the slave&quo
Good morning guys, (and girls), I hope all is well. I've been given the
task to, and I quote - "Write a Nagios plugin to test the replication
status of two servers by
comparing the position on the master to that on the slave"
To save myself a lot of work, I'd like to know if anything has been
ave status\G;
...
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
...
it will restart the replication, but you have to check then why this happened,
just in case...
- Original Message -
From: Shain Miley
To: mysql@lists.mysql.com
Sent: Friday, January 09, 2009 3:17 PM
Su
restart the replication, but you have to check then why this happened,
just in case...
- Original Message -
From: Shain Miley
To: mysql@lists.mysql.com
Sent: Friday, January 09, 2009 3:17 PM
Subject: Mysql Replication out of sync
Hello all,
I noticed that my two Mysql s
Hello all,
I noticed that my two Mysql slave servers were running out of sync this
morning. After looking into it...it appears that yesterday when I tried
to change the username of a user on the master server...it caused some
issues on the slaves. Here is what I was able to pull from the slav
I think this is the same as the other system.
On Mon, Mar 31, 2008 at 10:32 PM, Daniel Brown <[EMAIL PROTECTED]> wrote:
> On Mon, Mar 31, 2008 at 9:39 AM, Kaushal Shriyan
> <[EMAIL PROTECTED]> wrote:
> > Hi
> >
> > Is there a documentation on replication of MySQL Database on Gentoo
>
> From
On Mon, Mar 31, 2008 at 9:39 AM, Kaushal Shriyan
<[EMAIL PROTECTED]> wrote:
> Hi
>
> Is there a documentation on replication of MySQL Database on Gentoo
From the manual:
http://dev.mysql.com/doc/refman/5.0/en/replication-howto.html
--
Forensic Services, Senior Unix Engineer
1+ (570
http://gentoo-wiki.com/HOWTO_MySQL_Replication
On 3/31/08, Kaushal Shriyan <[EMAIL PROTECTED]> wrote:
>
> Hi
>
> Is there a documentation on replication of MySQL Database on Gentoo
>
> Thanks and Regards
>
> Kaushal
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/my
Hi
Is there a documentation on replication of MySQL Database on Gentoo
Thanks and Regards
Kaushal
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Naufal,
You probably need to start with a clean slate. Do a complete resync and
start the slave back up from a known stopping point.
Keith
Naufal Sheikh wrote:
Hello,
Just a small question. I had mysql replication configured on my master and
slave server. Due to some issues ( when I was
Hello,
Just a small question. I had mysql replication configured on my master and
slave server. Due to some issues ( when I was on vacations ), logging on
master server was switched off and server restarted. Now my question is that
in order to resysnc my master and slave correctly, do I need to
ge-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Behalf Of Baron Schwartz
> Sent: Tuesday, November 27, 2007 6:50 AM
> To: bruce
> Cc: B. Keith Murphy; mysql list
> Subject: Re: mysql replication
>
>
> You can only do that in the my.cnf file.
>
&
there an option/attribute for this.
thanks
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Baron Schwartz
Sent: Tuesday, November 27, 2007 6:50 AM
To: bruce
Cc: B. Keith Murphy; mysql list
Subject: Re: mysql replication
You can only do that in the my.cnf
l
> like to know this, given that i might not want to use the my.cnf file...
>
> thanks
>
>
> -Original Message-
> From: B. Keith Murphy [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, November 27, 2007 6:31 AM
> To: bruce; 'mysql list'
> Subject: Re: mysql replic
6:31 AM
To: bruce; 'mysql list'
Subject: Re: mysql replication
bruce wrote:
> hi...
>
> a quick question that i haven't found an answer to.
>
> i can use "replicate-do-db=foo" in a my.cnf file for replication, to
> replicate the master foo db on the sla
bruce wrote:
hi...
a quick question that i haven't found an answer to.
i can use "replicate-do-db=foo" in a my.cnf file for replication, to
replicate the master foo db on the slave. but this requires that i use/have
a my.cnf set on the slave.
is there a way to dynamically set this attribute/pa
hi...
a quick question that i haven't found an answer to.
i can use "replicate-do-db=foo" in a my.cnf file for replication, to
replicate the master foo db on the slave. but this requires that i use/have
a my.cnf set on the slave.
is there a way to dynamically set this attribute/parameter within
From: Dan Rogart [mailto:[EMAIL PROTECTED]
> On 11/14/07 4:01 PM, "Mike Johnson"
> <[EMAIL PROTECTED]> wrote:
>
> > Correction to a couple of replies I've seen -- a slave
> > server can have more than one master, but not to the same
> > database. That is, Slave reads Database1 and Database3
-Original Message-
From: Dan Rogart [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 14, 2007 1:07 PM
To: Mike Johnson; Baron Schwartz; bruce
Cc: mysql list
Subject: Re: MySQL - Replication (Master/Slave) Question
On 11/14/07 4:01 PM, "Mike Johnson" <[EMAIL PROTECTED]>
ible, can I get/see a sample my.cnf file illustrating
how this can be handled
thanks
-Original Message-
From: Dan Rogart [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 14, 2007 1:07 PM
To: Mike Johnson; Baron Schwartz; bruce
Cc: mysql list
Subject: Re: MySQL - Replication (Master
On 11/14/07 4:01 PM, "Mike Johnson" <[EMAIL PROTECTED]> wrote:
> Correction to a couple of replies I've seen -- a slave server can have
> more than one master, but not to the same database. That is, Slave reads
> Database1 and Database3 from Master1 and also reads Database2 from
> Master2.
>
>
Correction to a couple of replies I've seen -- a slave server can have
more than one master, but not to the same database. That is, Slave reads
Database1 and Database3 from Master1 and also reads Database2 from
Master2.
You may actually be able to get down to the table level, but I'd have to
check
On Nov 14, 2007 3:40 PM, bruce <[EMAIL PROTECTED]> wrote:
> Hi...
>
> I have a number of servers that I want to treat as Master Servers or the
> purpose of Replication..
>
> I'd like to have each of the Master, have the Slave DB on the same machine.
> Ie, a Slave server, might have 10 different Sla
bruce wrote:
Hi...
I have a number of servers that I want to treat as Master Servers or the
purpose of Replication..
I'd like to have each of the Master, have the Slave DB on the same machine.
Ie, a Slave server, might have 10 different Slave Databases/config files,
with each of the SlaveDB tie
Hi...
I have a number of servers that I want to treat as Master Servers or the
purpose of Replication..
I'd like to have each of the Master, have the Slave DB on the same machine.
Ie, a Slave server, might have 10 different Slave Databases/config files,
with each of the SlaveDB tied back to the M
On Sat, 2006-08-12 at 08:38 -0400, Warren Crigger wrote:
> > Note that you should not just delete the bin logs. Instead
> > use PURGE MASTER LOGS. See
> > http://dev.mysql.com/doc/refman/4.1/en/purge-master-logs.html
> >
> > hth,
> > mark
>
>
> Sorry, accidently hit Ctrl/Enter :(
>
> Anyway,
1 - 100 of 291 matches
Mail list logo