SQL Relay 0.42 Publishing Database pool Connection Proxy Server

Source: Internet
Author: User
Keywords Proxy server Relay database pool
Tags .gz .net access address aliyun application applications based

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.