#1 2010-08-09 12:24:56

Nizar
Member
Registered: 2010-08-03
Posts: 22

automation of replications

Hi,
I want to make a replication between two distant MySQL databases automatically: it means that I want to have an automatical execution of the replication job one time every day at a specific time.

Could you help me solve this issue? It is really urgent.

Thank you very much!

Best regards,

Nizar,

Offline

#2 2010-08-09 12:26:10

Nizar
Member
Registered: 2010-08-03
Posts: 22

Re: automation of replications

Hi,
I would like to say that I am using Talend Open Studio.
Thanks,
Nizar

Offline

#3 2010-08-09 12:55:46

shong
Talend team
Registered: 2007-08-29
Posts: 10302
Website

Re: automation of replications

Hi
Please search 'scheduler' on forum, there are many related topics.

Best regards
Shong


Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the leader of open source data management and application integration solutions!

Offline

#4 2010-08-09 13:40:56

Nizar
Member
Registered: 2010-08-03
Posts: 22

Re: automation of replications

Hi
I can not find schedular on forum, where is it?
Best regards,
Nizar

Offline

#5 2010-08-09 14:05:44

lijolawrance
Member
Registered: 2010-01-27
Posts: 364

Re: automation of replications

Hi

You can export the job i.e in jar, put it in a scheduler and run it.


Regards
Lijo Lawrance

Offline

#6 2010-08-09 14:08:00

Nizar
Member
Registered: 2010-08-03
Posts: 22

Re: automation of replications

Hi,
How can I export the job to jar & which schedular can I use with Windows XP?
Regards,

Offline

#7 2010-08-09 14:14:22

lijolawrance
Member
Registered: 2010-01-27
Posts: 364

Re: automation of replications

Hi
Sorry batch file, not jar..

Right click on a job and select Export job scripts. This will give u a zip file. Extract the folder. For Example, if your job name is A1.0. Once extracted it will generate two folders inside A1.0 (A1.0 and lib). In the A1.0 sub folder you can see a batch file. You can schedule that batch file.

Scheduler
You can use windows scheduler, I am using a solway's task scheduler.

Hope this helps you


Regards
Lijo Lawrance

Offline

#8 2010-08-09 19:21:23

Nizar
Member
Registered: 2010-08-03
Posts: 22

Re: automation of replications

Hi,

With windows scheduler, if everything is ok, there is no problem; but if there is an error, what happens? does the execution be interrupted? and where can we see the errors generated?

Thanks for all,
Best regards,
Nizar.

Offline

#9 2010-08-10 07:06:42

lijolawrance
Member
Registered: 2010-01-27
Posts: 364

Re: automation of replications

Hi

It depends on your job designing. If you are writing into a file, where there is any error then that will work.

ie innner join rejected rows of tJoin into a log file

Other wise , one easy solution is A1.bat>> c:\log.txt. this is not an optimal solution.


Regards
Lijo Lawrance

Offline

#10 2010-08-10 11:33:24

Nizar
Member
Registered: 2010-08-03
Posts: 22

Re: automation of replications

Hi,
In fact, my job design is: tMysqlInput >> tMysqlOutput.
I have exported my job (a batch file) and scheduled its execution once a day with Windows Task Scheduler.
So, is it possible to get the errors when the execution fails and how?
Best regards,
Nizar.

Offline

#11 2010-08-10 11:54:44

lijolawrance
Member
Registered: 2010-01-27
Posts: 364

Re: automation of replications

Hi
Use  tMysqlOutput->rejects also, if rejected point to an output txt file writing the error i.e

tMysqlOutput _____rejects_____>tMap->tOutputDelimited

This write the error into a file.


Regards
Lijo Lawrance

Offline

#12 2010-08-10 16:05:16

Nizar
Member
Registered: 2010-08-03
Posts: 22

Re: automation of replications

Hi
I can not find the component tOutputDelimited in TOS. Where is it please?
Best regards,
Nizar.

Offline

#13 2010-08-10 16:10:22

lijolawrance
Member
Registered: 2010-01-27
Posts: 364

Re: automation of replications

Hi

Sorry its tFileOutputdelimited

its in File-> Output palette section


Regards
Lijo Lawrance

Offline

#14 2010-08-17 11:44:38

Nizar
Member
Registered: 2010-08-03
Posts: 22

Re: automation of replications

Hi,
I made as lijo told me: tMysqlInput > tMysqlOutput > tMap > tFileOutputDelimited
but I find nothing written in the file out.csv when an error happens!
Could you help me solve this issue? Which kind of errors are written in the file...?
Thank you!
Best regards,
Nizar

Offline

#15 2010-08-18 08:20:33

lijolawrance
Member
Registered: 2010-01-27
Posts: 364

Re: automation of replications

Hi

The normal errors will be mostly database specific errors. It will not catch the exceptions.

i hope you are giving tMysqlOutput __Rejects__->tMap


Regards
Lijo Lawrance

Offline

Board footer

Powered by FluxBB