I'm looking to use Hibernate Shards for a project I'm working on. Is it possible to use database replication for failover with shards? For example, I have 2 shards, 0 and 1, and they are both being replicated to another server, so 4 servers total. If my primary server, shard 0, goes down, how can I setup shards to failover to the replicated shard 0?

Hi,
usually replication should work at JDBC level, so AFAIK it has not much to do with Shards but about how you configure your JDBC drivers; Shards should work on top of this and doesn't need to be aware of your DBMS configuration.

I don't know if Shards could be used to build a failover system at higher level.

regards,

Shards in itself does not to failover, but as Sanne said, this should be handled at the JDBC level (maybe your connection pool)