Re: MySQL Replication Error

2012-12-10 Thread Johan De Meersman
- 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

Re: MySQL Replication Error

2012-12-07 Thread Igor Shevtsov
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

Re: MySQL Replication Error

2012-12-06 Thread Néstor
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-

Re: MySQL Replication Error

2012-12-06 Thread Igor Shevtsov
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

Re: MySQL Replication Error

2012-12-06 Thread 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 key 1' on query. Default database: 'parallax'. Query: 'INSERT INTO watchdog (uid, type, message, variables, severity, link, location, ref

Re: MySQL Replication Error

2012-12-06 Thread Igor Shevtsov
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

Re: MySQL Replication Error

2012-12-05 Thread Néstor
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

Re: MySQL Replication Error

2012-12-05 Thread Manuel Arostegui
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

Re: MySQL Replication Error

2012-12-05 Thread Johan De Meersman
- 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

Re: MySQL Replication Error

2012-12-04 Thread divesh kamra
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 >

Re: MySQL Replication Error

2012-11-30 Thread Reindl Harald
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

RE: MySQL Replication Error

2012-11-30 Thread Rick James
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

Re: mysql replication

2012-08-28 Thread P.R.Karthik
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

Re: MySQL Replication - promote slave

2011-06-22 Thread Matthias Urlichs
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

Re: MySQL Replication - promote slave

2011-06-22 Thread Radoulov, Dimitre
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

Re: MySQL replication server

2010-11-22 Thread Johan De Meersman
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

Re: MySQL replication server

2010-11-22 Thread a . smith
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

Re: MySQL replication server

2010-11-22 Thread Tyler Poland
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

Re: MySQL replication server

2010-11-22 Thread John Daisley
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

Re: MySQL replication server

2010-11-22 Thread Machiel Richards
. -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

Re: MySQL replication server

2010-11-22 Thread a . smith
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

Re: MySQL replication server

2010-11-22 Thread John Daisley
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

Re: MySQL Replication

2010-06-30 Thread Jaime Crespo Rincón
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

Re: MySQL Replication

2010-06-30 Thread 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 ? Thanks Neil 2010/6/24 Jaime Crespo Rincón > 2010/6/24 Tompkins Neil : > > Hi > > > > Regarding tw

Re: MySQL Replication

2010-06-24 Thread Jaime Crespo Rincón
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

Re: MySQL Replication

2010-06-24 Thread Johan De Meersman
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

Re: MySQL Replication

2010-06-24 Thread Tompkins Neil
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

Re: MySQL Replication

2010-06-24 Thread Tompkins Neil
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

Re: MySQL Replication

2010-06-24 Thread Mark Goodge
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

Re: MySQL Replication

2010-06-24 Thread 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 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

Re: MySQL Replication - Master-Slave crash

2010-06-24 Thread Manasi Save
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

Re: MySQL Replication - Master-Slave crash

2010-06-23 Thread Nilnandan Joshi
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

Re: MySQL Replication Delete is not gettting replicated

2010-01-18 Thread Suresh Kuna
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

Re: MySQL Replication Delete is not gettting replicated

2010-01-18 Thread Carlos Proal
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

Re: MySQL Replication Delete is not gettting replicated

2010-01-18 Thread Manasi Save
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

Re: MySQL Replication Delete is not gettting replicated

2010-01-18 Thread Carlos Proal
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

Re: MySQL Replication Delete is not gettting replicated

2010-01-17 Thread Manasi Save
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

Re: MySQL replication status plugin

2009-04-15 Thread Baron Schwartz
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

Re: MySQL replication status plugin

2009-04-15 Thread Jim Lyons
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

RE: MySQL replication status plugin

2009-04-15 Thread Andrew Braithwaite
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

Re: Mysql Replication out of sync

2009-01-09 Thread Shain Miley
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

Re: Mysql Replication out of sync

2009-01-09 Thread Jose Julian Buda
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

Re: mysql replication

2008-04-06 Thread Moon's Father
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

Re: mysql replication

2008-03-31 Thread Daniel Brown
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

Re: mysql replication

2008-03-31 Thread Mike Zupan
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

Re: mysql replication

2008-01-23 Thread B. Keith Murphy
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

Re: mysql replication....

2007-11-27 Thread Baron Schwartz
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. > &

RE: mysql replication....

2007-11-27 Thread bruce
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

Re: mysql replication....

2007-11-27 Thread Baron Schwartz
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

RE: mysql replication....

2007-11-27 Thread bruce
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

Re: mysql replication....

2007-11-27 Thread B. Keith Murphy
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

RE: MySQL - Replication (Master/Slave) Question

2007-11-15 Thread Mike Johnson
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

RE: MySQL - Replication (Master/Slave) Question

2007-11-14 Thread bruce
-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]>

