Chris,
sooooo for this setup i need 7 virtual databases ? or can i use the
whole mysql server as one database?
You need 7 virtual databases. There is no notion of virtual RDBMS in
Sequoia. If you use a database that supports schemas, you could
consolidate your data in a single database instance and split your
current databases in different schemas.
do i need a separate recoverlog database for each virtual database?
Yes.
Or can i use one recoverylog database for all virtual databases?
No.
2nd question: with this setup i can't use left joins over multiple
databases?
SELECT *
FROM `work`.`whatever`
LEFT JOIN `statistic`.`anything` ...
? is this possible?
No, as specified in the doc, Sequoia does not support cross-database
queries. However, in practice SELECTs should work and issue a warning.
There will be no consistency guarantees for reads across multiple databases.
3rd question: in the manual they wrote about a "fault tolerant
Recovery Log".
that's like creating a virtual database for the recoverylog database?
If you have 2 controllers, this is not necessary since each controller
will replicate the recovery log.
buuuut what do i write for the <RecoveryLog> entry inside the
virtualdatabase xml for the recoverylog database?
`configuration` database for example:
<RecoveryLog
driver="org.continuent.sequoia.driver.Driver"
url="jdbc:sequoia://localhost:25325/configuration-recovery" .../>
now i need a configuration-recovery.xml.
but do i write in the <RecoveryLog> entry???
a recoverylog for the recoverlog ? :)
You have to define a virtual database without recovery log. Look at the
examples/RecoveryLog directory for configuration file samples.
Thanks for your interest in Sequoia,
Emmanuel
--
Emmanuel Cecchet - Research scientist
EPFL - LABOS/DSLAB - IN.N 317
Phone: +41-21-693-7558
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
