Re: Replication of MySQL Stored Procedure
I think even if you ignore the mysql database from replication and set Is_Deterministic = YES then your stored procedures will be replicated. Please set it to NO if you do not wish the stored procedures will not be replicated. You can set this in mysql.proc table. -- Regards, Manasi Save On Mon, 7 Jun 2010 12:31:13 -0700, Sabika Gmail wrote: I already have mysql in the replicate wild ingore table. I am running > mysql 5.1.40sp1 > > Could it be a bug? > > On Jun 7, 2010, at 8:30 AM, Rolando Edwards > wrote: > > > I think this is normal because stored procedures live in mysql.proc. > > > > You would have to filter out mysql.proc by adding this to /etc/my.cnf > > > > replicate-ignore-table=mysql.proc > > > > Rolando A. Edwards > > MySQL DBA (CMDBA) > > > > 155 Avenue of the Americas, Fifth Floor > > New York, NY 10013 > > 212-625-5307 (Work) > > 201-660-3221 (Cell) > > AIM & Skype : RolandoLogicWorx > > redwa...@logicworks.net > > http://www.linkedin.com/in/rolandoedwards > > > > > > -Original Message- > > From: Sabika Gmail [mailto:sabika.makhd...@gmail.com] > > Sent: Monday, June 07, 2010 11:14 AM > > To: mysql@lists.mysql.com > > Subject: Replication of MySQL Stored Procedure > > > > Hi! > > > > I have a database in the wild ignore table as table.%. Recently I > > created a store procedure on it and it replicated. Does any one know > > if this is normal bahvior? If I wanted to make sure store procedures > > do not replicate, what should I do? > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/mysql?unsub=redwa...@logicworks.net > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=manasi.s...@artificialmachines.com > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Replication of MySQL Stored Procedure
SP generally goes as per the database you have created. Set you binlog off while creating for the sql. sql_log_bin is the variable to do it. On Tue, Jun 8, 2010 at 1:01 AM, Sabika Gmail wrote: > I already have mysql in the replicate wild ingore table. I am running mysql > 5.1.40sp1 > > Could it be a bug? > > > On Jun 7, 2010, at 8:30 AM, Rolando Edwards > wrote: > > I think this is normal because stored procedures live in mysql.proc. >> >> You would have to filter out mysql.proc by adding this to /etc/my.cnf >> >> replicate-ignore-table=mysql.proc >> >> Rolando A. Edwards >> MySQL DBA (CMDBA) >> >> 155 Avenue of the Americas, Fifth Floor >> New York, NY 10013 >> 212-625-5307 (Work) >> 201-660-3221 (Cell) >> AIM & Skype : RolandoLogicWorx >> redwa...@logicworks.net >> http://www.linkedin.com/in/rolandoedwards >> >> >> -Original Message- >> From: Sabika Gmail [mailto:sabika.makhd...@gmail.com] >> Sent: Monday, June 07, 2010 11:14 AM >> To: mysql@lists.mysql.com >> Subject: Replication of MySQL Stored Procedure >> >> Hi! >> >> I have a database in the wild ignore table as table.%. Recently I >> created a store procedure on it and it replicated. Does any one know >> if this is normal bahvior? If I wanted to make sure store procedures >> do not replicate, what should I do? >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: >> http://lists.mysql.com/mysql?unsub=redwa...@logicworks.net >> >> > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com > > -- Thanks Suresh Kuna MySQL DBA
Re: Replication of MySQL Stored Procedure
I already have mysql in the replicate wild ingore table. I am running mysql 5.1.40sp1 Could it be a bug? On Jun 7, 2010, at 8:30 AM, Rolando Edwards wrote: I think this is normal because stored procedures live in mysql.proc. You would have to filter out mysql.proc by adding this to /etc/my.cnf replicate-ignore-table=mysql.proc Rolando A. Edwards MySQL DBA (CMDBA) 155 Avenue of the Americas, Fifth Floor New York, NY 10013 212-625-5307 (Work) 201-660-3221 (Cell) AIM & Skype : RolandoLogicWorx redwa...@logicworks.net http://www.linkedin.com/in/rolandoedwards -Original Message- From: Sabika Gmail [mailto:sabika.makhd...@gmail.com] Sent: Monday, June 07, 2010 11:14 AM To: mysql@lists.mysql.com Subject: Replication of MySQL Stored Procedure Hi! I have a database in the wild ignore table as table.%. Recently I created a store procedure on it and it replicated. Does any one know if this is normal bahvior? If I wanted to make sure store procedures do not replicate, what should I do? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=redwa...@logicworks.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Replication of MySQL Stored Procedure
I think this is normal because stored procedures live in mysql.proc. You would have to filter out mysql.proc by adding this to /etc/my.cnf replicate-ignore-table=mysql.proc Rolando A. Edwards MySQL DBA (CMDBA) 155 Avenue of the Americas, Fifth Floor New York, NY 10013 212-625-5307 (Work) 201-660-3221 (Cell) AIM & Skype : RolandoLogicWorx redwa...@logicworks.net http://www.linkedin.com/in/rolandoedwards -Original Message- From: Sabika Gmail [mailto:sabika.makhd...@gmail.com] Sent: Monday, June 07, 2010 11:14 AM To: mysql@lists.mysql.com Subject: Replication of MySQL Stored Procedure Hi! I have a database in the wild ignore table as table.%. Recently I created a store procedure on it and it replicated. Does any one know if this is normal bahvior? If I wanted to make sure store procedures do not replicate, what should I do? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=redwa...@logicworks.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
