Find Jobs
Hire Freelancers

mysql database replication master slave sync checks checksums and resync tables script

$30-5000 USD

Dibatalkan
Dibuat hampir 12 tahun yang lalu

$30-5000 USD

Dibayar ketika dikirim
I need mysql replication scripts that will show any tables from databases that are not identical on master and slave. So , run one script, for each database, lists the database and the tables that have mismatched table checksums etc... 2. other scripts which will quickly let me resync those tables from the master to the slave... The scripts may use if you want the percona/maatkit toolkit. Ideally it should support maatkit-7540 since I have it installed, but I can install the newest versions if need be etc.. They should work on a mysql version 4.1.21 master+slave setup. and also on separate Mysql version 5.5.25a master+slave setup. Currently I had been using a script, but I noticed that sometimes it would say some tables do not match, but when I did a mysqldump of the tables from master and host and did a "diff" there was no difference so I don't know where the problem/error lies in the script but I can't trust it since it seems to say some tables are out of sync when in fact they are identical. I'm attaching the script for reference... ## Deliverables attached example script I use which doesn't seem too good, it says table checksums mismatch on some tables which mysqldumps of prove are identical. (on a moodle database for example mdl_quiz_grades for some reason shows up mismatching with this cript when its actually identical even after I've manually imported again from the master..)
ID Proyek: 2765366

Tentang proyek

1 proposal
Proyek remot
Aktif 12 tahun yang lalu

Ingin menghasilkan uang?

Keuntungan menawar di Freelancer

Tentukan anggaran dan garis waktu Anda
Dapatkan bayaran atas pekerjaan Anda
Uraikan proposal Anda
Gratis mendaftar dan menawar pekerjaan
1 freelancer menawar dengan rata-rata $300 USD untuk pekerjaan ini
Avatar Pengguna
See private message.
$300,05 USD dalam 14 hari
4,3 (49 ulasan)
6,1
6,1

Tentang klien

Bendera UNITED STATES
United States
5,0
59
Memverifikasi Metode pembayaran
Anggota sejak Apr 5, 2005

Verifikasi Klien

Terima kasih! Kami telah mengirim Anda email untuk mengklaim kredit gratis Anda.
Anda sesuatu yang salah saat mengirimkan Anda email. Silakan coba lagi.
Pengguna Terdaftar Total Pekerjaan Terpasang
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuat pratinjau
Izin diberikan untuk Geolokasi.
Sesi login Anda telah kedaluwarsa dan Anda sudah keluar. Silakan login kembali.