BestHub
Sign in
IT Xianyu
Author

IT Xianyu

We share common IT technologies (Java, Web, SQL, etc.) and practical applications of emerging software development techniques. New articles are posted daily. Follow IT Xianyu to stay ahead in tech. The IT Xianyu series is being regularly updated.

142
Articles
0
Likes
385
Views
0
Comments
Recent Articles

Latest from IT Xianyu

100 recent articles max
IT Xianyu
IT Xianyu
Jan 9, 2022 · Operations

Comprehensive Guide to Installing Nginx, Configuring Reverse Proxy, Load Balancing, SSL, Keepalived, LVS, and High‑Availability Clusters

This tutorial walks through installing Nginx from source, setting up upstream reverse‑proxy groups, configuring various load‑balancing methods (weight, IP hash, URL hash, least connections), enabling SSL, deploying Keepalived for failover, and building an LVS‑DR high‑availability cluster with detailed command‑line examples.

KeepalivedLVSNginx
0 likes · 23 min read
Comprehensive Guide to Installing Nginx, Configuring Reverse Proxy, Load Balancing, SSL, Keepalived, LVS, and High‑Availability Clusters
IT Xianyu
IT Xianyu
Jan 6, 2022 · Backend Development

Spring Boot Packaging with Maven Assembly Plugin and Shell Deployment Script

This article explains how to use Maven profiles and the maven‑assembly‑plugin to create environment‑specific zip packages for a Spring Boot application and provides a reusable shell script (shenniu_publish.sh) for extracting, starting, stopping, and managing the deployed JAR on Linux.

LinuxSpring Bootdeployment
0 likes · 14 min read
Spring Boot Packaging with Maven Assembly Plugin and Shell Deployment Script
IT Xianyu
IT Xianyu
Dec 28, 2021 · Fundamentals

How to Configure Class and Method Comment Templates in IntelliJ IDEA

This guide explains step‑by‑step how to set up class and method comment templates in IntelliJ IDEA, including creating file and live templates, configuring parameters, adding Groovy scripts for @param and @return generation, and verifying the generated Javadoc comments for Java files.

IDE configurationIntelliJ IDEAJava
0 likes · 6 min read
How to Configure Class and Method Comment Templates in IntelliJ IDEA
IT Xianyu
IT Xianyu
Oct 14, 2021 · Databases

Comparing MySQL and HBase: Architecture, Engine, and Application Scenarios

This article compares MySQL and HBase by examining their architectural designs, storage engines, data access patterns, and ecosystem features, highlighting the strengths and trade‑offs of each system and outlining the scenarios where HBase is a suitable complement to MySQL.

B+TreeBig DataDatabase comparison
0 likes · 5 min read
Comparing MySQL and HBase: Architecture, Engine, and Application Scenarios
IT Xianyu
IT Xianyu
Sep 15, 2021 · Databases

Database Types, Bottlenecks, Optimization Strategies and Scaling Techniques

This article explains the classification of relational and NoSQL databases, analyzes common performance bottlenecks such as query latency, large fields, and write overhead, and presents practical optimization methods including caching, proper indexing, transaction handling, read‑write separation, and sharding for large‑scale systems.

CachingIndexingdatabases
0 likes · 17 min read
Database Types, Bottlenecks, Optimization Strategies and Scaling Techniques
IT Xianyu
IT Xianyu
Aug 17, 2021 · Databases

Key New Features of MySQL 8.0 for Relational Databases

MySQL 8.0 introduces several relational‑database enhancements, including invisible indexes for performance tuning, persistent configuration via SET PERSIST, default utf8mb4 character set, support for Common Table Expressions, and window functions, each illustrated with practical SQL examples.

8.0CTEIndexes
0 likes · 7 min read
Key New Features of MySQL 8.0 for Relational Databases
IT Xianyu
IT Xianyu
Jul 19, 2021 · Backend Development

Implementing a Real‑Time Leaderboard with Redis and PHP

This article explains how to build a real‑time game leaderboard using Redis sorted sets, covering ranking categories, composite scoring formulas, dynamic updates, efficient data retrieval with pipelines, and provides a complete PHP class implementation.

LeaderboardPHPPipeline
0 likes · 11 min read
Implementing a Real‑Time Leaderboard with Redis and PHP
IT Xianyu
IT Xianyu
Jun 16, 2021 · Databases

Understanding Database Connection Pools vs. ThreadLocal in Java

This article explains the fundamental differences between database connection pools and ThreadLocal‑cached connections in Java, illustrating how connection pools improve performance while ThreadLocal enables sharing a single connection across methods within the same thread for consistent transaction control, and discusses practical usage patterns.

Connection PoolJavaThreadLocal
0 likes · 7 min read
Understanding Database Connection Pools vs. ThreadLocal in Java