Programmer Think

Why are sub databases and sub tables If you think the theory is wordy, just jump to the second level 1 Title sub library and start looking. What is sub database and sub table? In fact, it means literally. It's easy to understand: Sub database: the process of splitting a single database into multiple databases, scattering data in mul ...

1. Problems encountered in development With the growth of business, the historical data table already has 400-500 million data. Previously, a table was created every month according to the scheduled task. When inserting, the data was inserted into the current table according to the current time. Cross month query is a problem when performing a ...

I preface Mycat exposes services in the form of a Server, and its main configuration class is Server XML, this article mainly focuses on some small details, mainly including: Server. How to load XML Configuration and role in Server Flow of Server in connection request II Server.xml configuration 2 ...

Mycat is a database middleware. Usage scenario: High availability and Mysql read / write separationHierarchical storage of business dataLarge table, horizontal splitting, cluster parallel computingDatabase connection poolConsolidate multiple data sources install Download address: http://dl.mycat.org.cn Before installing Mycat, you need to ...

I brief introduction MyCat is an open source distributed database system and a server that implements MySQL protocol. Front end users can regard it as a database agent and access it with MySQL client tools and command line, while its back end can communicate with multiple MySQL servers using MySQL native protocol or with most mainstream databa ...

Since our Web application is running in tomcat, the request must arrive at Tomcat first. Tomcat actually handles the request as follows. First, provide Socket service The start of Tomcat must be Socket service, but it only supports HTTP protocol! In fact, we can expand our thinking here. Since Tomcat is based on Socket, what about BIO or NIO ...

Demand: The user instance SERV is divided into different databases according to the org? ID Agreement: Beijing (ORG UU id = 101), Shanghai (ORG UU id = 102), Shenzhen (ORG UU id = 103), Chongqing (ORG UU id = 104), Sichuan (ORG UU id = 105) Beijing bjdb, Shanghai shdb, Shenzhen szdb and Chongqing cqdb are built on dn10 and dn11 Sichuan scd ...

First read the quick start of the official website, then build it yourself. The result is various errors and pits.Record it. 1. Environment A virtual machine, a cloud server, a local Mac (because mysql is installed on the cloud server and locally, or you can use the virtual machine entirely, just look at yourself), mycat is deployed on the virt ...

1. Key xml configuration tables    server.xml The user tab specifies the account to access the database. <?xml version="1.0" encoding="UTF-8"?> <!-- - - Licensed under the Apache License, Version 2.0 (the "License"); - you may not use this file except in compliance with the License. - Y ...

mycat mainly provides a specific configuration of database segmentation. In this article, we will not do in-depth analysis, let the program run first! MYCAT official website: http://www.mycat.io/ ා don't be afraid of Chinese 1 > environment: CentOS operating system mysql5.6 Master database host: 192.168.0.1 Slave a host: 192.168.0 ...