BestHub
Sign in
Tagged articles

database

2754 articles · Page 22 of 28
ITPUB
ITPUB
Apr 25, 2020 · Databases

Master Oracle Database: Startup, Shutdown, Users, Tablespaces, Indexes, Views, and Partitions

This comprehensive guide walks you through essential Oracle database administration tasks—including starting and stopping the database, managing listeners, creating and altering tablespaces, handling users and privileges, controlling transactions, building indexes, defining views and materialized views, working with sequences, synonyms, and partitioned tables—complete with commands, examples, and best‑practice tips.

AdministrationOracleSQL
0 likes · 21 min read
Master Oracle Database: Startup, Shutdown, Users, Tablespaces, Indexes, Views, and Partitions
Laravel Tech Community
Laravel Tech Community
Apr 23, 2020 · Backend Development

Understanding ORM vs DB Query Builder in Laravel

This article explains the differences between Laravel's ORM and DB query builder, outlines their advantages and appropriate use cases, and provides step‑by‑step code examples for defining models, retrieving, creating, and deleting records, as well as handling transactions.

LaravelORMPHP
0 likes · 5 min read
Understanding ORM vs DB Query Builder in Laravel
macrozheng
macrozheng
Apr 22, 2020 · Databases

13 Proven Techniques to Supercharge Redis Performance

Learn how to dramatically boost Redis speed by shortening key/value sizes, enabling lazy free, setting expirations, disabling costly commands, using slowlog, pipelines, avoiding mass expirations, optimizing clients, limiting memory, running on physical servers, tweaking persistence, disabling THP, and adopting distributed architectures.

Lazy FreePerformance OptimizationRedis
0 likes · 19 min read
13 Proven Techniques to Supercharge Redis Performance
Laravel Tech Community
Laravel Tech Community
Apr 21, 2020 · Backend Development

Master Laravel Eloquent: Essential Model Cheat Sheet & Usage Guide

This cheat sheet provides a concise yet comprehensive guide to Laravel's Eloquent Model, covering definition, artisan commands, common CRUD methods, soft‑deletes, relationship types, model events, and configuration tips, all illustrated with ready‑to‑copy code examples.

BackendEloquentLaravel
0 likes · 9 min read
Master Laravel Eloquent: Essential Model Cheat Sheet & Usage Guide
Code Ape Tech Column
Code Ape Tech Column
Apr 20, 2020 · Databases

Understanding Redis Persistence: RDB vs AOF and Performance Tips

This article explains how Redis implements two persistence mechanisms—RDB snapshots and AOF logs—covering their triggers, execution flows, advantages, drawbacks, differences, restart recovery procedures, and practical ways to mitigate performance overhead caused by fork operations.

AOFPerformancePersistence
0 likes · 14 min read
Understanding Redis Persistence: RDB vs AOF and Performance Tips
Meituan Technology Team
Meituan Technology Team
Apr 16, 2020 · Databases

Analyzing and Optimizing MySQL Performance on Intel Skylake CPUs

Meituan’s DBA team discovered that Intel Skylake CPUs dramatically increased PAUSE‑instruction latency, causing MySQL’s ut_delay spin‑wait loops to consume most CPU cycles and reduce write throughput, and they restored performance by back‑porting MySQL 8.0’s spin_wait_pause_multiplier patch to 5.7, upgrading to CentOS 7, and moving to Cascadelake hardware.

CPULinuxMySQL
0 likes · 18 min read
Analyzing and Optimizing MySQL Performance on Intel Skylake CPUs
Laravel Tech Community
Laravel Tech Community
Apr 16, 2020 · Backend Development

Laravel Eloquent ORM: Defining Models, Queries, and Data Operations

This tutorial explains how to configure Laravel's Eloquent ORM, create and customize model classes, manage table names, primary keys, timestamps, perform queries, insert, update, delete records, handle soft deletes, apply global and local scopes, and work with model events and observers, all with practical PHP code examples.

EloquentLaravelModel
0 likes · 22 min read
Laravel Eloquent ORM: Defining Models, Queries, and Data Operations
Youzan Coder
Youzan Coder
Apr 15, 2020 · Databases

