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
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
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 to be
replicated
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 been a typical
- Original Message -
From: Néstor rot...@gmail.com
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
in the link
on top of this message.
THANKS!!!
On Wed, Dec 5, 2012 at 3:42 AM, Manuel Arostegui man...@tuenti.com
wrote:
2012/11/30 Néstor rot...@gmail.com
I am trying to set up mysql replication on 2 systems but Once I get it
going, I get the following an error 1062,
skip
I have re
of this message.
THANKS!!!
On Wed, Dec 5, 2012 at 3:42 AM, Manuel Arostegui man...@tuenti.com wrote:
2012/11/30 Néstor rot...@gmail.com
I am trying to set up mysql replication on 2 systems but Once I get it
going, I get the following an error 1062,
skip
I have re-installed the database on the slave
...@tuenti.com wrote:
2012/11/30 Néstor rot...@gmail.com
I am trying to set up mysql replication on 2 systems but Once I get it
going, I get the following an error 1062,
skip
I have re-installed the database on the slave also to see if this fixes
the
problem
but after a few minutes I get
/30 Néstor rot...@gmail.com
I am trying to set up mysql replication on 2 systems but Once I get it
going, I get the following an error 1062,
skip
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 error. I have repeated
...
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 man...@tuenti.com
wrote:
2012/11/30 Néstor rot...@gmail.com
I am trying to set up mysql replication on 2 systems
- Original Message -
From: divesh kamra kamra.div...@gmail.com
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
2012/11/30 Néstor rot...@gmail.com
I am trying to set up mysql replication on 2 systems but Once I get it
going, I get the following an error 1062,
skip
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 error. I
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:
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 h.rei...@thelounge.netwrote:
Am 30.11.2012 23:52, schrieb Rick James:
Possible causes:
* Someone is writing
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 systems but Once I get it
going, I
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 cloned
Hi ,
Can you paste the complete error log.
Regards,
KarthiK.P.R
On Wed, Aug 29, 2012 at 7:04 AM, aaron zhang
aaron.zh...@embracesource.comwrote:
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
Quoting Brown, Charles cbr...@bmi.com:
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
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 Gurus,
Can the mysql replication limited
: 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,
Can the mysql replication limited to selected schema or database? I've
been asked to set up
on replication,
and especially the flowchart on how those 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
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
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,
What goes into your my.cnf slave ?
Given
replication limited to one database
Quoting Brown, Charles cbr...@bmi.com:
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
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' modifier, if you have
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
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-slave
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
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
Hi Anand,
Just try 'load data local infile',it maybe work.
Eric
2010/12/20 Anand anand@gmail.com:
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
On Mon, Dec 20, 2010 at 9:00 AM, Anand anand@gmail.com 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
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
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 General
On Wed, Dec 15, 2010 at 10:08 AM, Per Jessen p...@computer.org 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
Johan De Meersman wrote:
On Wed, Dec 15, 2010 at 10:08 AM, Per Jessen p...@computer.org 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
You are correct, in a master slave setup the slave does not accept writes.
John
On 22 November 2010 11:06, Machiel Richards machi...@rdc.co.za 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
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.
.
-Original Message-
From: a.sm...@ukgrid.net
To: John Daisley daisleyj...@googlemail.com
Cc: Machiel Richards machi...@rdc.co.za, mysql mailing list
mysql@lists.mysql.com
Subject: Re: MySQL replication server
Date: Mon, 22 Nov 2010 13:03:38 +
Hi,
I think you are wrong, slaves will always
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, a.sm...@ukgrid.net 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
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
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
On Mon, Nov 22, 2010 at 2:08 PM, John Daisley daisleyj...@googlemail.comwrote:
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
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 jcre...@warp.es
2010/6/24 Tompkins Neil
2010/6/30 Tompkins Neil neil.tompk...@googlemail.com:
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
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
2010/6/24 Tompkins Neil neil.tompk...@googlemail.com:
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
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
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
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 jcre...@warp.es
2010/6/24 Tompkins Neil neil.tompk...@googlemail.com:
HI,
We have set-up MySQL Community Server 5.1.46 with
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
2010/6/24 Tompkins Neil neil.tompk...@googlemail.com:
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
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
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
. 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 written to the binary
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 suggestions.
1) Read how the replication systems of MySQL actually work
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
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 carlos.pr...@gmail.com:
I dont
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
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 replication
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=database
name # input the database which should be
replicatedbinlog-ignore-db=mysql
#
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
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
@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
To save
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
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
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 slave servers
;
...
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
Subject: Mysql
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 the manual:
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/mysql
To
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
--
/Daniel P. Brown
Forensic Services, Senior Unix
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
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
-
From: B. Keith Murphy [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 27, 2007 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
is 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
'
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 slave. but this requires that i
use/have
a my.cnf set on the slave.
is there a way
: 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.
On Nov 27, 2007 9:50 AM, bruce [EMAIL PROTECTED] wrote:
hi keith...
i recognize you can't do multiple masters to a single slave
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
from
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
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 Slave
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
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.
You may
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/Slave) Question
On 11/14/07 4
[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] wrote:
Correction to a couple of replies I've seen -- a slave
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, I can't purge
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, I can't purge with that command:
mysql PURGE MASTER LOGS TO 'mysql-bin.023';
ERROR:
7430 4678
F
E [EMAIL PROTECTED]
WWW.ITN.CO.UK
-Original Message-
From: Warren Crigger [mailto:[EMAIL PROTECTED]
Sent: Thursday, 10 August 2006 9:52 AM
To: mysql@lists.mysql.com
Cc: [EMAIL PROTECTED]
Subject: MySQL Replication Binary Logs - How Long to Keep?
I've just recently set
---
-Original Message-
From: Warren Crigger [mailto:[EMAIL PROTECTED]
Sent: Thursday, 10 August 2006 9:52 AM
To: mysql@lists.mysql.com
Cc: [EMAIL PROTECTED]
Subject: MySQL Replication Binary Logs - How Long to Keep?
I've just
To add a few short notes:
1) What happens when you modify data on the slave directly depends on how
you configure your setup. It is possible to have slave updates appear on
the master, that is usually referred to as circular replication. Since you
have 2 replication slaves I would advise against
To be clear:
Replication in MySQL replicates the DML (data manipulation language)
and DDL (data definition language) commands -- that is, any command
that's an alter, update, insert, replace, create, drop, etc statement
to the slave.
If you write to the slave, it does not write back to the
---
-Original Message-
From: Jason Williard [mailto:[EMAIL PROTECTED]
Sent: Saturday, 7 January 2006 9:32 AM
To: mysql@lists.mysql.com
Subject: MySQL Replication
I am trying to understand exactly how replication works. So far, I see
I'll 2nd that High Performance MySQL.
it is by far the best MySQL book I've come across (though I didn't need the
101 stuff, I specifically needed tuning/architecting for HA, etc.)
the only knock I could make (which isn't their fault) is that it needs to be
updated for 5.x (can you say 2nd
Jason Williard wrote:
I am trying to understand exactly how replication works. So far, I see that
changes made on a master server are replicated to the slave server(s).
However, if a change is made on a slave server, is that replicated back to
the master as well as all other slaves?
It can
Hello.
Not enough information to make a conclusion. Use SHOW SLAVE STATUS and
information from the binary logs to determine the problem. See:
http://dev.mysql.com/doc/mysql/en/replication-problems.html
David Lloyd [EMAIL PROTECTED] wrote:
Hi There,
I have a
Hello.
Use --replicate-do-db=db_name
See:
http://dev.mysql.com/doc/mysql/en/replication-options.html
[snip]
I have two mysql server A,B. I'm using the replication between these servers.
But i want
to the replication work with just one database.
Example:
A server: database1,
Hello.
See:
http://dev.mysql.com/doc/mysql/en/Replication_Options.html
Dave Goodrich [EMAIL PROTECTED] wrote:
Good morning,
Been reading through the docs and checking online info and I m still
looking for a answer. I have a radius DB on two radius servers and I
want to sync
Ahh, thanks and to Bill Alliar as well. I just needed to re-read
everything, I think that answers my questions. This full situation is this.
On each slave I have a database, radius, which holds auth info and
accounting info for each user. I want to limit the accounting info on
the slave
Hi List,
What are some issues relating to using OPTIMIZE TABLE and replication?
Does running OPTIMIZE TABLE on a master DB cause the optimizations to be
passed on to the slaves?
Thanks,
Jim
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
In the last episode (May 14), Jim said:
What are some issues relating to using OPTIMIZE TABLE and
replication? Does running OPTIMIZE TABLE on a master DB cause the
optimizations to be passed on to the slaves?
Yes, unless you add the LOCAL flag to optimize.
In the last episode (May 14), Dan Nelson said:
In the last episode (May 14), Jim said:
What are some issues relating to using OPTIMIZE TABLE and
replication? Does running OPTIMIZE TABLE on a master DB cause the
optimizations to be passed on to the slaves?
Yes, unless you add the LOCAL
On Fri, May 14, 2004 at 03:10:05PM -0400, Jim wrote:
Hi List,
What are some issues relating to using OPTIMIZE TABLE and replication?
Does running OPTIMIZE TABLE on a master DB cause the optimizations to be
passed on to the slaves?
It does not. The command doesn't replicate.
--
Jeremy D.
1 - 100 of 216 matches
Mail list logo
