The modified character set code of MySQL 5.6 under Linux is UTF8 (to solve the problem of Chinese code scrambling, it can be used for personal test!)

The modified character set code of MySQL 5.6 under Linux is UTF8 (to solve the problem of Chinese scrambling) 1, Log in to MySQL to view SHOW VARIABLES LIKE 'character%'; the following character set is displayed as follows:+--------------------------+----------------------------+ | Variable_name | Value | +--------------------------+---------- ...

Posted on Sat, 30 May 2020 22:14:46 -0700 by Bob Norris

Database experiment - Data Query Language

(1) Query the basic information of students;   select * from S;           (2) To inquire the basic information of CS students select * from S where Sdept ='CS'; (3) Inquire the student number and name of "CS" students whose age is not between 19 and 21 select Sno, Sname from S where Sdept = 'CS' and Sage not Between 19 and 21; ...

Posted on Fri, 29 May 2020 01:43:07 -0700 by hl_tan

Build hive clusters based on different versions of Hadoop (with configuration files)

Focus on Public Number: Alliance of Java Architects, Daily Technical Updates This tutorial uses two scenarios One is hive-1.21 and hadoop is hadoop 2.6.5 Another is mainly about the construction based on hadoop3.x hive   First come first 1. Local (embedded derby) step This storage requires running a mysql server locally and configuring ...

Posted on Thu, 28 May 2020 09:18:13 -0700 by adam119

CDH6.3.2 deployment of big data platform

Tags (space separated): building big data platform 1: Environment initialization 2: Installation of CDH6.3.2 1: Environment initialization 1.1 environment introduction System: CentOS7.5X64 cat /etc/hosts ---- 192.168.11.160 dev01.lanxintec.cn 192.168.11.161 dev02.lanxintec.cn 192.168.11.162 dev03.lanxintec.cn ---- 1.2: Keyless l ...

Posted on Thu, 28 May 2020 08:02:40 -0700 by tomhilton

Technology sharing how to write MySQL Shell plug-ins

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

How MySQL master-slave synchronization architecture is built

Catalog I. Preface 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+grafana deploy distributed monitoring system

Preface: 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

MySQL Pressure Test Tool

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

Using mysqldump to back up multiple libraries

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: action1 mysqldump -hrm-2ze04c849v9m32bzj.mysql.rds.aliyuncs.com -uadminr ...

Posted on Tue, 26 May 2020 07:57:51 -0700 by ponies3387

Three cases of @Import in Spring

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