Freaks City

Redis Installation and Setup Redis 5.0+ requires GCC 9.0 or higher for compilation. # Download and extract wget http://download.redis.io/releases/redis-3.2.12.tar.gz tar xzf redis-3.2.12.tar.gz mv redis-3.2.12 /data/redis # Build from source cd /data/redis make # Configure environment vim /etc/profile export PATH=/data/redis/src:$PATH source ...

Transaction Lock Management Database management systems utilize two types of synchronization mechanisms: Locks and Latches, each serving distinct purposes: Aspect Locks Latches Scope User transactions Threads Protection Database contents In-memory data structures Duration Entire transaction Critical sections Modes Shared, Exclusive ...

MySQL Lock Granularity and Types In MySQL, locking mechanisms are categorized by their scope into three primary types: global locks, table-level locks, and row-level locks. Global Locking Applying a global lock places the entire database instance into a read-only state. This is historically used for logical full-database backups to ensure consi ...

Redis operates as an in-memory data store, leveraging RAM to achieve high-speed data access. While the primary design goal is performance, relying solely on memory introduces a risk of data loss during power outages or process failures. To mitigate this, Redis provides robust persistence mechanisms to save the in-memory state to disk, allowing ...

Setting Up SaltStack Job Cache with MySQL Backend The SaltStack Job Cache functionality allows you to persist all Salt operations in a MySQL database, providing a centralized storage for job execution data. Prerequisites Begin by installing the MySQL Python connector on your Salt master node: yum install MySQL-python Configuring Salt Master Ed ...

Database Selection and Rationale The project uses MySQL as its primary database. This choice is driven by several practical advantages: MySQL offers exceptional stability with minimal downtime occurrences, operates under an open-source license with zero licensing costs, features a compact footprint with straightforward installation and maintena ...

Overview This article explores the behavioral differences between placing filtering conditions in the ON clause of a LEFT JOIN versus the WHERE clause. The examples use two tables: a (with data) and b (empty). Tables Setup Table a CREATE TABLE product_catalog ( record_id INT AUTO_INCREMENT PRIMARY KEY, item_name VARCHAR(255) NOT NULL, ...

The previous lecture discussed Two-Phase Locking (2PL), a pessimistic concurrency control method. This lecture introduces Timestamp Ordering (T/O), an optimistic approach where transactions do not require explicit locking during data access. The core concept of T/O uses timestamps to define a serial execution order for transactions: if TS(T_i) ...

MongoDB Overview MongoDB is a document-oriented database built using C++ that provides scalable, high-performance storage for web applications. It represents data in BSON format (binary JSON), which allows for flexible data structures and supports complex data types. Unlike traditional relational databases, MongoDB offers a flexible schema appr ...

Go Redis Client Implementation Installation The go-redis/redis library provides a rich set of functions for executing Redis commands, unlike older libraries that rely solely on a single execution method. This library supports both sentinel and cluster configurations. Insatllation command: go get github.com/go-redis/redis/v8 Connection Methods ...