RE: Re: Replication, Stored Proceedures and Databases
> -Original Message- > From: Claudio Nanni [mailto:claudio.na...@gmail.com] > Sent: Saturday, July 11, 2009 2:44 AM > To: Simon J Mudd > Cc: mysql@lists.mysql.com > Subject: R: Re: Replication, Stored Proceedures and Databases > > You dont have changes coming from db G since it is ignored from > replication. > Why dont You move all stored procs in a separate db and replicate it as > well? You will use it as a 'library' for all of your dbs. Of course > prepose > your schema name, always. You dont have to change replication type in > This > case. Cheers, Claudio > Database G is just that, a library for the stored procedures. Anyway, as mentioned in the other email, replicating all of the tables solved the problem. As for the schema name, I always include it on all queries. I found that it was much easier to always to it instead of only doing it when I need to and forgetting. I work with Oracle and I'm always doing stuff in another schema so I do it out of habit. Thanks guys for the follow up. I think someone should add a clear statement to the doc's regarding the cross schema replication for stored procedures and tables, when the active database is not the replicated database, even though the affected table is in a replicated database. The docs are currently vague on this. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: RE: Replication Performance
Dear ALL: Some time the slave would crushed by I/O error.It happen at the server with the lower CPU.( per 45 days ) All of the slave database has block the binary log,it reduce the CPU loading. The database would replicate text,int,varchar but no blob. Network connection hasn't drop frequently,it seems hard to avoid that. Do any way make the slave query more time but not just idle and wait for the data? Since we can't bear the slave need 10 minutes to synchronize the data with master. Here the master status Uptime: 2592393 Threads: 24 Questions: 214644229 Slow queries: 197 Opens: 580 Flush tables: 1 Open tables: 254 Queries per second avg: 82.798 At 2004-07-01, 22:06:24 you wrote: What does the network setup look like? What type of data is being replicated varchar, text, blob? Is the network connection being dropped or are there any errors being logged anywhere? -Original Message- From: MaFai To: [EMAIL PROTECTED] Sent: 6/30/04 10:34 PM Subject: Replication Performance Dear, [EMAIL PROTECTED], We have set up 1 master and 4 slave as replication. Sometime,the slave need 4~10 minutes to synchronize the data with master database. Do any way to tune the performance? Or any other way to reduce the time to replicate? Best regards. MaFai [EMAIL PROTECTED] 2004-07-01 = = = = = = = = = = = = = = = = = = = = = = Best regards. MaFai [EMAIL PROTECTED] 2004-07-02
re: Re: Replication problem (alter table fails)
On Wednesday 26 February 2003 10:19, Kirill Peskov (WEB-EU) wrote: > Looks like we've mixed up two threads into one ;-) > > As I understood from various forums and maillists, versions 4.x are > still in development state. Yup, 4.0.X is gamma. > The newest production version is 3.23.55, > am I right? Do you recommend this version for testing? Yes, test it on 3.23.55 and tell me about results. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: RE: Replication problem (alter table fails)
On Tuesday 25 February 2003 16:36, Floyd Wellershaus wrote: > Egor, > I am sorry, my bad. I misrepresented the versions of mysql I am using. Must > have been a typo. > Here is what I am using. > > Master: Sparc Solaris 7 MySQL 4.0.9-gamma-log > Slave: RedHat Linux 7.2 MySQL 4.0.8-gamma-log. > > Could you continue to help me with this ? I tested on 4.0.10 .. What replication options do you have in my.cnf? Do you use any replicate-* options? Could you provide a test case? > > -Original Message- > From: Egor Egorov [mailto:[EMAIL PROTECTED] > Sent: Tuesday, February 25, 2003 8:28 AM > To: [EMAIL PROTECTED] > Subject: re: Replication problem (alter table fails) > > On Tuesday 25 February 2003 14:17, Kirill Peskov (WEB-EU) wrote: > > Coud you, please, give an advice to solve following problem: > > > > I've got two Mysql Servers: > > > > * Master: Sparc Solaris 8, MySQL 3.23.32 > > * Slave: RedHat Linux 7.2, MySQL 3.23.32 > > > > Replication of data runs fine, all "insert into" and "delete from" made > > on master successfully change the slave database. Creation and dropping > > of the whole tables also work fine. But if I add or delete certain > > column in any table on master DB (e.g. run ALTER TABLE commands), slave > > ignores is and later on stops replication because it cannot replicate > > the data appeared or changed on the master afterwards (because these > > fields not exist on the slave). > > > > Is there any way to tell either Master or Slave to replicate ALTER TABLE > > queries as well? > > Since 3.23.32 there were a lot of bug fixed related to the replication. > Please, upgrade servers and test it again. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: re: Replication of only a couple of databases
On Wednesday 18 December 2002 17:18, you wrote: > At 16:57 18-12-02 +0200, you wrote: > >On Wednesday 18 December 2002 11:36, Wico de Leeuw wrote: > > > I've setup replication with a master-slave. > > > But i only want to replicate some databases so i'd put in my.cnf on the > > > slave (it's being used, checked that) > > > replicate-wild-do-table=adb.% (it has to catch cross updates to) > > > I also tried to replicate-do-database=adb (in different combinations) > > > > > > What i have found: (replicate-wild-do-table=adb.%) > > > create/drop/insert/delete with current db adb works, replace isn't > > > working > > > >Replace works fine for me with 4.0.6 master and 4.0.5 slave. > >Could you provide a repeatable test case? > > use adb; > update atable set name = 'test'; > > the query showsup in the logs but values aren't changed It is already fixed in 4.0.6 -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: Re: Replication
Alexander, Friday, November 01, 2002, 9:48:50 PM, you wrote: AB> I did the configuration below but the server doesn´t make the replication. AB> I tryed some commands. AB> start/stop slave AB> status master AB> but they didn´t. AB> What else do I have to do? Is there anything in the error log? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: Re: Re: Re: Replication
CP, Tuesday, October 01, 2002, 11:29:30 AM, you wrote: C> I stopped both mysql in master and slave. Then I put in the server id for C> both master and slave, start the master then the slave. Is it okay? Yes. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: Re: Replication
hi Victoria, I stopped both mysql in master and slave. Then I put in the server id for both master and slave, start the master then the slave. Is it okay? Thanks, Chee Peng - Original Message - From: "Victoria Reznichenko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, September 30, 2002 10:37 PM Subject: re: Re: Re: Replication > CP, > Monday, September 30, 2002, 3:48:31 AM, you wrote: > > C> The Master's server id is 1 while the slave's server id was set to 5. There > C> is no problem for the slave to establish connection to the master. However, > C> the slave complains that error reading packet from server, the reason is > C> misconfigured-master, server id was not set and this messages keep on > C> repeating. > > Did you set up server-id for master from the very outset or you set up > the one after master has been started? > > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.net http://www.ensita.net/ >__ ___ ___ __ > / |/ /_ __/ __/ __ \/ /Victoria Reznichenko > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ><___/ www.mysql.com > > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: Re: Re: Replication
CP, Monday, September 30, 2002, 3:48:31 AM, you wrote: C> The Master's server id is 1 while the slave's server id was set to 5. There C> is no problem for the slave to establish connection to the master. However, C> the slave complains that error reading packet from server, the reason is C> misconfigured-master, server id was not set and this messages keep on C> repeating. Did you set up server-id for master from the very outset or you set up the one after master has been started? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: Replication
hi Victoria, The Master's server id is 1 while the slave's server id was set to 5. There is no problem for the slave to establish connection to the master. However, the slave complains that error reading packet from server, the reason is misconfigured-master, server id was not set and this messages keep on repeating. Any idea? Thanks, Chee Peng - Original Message - From: "Victoria Reznichenko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, September 27, 2002 9:16 PM Subject: Re: Re: Replication > Hello CP, > Friday, September 27, 2002, 3:11:14 AM, you wrote: > > C> hi Victoria, thanks for the reply. I have set server id in the very > C> beginning, but its still not working. I don't understand why the MySQL would > C> not let me change its server id accordingly. The server id was set to 1. > > You must set up unique server-id for the master and for the slave. You > said that server-id=1, but it's only one server id, what about > another? > > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.net http://www.ensita.net/ >__ ___ ___ __ > / |/ /_ __/ __/ __ \/ /Victoria Reznichenko > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ><___/ www.mysql.com > > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: Replication
Hello CP, Friday, September 27, 2002, 3:11:14 AM, you wrote: C> hi Victoria, thanks for the reply. I have set server id in the very C> beginning, but its still not working. I don't understand why the MySQL would C> not let me change its server id accordingly. The server id was set to 1. You must set up unique server-id for the master and for the slave. You said that server-id=1, but it's only one server id, what about another? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Re: Replication Circle
Hello, I also plan to use two servers such that each is a master for the other. A -> B B -> A Unless you tell me otherwise, the log-server-updates option will not be used. Seems to work in a small test I've conducted. In fact this setup will be used for reasons of high availability. (rather than performance). Whenever at least one of the servers is up it should be used (and the other is not used even if it is also up). Can you think of some pitfalls I need to watch out from? Regards, Oren. Oren Zeev-Ben-Mordehai Infrastructure Engineer PhoneDo Networks office: +972-9-951-7771 ext. 204 fax:+972-9-951-7772 email: [EMAIL PROTECTED] sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[mysql@lists.mysql.com: Re: Re: Replication: Push by Master or Pop by Slaves ?]
On Thu, Aug 30, 2001 at 12:44:46PM +0200, Claudio Cicali wrote: [snip] > Here, seems that are the slaves that pop data from master. > So where is the truth ? Is the master that pushes or the slaves the pops ? > Or it is a combination of the two ? In normal operation, the master pushes to the slave. When a slave is turned off temporarily and is turned back on, it pops all changes that happened while it was down. After that, the master starts pushing again. Magic 5 letter word: MySQL. Tsk. Greetz, Peter -- Monopolyhttp://www.dataloss.nl/monopoly.html - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: replication doesn't maintain logs?
No, this isn't spam. I was publicly thanking someone for advice given. :/ On Thu, Jun 21, 2001 at 08:25:37PM -, [EMAIL PROTECTED] wrote: > Your message cannot be posted because it appears to be either spam or > simply off topic to our filter. To bypass the filter you must include > one of the following words in your message: > > database,sql,query,table > > If you just reply to this message, and include the entire text of it in the > reply, your reply will go through. However, you should > first review the text of the message to make sure it has something to do > with MySQL. You have written the following: > > > On Thu, Jun 21, 2001 at 08:53:31AM -0700, Ben Curtis wrote: > > > > You need to have log-slave-updates in my.cnf > > Ah! Thanks for the pointer; let me try that out... > > > -- > > My pid is Inigo Montoya. You killed -9 my parent process. Prepare to vi. > > Cute .sig. :) > > -- > Brian 'you Bastard' Reichert <[EMAIL PROTECTED]> > 37 Crystal Ave. #303 Daytime number: (603) 434-6842 > Derry NH 03038-1713 USA Intel architecture: the left-hand path > -- Brian 'you Bastard' Reichert<[EMAIL PROTECTED]> 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: Replication question.
On Sun, Feb 25, 2001 at 03:29:37PM +0900, ÇãÁ¤¼ö wrote: > > >It sounds like you are using a version of MySQL that had a > >replication bug in it. I suspect that if you upgrade to 3.23.33 the > >problem will go away. > > > > No, Master is 3.23.33, and slave is 3.23.32 3.23.32 was troublesome for slaves. Here http://www.mysql.com/doc/N/e/News-3.23.33.html you'll find an entry which says: Fixed bug in replication that broke slave server start with existing master.info. This fixes a bug introduced in 3.23.32. I'd suggest and upgrade to see if it solves your problem... Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: Replication Bug in 3.23.33
On Thursday 15 February 2001 18:50, Rodolfo Sikora wrote: >Does this problem exist in 3.23.32?? > > > >> >>Thanks for the bug report. The problem is a bug in the code that skips events >>when it sees a log entry with the same server id - something that can only >>happen in the bi-directional replicaiton setup. Fix: >> >>--- 1.85/sql/slave.cc Sat Jan 27 15:33:30 2001 >>+++ edited/slave.ccWed Feb 14 12:35:34 2001 >>@@ -849,7 +849,8 @@ >> >> mi->inc_pos(event_len); >> flush_master_info(mi); >>- --slave_skip_counter; >>+ if(slave_skip_counter) >>+ --slave_skip_counter; >> delete ev; >> return 0;// avoid infinite >>update loops >> } > This one does not, but there is a bigger one - restarting the slave does not work. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA <___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: Replication Bug in 3.23.33
Does this problem exist in 3.23.32?? > >Thanks for the bug report. The problem is a bug in the code that skips events >when it sees a log entry with the same server id - something that can only >happen in the bi-directional replicaiton setup. Fix: > >--- 1.85/sql/slave.cc Sat Jan 27 15:33:30 2001 >+++ edited/slave.cc Wed Feb 14 12:35:34 2001 >@@ -849,7 +849,8 @@ > > mi->inc_pos(event_len); > flush_master_info(mi); >- --slave_skip_counter; >+ if(slave_skip_counter) >+--slave_skip_counter; > delete ev; > return 0;// avoid infinite >update loops > } > --- Tenha uma conta de email Grátis no ACBusca! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