RE: MySQL - Replication (Master/Slave) Question

2007-11-14 Thread bruce
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

Re: MySQL - Replication (Master/Slave) Question

2007-11-14 Thread Dan Rogart
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. > >

RE: MySQL - Replication (Master/Slave) Question

2007-11-14 Thread Mike Johnson
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

Re: MySQL - Replication (Master/Slave) Question

2007-11-14 Thread Michael Dykman
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

Re: MySQL - Replication (Master/Slave) Question

2007-11-14 Thread Baron Schwartz
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

RE: MySQL Replication Binary Logs - How Long to Keep?

2006-08-14 Thread mark addison
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,

RE: MySQL Replication Binary Logs - How Long to Keep?

2006-08-12 Thread Warren Crigger
> 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';

RE: MySQL Replication Binary Logs - How Long to Keep?

2006-08-10 Thread mark addison
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

RE: MySQL Replication Binary Logs - How Long to Keep?

2006-08-09 Thread Logan, David (SST - Adelaide)
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

Re: MySQL Replication

2006-01-09 Thread Sid Lane
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

RE: MySQL Replication

2006-01-09 Thread Logan, David (SST - Adelaide)
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 --

Re: MySQL Replication

2006-01-09 Thread sheeri kritzer
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

Re: MySQL Replication

2006-01-09 Thread Atle Veka
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

Re: MySQL Replication

2006-01-06 Thread Chander Ganesan
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

Re: MySQL Replication

2005-04-04 Thread Gleb Paharenko
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

Re: mysql replication with one database

2005-03-11 Thread Gleb Paharenko
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

Re: MySQL replication

2004-11-08 Thread Dave Goodrich
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

Re: MySQL replication

2004-11-08 Thread Gleb Paharenko
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

Re: [mysql] replication of database structure changes

2004-05-04 Thread Dan Nelson
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

Re: MySQL Replication scheme - DMZ - LAN

2004-02-20 Thread Sasha Pachev
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

RE: MySQL Replication

2003-08-14 Thread Dathan Vance Pattishall
-->-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

RE: MySQL Replication

2003-08-14 Thread Ian Neubert
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

Re: MySQL Replication

2003-08-14 Thread Jeremy Zawodny
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

Re: MySQL Replication

2003-08-14 Thread Jeremy Zawodny
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

RE: MySQL Replication

2003-08-14 Thread Adam Nelson
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

Re: MySQL Replication

2003-08-14 Thread yin
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

RE: MySQL Replication

2003-08-14 Thread Dathan Vance Pattishall
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

Re: MySql Replication through a tunnel.

2003-08-14 Thread colbey
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

RE: MySQL Replication

2003-08-14 Thread Ian Neubert
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

RE: MySQL Replication

2003-08-14 Thread Ian Neubert
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

Re: MySQL Replication

2003-08-14 Thread Jeremy Zawodny
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

RE: MySQL Replication

2003-08-14 Thread Ian Neubert
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

Re: MySQL Replication

2003-08-12 Thread Michael Conlen
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

RE: MySQL Replication

2003-08-07 Thread Dathan Vance Pattishall
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

Re: Mysql replication with 2 masters and 1 slave

2003-06-22 Thread Joseph Bueno
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

RE: Mysql replication with 2 masters and 1 slave

2003-06-22 Thread Erik Olsen
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

Re: Mysql replication with 2 masters and 1 slave

2003-06-22 Thread Andreas
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

Re: mysql replication problem

2003-03-04 Thread Alec . Cawley
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>

Re: mysql replication across platforms

2003-02-27 Thread Jerry
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

Re: mysql replication problem

2003-01-14 Thread walt
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

Re: Mysql Replication

2002-12-03 Thread Gianluca Sordiglioni
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

Re: Mysql replication problem

2002-11-23 Thread Gerald R. Jensen
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

RE: Mysql Replication

2002-11-21 Thread Jon Frisby
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

RE: Mysql Replication

2002-11-21 Thread Simon Green
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

Re: mysql replication

2002-11-11 Thread Jeremy Zawodny
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

RE: mysql replication error

2002-10-23 Thread Natale Babbo
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?

Re: MySQL Replication - v4 slave with v3 master

2002-10-15 Thread Jeremy Zawodny
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   2   >