Discover | BestHub

Quick starts observability distributed systems platform engineering kubernetes golang raft

Results

Matches for “mysql”

1000 results

Databases May 9, 2025 Code Ape Tech Column

Efficient Strategies for Importing One Billion Records into MySQL

This article explains how to import 1 billion 1 KB log records stored in HDFS or S3 into MySQL by analyzing single‑table limits, using batch inserts, choosing storage engines, sharding, optimizing file‑reading methods, and coordinating distributed tasks with Redis, Redisson, and Zookeeper to ensure ordered, reliable, and high‑throughput data loading.

Distributed SystemsRedisKafkaPerformance TuningMySQLBatch InsertData Import

Backend Development May 8, 2025 php中文网 Courses

Using mysqli_fetch_assoc to Retrieve Query Results in PHP

This tutorial demonstrates how to connect to a MySQL database in PHP using mysqli_connect, execute queries with mysqli_query, and retrieve each row as an associative array using mysqli_fetch_assoc, providing complete code examples and a full script for efficient backend data handling.

backendSQLDatabaseMySQLPHPmysqli

Databases May 8, 2025 Architect's Guide

An Overview of TiDB: NewSQL Distributed Database Architecture, Features, and MySQL Compatibility

This article provides a comprehensive introduction to TiDB, a NewSQL distributed database, covering its origins, core components, high‑availability design, NewSQL characteristics, differences from traditional SQL and NoSQL, compatibility with MySQL, configuration nuances, and typical use cases such as HTAP and cloud‑native deployments.

Cloud NativeDistributed DatabaseTiDBHTAPNewSQLMySQL Compatibility

Big Data May 7, 2025 Top Architect

Using DataX for Efficient MySQL Data Synchronization

This article provides a comprehensive guide on using Alibaba's open‑source DataX tool for efficient offline synchronization between heterogeneous databases such as MySQL, covering its architecture, installation on Linux, job configuration, full‑ and incremental data transfer, and practical code examples.

Big DataMySQLData SynchronizationDataXETL

Databases May 7, 2025 Top Architecture Tech Stack

Why Store IPv4 Addresses as UNSIGNED INT in MySQL: Benefits, Drawbacks, and Conversion Methods

The article explains that storing IPv4 addresses as a 32‑bit UNSIGNED INT in MySQL reduces storage and index size, speeds up range queries, and provides built‑in conversion functions, while also noting readability drawbacks and offering Java conversion examples.

JavaMySQLIP addressconversionINET_ATONUNSIGNED INT

Big Data May 6, 2025 Architecture Digest

Using DataX for Efficient Data Synchronization Between MySQL Databases

This article explains how to employ Alibaba's open‑source DataX tool to perform fast, reliable full‑ and incremental data synchronization between MySQL instances, covering installation, framework design, job execution, and practical shell commands for Linux environments.

Big DataLinuxMySQLData SynchronizationDataXETLShell

Databases May 6, 2025 Aikesheng Open Source Community

Using GDB to Adjust MySQL max_connections Without Restart

This article explains how to troubleshoot and resolve the MySQL "Too many connections" error by using GDB to modify the max_connections parameter on a running MySQL 5.7 instance without restarting, including step‑by‑step commands, sysbench load testing, and two practical methods.

MySQLtroubleshootingGDBdatabase tuningsysbenchmax_connections

Databases May 5, 2025 Selected Java Interview Questions

Implementing Coupon Template Retrieval by Product ID in MySQL: Fuzzy Search vs Multi-Value Index

This article explains how to retrieve coupon templates linked to a specific product ID in MySQL, comparing a simple fuzzy‑search approach with a more accurate and performant multi‑value JSON index solution, and provides step‑by‑step SQL code examples.

JSONMySQLDatabase OptimizationFuzzy SearchMulti-Value IndexCoupon Template

Databases May 4, 2025 Java Captain

Evolution of MySQL, Rise of NoSQL, and In‑Depth Redis Data Types and Usage

This article traces MySQL’s architectural evolution from single‑node to sharded clusters, explains the fundamentals and classifications of NoSQL databases, and provides a comprehensive guide to Redis—including installation, memory management, and detailed usage of its five core data types with best‑practice considerations.

DatabaseRedisCachingMySQLData StructuresNoSQL

Backend Development May 4, 2025 Java Captain

Migrating MySQL Data to Elasticsearch: Full Sync, Incremental Sync, Consistency Issues, and Using Canal

This article explains how to migrate MySQL table data to Elasticsearch using a one‑time full sync, a scheduled incremental sync, addresses strong consistency challenges, and introduces Alibaba's Canal framework for reliable binlog‑based data replication.

BackendData MigrationElasticsearchMySQLCanalSync

Previous Page 7 Next