- 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
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 parall
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 wrote:
> HI Igor,
>
> Are you saying to add these lines to the my.cnf file:
> replicate-
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 ei
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, ref
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,
Ig
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 error. I have repeated th
- 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
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 CR
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 'row is
> too large', i
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
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
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
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 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
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
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: mysql@l
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 particul
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 r
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
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 on
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
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
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,
> 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';
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.
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 mai
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 edit
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
--
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 master
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 u
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 rep
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, da
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 servers
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
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? The
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 Mast
-->-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 set
t'; [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.
-->For example, if a person places an order
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 sho
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 d
TECTED]
> Cc: Dathan Vance Pattishall; [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 su
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
Sub
Thursday, 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
p
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 t
ubert
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
Acomm.com, Inc.
http://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 w
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 (li
can't 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
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 upd
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
repli
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
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
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
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
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 mysql_conne
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
ailto:[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 PRO
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:2
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 no
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?
On Tue, Oct 15, 2002 at 02:35:34PM +0100, Andrew Braithwaite wrote:
> Hi all,
>
> Does anyone have any experience with running a v3 master and v4 slaves?
>
> Will it work? - I can't see why not...
Works well, yes. We have a .51 master with 4.0.{3,4} slaves.
--
Jeremy D. Zawodny | Perl,
1 - 100 of 129 matches
Mail list logo