Shulou(Shulou.com)05/31 Report--

Today, I will talk to you about what Slice expansion is, many people may not know much about it. In order to make you understand better, the editor has summarized the following content for you. I hope you can get something according to this article.

Slice extends from an open source project of OpenJPA for distributed databases. Slice is attached to OpenJPAruntime as a plug-in, and multiple database support can be activated by configuring a persistence unit. Once Slice is configured, existing OpenJPA applications can leverage multiple databases for processing in the same transaction. The query will also rely on all databases to execute in parallel, and any updates will be submitted to the appropriate database.

DbShards

First of all, this is a commercial product, definitely not an open source solution.

Single database:

First of all, start by configuring a website application, which is composed of a 4-Ethernet application server and a database. The following figure shows the configuration of an application with a database configuration max_connections of 1000. To avoid database overload, we set the number of concurrent requests to 800, so the connection pool for each application server is set to allow up to 200 connections. Set each application server to support at least 200 threads of processing for inbound HTTP requests.

Split the database:

Now suppose we use a split database with four physical sublibraries (a separate instance of MySQL on each dedicated server). Now we have four databases, each with a max_connections configuration of 1000. Similarly, we want to limit 800 concurrent transactions per database. Assume that the result of splitting the architecture is to distribute queries evenly across all four sublibraries, that is, each application server can handle four times as many concurrent requests and establish 200 connections to each sublibrary.

CUBRID

CUBRID is a fully open source and completely free relational database management system. CUBRID is highly optimized for efficient execution of Web applications, especially complex business services that need to handle large amounts of data and highly concurrent requests. By providing unique optimization features, CUBRID can support more concurrent requests and less response time.

The name CUBRID is actually a combination of two words: Cube (cube) and Bride (bridge). For CUBRID, "Bride" stands for "databridge", while "Cube" stands for a sealed box that provides security for the data placed in it. Therefore, CUBRID representatives can provide security for confidential information.

Most solutions are based on a specific database. Their usual approach is to use an intermediate proxy layer. This means that every SQL request needs to be parsed.

After reading the above, do you have any further understanding of what Slice expansion is? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.