Need to compare 2 tables data from different linux servers with mysql using perl script
I am having 2 Mysql servers installed on 2 servers.
They have same table in same database with some different records. I need to compare data of these tables and generate logs. Similar to MYSQL_DIFF generates logs comparing schemas, i need comparing logs of table data. i am not able to find any appropriate solution to this. Apart from writing the complete logic for doing this, is there any solution to do this using MYSQL_DIFF type of libraries. |
|
I need a perl script written for it on RHEL command line platform. Also i need data to be comparedin those 2 tables. The link provided shows ways to compare data and schema using some softwares available as far as i understood. In case I misunderstood, could you please explain a bit.
Thanks for reply anyways |
I don't know in which languages the program are written. At least the programs included with maatkit which now can be found here http://www.percona.com/software/percona-toolkit run from command line. As far as I remeber they are either bash or perl scripts.
Does it really have to be perl? Or does it just need to be something that can be run from cmd? I normaly just take a look at the available tools and then choose the best one on mostly "can it doe the job" and "do i understand the language (so i can tweak it myself)". |
All times are GMT -5. The time now is 03:14 AM. |