hera icon indicating copy to clipboard operation
hera copied to clipboard

Mention multiple datasource in TWO_TASKS

Open ishanroy opened this issue 5 years ago • 1 comments

Hi, I wanted to know is there support for multiple datasource in hera and if so, how can we mention it using the TWO_TASKS parameter as presently it is accepting only one connection detail as mentioned in the page.. There is option to mention different shards but if we want connectivity to different databases, how to do the same.

ishanroy avatar Feb 20 '20 11:02 ishanroy

For the read-replica query failover, the failover database would be TWO_TASK_STANDBY0.

For MySQL failover, two pipes to separate entries, tcp(127.0.0.1:3306)/myschema?timeout=9s||tcp(127.0.0.2:3306)/myschema

I'm not sure if those cover how you'd like to use different databases.

ModEtchFill avatar Mar 12 '20 23:03 ModEtchFill