Freaks City

Installation MongoDB 5.0 Installation Refer to the official documentation: https://docs.mongodb.com/manual/tutorial/install-mongodb-on-red-hat/ MongoDB 3.4 Installation (Tarball Method) The yum repository for 3.4 is no longer available, so manual installation via tarball is required. sudo groupadd mongod sudo useradd -r -g mongod -s /sbin/nolog ...

Handling Chinese Characters in MySQL When inserting Chinese characters into database fields, ensure proper encoding by using: string_value.encode('utf8') To modify a column's character set to support full UTF-8 including emoji characters: ALTER TABLE case_test_point MODIFY COLUMN `tp_name` VARCHAR(500) CHARACTER SET utf8mb4 NOT NULL; Example ...

Defining a New Table CREATE TABLE members ( member_id INT PRIMARY KEY AUTO_INCREMENT, fullname VARCHAR(50) NOT NULL UNIQUE, years_old INT DEFAULT 0, contact_email VARCHAR(100), joined_at DATETIME DEFAULT CURRENT_TIMESTAMP ); Inserting Records Single Row Insertion -- Insert specific fields INSERT INTO members (fullname, years_old, con ...

Determining System glibc Version Before downloading MySQL, identify the glibc version installed on your system: rpm -qa | grep glibc Common versions include glibc 2.17 and glibc 2.28. Download the corresponding MySQL package from the official website that matches your system's glibc version. Pre-Installation Checks Removing Conflicting Package ...

Web Protocols and HTTP BasicsHTTP communication relies on specific headers to manage content negotiation and client identification. Key request headers include Host, User-Agent, Content-Type, Accept-Encoding, Cookie, and Referer. The standard methods for interacting with resources are GET (retrieve), POST (create), PUT (update), DELETE (remove) ...

Transaction Overview 1.1 What is a Transaction? A transaction refers to a sequence of operations combined into a single operation. 1.2 Role of Transactions When individual operations in a database operation sequence fail, it provides a way to restore the database state to a normal state (A), ensuring data consistency even in abnormal states ...

Database Connection Management Applications communicate with MySQL databases through a dedicated MySQL driver that establishes TCP/IP connections. Rather than creating new connections for each request, connection pooling maintains reusable connections to avoid the overhead of repeated connection establishment and teardown. Popular Java connecti ...

Technical Overview Redis (Remote Dictionary Server) operates as an open-source, in-memory data structure storage system. Written in C, it supports network interaction and serves as a high-performance key-value (NoSQL) repository. It functions effectively as a database, a cache layer, and a message broker. Unlike relational databases, Redis does ...

Delete Operation Failure on Replica When a record is deleted on the primary but doesn't exist on the replica, replication halts with an error. Last_SQL_Error: Could not execute Delete_rows event on table app.users; Can't find record in 'users', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log mysql-bin.000008, end_lo ...

During a recent security scan of backend components, several minor vulnerabilities were detected. To prevent issues during future deployments, I decided to upgrade the MySQL installation. The upgrade strategy involves replacing MySQL binaries only, upgrading the replica node first, promoting it to the primary, and then upgrading the original pr ...