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 <[email protected]>
> 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
> > [email protected]
> > http://www.linkedin.com/in/rolandoedwards
> >
> >
> > -----Original Message-----
> > From: Sabika Gmail [mailto:[email protected]]
> > Sent: Monday, June 07, 2010 11:14 AM
> > To: [email protected]
> > 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/[email protected]
> >
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/[email protected]
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[email protected]
