Programmer Think

👨‍🎓 Blogger introduction: IT Bond, a Jianghu person jeames007，10 year DBA hands-on background China DBA union(ACDU)Member, currently engaged in DBA And program programming SQL is almost a necessary skill for the production and research position of Internet companies, but if you only know SQL, you can't do anything. 1. If you are a da ...

EMQX security certification The connection authentication and access control of EMQ X message server are provided by a series of authentication plugins, and their names comply with emqx_auth_ In EMQ X, these two functions refer to: Connection authentication: EMQ X checks whether the client on each connection has the permission to access t ...

Steps for installing MySQL database in CentOS7 MySQL database installation Download wget command Delete the installed MySQL service Install MySQL installation package Possible problems Question one Question two MySQL database configuration Get temporary password ·Log in to MySQL Change Password Modify MySQL default code Simp ...

brief introduction Many articles on MySQL master-slave replication on the network explain how to implement and some implementation principles, and lack a comprehensive introduction to MySQL master-slave replication. For example, the mode of master-slave replication (semi synchronous mode and asynchronous synchronous mode), the principle of sy ...

Nginx download address: http://nginx.org/en/download.html MySQL download address: https://dev.mysql.com/downloads/mysql/ PHP download address: https://windows.php.net/download/ Step 1: download the required installation package Create a new folder containing the above three compressed packages, and create three directories to extract them ...

What problems does mysql replication solve Realize data distribution on different serversLoad balancing of data readingEnhanced data securityAchieve high database availability and failoverRealize online database upgrade mysql binary log Service layer log Binary logSlow check logGeneral log Storage engine tier loginnodb redo loginnodb rollba ...

Mysql Related concepts DB database: a container that holds a set of organized data DBMS database management system: used to manage data in DB SQL structured query language: a language used to communicate with DBMS # Enter exit mysql -h localhost -P 3306 -u root -proot exit Common commands # View database version mysql --version mysq ...

preface Querying the same data, after using Order by and limit, may have a hundred times impact on the query results and time-consuming. Optimizing SQL is not only to optimize those slow queries with more than 1 second, but also those with ultra-high frequency of 0.1 second. Here, I simulated and created a table limit_table And initialize the ...

Continuous check-in and receive gold coins describe User behavior log table tb_user_log (uid - user ID, artistic_id - article ID, in_time - entry time, out_time - departure time, sign_in - check in or not) Scenario Logic Description: artical_id - article ID represents the ID of the article the user browses. In special cases, it is artistic ...

🎈 Write in front 🙋‍♂️ Hello everyone, I'm super dream. We all know that we have to deal with the database almost every day, whether in study or daily work. In order to better operate the database, our SQL knowledge reserve is essential. If you want to master SQL well, you must practice and study every day. Next, Xiaomeng will lead our p ...