Database High Availability Solutions: How to switch between different connections if one fails

InfoCraft — Fri, 15 Nov 2024 22:45:27 GMT

1. What is a High Availability Database System? A High Availability (HA) Database is a database system designed to operate continuously with no interruptions in service. So, database errors and failures must be handled by automatically failing over to redundant nodes when problems occur.

2. So we are going to implement a simple failover solution in case of connection failure1

NB. (Customer) asked if there is option in talend to pass two hosts in the connection component if either one fails. ==> There are several ways to solve it.

We can take inspiration from this solution for different use cases.

Please find all the details in the attached pdf file📎

Happy learning,

Kind regards,

😷19.

Re: Database High Availability Solutions: How to switch between different connections if one fails

Anonymous — Mon, 11 Jul 2022 02:30:48 GMT

Hello @not specified not specified

It is a very good topic and I will check it with my manager to see if it could be a new tip.

Really Thanks for sharing it with us on Community.

Best regards

Sabrina

topic Re: Database High Availability Solutions: How to switch between different connections if one fails in Talend Studio

Database High Availability Solutions: How to switch between different connections if one fails

Re: Database High Availability Solutions: How to switch between different connections if one fails