Bug #2610 create procedure not replicated
Submitted: 2 Feb 2004 7:39 Modified: 8 Jul 2005 17:18
Reporter: Bill Au Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Replication Severity:S3 (Non-critical)
Version:5.0 OS:Linux (RedHat 7.3)
Assigned to: Guilhem Bichot CPU Architecture:Any

[2 Feb 2004 7:39] Bill Au
Description:
create procedure is not replicated.

How to repeat:
Run the following two SQL statements on the replication master:

create table testtable
(
        id      INT
);
                                                                                                                                                  
create procedure testproc ()
insert into testtable (id) values (123456);

Table is created on master and all slaves but procedure is created
only on the master and not on the slaves.
[5 Feb 2004 12:18] Dean Ellis
Verified against the current 5.0 development tree.

CREATE/DROP PROCEDURE statements are not written to the binlog (so cannot be replicated).
[19 Apr 2005 9:26] Guilhem Bichot
Too hard and imperfect with statement-level binary logging of 5.0. Will be fixed in 5.1 with record-level binary logging.
[20 Apr 2005 21:35] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/24177
[20 Apr 2005 21:36] Guilhem Bichot
Finally, fixed it in 5.0.5. But there will be caveats with that until 5.1, I'll document them.
[10 May 2005 13:59] Guilhem Bichot
Will talk with Paul about documentation of this bugfix.
[10 Jun 2005 17:18] Paul Dubois
Noted in 5.0.5 changelog. Bug report remains
in Documenting state pending additional
documentation.
[14 Jun 2005 19:41] Paul Dubois
Changelog entry has been moved to 5.0.6.
[8 Jul 2005 17:18] Paul Dubois
Stored routine logging now is documented at:

http://dev.mysql.com/doc/mysql/en/stored-procedure-logging.html