List:Replication« Previous MessageNext Message »
From:Krishna Chandra Prajapati Date:April 14 2008 5:56am
Subject:Re: Data transfer
View as plain text  
Development server has multiple databases.

On Fri, Apr 11, 2008 at 3:07 PM, Ananda Kumar <anandkl@stripped> wrote:

> does your development server have only one database or multiple database.
>
> regards
> anandkl
>
>
> On 4/11/08, Krishna Chandra Prajapati <prajapatikc@stripped> wrote:
> >
> > 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 transferKrishna Chandra Prajapati11 Apr
  • RE: Data transferMuthukumar-Fijilive11 Apr
  • RE: Data transferMuthukumar Selvarasu11 Apr