Programming VIP

mysql5.7 minor version upgrade - windows Application scenario: upgrade mysql 5.7.20 to the latest 5.7.31, Windows Environment Download link on the official website: https://dev.mysql.com/downloads/mysql/5.7.html Note: mysql data must be backed up before operation to avoid problems during installation and can be remedied 1, Close and delete ...

Physical backup Reference learning articles Official documents A better article on the preparation Online articles corresponding to official documents dmrman physical offline backup article on line backup There are two ways to start archiving Online archive configurationManual archive configuration be careful During online backup, clo ...

Gaode map API official website: Gaode open platform | Gaode map API . Since the blogger is developed based on the front-end Vue framework, the map JavaScript API * * * * is introduced in combination with Vue. 1, Case effect 2, Development preparation It should be noted that if you want to use JS API, you must register an account and ...

1. Index type BTREE : b-tree , b+tree , b*tree RTREE FULLTExT HASH 2. Differences and relations between clustered index and auxiliary index difference: Generally, the primary key is selected to generate the cluster index. There can only be one table. If there is no primary key, the unique key is selected, and the hidden ...

Manually deploy ob triple-copy cluster 1. IP Address and Machine Planning Machine os:centos 7.5 8c12g IP Addresshost nameMachine RoleExplain192.168.32.111obce01observer+obproxy192.168.32.112obce02observer192.168.32.113obce03observer+obproxy192.168.32.114obce04observerAdd, Expand192.168.32.115obce05observer+obproxyAdd, Expand Note: The machin ...

mysql IO replication exception - heartbeat is not compatible with local info 1. Problem description An IO replication exception case was recorded. One set of MySQL Cluster slave database on a system line had the problem of IO replication thread interruption at about 22:57 every day in the recent week. Check the error information "h ...

Environmental preparation (1) Two virtual machines are required, and the memory is better than 2G. DM8 is installed on each virtual machine, and initialization is not required after installation.(2) In this paper, the machine is named. The first one is called node 1 and the second one is called node 2, which is convenient to call. Because it i ...

catalogue 1, Environment construction 1. System planning 2. Configure DM ini 3. Configure dmmal ini 4. Configure dmmpp ctl 5. Run MPP 2, Problem solving 1. After starting two instances, start/ disql error  2. Common meter test 3. Temporary meter test 1, Environment construction Build a two node MPP cluster in linux environment ...

It took bloggers many days to build DMDSC, not because of how difficult it is, but because of some details. 1. Environmental preparation 1.1 hardware facilities The virtual machine system used by the landlord is centos7. This tutorial is applicable to most virtual machine systems. It runs 2g of memory, 20g of disk, and 20g of new shared disk. ...

introduction As developers, we often deal with databases. When we modify the database, such as adding fields and updating records, we do not correctly evaluate the frequency of use of the table at this time, so we directly modify it, resulting in a long time of unresponsiveness to the modification operation and locking the table. In mysql, if ...