Key Points and Common Errors in Building MySQL Log Platform Based on ELK
Part One Summary
ELK is a log analysis platform that integrates distributed data storage, visual query and log resolution.ELK=elasticsearch+Logstash+kibana, each of which has its own duties, cooperates with each other to complete the data processing of the log.The main functions of each ELK component are as follows:
elasticsearch, data storage ...
Posted by saviiour on Wed, 13 May 2020 11:10:51 -0700
Python uses Oracle to operate mysql database
install
Oracle installation command
pip install orator
##Easy to use
Connection operation of database
config = {
'mysql': {
'driver': 'mysql',
'host': 'localhost',
'database': 'test_one',
'user': 'root',
'password': '123456',
'prefix': ...
Posted by mrwutang on Wed, 13 May 2020 09:45:05 -0700
The difference between [MySQL] char and varchar
CHAR and VARCHAR types are similar, but they are saved and retrieved in different ways. Their maximum length and whether trailing spaces are preserved are also different. There is no case conversion during storage or retrieval.
Char 0-255 byte fixed length string
VARCHAR 0-65535 byte variable length string
Create test table
mysql> c ...
Posted by thomasob on Tue, 12 May 2020 08:41:49 -0700
The official zabbix source is replaced by Alibaba cloud's zabbix source, one click script.
When zabbix is installed suddenly recently, it always reports an error, such as:
(24/27): t1lib-5.1.2-14.el7.x86_64.rpm | 166 kB 00:00:00
zabbix-web-4.4.6-1.el7.noarch. FAILED ==================================- ] 347 kB/s | 11 MB 00:00:15 ETA
http://repo.zabbix. ...
Posted by dniezby on Mon, 11 May 2020 07:13:47 -0700
An article about TiDB disaster recovery recommendation
An article to play with TiDB disaster recovery
1, Background
High availability is another major feature of TiDB. All three components of TiDB/TiKV/PD can tolerate partial instance failure without affecting the availability of the whole cluster. The following describes the availability of these three components, the consequences of a single ...
Posted by misschristina95 on Sun, 10 May 2020 20:43:02 -0700
Monitoring Software - prometheus+exporter component+grafana
Environmental Science
linux: centos7.6
The most common server system in the company
prometheus: 2.13.1.linux-amd64
Container monitoring solution for numerical data based on time series: with its own data storage and monitoring, it is the official monitoring scheme designated by k8s.
node_exporter: 0.18.1.linux-amd64
Used to collect opera ...
Posted by thegreatone2176 on Sun, 10 May 2020 18:44:50 -0700
Stored Procedures for MySQL
Stored procedures are an important feature of database storage. Stored procedures were not supported by MySQL prior to version 5.0. Stored procedures can greatly improve the processing speed of the database and the flexibility of database programming.1. What is a stored procedure?Stored procedures are a collection of SQL statements that are de ...
Posted by sm on Sun, 10 May 2020 10:17:41 -0700
Docker installs JIRA and Confluence (cracked version)
1. Description
1.1 Material
This paper uses the following materials:
Docker Mirror Github Link
Crack Tool Gitee Link
With these tools, you can theoretically crack almost all versions.
1.2 Database
If you choose an external database, you can create it as follows:
# Create jira database and users
CREATE DATABASE jiradb CHARACTER SET utf8mb4 ...
Posted by stiphu on Sun, 10 May 2020 10:14:43 -0700
mariadb Source Installation
Dead work
Because MariaDB's binary package mirroring source is at a foreign address, the package is downloaded in advance to the local physical machine and uploaded to the virtual machine/usr/local/src directory for installation using the lrzsz tool.
The physical address is (click to download directly to the ph ...
Posted by abo28 on Sun, 10 May 2020 09:09:17 -0700
15. Chapter 15 of spring cloud Alibaba, upgrade, distributed transaction solution, Seata
Chapter 14 of SpringCloud Alibaba, upgrade, distributed transaction solution, Seata
1, Overview of distributed transactions
1. What is distributed transaction
With the rapid development of the Internet, the software system has changed from the original single application to the distributed application.
The distributed system will split an appli ...
Posted by fatmcgav on Sat, 09 May 2020 02:57:10 -0700