Mr.Lucy's Technical Documentation

website·Indexed 32 days ago

https://liuchenyang.top/

A collection of technical guides and tutorials focusing on Linux administration, automation, and DevOps. Topics include Linux command usage (traceroute, netstat, history), software deployment (Jenkins, Tomcat, OpenJDK11, NFS), security tools (ClamAV, Trivy), and infrastructure management using Ansible, Zabbix 5.0, and Jumpserver. Also includes MySQL performance optimization and Python programming basics.

Tokens
837.3K
Snippets
4.5K
Records
5.6K
Agent score
58%

What's inside Mr.Lucy's Technical Docs

  1. Overview of common Prometheus Exporters

    • node_exporter: Linux/Unix system hardware and kernel metrics. • blackbox_exporter: Probing HTTP, HTTPS, TCP, ICMP, DNS (latency, cert expiry). • mysqld_exporter: MySQL/MariaDB connections, slow queries, QPS. • redis_exporter: Redis memory, hit rate, connections. • kafka_exporter: Kafka topic lag, leader distribution. • snmp_exporter: Network device (switches, firewalls) SNMP OID metrics. • pushgateway: Intermediate for short-lived batch jobs to push metrics. • statsd_exporter: Converts StatsD UDP/TCP metrics to Prometheus format. • memcached_exporter: Memcached hit rate, memory usage. • consul_exporter: Consul cluster health and leader status. • graphite_exporter: Converts Graphite protocol metrics to Prometheus format.

  2. Overview of SQL Functional Categories

    SQL (Structured Query Language) is the standard language for operating relational databases. Its functionality is divided into three primary categories:

    1. Data Definition Language (DDL): Used to define, modify, or delete the database schema, including base tables, views, and indexes. Key verbs: CREATE, DROP, ALTER.
    2. Data Manipulation Language (DML): Used for querying and modifying data (inserting, deleting, updating). Key verbs: SELECT, INSERT, UPDATE, DELETE.
    3. Data Control Language (DCL): Used to manage user access permissions. Key verbs: GRANT, REVOKE.
  3. Overview of Jenkins Declarative Pipeline Structure

    Jenkins Declarative Pipelines provide a structured, simplified syntax for defining CI/CD workflows. Unlike Scripted Pipelines (which use Groovy), Declarative Pipelines have a strict organizational structure that allows Jenkins to report syntax errors before the pipeline starts. A valid Declarative Pipeline must be wrapped in a pipeline block and include the following required sections: agent, stages, stage, and steps.
    pipeline {
        agent any
    
        stages {
            stage('Hello') {
                steps {
                    echo 'Hello World'
                }
            }
        }
    }
  4. Overview of Jenkins for Continuous Integration

    Jenkins is an open-source automation server written in Java that facilitates Continuous Integration (CI) and Continuous Delivery (CD). It allows developers to automate the repetitive tasks of integrating, testing, and deploying software. Jenkins runs in a Servlet container (like Tomcat) and supports various Software Configuration Management (SCM) tools including Git, Subversion, and Perforce. It can execute Apache Ant projects, Shell scripts, and Windows batch commands. Key features include a GUI-based configuration interface, support for third-party plugins, and the ability to distribute builds across multiple computers.
  5. Overview of Postfix and Dovecot Mail Server Architecture

    This architecture uses Postfix as the SMTP server for sending and receiving mail across the internet, and Dovecot as the POP3/IMAP server to retrieve mail from the server to the client. To avoid Linux UID limits when managing thousands of users, a 'virtual user' mode is implemented where users are managed in a database (MariaDB/MySQL) rather than as local system accounts.
  6. Overview of SQL Functional Categories

    SQL (Structured Query Language) is the standard language for operating relational databases. Its functionality is divided into three main categories:

    1. Data Definition Language (DDL): Used to define, modify, or delete the database schema, including base tables, views, and indexes.
    2. Data Manipulation Language (DML): Used for querying data and performing CRUD operations (Insert, Update, Delete).
    3. Data Control Language (DCL): Used to manage user access permissions (Grant, Revoke).
    -- DDL
    CREATE, DROP, ALTER
    
    -- DML
    SELECT, INSERT, UPDATE, DELETE
    
    -- DCL
    GRANT, REVOKE
  7. Overview of the blog technology stack

    The blog is built using the following services and tools:

    • Engine: VuePress with Theme Hope
    • CDN: Cloudflare
    • Search: Algolia
    • Comments: Waline (deployed via Vercel)
    • Analytics: Umami and Baidu Statistics
    • Images: PicGo (transfer tool) and GitHub/Aliyun OSS (storage)
    • Weather: Seniverse (心知天气) API and plugin
    • Music: vuepress-plugin-meting2
    • Icons: Iconfont
  8. Overview of Jenkins Declarative Pipeline Structure

    Jenkins Declarative Pipelines provide a structured, simplified syntax for defining CI/CD workflows. Unlike Scripted Pipelines (which use Groovy), Declarative Pipelines have a strict organization and report syntax errors at the start of the script. A valid Declarative Pipeline must be wrapped in a pipeline block and include the following required sections: agent, stages, stage, and steps.
    pipeline {
        agent any
    
        stages {
            stage('Hello') {
                steps {
                    echo 'Hello World'
                }
            }
        }
    }
  9. Overview of Postfix and Dovecot Mail Server Architecture

    This architecture uses Postfix as the SMTP server for sending and receiving mail across the internet, and Dovecot as the POP3/IMAP server to retrieve mail from the server to the client. To avoid Linux UID limits when managing thousands of users, a 'virtual user' mode is implemented where user accounts are stored in a database (MariaDB/MySQL) rather than as local system accounts.
  10. Overview of nvidia-smi

    The nvidia-smi (NVIDIA System Management Interface) is a cross-platform command-line utility provided with NVIDIA drivers for Linux and Windows (Server 2008 R2 and later). It is used to monitor GPU utilization, check memory usage, monitor temperatures, and enable/disable GPU configuration options such as ECC memory.
  11. Overview of Kubernetes StatefulSet

    StatefulSet is a Kubernetes workload controller designed for stateful applications. Unlike stateless controllers (like Deployment), StatefulSet provides support for applications that require stable network identifiers, persistent storage, and ordered lifecycle management. It is typically used for distributed systems where each instance has a unique identity and role (e.g., primary/replica or sharding).
  12. Overview of common Ansible modules and their purposes

    Ansible provides a variety of core modules to manage remote systems. Key modules include:

    • command: Executes simple commands (default module); does not support pipes, redirects, or variables.
    • shell: Executes complex shell commands; supports pipes, redirects, and variable references.
    • copy: Copies files to remote hosts with support for backups and permission settings.
    • template: Copies files based on Jinja2 templates, allowing variable replacement.
    • file: Manages file attributes such as permissions, owner, group, and state.
    • yum/apt: Package management for installing, removing, and updating software.
    • service/systemd: Manages system services (start, stop, restart, enable).
    • user/group: Manages user and group accounts.
    • ping: Tests connectivity to the host.
    • setup: Collects Facts information from the target host.
    • fetch: Pulls files from remote hosts to the local machine.
    • lineinfile/replace: Modifies file content by replacing specific lines or strings.
    • unarchive: Unarchives files (supports remote or local extraction).
    • git: Clones code from Git repositories.
    • cron: Manages scheduled cron jobs.
    • mount: Manages mount points.
    • debug: Prints variable information for troubleshooting.