Optimizing Druid Connection Pool: Practical Configurations and Tuning Guide

This article explains how to size and tune Druid's connection pool for high‑traffic Java applications, covering pool‑size formulas, timeout settings, keep‑alive behavior, essential XML properties, and version recommendations to prevent misleading SQL latency and improve overall database stability.

DruidJavaconnection pool
0 likes · 10 min read
Optimizing Druid Connection Pool: Practical Configurations and Tuning Guide
Laravel Tech Community
Laravel Tech Community
Apr 15, 2020 · Backend Development

Master Laravel Database Connections: Configuration, Read/Write Splitting, and Transactions

This guide explains how to configure Laravel's supported databases, set up SQLite, implement read/write connection splitting, use multiple connections, execute raw SQL queries, listen to query events, and manage transactions—including deadlock handling and manual control—complete with code examples.

ConfigurationLaravelRead/Write
0 likes · 8 min read
Master Laravel Database Connections: Configuration, Read/Write Splitting, and Transactions
Laravel Tech Community
Laravel Tech Community
Apr 15, 2020 · Backend Development

Using Laravel Seeders to Populate a Database with Test Data

This guide explains how to use Laravel seeders to generate test data, covering creation of seeder classes via Artisan, inserting records manually or with model factories, calling additional seeders, and the commands needed to run or refresh database seeding.

BackendLaravelPHP
0 likes · 4 min read
Using Laravel Seeders to Populate a Database with Test Data
Tencent Cloud Developer
Tencent Cloud Developer
Apr 13, 2020 · Databases

TBase Database Technology Salon: April Special Live Broadcast Announcement

Tencent Cloud is hosting a three‑month online technical salon, featuring dozens of senior database experts who will nightly dissect the architecture, implementation and best practices of domestic databases such as TDSQL, TBase and CynosDB/CDB, with April’s TBase sessions open for reservation via QR code and offering live‑stream giveaways.

Cloud ComputingHTAPTBase
0 likes · 4 min read
TBase Database Technology Salon: April Special Live Broadcast Announcement
Ops Development Stories
Ops Development Stories
Apr 9, 2020 · Databases

Build a Simple Employee Management System with MongoDB and Flask

This tutorial walks you through creating a web‑based employee management system that demonstrates MongoDB CRUD operations using Python, Flask, and Pipenv, covering project setup, environment configuration, code implementation for querying, adding, updating, and soft‑deleting records, and how to run the application.

CRUDEmployee ManagementFlask
0 likes · 15 min read
Build a Simple Employee Management System with MongoDB and Flask
Wukong Talks Architecture
Wukong Talks Architecture
Apr 8, 2020 · Databases

How to Install and Configure Redis Using Docker

This tutorial walks through pulling the Redis Docker image, creating configuration files, running the container, connecting with redis-cli, testing commands, enabling persistence, and installing a visual management tool, providing complete step‑by‑step instructions for Docker‑based Redis deployment.

ConfigurationDockerInstallation
0 likes · 4 min read
How to Install and Configure Redis Using Docker
Wukong Talks Architecture
Wukong Talks Architecture
Apr 8, 2020 · Databases

Step-by-Step Guide to Installing MySQL Using Docker

This tutorial explains how to download the MySQL Docker image, create and run a MySQL container with volume mappings and environment variables, verify the container, connect to the database via Workbench, and access the container’s shell and host files.

DockerInstallationLinux
0 likes · 3 min read
Step-by-Step Guide to Installing MySQL Using Docker
Ops Development Stories
Ops Development Stories
Apr 7, 2020 · Databases

Master MongoDB: From Basics to Advanced Operations

This comprehensive guide introduces NoSQL concepts, classifies non‑relational databases, explains why MongoDB is suited for loosely structured data, walks through Windows and Linux installations, demonstrates using Robo 3T, and covers all CRUD operations, queries, updates, deletions, and data de‑duplication with practical code examples.

CRUDInstallationMongoDB
0 likes · 26 min read
Master MongoDB: From Basics to Advanced Operations
Ops Development Stories
Ops Development Stories
Apr 7, 2020 · Databases

