Programmer Think

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 ...

Monitoring mysql service on zabbix server 1. Configure mysql In the / etc / zabbix / zabbix ﹣ agent D. D / userparameter ﹣ mysql.conf file, it is specified how zabbix agent obtains various information of MySQL service, and a new ". my.cnf" file is created in the / var/lib/zabbix directory to specify how zabbix age ...

Now the mysql database we use is divided into two versions, one is mysql and the other is mariadb. There are some differences between the two versions of the solution, which I will explain below. First step First, we need to turn on my.cnf vim /etc/my.cnf Add skip grant tables under [mysqld], then save and exit ...

I. Preface Select is the most frequently used in the database, and it is basically the same every time. update, delete and insert are not used as frequently as select, and they are basically different every time. In order to reduce the pressure of the database, it is necessary to use cache for select. In the past, Ehcache was ...

Details of mysql automatic partition Why auto partition: because there are more than one million pieces of data in a table, and the query speed is very slow, the auto partition function is added to improve the query ability. First, define the steps of partition: New backup table Delete new table partition Swap partition Del ...

For the convenience of not starting from scratch, experiment directly on the existing database system, omit to install the database software (the method is similar), the following is an example of adding an instance essential information: [root@localhost ~]# cat /etc/issue CentOS release 6.5 (Final) mysql> \s ...

/*   *Copyright (c)2017, School of computer and control engineering, Yantai University *All rights reservrd.            *Author: Li Xinhao *Completion time: November 26, 2017 *Version number: v1.0 *Problem Description: topological sorting algorithm verification The following figure is an example: 1, Based on g ...

One. Remember to build the connection foundation before getting the database 1. driver 2. connection 3. statement 4. resultSet //1 Class.forName(ConfigUtil.getValue("driver")); //2 Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/resource_integrate","root","root");//The three paramete ...

This paper introduces the usage of mongodb database in node.js project. The related directory structure is the directory in the project. The code is not uploaded first, only the method is introduced. Using mongodb for database The installation method of mongodb server is to execute apt get install mongodb in ubuntu, a ...

Development tool: MyEclipse 2013, database: MySql 1. First, create a database in the database. The database tool I use is sqllog Create the following database: Open MyEclispe after database creation 2. Create Web Project 2.1: Item 1: Guide Package The following packages need to be imported:(these bags can be found on ...