Tagged articles
6 articles
Page 1 of 1
Aikesheng Open Source Community
Aikesheng Open Source Community
May 30, 2024 · Databases

OceanBase Single-Node Deployment, Configuration, and Performance Comparison with MySQL

This article provides a comprehensive guide to installing and configuring OceanBase single-node (centralized) clusters, explains primary‑standby tenant architectures, details performance benchmarking against MySQL using sysbench and fio, and offers recommended resource settings and diagnostic procedures for optimal operation.

Database ConfigurationMySQL ComparisonOceanBase
0 likes · 22 min read
OceanBase Single-Node Deployment, Configuration, and Performance Comparison with MySQL
IT Services Circle
IT Services Circle
Feb 8, 2024 · Databases

TiDB Overview: Architecture, Core Features, and Performance Compared with MySQL

The article explains why traditional MySQL sharding is discouraged, introduces the distributed database TiDB, details its architecture, core capabilities such as HTAP and Raft‑based consistency, compares feature support and resource usage with MySQL, and presents benchmark results demonstrating TiDB’s advantages at large scale.

HTAPMySQL ComparisonRaft
0 likes · 12 min read
TiDB Overview: Architecture, Core Features, and Performance Compared with MySQL
Top Architect
Top Architect
Jul 17, 2023 · Databases

Using Redis as a Database: Python Code Samples and Comparison with MySQL

This article provides Python code examples for using Redis as a database—including connection, basic CRUD, list and sorted set operations, key expiration, publishing/subscribing, distributed locking, and caching—followed by a detailed comparison of Redis and MySQL across data model, persistence, query capabilities, performance, scalability, and transaction support.

MySQL ComparisonPubSubPython
0 likes · 11 min read
Using Redis as a Database: Python Code Samples and Comparison with MySQL
DeWu Technology
DeWu Technology
Dec 16, 2022 · Databases

TiDB Adoption and Operational Practices at Dewu

Dewu transitioned from a single‑instance MySQL setup to a distributed TiDB architecture—using three TiDB, PD, and TiKV/TiFlash nodes, automated backups, Prometheus monitoring, and chaos‑engineering controls—which delivered linear scalability, eliminated slow queries, cut infrastructure costs by about 58 % and maintained stable performance during major sales events.

MySQL ComparisonTiDBdistributed database
0 likes · 28 min read
TiDB Adoption and Operational Practices at Dewu
dbaplus Community
dbaplus Community
Dec 17, 2018 · Databases

Exploring MongoDB 4.0 Multi-Document ACID Transactions vs MySQL

MongoDB 4.0 introduces multi‑document ACID transactions with snapshot isolation, supporting replica sets and WiredTiger, and this article explains ACID concepts, outlines limitations, demonstrates session commands, and compares transaction behavior—including conflict detection, repeatable reads, and phantom reads—to MySQL’s implementation.

ACID TransactionsMongoDBMySQL Comparison
0 likes · 10 min read
Exploring MongoDB 4.0 Multi-Document ACID Transactions vs MySQL