Master MongoDB with Python: Complete Guide to CRUD Operations

This tutorial explains how to install PyMongo, connect to local or remote MongoDB instances, choose databases and collections, and perform all common CRUD operations—including inserts, queries, updates, deletions, and special cases—using Python code examples and practical tips.

CRUDMongoDBNoSQL
0 likes · 14 min read
Master MongoDB with Python: Complete Guide to CRUD Operations
Tencent Cloud Developer
Tencent Cloud Developer
Apr 5, 2020 · Databases

Database Operations, Optimization, High Availability and Self‑Service – Insights from DBA Yang Jianrong

Senior DBA Yang Jianrong shares how standardized processes, robust security, and modern optimization—such as partitioning, middleware, and NoSQL—combined with high‑availability designs and self‑service tools like automated slow‑log analysis can streamline large‑scale MySQL operations, migrations, and continuous DBA learning.

DBAOptimizationbackup
0 likes · 24 min read
Database Operations, Optimization, High Availability and Self‑Service – Insights from DBA Yang Jianrong
Tencent Cloud Developer
Tencent Cloud Developer
Apr 3, 2020 · Cloud Native

TVP Technical Closed-door Conference Summary: Exploring the Dawn of Technology Trends

The TVP Technical Closed‑door Conference gathered 44 experts across eight sessions to examine post‑pandemic technology trends—including blockchain as institutional infrastructure, cloud‑native databases and serverless computing, industrial internet transformation, data‑driven online education, federated learning for privacy‑preserving AI, and the shift toward resource‑focused technical entrepreneurship.

Cloud NativeDigital TransformationIndustrial Internet
0 likes · 13 min read
TVP Technical Closed-door Conference Summary: Exploring the Dawn of Technology Trends
Qunar Tech Salon
Qunar Tech Salon
Apr 2, 2020 · Databases

30 Practical SQL Optimization Tips with Examples

This article presents thirty actionable SQL performance recommendations—including selecting specific columns, using LIMIT, avoiding OR and functions in WHERE clauses, proper indexing, batch inserts, and query planning—each illustrated with clear examples and explanations to help developers write faster, more efficient queries.

MySQLOptimizationSQL
0 likes · 19 min read
30 Practical SQL Optimization Tips with Examples
macrozheng
macrozheng
Mar 30, 2020 · Databases

Build a Redis Cluster with Docker Compose and Use It in SpringBoot

This guide walks you through setting up a six-node Redis cluster using Docker Compose, configuring the necessary redis.conf settings, deploying the containers, initializing the cluster, and then integrating the cluster into a SpringBoot application via appropriate application.yml configurations and connection commands.

DockerDocker ComposeRedis
0 likes · 8 min read
Build a Redis Cluster with Docker Compose and Use It in SpringBoot
macrozheng
macrozheng
Mar 27, 2020 · Backend Development

Why @Transactional Fails: 6 Common Pitfalls and How to Fix Them

This article explains the purpose of Spring's @Transactional annotation, details its configurable attributes, and enumerates six typical scenarios—such as non‑public methods, wrong propagation settings, self‑invocation, and unsupported database engines—that cause the annotation to become ineffective, providing code examples and solutions.

@TransactionalAOPBackend
0 likes · 12 min read
Why @Transactional Fails: 6 Common Pitfalls and How to Fix Them
Architecture Digest
Architecture Digest
Mar 26, 2020 · Databases

MySQL Pagination Optimization Techniques and Performance Testing

This article examines various MySQL pagination methods—including simple LIMIT, offset impact, sub‑query, ID‑range, and temporary‑table strategies—provides detailed performance measurements on a table with over five million rows, and offers practical recommendations for speeding up large‑scale data retrieval.

MySQLOptimizationPerformance
0 likes · 8 min read
MySQL Pagination Optimization Techniques and Performance Testing
Liangxu Linux
Liangxu Linux
Mar 23, 2020 · Databases

10 Essential Redis Best Practices Every Developer Should Follow

This article presents ten practical Redis best‑practice guidelines—from avoiding the costly KEYS * command and leveraging SCAN, to using INFO for command statistics, employing hashes, setting expirations, selecting eviction policies, handling errors, scaling with clusters, understanding threading limits, and configuring Sentinel for high availability.

