SQL Relay 0.42 Publishing Database pool Connection Proxy Server

SQL Relay is an open source database pool connection Proxy server. For Unix or Linux to provide database connection pool, agent and http://www.aliyun.com/zixun/aggregation/13996.html "> load balancing function.

The application idea of SQL Relay:

• Accelerate database-driven web-based applications
• Increase scalability of WEB applications
• Distributed access to replicated database systems
• Throttling Database access
• Access to a database on a platform that is never supported
• Easy porting of database systems

SQL Relay Supported databases

* Oracle
* MySQL
* mSQL
* PostgreSQL
* Sybase
* MS SQL Server
* IBM DB2
* InterBase
* Sybase
* SQLite
* Lago
* ODBC
* MS Access

SQL Relay 0.42 This version updates the configuration script to detect more languages and newer versions of the database. The Java API can now run on 64-bit machines. The error of address = "" was amended. Oracle cursor bindings and CLOB errors have been corrected. The maxsession parameter defaults to 0 (disabled). Patches can be used to improve stability under high loads, deal with competitive conditions, improve status reporting and address specific, unusual situations. Many ambiguous errors, memory leaks, and border cases are resolved.

Download Address: Http://prdownloads.sourceforge.net/sqlrelay/sqlrelay-0.42.tar.gz?download

Installation and Configuration

Start installing SQL Relay and go to http://sqlrelay.sourceforge.net/to download the appropriate software
Install SQL relay need to install Rudiments first, in http://sqlrelay.sourceforge.net/download.html can find

1, Installation rudiments:

# tar Vxzf rudiments-0.28.2.tar.gz
# CD rudiments-0.28.2
#./configure--prefix=/usr/local/rudiments
# make
# make Install

At this point, the rudiments installation is complete

2. Install SQL Relay:

# tar Vxzf sqlrelay-0.36.4.tar.gz
# CD sqlrelay-0.36.4
#./configure--prefix=/usr/local/sqlrelay--with-rudiments-prefix=/usr/local/rudiments--with-mysql-prefix= MySQL installation path--with-freetds-prefix=freetds installation path--with-oracle-home=oracle installation path--with-php-prefix=php installation path
# make
# make Install

At the end of Setup, the above compilation parameters are set according to personal needs, because I also need Oracle SQL Server MySQL, so I added so many parameters