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
--
Emmanuel Cecchet
Chief Scientific Officer, Continuent
Blog: http://emanux.blogspot.com/
Open source: http://www.continuent.org
Corporate: http://www.continuent.com
Skype: emmanuel_cecchet
Cell: +33 687 342 685
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