PerformanceRedisbest practices
0 likes · 9 min read
10 Essential Redis Best Practices Every Developer Should Follow
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Mar 22, 2020 · Backend Development

Common Reasons Why Spring @Transactional May Not Work

This article explains several typical pitfalls that cause Spring's @Transactional annotation to be ineffective, such as unsupported database engines, unmanaged service beans, internal method calls, non‑public methods, default rollback rules, and missing transaction manager configuration, and provides practical solutions for each case.

AOPBackendJava
0 likes · 4 min read
Common Reasons Why Spring @Transactional May Not Work
21CTO
21CTO
Mar 18, 2020 · Databases

Master MySQL: Key Differences, Index Types, and Performance Tips

This article explains the distinctions between UNION and UNION ALL, TRUNCATE and DELETE, TIMESTAMP and DATETIME, introduces composite and covering indexes, describes InnoDB versus MyISAM storage, the left‑most prefix rule, monotonic primary keys, int display length, SHOW INDEX fields, handling LIKE patterns, and efficient pagination techniques.

MySQLSQLdatabase
0 likes · 14 min read
Master MySQL: Key Differences, Index Types, and Performance Tips
Programmer DD
Programmer DD
Mar 17, 2020 · Databases

10 Essential Redis Tips to Boost Performance and Reliability

This article presents ten practical Redis best‑practice tips—including avoiding KEYS *, using SCAN, monitoring command stats, leveraging hashes, setting expirations, choosing eviction policies, handling errors, scaling with clusters, understanding threading, and configuring Sentinel—for improved performance, stability, and high availability.

Performancebest practicesdatabase
0 likes · 9 min read
10 Essential Redis Tips to Boost Performance and Reliability
ITPUB
ITPUB
Mar 16, 2020 · Databases

MySQL Essentials: UNION vs UNION ALL, TRUNCATE vs DELETE, Index Types Explained

This article explains core MySQL concepts, comparing UNION and UNION ALL, TRUNCATE versus DELETE, TIMESTAMP and DATETIME, composite and covering indexes, the left‑most prefix rule, clustered vs non‑clustered indexes, prefix indexes, InnoDB vs MyISAM storage, monotonic primary keys, column length display, SHOW INDEX fields, LIKE pattern pitfalls, and efficient pagination techniques.

MySQLOptimizationPerformance
0 likes · 15 min read
MySQL Essentials: UNION vs UNION ALL, TRUNCATE vs DELETE, Index Types Explained
Liangxu Linux
Liangxu Linux
Mar 15, 2020 · Databases

Master MySQL Indexes: Differences, Composite Strategies & Performance Hacks

This guide explains essential MySQL concepts such as the distinction between UNION and UNION ALL, TRUNCATE versus DELETE, TIMESTAMP versus DATETIME, the purpose and benefits of composite indexes, index storage engines, prefix indexes, covering indexes, the left‑most prefix rule, and efficient pagination techniques.

MySQLOptimizationPerformance
0 likes · 15 min read
Master MySQL Indexes: Differences, Composite Strategies & Performance Hacks
Java Backend Technology
Java Backend Technology
Mar 13, 2020 · Backend Development

Idempotency Strategies: Preventing Duplicate Operations in High‑Traffic Systems

Idempotency ensures that repeated execution of an operation yields the same result as a single execution, and this article explains its importance in backend systems, outlines concepts, and presents practical techniques such as unique indexes, token mechanisms, pessimistic and optimistic locks, distributed locks, and API design for reliable, duplicate‑free processing.

Backend DevelopmentTokendatabase
0 likes · 9 min read
Idempotency Strategies: Preventing Duplicate Operations in High‑Traffic Systems
Programmer DD
Programmer DD
Mar 13, 2020 · Databases

10 Essential Redis Best Practices Every Developer Should Follow

This article presents ten practical Redis best‑practice recommendations—from avoiding the costly KEYS * command and using SCAN, to leveraging hashes, setting key expirations, choosing appropriate eviction policies, handling errors, scaling with clusters, and ensuring high availability—helping developers optimize performance and reliability.

