I'm currently working on a SymmetricDS architecture with High Availability
considered. I have a question on sym tables.
As far as my understanding, sym tables are hosted on the server-side
database. With SymmetricDS configured as a cluster using load-balancing,
the nodes in cluster are still connecting to the sym tables hosted on
server-side database.
In this case, the single point of failure in the HA architecture would be
if the server-side database hosting the sym tables?
Ken, you're understanding is correct. Each SymmetricDS node connects to one database. When you cluster, you are standing up multiple SymmetricDS servers which act as one node and connect to the same database instance. Users who need more HA usually cluster at the database level using things like Oracle RAC.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi Everyone,
I'm currently working on a SymmetricDS architecture with High Availability
considered. I have a question on sym tables.
As far as my understanding, sym tables are hosted on the server-side
database. With SymmetricDS configured as a cluster using load-balancing,
the nodes in cluster are still connecting to the sym tables hosted on
server-side database.
In this case, the single point of failure in the HA architecture would be
if the server-side database hosting the sym tables?
Can the sym tables replicated in a cluster?
Thank you for your support in advance.
--
Regards,
Ken Seong
Ken, you're understanding is correct. Each SymmetricDS node connects to one database. When you cluster, you are standing up multiple SymmetricDS servers which act as one node and connect to the same database instance. Users who need more HA usually cluster at the database level using things like Oracle RAC.