The Way to Learn Linux Operations and Maintenance (8) Pipeline and Redirection

I. File Descriptors File Descriptor (fd): A file descriptor is a non-negative integer. When an existing file or a new file is opened, the kernel returns a file descriptor. Reading and writing a file also requires the use of a file descriptor to access the file. It is also the file record table that the kernel maintains for each process ...

Posted by shayman on Mon, 27 May 2019 00:26:10 +0200

JOIN of MySQL (1): Usage

JOIN, like the English word "join", connects two tables, roughly divided into internal connection, external connection, right connection, left connection and natural connection. This description first throws out a rotten graph and then inserts the test data. CREATE TABLE t_blog( id INT PRIMARY KEY AUTO_INCREMENT, ...

Posted by haddydaddy on Mon, 27 May 2019 00:22:53 +0200

In-depth introduction to Mybatis series three-configuration details of properties and environments (mybatis source code)

This article is reproduced from Nan Ke Meng In the previous article, Mybatis Series (2) - Introduction to Configuration (Mybatis Source Chapter), through a simple analysis of mybatis source code, we can see that in the mybatis configuration file, under the configuration root node, configurable properties, type Aliases, plugins, objectFactory, o ...

Posted by leetcrew on Fri, 24 May 2019 23:45:21 +0200

docker mysql master-slave replication practice (pro-test feasible)

Modify configuration mode in container 1. Assume that the reader docker has been installed on CentOS 6.5 (or other operating systems) Detected version: docker -v Docker version 1.7.1, build 786b29d/1.7.1 2. Pull out the mirror docker pull hub.c.163.com/library/mysql:5.7 # Or elsewhere docker images #See if there is a list of mirrors 3. ...

Posted by Sera on Fri, 24 May 2019 23:17:22 +0200

ghost blog deployment

Summary ghost is an open source blog platform based on nodejs There are many articles about ghost blog deployment, including ghost Chinese network. There are many ways to deploy ghost blog. But I think the most convenient way is to deploy ghost with ghost_cli. ghost-cli is a new tool after version 1.0. Simply put, it can help us install, sta ...

Posted by sfc12345 on Fri, 24 May 2019 22:37:16 +0200

Web Server Framework Based on Koa and Mysql

Recently, I was writing a custom interface for a project. For the first time, I used node.js to implement it. I searched books and materials for several days. I planned to use express + mongodb to implement it. Later, I found that Koa, good boy, mysql is the final choice of the database. Old fashion, I built a framework based on Koa + Mysql: Ko ...

Posted by jac38 on Fri, 24 May 2019 22:31:54 +0200

p6spy displays complete executable SQL

Previous projects used mybtis to do ORM, it has its own SQL output, or third-party plug-ins are very good output display execution of the SQL and results. You can even use mybtis's interceptor to customize the output of formatted SQL. The project is currently developed using hibernate 3. Projects are also relatively old... The SQL statements di ...

Posted by Lee W on Fri, 24 May 2019 01:14:52 +0200

MySQL Introduction Basic Grammar 1

I. Basic Use of MySQL 1.1 Basic operations on the command line Mysql-u username-p carriage return Enter password: xxx Enter the database (All commands in mysql end with a semicolon and enter help; query all mysql commands) 1.2 MySQL directory structure bin: All executable files exe File of MySQL InstanceConf ...

Posted by bruce080 on Wed, 22 May 2019 20:15:30 +0200

Using MYCAT to Realize MYSQL Horizontal Fragmentation Easily

Original address: http://blog.csdn.net/Dreamcode/article/details/50401858 Full article download address: http://download.csdn.net/detail/dreamcode/9383516  Simply put, we can understand the horizontal segmentation of data as the segmentation of data rows, that is to say, some rows in the table are divided into one database, while some o ...

Posted by AbeFroman on Wed, 22 May 2019 02:01:53 +0200

11.1 LAMP Architecture Introduction 11.2 MySQL, MariaDB Introduction 11.3/11.4/11.5 MySQL Installation

11.1 Introduction to LAMP architecture11.2 Introduction to MySQL and MariaDB11.3/11.4/11.5 MySQL installationExtend mysql5.5 source compilation installation http://www.aminglinux.com/bbs/thread-1059-1-1.html mysql5.7 binary package installation (large change) http://www.apelearn.com/bbs/thread-10105-1-1.html 11.1 Introduction to ...

Posted by jpraj on Tue, 21 May 2019 20:58:43 +0200