Performancebest practicesdatabase
0 likes · 9 min read
10 Essential Redis Best Practices Every Developer Should Follow
Efficient Ops
Efficient Ops
Mar 5, 2020 · Databases

Inside MySQL InnoDB: Unveiling Architecture, Memory Structures, and Transaction Mechanics

This article provides a comprehensive overview of MySQL InnoDB's internal architecture, covering its memory and disk structures, buffer pool, change buffer, adaptive hash index, log buffer, various tablespace types, page layout, undo and redo logs, double‑write buffer, transaction isolation levels, and how the engine satisfies ACID properties.

ACIDBuffer PoolInnoDB
0 likes · 32 min read
Inside MySQL InnoDB: Unveiling Architecture, Memory Structures, and Transaction Mechanics
Wukong Talks Architecture
Wukong Talks Architecture
Mar 3, 2020 · Databases

Using JDBC in Spring Boot: Dependency Setup, DataSource Configuration, Auto‑Configuration, JdbcTemplate, Swagger Integration, and Common Troubleshooting

This tutorial explains how to integrate JDBC into a Spring Boot project, covering Maven dependencies, MySQL driver setup, application.yml datasource configuration, Spring Boot's auto‑configuration mechanism, JdbcTemplate usage, Swagger documentation, CRUD endpoint implementation, and solutions to typical connection errors.

Auto-configurationJDBCJdbcTemplate
0 likes · 12 min read
Using JDBC in Spring Boot: Dependency Setup, DataSource Configuration, Auto‑Configuration, JdbcTemplate, Swagger Integration, and Common Troubleshooting
Liangxu Linux
Liangxu Linux
Feb 22, 2020 · Backend Development

Generate Spring Boot CRUD Code Instantly with EasyCode Plugin

This guide walks through installing the EasyCode IntelliJ plugin, setting up a MySQL database, configuring a Spring Boot project, adding necessary Maven dependencies and application.yml settings, and using EasyCode to automatically generate CRUD code for the defined tables.

Code GenerationIntelliJ PluginLombok
0 likes · 6 min read
Generate Spring Boot CRUD Code Instantly with EasyCode Plugin
Liangxu Linux
Liangxu Linux
Feb 18, 2020 · Databases

Master MySQL Transactions, Indexes, and Locking: From ACID to Large‑Table Optimization

This guide explains MySQL fundamentals—including what a database is, transaction concepts and ACID properties, isolation levels and their effects, index structures and the left‑most prefix rule, storage engine differences, lock algorithms, and practical techniques for optimizing large tables such as partitioning and sharding.

MySQLPerformance OptimizationTransactions
0 likes · 23 min read
Master MySQL Transactions, Indexes, and Locking: From ACID to Large‑Table Optimization
Architects Research Society
Architects Research Society
Jan 22, 2020 · Databases

How to Install PostgreSQL 12 on CentOS 7 and CentOS 8

This step‑by‑step guide explains how to add the PostgreSQL Yum repository, install PostgreSQL 12 client and server packages, initialize and start the database service, set the admin password, optionally enable remote access, and install the pgAdmin 4 web interface on CentOS 7 or 8 systems.

CentOSInstallationLinux
0 likes · 11 min read
How to Install PostgreSQL 12 on CentOS 7 and CentOS 8
Efficient Ops
Efficient Ops
Jan 16, 2020 · Databases

Designing the Underworld’s Hell‑DBMS: How Myth Meets Massive Data

This whimsical yet technically detailed article explores how a mythic Hell‑DBMS could be architected, covering unique identifiers, massive concurrent writes, batch processing, NoSQL tree‑structured storage, disaster recovery, and a real‑world demo project that brings the underworld’s life‑and‑death ledger to life.

big-datadatabasemythology
0 likes · 12 min read
Designing the Underworld’s Hell‑DBMS: How Myth Meets Massive Data
Big Data Technology & Architecture
Big Data Technology & Architecture
Jan 15, 2020 · Databases

Understanding and Using Hash Join in MySQL 8.0

