Hi Bin,
The problem is we have two controllers, and the configuration is:
controller [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> has its own
postgresql backend and the url is
"jdbc:postgresql://192.168.5.1:5432/test <http://192.168.5.1:5432/test>"
controller [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> has its own
postgresql backend and the url is
"jdbc:postgresql://192.168.5.1:5432/test <http://192.168.5.1:5432/test>"
This is not correct, you are not allowed to share the same database
between 2 controllers. If controller 2 has its own backend it should
point to jdbc:postgresql://192.168.5.2:5432/test and not
jdbc:postgresql://192.168.5.1:5432/test (which is the database hosted on
the first controller).
The controller should not allow you to load such configuration and
report an error that you are trying to share a backend between multiple
controllers.
As you've pointed out that if I shutdown the backend posgresql
@192.168.5.1 <http://192.168.5.1>, the requests are still being
forwarded to controller [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>,
unless I shutdown controleer [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>,
am I right? If that's the case, I believe that's problem, initially
I thought all the requrests will be forwarded to controller two
automatically once I disable controller one's backend.
The connection between the application and the controllers are made
depending on the JDBC url you configure in the Sequoia driver used by
the application. A controller even with all its backends disabled is
still a valid controller to receive requests. If you don't want that
controller to receive requests for a particular database you have to
shutdown that virtual database. If your application uses a connection
pool, you can reconfigure the pool or aggressively renew connections to
force the driver to reconnect to another controller.
i.e., I have to dupliate the test [EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]> and rename it in odered to be connected
to controller one as well?
I am not sure what you mean but if you want 1 database per controller,
yes you will need a database on 192.168.5.2 for sure.
Keep us posted with your progress,
Emmanuel
--
Emmanuel Cecchet
FTO @ Frog Thinker
Open Source Development & Consulting
--
Web: http://www.frogthinker.org
email: [EMAIL PROTECTED]
Skype: emmanuel_cecchet
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
