Extra big Database Solution The bigger, the better...


God, we have a big database with 1.5 million rows, now it can return a query result in 10 or 15 seconds, but the customer started a new product, the rows will grow to 4 or 5 million rows, how should I do, my God ?

God answers: Try LEXST database system and create table partition, my child.

topology of big database solution:LEXST

LEXST database system Overview

LEXST database system is designed to meet the demand of massive searching, in big tables , it's some kind of relational database, but it's a clustered and big database system with talbe partition technology.

On top of that, LEXST database system is cheap solution, it can run on ordinary PC, no need very professional hardwares.

LEXSTsystem, with very little human interference, saves cost.

With simple tools you can dump into LEXST database system from your existing database, it's just easy and quick step.

LEXST database system runs in LAN environments or extranet environment, and servers can be distributed in different location. Besides, it can be an internet web page search engine, if you dump data into LEXST database system.

Some companies and sectors have massive data storage, these data have very simple schema, if you want to get a query result very quickly, conventional relational database systems can't help. In the meantime, some high end distributed databases are too expensive. That's why we decided to present LEXST when numerous database systems already existed in the market for a few decades.

Features:

  • Return search results within 0.1-0.5 seconds, no matter how many rows you have in your big table;

  • Control up to 20,000 nodes working together to search.

  • Very fast response to concurrent massive queries, one server can handle up to 1200 tasks simultaneously;
  • Redundancy technology secures the data;

  • Restore the data from breakdown safely and easily;

  • The monitoring robot runs 24 hours, it alarms, cuts away the brokedown nodes and starts the standby servers automatically;

  • Full log management.

 

 

Mysql cluster and Lexst cluster comparision  
SQL clustered server: the advantages and the shortcomings SQL Table Partitioning on SQL Server