rt-mysql-galera-client

mariadb/mysql client support galera cluster High Availability

Introduction

This is a node.js driver for mysql galera cluster, include those features:

* auto recover from mysql server crash or connection failure.
* provide high availability. If one mysql server crash at runtime, it will auto re-send mysql command to another host in galera cluster. So your won't lose any data or query failure.
You need at least 2 hosts in galera cluster to enable high availability.
* use Round-Robin rule to send mysql command to galera cluster

Install

``npm install --save rt-mysql-galera-client`

Usage

`js
var MyGaleraClient = require('rt-mysql-galera-client');

//createPool = function(mysqlGaleraHostsArray, user, password, database)
pool = MyGaleraClient.createPool([
{
host: '192.168.1.221',
port: 3306,
connectionLimit: 2
}, {
host: '192.168.1.223',
port: 3306,
connectionLimit: 3
}
], 'testuser', '123123', 'test1');

//pool.query(sql, function(error, results, fields)
pool.query("select count(*) from MyClass", function(error, results, fields){
console.log("out error = ", error);
console.log("out results = ", results);
});
``