This article explains the concept of Hash Join in MySQL 8.0, compares it with Nested Loop joins, shows how to enable or force it with server variables or hints, and presents performance benchmarks that demonstrate its speed advantages on large datasets.

Hash JoinMySQLQuery Optimization
0 likes · 12 min read
Understanding and Using Hash Join in MySQL 8.0
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 14, 2020 · Databases

MySQL 8.0.19 Maintenance Release – New Features and Improvements

MySQL 8.0.19 introduces InnoDB ReplicaSet, Router enhancements, numerous SQL syntax additions, optimizer improvements, new Information Schema role views, security features, replication options, X Protocol compression, and a range of deprecations and bug fixes, providing a comprehensive update for database administrators and developers.

InnoDBMySQLReplication
0 likes · 12 min read
MySQL 8.0.19 Maintenance Release – New Features and Improvements
Programmer DD
Programmer DD
Jan 13, 2020 · Databases

Unveiling MyBatis Transaction Mechanics: From JDBC to Real‑World Scenarios

This article demystifies MyBatis transaction handling by clarifying the true JDBC transaction methods, explaining Spring's propagation concepts, detailing the MyBatis Transaction and TransactionFactory interfaces, showcasing code examples, and exploring special cases such as auto‑commit nuances and connection‑pool interactions.

ConnectionPoolJDBCJava
0 likes · 10 min read
Unveiling MyBatis Transaction Mechanics: From JDBC to Real‑World Scenarios
Java Architecture Diary
Java Architecture Diary
Jan 6, 2020 · Databases

How to Install and Use the Redis 6.0 Cluster Proxy

This guide explains the new Redis 6.0 cluster proxy feature, its purpose, and provides step‑by‑step instructions for installing, starting, and connecting to the proxy, including required GCC upgrades and example commands for a smooth setup.

BackendCluster‑ProxyInstallation
0 likes · 2 min read
How to Install and Use the Redis 6.0 Cluster Proxy
Laravel Tech Community
Laravel Tech Community
Jan 3, 2020 · Backend Development

Laravel Session Management: Configuration, Drivers, and Usage

This guide explains how Laravel handles session storage across HTTP requests, covering configuration files, built‑in drivers such as file, cookie, database, Memcached and Redis, custom driver creation, and common session operations like retrieving, storing, flashing, and regenerating IDs, with code examples throughout.

BackendLaravelPHP
0 likes · 12 min read
Laravel Session Management: Configuration, Drivers, and Usage
Efficient Ops
Efficient Ops
Jan 2, 2020 · Operations

When a Database Outage Turns Into a Comedy of Errors: A Real‑World Ops Tale

A chaotic incident‑response story shows how a DBA and SA scramble through VPN glitches, broken jump servers, log hunting, ad‑hoc config tweaks, unexpected bugs, security scans, and frantic firefighting to finally restore a production system, highlighting the messy reality of modern operations.

DevOpsSQLTroubleshooting
0 likes · 4 min read
When a Database Outage Turns Into a Comedy of Errors: A Real‑World Ops Tale
Senior Brother's Insights
Senior Brother's Insights
Dec 25, 2019 · Backend Development

Ensuring Idempotency in Distributed Systems: Strategies and Best Practices

The article explains why idempotent operations are essential in high‑traffic systems, defines idempotency, and presents a comprehensive set of techniques—including unique indexes, token validation, pessimistic and optimistic locking, distributed locks, select‑plus‑insert patterns, state‑machine design, and API safeguards—to guarantee consistent outcomes even under repeated requests.

Optimistic Lockdatabasedistributed lock
0 likes · 9 min read
Ensuring Idempotency in Distributed Systems: Strategies and Best Practices
MaGe Linux Operations
MaGe Linux Operations
Dec 24, 2019 · Backend Development

Build a Full‑Stack Zhihu Hot List: From Scraper to Mini‑App API

This tutorial walks through creating an end‑to‑end Zhihu hot‑list project that scrapes the billboard page, stores the data with Flask‑SQLAlchemy, schedules periodic updates, exposes RESTful APIs, and finally displays the results in a uni‑app mini‑program with interactive charts.

