List:Replication« Previous MessageNext Message »
From:Julian Rawcliffe Date:August 18 2010 8:27am
Subject:SUMMARY - InnoDB table replication
View as plain text  
I was experiencing difficulties getting replication working between
two identical Ubuntu 8.04 VMs for databases using InnoDB tables.

The error I was getting was:

'Access denied; you need the SUPER privilege for this operation'

despite the replication user being granted all privileges to all
databases on the master and slave.

I was unable to identify any cause for the problem, but after
removing the MySQL server package, reinstalling and configuring
replication from scratch, replication still failed because of
INSERTS after the recorded MASTER_LOG_POS before the dump was
taken were also appearing in the mysqldump.
This was caused by using --single-transaction with the dump.

The problem was resolved by using only --master-data=1 for the
mysqldump.

The databases are now correctly replicated to the slave.

Regards,
Julian




______________________________________________________________________

This email has been scanned by the MessageLabs Email Security System
on behalf of the London Business School community.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________
Thread
InnoDB table replicationJulian Rawcliffe11 Aug
Re: InnoDB table replicationJulian Rawcliffe11 Aug
  • Re: InnoDB table replicationmartín arrieta11 Aug
    • Re: InnoDB table replicationJulian Rawcliffe11 Aug
      • Re: InnoDB table replicationPrabhat Kumar11 Aug
        • Re: InnoDB table replicationDatabase System11 Aug
      • Re: InnoDB table replicationRick James11 Aug
        • Re: InnoDB table replicationJulian Rawcliffe11 Aug
          • Re: InnoDB table replicationRick James12 Aug
          • Re: InnoDB table replicationDatabase System12 Aug
            • Re: InnoDB table replicationJulian Rawcliffe12 Aug
              • Re: InnoDB table replicationMarcus Bointon12 Aug
Re: InnoDB table replicationJulian Rawcliffe13 Aug
Re: InnoDB table replicationJulian Rawcliffe13 Aug
  • Re: InnoDB table replicationRick James17 Aug
    • SUMMARY - InnoDB table replicationJulian Rawcliffe18 Aug