Tags (space separated): building big data platform
1: Environment initialization
2: Installation of CDH6.3.2
1: Environment initialization
1.1 environment introduction
1.2: Keyless l ...
Posted on Thu, 28 May 2020 08:02:40 -0700 by tomhilton
Author: Hong bin
The person in charge and technical service director of akerson South District, MySQL ACE, is good at database architecture planning, fault diagnosis, performance optimization analysis, with rich practical experience, helping customers in various industries to solve MySQL technical problems, and providing customers in finance, ...
Posted on Thu, 28 May 2020 02:07:16 -0700 by huzefahusain
2. About MySQL Master-Slave Synchronization
3. Deployment Planning
3.1 Server Planning
3.2 Database Catalog Planning
4. Preparation Tools
5.4 Use Universal Binary Package to install MySQL on four machines (node7 as an example)
5.1 Upload MySQL Universal Binary Installation Package to Noe7/usr/local/src directory
5.2 Unz ...
Posted on Wed, 27 May 2020 21:17:41 -0700 by acac
Zabbix is an excellent distributed monitoring server, which consists of two parts:
1. "ZABBIX server" is used to collect and display data on the web
2. "ZABBIX agent" is used to collect data and send it to the server
When Zabbix was installed, three virtual machines were used to test whether the monito ...
Posted on Wed, 27 May 2020 01:54:43 -0700 by apocryia
Mysqlslap: MySQL's own stress testing toolmysqlslap is the benchmark tool that comes with mysql. It queries data, has simple syntax, is flexible and easy to use. It can simulate multiple clients concurrently sending query updates to the server, gives performance test data, and provides performance comparison of various engines.mysqlslap provid ...
Posted on Tue, 26 May 2020 09:29:37 -0700 by Bramme
mysqldump backs up multiple libraries at a time
There are 20 + databases in a database instance, and 10 + of them need to be backed up in this backup. Use mysqldump to directly back up and step on a warning and an error.
Database version: 5.7.26
The process is as follows:
mysqldump -hrm-2ze04c849v9m32bzj.mysql.rds.aliyuncs.com -uadminr ...
Posted on Tue, 26 May 2020 07:57:51 -0700 by ponies3387
We often see @Import import functionality in the Spring framework, especially at the framework level.
I'll just tell you what it can import. First, declare that @Import is a comment. There are three types of imports:
1. Import the configuration @Configuration, similar to the import xml file of spring's earlier version 2.5,
<?xml version=" ...
Posted on Mon, 25 May 2020 16:46:45 -0700 by warriors2003
Mysql_5.7 and Mysql_5.6 large difference
Mysql_5.7 installation steps
1. In the / usr/local/src directory, download the MySQL 64 bit package and extract it
[root@dl-001 src]# wget http://mirrors.sohu.com/mysql/MySQL-5.7/mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz
[root@dl-001 src]# tar zxvf mysql-5.7.17-linux-glibc ...
Posted on Sun, 24 May 2020 08:07:19 -0700 by JWitness
1. limit usage of Mysql
When we use query statements, we often need to return the first few or some middle rows of data. What should we do at this time? never mind, mysql We have such a function.
SELECT * FROM table LIMIT [offset,] rows | rows OFFSET offset
The LIMIT clause can be used to force a SELECT statement to return the spec ...
Posted on Thu, 21 May 2020 01:00:12 -0700 by jpopuk
Last article( https://www.cnblogs.com/meowv/p/12896898.html )The blog project has been successfully run, so this article is mainly to solve the problems left before. Now the code seems to be confused. There are a lot of unrelated codes in it, which is really zero tolerance for obsessive-compulsive patients.
In the world of programmers, there i ...
Posted on Mon, 18 May 2020 19:13:37 -0700 by suresh_nsnguys