APIFlaskdatabase
0 likes · 11 min read
Build a Full‑Stack Zhihu Hot List: From Scraper to Mini‑App API
dbaplus Community
dbaplus Community
Dec 23, 2019 · Databases

How to Deploy, Scale, and Monitor ClickHouse for High‑Performance Big Data Analytics

This article explains ClickHouse's deployment architecture, read‑write separation, shard expansion steps, write‑batch strategies, a three‑layer monitoring model, and its practical application in Tencent's game analytics platform, offering concrete guidance for building a stable, high‑throughput analytics service.

Game Analyticsbig datadatabase
0 likes · 21 min read
How to Deploy, Scale, and Monitor ClickHouse for High‑Performance Big Data Analytics
Cloud Native Technology Community
Cloud Native Technology Community
Dec 23, 2019 · Databases

MongoDB Architect’s Talk on Cloud‑Native Data Challenges and Solutions at CNBPS 2019

In his CNBPS 2019 keynote, MongoDB architect Song Zhiqi discusses how the shift to cloud‑native architectures has amplified data volume and variety, outlines the key challenges such as rapid rollout, downtime, and unstructured data, and explains how MongoDB’s flexible, high‑availability document model addresses these issues while supporting modern micro‑service and Kubernetes ecosystems.

Cloud NativeMongoDBNoSQL
0 likes · 8 min read
MongoDB Architect’s Talk on Cloud‑Native Data Challenges and Solutions at CNBPS 2019
ITPUB
ITPUB
Dec 17, 2019 · Databases

Mastering LEFT JOIN: Common Pitfalls and Practical Solutions

This article explains the fundamentals of LEFT JOIN in SQL, illustrates one‑to‑one, one‑to‑many, and many‑to‑many scenarios, compares ON versus WHERE conditions, and provides concrete MySQL and Hive examples with code snippets and visual diagrams to avoid common mistakes.

HiveJoin TypesLEFT JOIN
0 likes · 14 min read
Mastering LEFT JOIN: Common Pitfalls and Practical Solutions
dbaplus Community
dbaplus Community
Dec 15, 2019 · Databases

10 MySQL Techniques to Sort Custom Role Levels (Make 2 > 3)

This article tackles the challenge of ordering hard‑coded role levels in a MySQL table by presenting ten distinct SQL solutions—including adding a helper column, using FIELD, FIND_IN_SET, CASE, subqueries, UNION, hash‑based formulas, and custom arithmetic—so that a "vice‑manager" (level 2) can be ranked above a "manager" (level 3).

Custom OrderMySQLSQL
0 likes · 10 min read
10 MySQL Techniques to Sort Custom Role Levels (Make 2 > 3)
Java Captain
Java Captain
Dec 12, 2019 · Databases

Redis Memory Limits, Configuration, and Eviction Policies (LRU & LFU)

This article explains how to set Redis's maximum memory usage via configuration files or commands, describes the built‑in eviction strategies including noeviction, allkeys‑lru, volatile‑lru, allkeys‑random, volatile‑random, volatile‑ttl, and shows how to query and change these policies, while also covering LRU fundamentals, a Java LRU cache example, Redis's approximate LRU implementation, its 3.0 optimizations, and the newer LFU eviction algorithm.

JavaLFULRU
0 likes · 10 min read
Redis Memory Limits, Configuration, and Eviction Policies (LRU & LFU)
Architecture Digest
Architecture Digest
Dec 10, 2019 · Databases

Using Redis SCAN to Safely Enumerate Keys Instead of KEYS

The article explains why using the KEYS command on large Redis datasets can cause service blockage and demonstrates how the SCAN command with MATCH and COUNT options provides a non‑blocking, incremental way to list keys, including syntax and practical examples.

CursorKEYSPerformance
0 likes · 5 min read
Using Redis SCAN to Safely Enumerate Keys Instead of KEYS
Programmer DD
Programmer DD
Dec 9, 2019 · Backend Development

How to Ensure Idempotency in Distributed Systems: Strategies and Code Examples

This article explains the importance of idempotent operations in backend systems, defines the concept, and presents practical techniques such as unique indexes, token mechanisms, pessimistic and optimistic locking, distributed locks, state‑machine design, and API patterns, complete with code snippets and diagrams.

