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