Geek asks and answers

DB Failover Support

We are currently evaluating fault tolerance support across multiple databases.
We used to use HSQLDB, but it does not seem to have clustering / replication support.

Our requirement is simply to have two database servers, one of which is intended only for synchronous backup, but if the primary server does not work, then the secondary should automatically start as the primary server.

Has anyone rated MySQL, PostgreSQL, or any other database server for such use?

Edit: we thought about using a MySQL cluster, but now it seems that it is under the GPL license, which we will not be able to work with. Can anyone suggest using a synchronous replication / clustering solution that can be used? We are currently using HSQL, so the HSQL solution used in cluster mode will be ideal for us, but we are open to change.

+3
source share
5 answers

Just for completeness, the H2 database has some support for clustering , but compared to the functions of MySQL and PostgreSQL, it is very limited, it is really only fault tolerant. First I will review HA-JDBC .

+2
source

Stackoverflow
MySQL : . MySQL: MySQL (, )

PostgreSQL , . : PostgreSQL

, MySQL
MySQL, -, , MySQL. , MySQL.

, .
. .

+6

, . DRBD Heartbeat.

: DRBD . . , , , . ( mysql, postgres , , )

+1

, HSQLDB:

http://ha-jdbc.sourceforge.net/

+1

, FOSS:-), DB2 9.7 (, DB2/z , , , DB2/LUW (Linux/UNIX/Windows) ).

DB2 (HA), db2haicu, DB2 ( , Big Blue), .

/, , DB2, , / .

, (, ), , HA , , DB2 .

( ) Q-, , , . DB2 .

developerWorks , , .

+1

More articles:


All Articles