BackendTokendatabase
0 likes · 10 min read
How to Ensure Idempotency in Distributed Systems: Strategies and Code Examples
ITPUB
ITPUB
Dec 4, 2019 · Databases

Essential SQL Server Commands: From Basic CRUD to Advanced Replication and Automation

This comprehensive guide covers fundamental SQL Server operations such as creating databases, tables, indexes, and views, advanced techniques like set operators, subqueries, and linked servers, plus step‑by‑step instructions for replication, backup, compression, and automated synchronization using stored procedures and SQL Agent jobs.

Linked ServerReplicationSQL
0 likes · 27 min read
Essential SQL Server Commands: From Basic CRUD to Advanced Replication and Automation
Java Backend Technology
Java Backend Technology
Nov 21, 2019 · Databases

Boost MySQL Performance: 8 Proven Tricks to Slash Query Times

This article examines common MySQL performance pitfalls such as inefficient LIMIT usage, implicit type conversion, suboptimal joins, mixed sorting, and unpushed predicates, and demonstrates eight practical rewriting techniques—including using max values, JOINs, WITH clauses, and early range reduction—to dramatically accelerate query execution.

MySQLSQL optimizationdatabase
0 likes · 7 min read
Boost MySQL Performance: 8 Proven Tricks to Slash Query Times
Qunar Tech Salon
Qunar Tech Salon
Nov 20, 2019 · Databases

Redis Expiration Mechanisms and Key Deletion Strategies

This article explains how Redis manages key expiration using EXPIRE, PEXPIRE, EXPIREAT, and PEXPIREAT commands, details the internal expires dictionary, demonstrates code examples for setting, retrieving, and removing TTL, and discusses the lazy and periodic deletion strategies along with their impact on persistence and replication.

Key DeletionLazy DeletionRedis
0 likes · 22 min read
Redis Expiration Mechanisms and Key Deletion Strategies
21CTO
21CTO
Nov 18, 2019 · Backend Development

Building a Scalable Like System with Spring Cloud, Redis, and Quartz

This article explains how to design and implement a high‑frequency like/unlike feature for large social platforms using Spring Cloud, Redis caching, MySQL persistence, and Quartz scheduled jobs, covering Redis setup, data modeling, service interfaces, database schema, and periodic data synchronization.

RedisSpringBootdatabase
0 likes · 19 min read
Building a Scalable Like System with Spring Cloud, Redis, and Quartz
ITPUB
ITPUB
Nov 15, 2019 · Databases

How Oracle Uses Cache, Buffer, and Write‑Back to Keep Data Consistent

The article explains the differences between cache and buffer, how Oracle’s log buffer and data buffer cache interact with various storage‑level caches, and why write‑back, battery‑backed caches, RAID and disk cache settings are crucial for maintaining data consistency during power loss.

OracleStorageWrite-Ahead Logging
0 likes · 6 min read
How Oracle Uses Cache, Buffer, and Write‑Back to Keep Data Consistent
AntTech
AntTech
Nov 13, 2019 · Databases

Evolution of Alipay’s Technical Architecture for Double 11 (2009‑2023): From SOFA to OceanBase and Cloud‑Native

This article chronicles Alipay’s engineering journey from 2009 to the present, detailing how its distributed middleware, database sharding, load‑balancing, LDC, OceanBase, cloud‑native Service Mesh, big‑data and blockchain technologies have been continuously refined to support ever‑growing Double 11 transaction volumes.

database
0 likes · 12 min read
Evolution of Alipay’s Technical Architecture for Double 11 (2009‑2023): From SOFA to OceanBase and Cloud‑Native
21CTO
21CTO
Nov 7, 2019 · Databases

How to Automate MySQL & MariaDB Backups on Jelastic PaaS

This guide explains how to create automated backup plans for MySQL and MariaDB databases on Jelastic PaaS, covering script configuration, cron scheduling, remote storage options, and restoring backups through phpMyAdmin, ensuring data safety and easy recovery.

CronJelasticMariaDB
0 likes · 7 min read
How to Automate MySQL & MariaDB Backups on Jelastic PaaS