Hello,
thank You very much for the answer.
a few other question raised in our group:
- Is your answer valid for both reading and writing?
- Is it possible to clear the (Result)Cache manually?
- When there are more than one SequoiaController between the application
and the DBs (nested RAIDbs), do you have to re-enable all controllers,
when there is a new DB-schema?
- What do you exactly mean by "executing a stored procedure without
semantic information"?
Thank You very much for Your help and time?
Greetings,
Sebastian
Emmanuel Cecchet wrote:
Hi Sebastian,
I am currently out of the office, but here is a quick answer.
The approach you describe should work as long as you are just using
Sequoia as a load balancer. However, if the native DB clients are doing
any schema changes, you will have to force a schema refresh in Sequoia.
This can be done by executing a stored procedure without semantic
information. Another option is to disable and then re-enable the backend
where the schema has changed.
Would you say, that you can omit the RAIDb-1s in our architecture?
Would that solve the consistancy problem?
Yes you can definitely omit the RAIDb-1 controllers and connect the
backends to the RAIDb-0 controller 1 layer above.
Note that as you don't replicate any data, you will not have any
consistency problem (unless you use a ResultCache and modify data
directly with the native database console).
Hope this helps,
Emmanuel
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
