Hi,
What ever queries are executed on 5 mysql server with multiple database
(more than one database on each mysql server). I have to reflect all the
changes on 1 mysql server (developement server for developers)
Initially, I thought to take take the queries from bin-log and execute on
development server. But, from the bin-log list. I am not able to identify
that which queries belong to which database.
Content of bin-log (multiple database)
# at 266708750
#080410 4:04:27 server id 1 end_log_pos 148 Query
thread_id=460143 exec_time=0 error_code=0
SET TIMESTAMP=1207825467;
UPDATE user_time_stamp_1 SET TIME_TOTAL='-999' WHERE USER_ID='8394042' AND
TASK='2.30';
# at 266708898
#080410 4:04:27 server id 1 end_log_pos 266708925 Xid = 22953623
COMMIT;
# at 266708925
#080410 4:04:27 server id 1 end_log_pos 162 Query
thread_id=460143 exec_time=0 error_code=0
SET TIMESTAMP=1207825467;
UPDATE user_cookie SET VALUE = '2.30_1207830154' WHERE USER_ID = '8394042'
AND PARAM = 'CURRENTTASK';
# at 266709087
#080410 4:04:27 server id 1 end_log_pos 266709114 Xid = 22953624
COMMIT;
What are the possible ways to perform this task.
--Thanks,
Krishna Chandra Prajapati
| Thread |
|---|
| • Data transfer | Krishna Chandra Prajapati | 11 Apr |