About Site Map Submit Contact Us Log in | Create an account
Create an account Log In
Average Rating
User Rating:
Visitors Rating:
My rating:

Write review
  • License: Freeware
  • Last update: 8 years ago
  • Total downloads: 159
  • Price: Free |
  • Operating system: Linux
  • Publisher: Derek Gottfrid
See full specifications

linux default iconDBSlayer Publisher's description

DBSlayer is a lightweight database abstraction layer suitable for high-load websites.

DBSlayer also know as Sl�yer (as we like to call it when we're feeling ironically heavy metal) is a lightweight database abstraction layer suitable for high-load websites where you need the scalable advantages of connection pooling. Written in C for speed, DBSlayer talks to clients via JSON over HTTP, meaning it's simple to monitor and can swiftly interoperate with any web framework you choose.

The DBSlayer originated as an internal tool at the New York Times. The typical LAMP strategy for scaling up data-driven applications is to replicate slave databases to every web server, but this approach can hit scaling limitations for high-volume websites, where processes can overwhelm their given backend DB's connection limits. Quite frankly, we wanted to scale the front-end webservers and backend database servers separately without having to coordinate them. We also needed a way to flexibly reconfigure where our backend databases were located and which applications used them without resorting to tricks of DNS or other such "load-balancing" hacks. Plus, it just seemed really cool to have a JSON-speaking DB layer that all our scriptable content could talk to. Thus, the DBSlayer was born.

Here are some key features of "DBSlayer":

· Simple HTTP interface
· JSON-format messages
· MySQL adapter (others possible in the future)
· Connection pooling
· Multithreaded
· Round-robin distribution of queries to slave instances
· Automatic failover to alternate databases
· Straight-forward configuration
· Simple yet powerful codebase.

Example Usage:

Starting the DBSlayer is as simple as pointing the DBSlayer at your mysql.cnf file with a few command-line options:
dbslayer -c /path/to/mysql.cnf -s servername

This starts up a DBSlayer daemon on 9090 (this default port can be changed) which acts as a proxy for the backend MySQL server. This proxy can then be queried via JSON over HTTP. Here is a query against one of the standard MySQL test databases:

select ci.* from City ci, Country

System Requirements:

· the Apache Portable Runtime (APR) library (1.0 or above)
· the Apache Portable Runtime Utility (APU) library (1.0 or above)
· the MySQL 5 client libraries (5.0 or above)


You can build and install the DBSlayer using the standard GNU autoconf process:

Unpack the DBSlayer archive

sudo make install

If the APR, APU, and MySQL libraries are installed in default locations, the configure script will find them. Otherwise, it may be necessary to specify the locations of apr-1-config, apu-1-config, and mysql-config with the --with-apr-1-config, --with-apu-1-config, and --with-mysql-config parameters to configure.

Program Release Status:
Program Install Support: Install and Uninstall and Repair

DBSlayer Tags:

Click on a tag to find related softwares

Most Popular

linux default icon A2Billing 1.6.0
A2Billing is a billing system interactive with Asterisk to give any Telecom company traditional offering VOIP... Read more
linux default icon FrontAccounting 2.3.10
FrontAccounting is free and released under the GNU General Public License.
linux default icon PgAdmin III for Linux 1.14.1
pgAdmin is the most popular and feature rich Open Source administration and development platform for... Read more
linux default icon RazorSQL for Linux 5.6.3
RazorSQL is an SQL query tool, database browser, SQL editor,....
linux default icon Salat Book 1.00
Salat / Namaz prayer database and tracking application