1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Stored Procedure In Master-slave Replication

Discussion in 'MySQL' started by amrush, Feb 6, 2013.

0
  1. #1
    Dear All,

    I have configured Mysql master-slave replication and it is working fine. But I am facing a little issue regarding replication.

    I have used SP in one of my database to pull data and push it into the master database table. at this point replication is not working. no data is replicating when data is inserted through SP. otherwise replication is working fine.

    Need help/suggestion

    regards,

    --amrush
     
    amrush, Feb 6, 2013 IP
  2. amrush

    amrush Active Member

    Messages:
    30
    Likes Received:
    2
    Best Answers:
    2
    Trophy Points:
    58
    #2
    After searching for few days I didn't find any solution for that. Now i am using script instead of SP/trigger. Now my data is replicating smoothly...I think the limitation is mysql version..!!

    regards,

    --amrush
     
    amrush, Feb 19, 2013 IP