HA-JDBC -

标签: | 发表时间:2018-09-27 17:39 | 作者:
出处:http://ha-jdbc.org

Cluster state management

The state manager component is responsible for storing the active status of each database in the cluster, as well as any durability state. During startup, HA-JDBC fetches its initial cluster state is fetched either from another server, if HA-JDBC is configured to be distributable, or if the configured state manager is persistent. If no state is found, all accessible databases are presumed to be active. To ignore (i.e. clear) the locally persisted cluster state at startup, start HA-JDBC using the ha-jdbc.state.clear=truesystem property.

HA-JDBC includes the following state manager implementations:

simple

A non-persistent state manager that stores cluster state in memory.

e.g.

<ha-jdbc xmlns="urn:ha-jdbc:cluster:3.0">
    <state id="simple"/>
    <cluster><!-- ... --></cluster>
</ha-jdbc>
sql

A persistent state manager that uses an embedded database. This provider supports the following properties, in addition to properties to manipulate connection pooling behavior. The complete list of pooling properties and their default values are available in the Apache Commons Pool documentationdocumentation.

Property Default Description
urlPattern jdbc:h2:{1}/{0}
jdbc:hsqldb:{1}/{0}
jdbc:derby:{1}/{0};create=true
A MessageFormat pattern indicating the JDBC url of the embedded database. The pattern can accept 2 parameters:
  1. The cluster identifier
  2. $HOME/.ha-jdbc
user Authentication user name for the embedded database.
password Authentication password for the above user.
e.g.
<ha-jdbc xmlns="urn:ha-jdbc:cluster:3.0">
    <state id="sql">
       <property name="urlPattern">jdbc:h2:/temp/ha-jdbc/{0}</property>
    </state>
    <cluster><!-- ... --></cluster>
</ha-jdbc>
berkeleydb

A persistent state manager that uses a BerkeleyDB database. This provider supports the following properties, in addition to properties to manipulate connection pooling behavior. The complete list of pooling properties and their default values are available in the Apache Commons Pool documentationdocumentation..

Property Default Description
locationPattern {1}/{0} A MessageFormat pattern indicating the base location of the embedded database. The pattern can accept 2 parameters:
  1. The cluster identifier
  2. $HOME/.ha-jdbc
e.g.
<ha-jdbc xmlns="urn:ha-jdbc:cluster:3.0">
    <state id="berkeleydb">
       <property name="locationPattern">/tmp/{0}</property>
    </state>
    <cluster><!-- ... --></cluster>
</ha-jdbc>
sqlite

A persistent state manager that uses a SQLite database. This provider supports the following properties, in addition to properties to manipulate connection pooling behavior. The complete list of pooling properties and their default values are available in the Apache Commons Pool documentationdocumentation.

Property Default Description
locationPattern {1}/{0} A MessageFormat pattern indicating the base location of the embedded database. The pattern can accept 2 parameters:
  1. The cluster identifier
  2. $HOME/.ha-jdbc
e.g.
<ha-jdbc xmlns="urn:ha-jdbc:cluster:3.0">
    <state id="sqlite">
       <property name="locationPattern">/tmp/{0}</property>
    </state>
    <cluster><!-- ... --></cluster>
</ha-jdbc>

相关 [ha jdbc] 推荐:

HA-JDBC -

- -
The state manager component is responsible for storing the active status of each database in the cluster, as well as any durability state.

MySQL HA 的選擇…

- - Gea-Suan Lin's BLOG
Percona 把常見的 MySQL High Availability 選擇整理後發表成 Webinar,投影片在這裡可以看到 (以及下載):「 Choosing a MySQL High Availability Solution」. 沒有太多新的東西,主要還是再次描述 MySQL HA 這塊目前沒有萬靈丹,常見的這幾個方案各有自己的優缺點,會依照環境與需求而產生不同的選擇.

nginx + keepalive 实现HA

- - CSDN博客编程语言推荐文章
主nginx负载均衡器 192.168.166.203. 辅nginx负载均衡器 192.168.166.177. VIP地址 192.168.166.178. 二.修改配置文件为以下内容: [master slave].  state MASTER #(主机为MASTER,备用机为BACKUP).

JDBC性能小贴

- - 开源软件 - ITeye博客
本文收集了一些用于提升JDBC性能的方法. Java应用或者JavaEE Web应用的性能是很重要的,尤其是数据库后端对应用的性能影响. 不知你是否经历过Java、JavaEE web应用非常慢的案例没有(处理一个简单的请求都要花上好几秒的时间用于数据库访问,分页、排序等). 下面这些贴士也许能提升Java应用的性能.

oracle的jdbc驱动

- - Oracle - 数据库 - ITeye博客
oracle的jdbc驱动主要有下面三类:.   1、JDBC OCI: oci是oracle call interface的缩写,此驱动类似于传统的ODBC 驱动. 因为它需要Oracle Call Interface and Net8,所以它需要在运行使用此驱动的JAVA程序的机器上安装客户端软件,其实主要是用到orcale客户端里以dll方式提供的oci和服务器配置.

SUSE Linux HA双机搭建

- - CSDN博客数据库推荐文章
原来的数据库服务器运行在HP DL388G7服务器上面,内存32G,由于业务增长,内存吃紧,加上时不时出现服务器硬件故障,由于是单实例单服务器,存在单点发现,于是打算采取一些措施改善一下:. 2)并搭建服务器操作系统级别的双机. 3)迁移数据库数据到新服务器. 前面已经写过数据迁移相关的文章,题目为“ EXP/IMP迁移数据”,链接如下: http://blog.csdn.net/laven54/article/details/8877940.

hdfs-ha热备原理

- - 开源软件 - ITeye博客
下面的总结来自于: http://dongxicheng.org/hadoop-hdfs/hdfs-ha-federation-deploy/ .            Hadoop 2.0中的HDFS增加了两个重大特性,HA和Federaion. HA即为High Availability,用于解决NameNode单点故障问题,该特性通过热备的方式为主NameNode提供一个备用者,一旦主NameNode出现故障,可以迅速切换至备NameNode,从而实现不间断对外提供服务.

MySQL HA Solution 2019(3)MyCat

- - 企业架构 - ITeye博客
0  . 0  .       .

MySQL HA Solution 2019(4)MaxScale

- - 企业架构 - ITeye博客
已有 0 人发表留言,猛击->> 这里<<-参与讨论. —软件人才免语言低担保 赴美带薪读研.

MySQL HA Solution 2019(2)ProxySQL

- - 企业架构 - ITeye博客
| hostgroup_id | hostname      | port | gtid_port | status | weight | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |.