17173 technical blog of the System Department team: the first activity of Fujian technology Carnival in 2015, 173ops, was published in 2014-12-1616: 21: 15... Read the full text GitLab setup and maintenance (based on the docker image sameersbndocker-gitlab) 173ops published on 2014-11-11:49:15 system O & M dockerGitLab setup and maintenance (based on the docker image sa
17173 technical blog of the System Department team: the first activity of Fujian technology Carnival in, 173ops, was published at 2015 16:21:15... Read the full text GitLab setup and maintenance (based on the docker image sameersbn/docker-gitlab) 173ops published on 10:49:15 system O & M docker GitLab setup and maintenance (based on the docker image sa
17173 technical blog of the System Department team
Fujian technology Carnival's first event in 2015173ops published on 16:21:15
... Read the full text
GitLab construction and maintenance (based on docker image sameersbn/docker-gitlab)173ops published on 10:49:15
System O & M docker
GitLab setup and maintenance (based on the docker image sameersbn/docker-gitlab) Cyent (QQ: 57237382) Create date: Last Update: read this article GitLab introduction 2.1. summary 2.2. architecture 2.3. component GitLab installation and deployment 3.1. officially Supported Method 3.... Read the full text
[MySQL FAQ] series-what should I pay attention to when converting from MyISAM to InnoDB?173ops published on 00:40:02
Currently, InnoDB can be used in most business scenarios. More and more businesses are switching from MyISAM to the InnoDB engine. What are the precautions? After analyzing the differences between the two engines, you can easily know the key points. In general, considerations for switching from MyISAM to InnoDB include: 1. In MyISAM's primary key index, you can use the auto-incrementing column in a non-first column (not the first field, when InnoDB's primary key index contains an auto-increment column, it must be at the beginning; this feature is in dis... Read the full text
[MySQL FAQ] series-how to reconcile two table names173ops published on 00:39:25
MySQL
A student asked me, in a scenario similar to pt-osc, how can we ensure that the two table names are correct? The analysis estimated that other students laughed. Isn't table name correct easy? RENAME each other. However, what we want is to complete table name reconciliation at the same time. If it is a successive pair, some data may fail to be written. What should we do? In fact, it is not difficult to find a method from the MySQL manual, that is: Lock two tables at the same time, do not allow writing, and then tune the table name. We usually only lock one table, So how should we lock two tables at the same time... Read the full text
[MySQL FAQ] series-modifying my. cnf configuration does not take effect173ops published on 00:15:58
MySQL
The problem is that my. cnf configuration file does not take effect. What is the problem? The reason is that we only mentioned modifying my. cnf, and we didn't know which file the absolute path is. That is to say, the my. cnf file in the correct path may be modified. In MySQL, multiple my. cnf configuration files are allowed, and some may affect the entire system environment, such as/etc/my. cnf. Some can only affect individual users, for example :~ /. My. cnf... Read the full text
Fujian technology Carnival: 20141018 technology salon activity PPT173ops published on 13:22:58
The PPT of this activity has been uploaded to Baidu cloud disk. Click here to view it! The video for this activity has been uploaded to Baidu cloud disk. Click here to view it! Next activity forecast: Date: October 1, January 2015 location: To be determined (expected in the Software Park, can accommodate more than 100 people) Main content: system O & M, database, O & M and development, big data, mobile development, testing, security, and other fields. We also welcome other peers to register for topics to share with us! Stay tuned! ... Read the full text
Docker basics and advanced173ops published on 01:56:27
Docker
Chen Cheng (cyent@163.com, QQ: 57237382) Create date: Last Update: 17: 16Docker install devicemapper play net namespace3.1. ENV (environment variable) port map directly uses the default IP address allocated by docker to provide external services (in testing) 5.1. use... Read the full text
[Recommendation] replacing iotop with iopp173ops published on 09:16:17
Linux
1. Why is it recommended that ioppiotop have certain requirements on the kernel and python version, and sometimes it cannot be used? In this case, iopp can be used as an alternative solution. In some cases, you may not be able to use iotop smoothly. In this case, you can choose iopp. Its author is Mark Wong, which is developed in C and has only 532 lines of code, which is very concise. Iopp Project address: https://github.com/markwkm/iopp2?install iopp=code segment; 3#use ioppi... Read the full text
Tpcc-mysql installation, use, and result explanation173ops published on 16:34:44
TPC-C is a specification specifically designed for online transaction processing systems (OLTP systems), which are generally called business processing systems. Tpcc-mysql is a product derived from percona Based on TPC-C (hereinafter abbreviated as TPCC), dedicated to MySQL benchmarking. Its source code is placed on launchpad, with bazaar management, project address: https://code.launchpad.net /~ Percona-dev/perconatools/tpcc-m... Read the full text
Quick migration between redis master and slave instances173ops published on 09:36:30
Redis Master/Slave
Step 1. create a redis instance on the slave server. It is recommended that the authentication password ("requirepass") be the same as that on the master server, but not in redis. configure synchronization in conf ("slaveof" "masterauth"); 2. start a new slave server; 3. online configuration synchronization: config set masterauth xxxxxxxx (config set master... Read the full text
Reasons why a php process cpu % nice is very high173ops published on 09:16:49
I. symptom Description: [code snippet] question: why are the priority values in ps different from those in top? PR in top is: The priority of the task (value range:-20 Highest, 19 lowest) PRI in ps is: realtime priority (calculated based on nice () and setpriority, the value of Static priority is 1-99. Dynamic priority is not yet understood... Read the full text