Is there any way I can provide multiple JDBC connections within the Sqoop command?
For example if JDBC1 is down then Sqoop should pick up JDBC2 and run the import/export.
sqoop export --connect "jdbc string 1 / jdbc string 2"
It should then pick the correct JDBC URL based on which on is up and running
Is this possible?
Thanks for any help you can provide,
@Daniel Perry There is no code example. It is just a load balancer. Lets say you are using on AWS. You would create a Elastic Load Balancer. The ELB would generate a URL. Then behind the load balancer you would provide the 2 jdbc url. thats it. Now if you want to access your DB via sqoop you would use the ELB URL.
You can also use Apache Camel as a load balancer. More info on setup here.