I fixed the discrepancy by just running pt-sync with --sync-to-master
option and no checksum. thanks for all your advise!
On Wed, Apr 4, 2012 at 4:07 PM, nhadie ramos <nhadie@stripped> wrote:
> Hi Marcus,
> i have tried xtrabackup before but not for a single table. tried it
> for my whole DB, the prob i have is that it locks the tables which i
> cant afford doing on the live server
> coz if i can lock the database i would simply grab the whole mysql
> directory and transfer it to the slave the restore replication. i will
> look into the single table option. thanks!
> On Wed, Apr 4, 2012 at 3:20 PM, Marcus Bointon
> <marcus@stripped> wrote:
>> On 4 Apr 2012, at 07:43, nhadie ramos wrote:
>>> thanks for the reply, i will try these one if i am getting these
>>> correctly. i will stop slave, then run mysqldump with master-data
>>> option so i can get the file and log position.
>> Not sure if you've tried it, but xtrabackup is way better than using mysqldump
> for setting up a slave. It does imply that you do a complete data restore, but it is
> transaction-safe, much faster and more reliable, and it keeps track of binlog position
>> It also has an ability to deal with individual databases and single tables but
> I've not looked into that.
>> Marcus Bointon
>> Synchromedia Limited: Creators of http://www.smartmessages.net/
>> UK info@hand CRM solutions
>> marcus@stripped | http://www.synchromedia.co.uk/
>> MySQL Replication Mailing List
>> For list archives: http://lists.mysql.com/replication
>> To unsubscribe: http://lists.mysql.com/replication