Tag

MySQL Comparison

1 views collected around this technical thread.

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.

Distributed DatabaseHTAPMySQL Comparison
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.

CachingDatabaseDistributed Lock
0 likes · 11 min read
Using Redis as a Database: Python Code Samples and Comparison with MySQL
Selected Java Interview Questions
Selected Java Interview Questions
Jun 29, 2023 · Databases

Using Redis as a Database: Basic Operations, Advanced Features, and Comparison with MySQL

This article demonstrates how to use Redis as a database with Python code examples for basic operations, advanced features like pub/sub and distributed locks, and compares Redis to MySQL across data model, persistence, query capabilities, performance, scalability, and transaction support.

CachingDatabaseDistributed Lock
0 likes · 11 min read
Using Redis as a Database: Basic Operations, Advanced Features, 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.

Distributed DatabaseMySQL ComparisonOperations
0 likes · 28 min read
TiDB Adoption and Operational Practices at Dewu