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 sabika.makhd...@gmail.comwrote:
I already have mysql in the replicate wild ingore table. I am running
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
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)
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 redwa...@logicworks.net
wrote:
I think this is normal because stored procedures live in mysql.proc.
You would have to filter out