Linux builds MySQL master slave

Achieve goals Set up two MySQL servers (one master and one slave), one as the master server and one as the slave server. The master server writes and the slave server reads. Workflow overview Primary server: Open binary log Configure a unique server ID Get the name and location of the master binary log file Create a user account for slave and ...

Posted on Wed, 16 Oct 2019 12:41:33 -0400 by Fahid

Installation of database pressure measuring tool Sysbench-0.4.12

> Recently, the company is going to oracle and migrate to mysql cluster. We choose mycat as the technology of distributed database middleware. There is no doubt that the preparatory work needs to be done well in the early stage. With the help of the operation and maintenance students, the cluster has been set up. Next, our task is the press ...

Posted on Tue, 15 Oct 2019 21:57:57 -0400 by Mind freak

Introduction to common commands of MySQL basic introduction

Next: MySQL database master slave synchronization process mysql command introduction mysql is a database management command adopt mysql --help To view relevant parameters and instructions mysql --help #mysql database management command Usage: mysql [OPTIONS] [database] #Grammatical format --help #View help d ...

Posted on Tue, 15 Oct 2019 15:50:10 -0400 by jblallement

C ා Chinese character gets the initial of Pinyin and adds the initial to the name in the database

The official language pack of Microsoft is adopted in this scheme. (download link: https://pan.baidu.com/s/10I1bhTdFr4-q_xKVHuEzMA Extraction code: p3nk ChnCharInfo.dll to get the initial The compressed package in the folder is official package, including Japanese, traditional, etc. Usage is the same. Install whichever you want in the C: \ ...

Posted on Tue, 15 Oct 2019 10:23:53 -0400 by Squallyboy

k8s security information (secret) and configuration information (configmap) management

Some sensitive information may be needed during application startup, such as user name password or secret key to access database. It is obviously inappropriate to store this information directly in the container image. Kubernetes provides a solution called Secret. Secret stores data in ciphertext, avoiding storing sensitive information directl ...

Posted on Mon, 14 Oct 2019 13:23:09 -0400 by stylusrose

android interacts with backstage database through web

@[toc] 1. background Develop an app to interact with the background database, based on mysql+jdbc+tomcat, without using DBUtils or JDBC framework, pure bottom JDBC implementation.In the future, we will gradually change to Spring framework, optimize mysql, further deploy tomcat and so on. Now the project has just started, there are still many t ...

Posted on Mon, 14 Oct 2019 09:18:20 -0400 by jamesp

Technology Sharing | MySQL A Strange Failure Analysis

Author: Gao PengAt the end of the article, there is his book "in-depth understanding of MySQL master-slave principle 32", in-depth understanding of MySQL master-slave, GTID related technical knowledge.Source version: 5.7.22Limited level, if there is any misunderstanding, please forgive me. Sources of problems This is a typical case ...

Posted on Mon, 14 Oct 2019 05:09:09 -0400 by irn3rd

Building Blog Based on Al egg Framework: Browsing and Publishing Articles

Related articles Blog Building Based on Al egg Framework (1) - Development PreparationsBuilding Blog Based on Al egg Framework (2) - Hello WorldBuilding Blog Based on Al egg Framework (3) - Registration and LoginBlog Building Based on Al egg Framework (4) - Privilege ControlBuilding Blog Based on Al egg Framework (5) - Top Navigation BarBuildin ...

Posted on Mon, 14 Oct 2019 02:31:55 -0400 by kgahn

Building Blog Based on Al egg Framework: Registration and Login

Related articles Blog Building Based on Al egg Framework (1) - Development PreparationsBuilding Blog Based on Al egg Framework (2) - Hello WorldBuilding Blog Based on Al egg Framework (3) - Registration and LoginBlog Building Based on Al egg Framework (4) - Privilege ControlBuilding Blog Based on Al egg Framework (5) - Top Navigation BarBuildin ...

Posted on Mon, 14 Oct 2019 00:12:46 -0400 by Cut

Backup database for introduction to MySQL database

Last time: MySQL database entry multi-instance configuration When it comes to data, we are nervous. There are many types of data, but the total normalization point, data is very important and very important. Therefore, the daily data backup work has become the focus of the operation and maintenance work. Let's first look at the data in the dat ...

Posted on Sun, 13 Oct 2019 22:05:58 -0400 by skeetley