Programmer Think

WeChat official account: operation and development story, author: wanger one Upgrade scheme 1 Scope of influence During the upgrade, the existing system will not be affected, and the system will maintain normal operation. After the upgrade, the availability test will be conducted for a period of time, and the production monitoring will b ...

The master-slave replication of Mysql requires at least two Mysql services. Of course, Mysql services can be distributed on different servers or multiple services can be started on one server. First, make sure that the Mysql versions on the master and slave servers are the same. 1, Installing and deploying mysql 1. Install server side: y ...

Set root password for the first timesudo passwd root1, Installing nginx1. Apt get installation commandsudo apt-get install nginxError: "Unable to locate package nginx"Solution: execute the command before installation to update the software sourcesudo apt-get updateLocation of nginx files after installation:/usr/sbin/nginx: main progra ...

The original content of GreatSQL community cannot be used without authorization. Please contact Xiaobian and indicate the source for reprint.Question 1, is there a recommended reference for the best configuration of MGR operationAt the sharing meeting of Guangzhou station of "3306 π" community on May 22, Lou Shuai, CTO of Wanli dat ...

Master slave synchronization Note: the code in this article may involve misuse of Chinese characters, such as quotation marks and commas. Ask the paster to debug and modify the self code. Open the primary server mysql database configuration file Find my. In the mysql installation directory Ini configuration file, add under [mysqld] server-i ...

Insert query results into other tables Be able to write SQL statements that insert query results into other tables 1. Thinking At present, there is only one goods table. We want to add a commodity classification information. For example, the classification information of mobile devices cannot be added only through the goods table. How ...

Tip: after the article is written, the directory can be generated automatically. Please refer to the help document on the right for how to generate it preface I saw it on the bus in the morning**_ The article on MySQL binlog written by yidianyu * * in Jiangnan is very detailed about the use of binlog to recover the database. I can under ...

Author: Yang TaotaoSenior database expert, specializing in MySQL for more than ten years. He is good at backup and recovery, SQL tuning, monitoring, operation and maintenance, high availability architecture design related to MySQL, PostgreSQL, MongoDB and other open source databases. At present, he works in aikesheng, providing MySQL related te ...

Welcome to my blog 1, Relational database < "\ 1 / >, data model There are three types of relationships between entities: The first mock exam model (1*) One to one Relational model uses two-dimensional tables to represent data and data relations. It is the most widely used data model. At present, various commonly used databa ...

Although the MVVM architecture was also used in previous projects, I was not familiar with the overall MVVM architecture because I did not build the overall framework myself, so I built and implemented the MVVM architecture myself this time.The components used by MVVM architecture include ViewModel, LiveData, ViewBinding/DataBinding, etc. these ...