- 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
Yes that's correct.
it needs to be added on the slave side under [mysqld] section usually
close to the place where you define your replication settings (for
convenience only).
The reason why server failed to start difficult to guess without error log.
this will prevent all tables under
Hi Néstor,
You might want to put those lines into your my.cnf under replication
section and restart the slave:
replicate-wild-ignore-table=dbname%.watchdog%
and may be this as well:
replicate-wild-ignore-table=dbname%.cache%
Do you really need to replicate cache and session tables?
Cheers,
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
key 1' on query. Default database: 'parallax'. Query: 'INSERT INTO watchdog
(uid, type, message, variables, severity, link, location,
In regards to the second part of your email.
You don't have errors in your mysql.err log. Those are notes saying that
you started IO and SQL replication threads after you skipped an
replication error and run start slave command.
I wouldn't run SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; command
I added those line to the slave's my.cnf and mysql would not start
replicate-wild-ignore-table=parallax%.watchdog%
replicate-wild-ignore-table=parallax%.cache%
Nestor
On Thu, Dec 6, 2012 at 4:39 PM, Néstor rot...@gmail.com wrote:
HI Igor,
Are you saying to add these lines to the my.cnf
- 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
Possible causes:
* Someone is writing to the Slave.
* The Slave was not in synch with the Master.
* Schemas are different between Master and Slave.
* Someone is changing the POS for replication.
After you have eliminated those possibilities, provide
SHOW SLAVE STATUS \G
SHOW MASTER STATUS;
SHOW
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,it
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
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
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
#
You could try this:
http://www.consol.de/opensource/nagios/check-mysql-health
(in German but should be self-explanatory).
Cheers,
Andrew
-Original Message-
From: Gabriel - IP Guys [mailto:gabr...@impactteachers.com]
Sent: 15 April 2009 10:12
To: replicat...@lists.mysql.com
Cc:
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
maybe if you put on the slave server :
mysql STOP SLAVE;
mysql SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1;
mysql START SLAVE;
then just to check take a look at this lines :
mysql show slave status\G;
...
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
...
it will restart the
Jose,
Thank you very much...I found that fix a few minutes before I read your
email...however I really appreciate your assistance.
Just an FYI to anyone one else though...I had to skip a total of 2
queries (I executed SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; two times)
because of the
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 was
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:
On Thu, 2006-08-10 at 14:47 +1000, Logan, David (SST - Adelaide) wrote:
Hi Warren,
I would generally keep the binary log until you have done a full backup.
Once that is done, all the transactions that are contained in those logs
are now committed and saved in your database backup.
snip
You
Hi Warren,
I would generally keep the binary log until you have done a full backup.
Once that is done, all the transactions that are contained in those logs
are now committed and saved in your database backup.
All binary logs may be deleted that were created before that backup took
place. The
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
Hi Jason,
Most other peoples responses are excellent as usual, however might I suggest
getting a copy of High Performance MySQL by Jeremy Zawodny (O'Reilly
publishers). This covers the exact scenario you are talking about.
Regards
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
In the last episode (May 04), Jim said:
Do changes in database structure replicate to the slaves from the
master? Is there a document somewhere in the manual (I have not
found one) that explains what gets replicated and what does not?
Specifically, does an ALTER TABLE get replicated? There
Fabbro Alberto wrote:
Network configuration:
- Firewall connected to Internet, with two ports: LAN (protected) and DMZ
- Web server on the DMZ segment
- Internal Servers on the LAN segment.
We would like to introduce a web database application on the Web server,
using a Slave replication of a
wait to get yours.
...
Ian Neubert
Director of IS
TWAcomm.com, Inc.
http://www.twacomm.com/
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
Sent: Monday, August 11, 2003 12:39 PM
To: Adam Nelson
Cc: 'Ian Neubert'; [EMAIL PROTECTED]
Subject: Re: MySQL
On Thu, Aug 07, 2003 at 01:00:12PM -0700, Ian Neubert wrote:
I was trying to design it so that the slaves wouldn't know they had
connected to a different master, as they both masters would have the same IP
address that gets failed over based on the Linux Virtual Server software and
VRRP (like
://www.twacomm.com/
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 07, 2003 2:53 PM
To: Ian Neubert
Cc: Dathan Vance Pattishall; [EMAIL PROTECTED]
Subject: Re: MySQL Replication
On Thu, Aug 07, 2003 at 01:00:12PM -0700, Ian Neubert wrote:
I was trying
Director of IS
TWAcomm.com, Inc.
http://www.twacomm.com/
-Original Message-
From: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 07, 2003 1:34 PM
To: 'Ian Neubert'
Cc: [EMAIL PROTECTED]
Subject: RE: MySQL Replication
---Original Message-
--From: Ian
, August 07, 2003 12:54 PM
--To: 'Ian Neubert'; [EMAIL PROTECTED]
--Subject: RE: MySQL Replication
--
--That configuration doesn't seem to work if I'm reading it right. A
slave
--cannot have more then one master unless mysql more then 1 mysqld
process
--running on different ports is used
You can use the default *.cnf file which is located at /usr/share/mysql.
There are several *.cnf files. You can choose one to suite your machine
configuration.
~~yin~~
- Original Message -
From: System [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, August 11, 2003 9:22 PM
Subject:
Consider using freeswan (http://www.freeswan.ca) to setup a VPN between
the 2 servers.. that way you can replicate between tunnel addresses..
Or you can spend some cash and buy some vpn appliances..
On Thu, 7 Aug 2003, System wrote:
Hello All,
How will i setup Mysql Replication btween two
; [EMAIL PROTECTED]
Subject: RE: MySQL Replication
Good question :)
I got a message from a person off the list that suggested I
use network disk
mirroring or a NAS/SAN/NFS system to handle that. I'm not sure if the
mirroring would be 100% perfect, but the NAS/SAN solution
should as either
On Fri, Aug 08, 2003 at 12:10:18PM -0400, Adam Nelson wrote:
Also, one has to work out the cost of high availability. If you're
talking about a situation where you reduce downtime from 4 hours/yr to
.5 hours/yr and it costs you x dollars, you have to make sure that the
extra 3.5 hours of
On Thu, Aug 07, 2003 at 03:22:58PM -0700, Ian Neubert wrote:
Good question :)
I got a message from a person off the list that suggested I use
network disk mirroring or a NAS/SAN/NFS system to handle that. I'm
not sure if the mirroring would be 100% perfect, but the NAS/SAN
solution should
]
Subject: RE: MySQL Replication
That configuration doesn't seem to work if I'm reading it right. A slave
cannot have more then one master unless mysql more then 1 mysqld process
running on different ports is used.
--For example, if a person places an order on our site, the update is
sent
---Original Message-
--From: Ian Neubert [mailto:[EMAIL PROTECTED]
--Sent: Thursday, August 07, 2003 1:00 PM
--To: Dathan Vance Pattishall
--Cc: [EMAIL PROTECTED]
--Subject: RE: MySQL Replication
--
--Off hand do you know any good resources on how to setup a highly
--available
Something to ask yourself in all this is, how fast can I change out a
piece of hardware? If I needed a high availability system, on the cheap
(ie, not a million dollars US worth of Sun hardware) I'd probably go
with a bunch of SuperMicro 2U rack mount servers with the hot swap SCSI
drives. You
That configuration doesn't seem to work if I'm reading it right. A slave
cannot have more then one master unless mysql more then 1 mysqld process
running on different ports is used.
--For example, if a person places an order on our site, the update is
sent
--to
--the master server. Can that
Erik Olsen wrote:
Is it possible for slave to connect to 2 different masters and have
synchronized database from both?
So you would have updates on 2 masters M1 and M2 which would be
replicated to the read-only slave S1 ?
The point of MySQL's replication is that after an replication-event
there
Yes. The idea was to backup 2 masters, 1 that is ours and 1 that is a
costumer. The slave's job is just going to have a synchronised db of
both servers db. The plan was to have it on a different place in case of
fire.
But I must find another solution then.
Erik Olsen wrote:
Is it possible
May be I am misunderstanding your goals but it seems that you want to
have a backup server for two independant masters (with different
databases). Something like:
M1 -- S -- M2
DB1DB1 DB2
DB2
If this is the case, you can run two mysqld instances on S, each one
Have you turned log-bin on the master server? The master will not generate
the log files that the slave reads unless this is turned on.
|-+
| | Floyd Wellershaus|
| | [EMAIL PROTECTED]|
| | .com
What versions of MySQL are on each machine ?
Jerry
- Original Message -
From: Floyd Wellershaus [EMAIL PROTECTED]
To: Mysqllist (E-mail) [EMAIL PROTECTED]
Sent: Thursday, February 27, 2003 1:55 PM
Subject: mysql replication across platforms
Hello,
I am unsuccessfully trying to start
Vaso Koutsonikola wrote:
Hi,
I am replicating a table between 2 servers.
The table on the master executes many transactions that should be
replicated to the table on the slave..
The table on the slave is only readable...
I have noticed that the changes on the master are not replicated at
AFAIK, you can't do it transparently from the MySQL client library. (like in
Oracle)
You have to accomplish the task in your application, ie: try to
connect/select from the master database, if command fails then try the
slave1, then slave2, then slave3... and so on.
Hint: create you own
Just a guess, but I would say the problem rests in the network or network
configuration. We have a number of installation running replication (both
Win32 and Linux), and have never seen anything like this.
Gerald Jensen
- Original Message -
From: Vaso Koutsonikola [EMAIL PROTECTED]
To:
Frisby [mailto:[EMAIL PROTECTED]]
Inviato: mercoledì 20 novembre 2002 21.10
A: Massimo Bandinelli
Oggetto: RE: Mysql Replication
No. Why would you wish to do so?
-JF
-Original Message-
From: Massimo Bandinelli [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 20, 2002 7:22 AM
Bandinelli
Oggetto: RE: Mysql Replication
No. Why would you wish to do so?
-JF
-Original Message-
From: Massimo Bandinelli [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 20, 2002 7:22 AM
To: [EMAIL PROTECTED]
Subject: Mysql Replication
A question:
I've
On Tue, Nov 12, 2002 at 12:06:08PM +0530, mod_perl wrote:
hi all,
i want to know how can i implement a two way replication between
more than two machines in mysql.
A slave can only have one master. So two-way replication can only be
done between two MySQL instances--whether or not
No ... I'm just setting up the replication for the
first time.
I make a dump of the master and i replaced it on the
slave.
thanks and bye.
--- Victor Pendleton [EMAIL PROTECTED] ha
scritto: Has the replication worked previously for
you?
If so, have you reset the master and the slave?
According to the replication compatibility table, you can.
http://www.mysql.com/doc/en/Replication_Implementation.html
-J
-Original Message-
From: Andrew Braithwaite [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 15, 2002 8:36 AM
To: [EMAIL PROTECTED]
Subject: MySQL Replication -
1 - 100 of 124 matches
Mail list logo