BestHub
Sign in
Tagged articles

Binlog

288 articles · Page 3 of 3
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Oct 26, 2020 · Databases

Understanding MySQL Binlog, Undo Log, Redo Log, and Change Buffer

This article provides a comprehensive overview of MySQL’s logging mechanisms—including Binlog, Undo log, Redo log, and Change Buffer—explaining their concepts, roles in replication and crash‑recovery, recording formats, flush timing, two‑phase commit, checkpoint handling, and how they interact during data modifications.

BinlogChange BufferDatabase Internals
0 likes · 22 min read
Understanding MySQL Binlog, Undo Log, Redo Log, and Change Buffer
Programmer DD
Programmer DD
Oct 14, 2020 · Databases

Master MySQL Binlog, Redo Log, and Undo Log: Complete Guide

This article explains MySQL’s essential logging mechanisms—binlog, redo log, and undo log—covering their purposes, formats, configuration parameters, flushing strategies, and roles in replication, recovery, and transaction atomicity, while comparing their differences and illustrating concepts with diagrams.

BinlogDatabase LoggingInnoDB
0 likes · 11 min read
Master MySQL Binlog, Redo Log, and Undo Log: Complete Guide
ITPUB
ITPUB
Sep 8, 2020 · Databases

Understanding MySQL Binlog, Redo Log, and Undo Log: Ensuring Data Consistency

This article explains the three core MySQL logs—binlog, redo log, and undo log—their structures, formats, configuration parameters, and how they work together to provide replication, crash recovery, and transactional atomicity while balancing performance and consistency.

BinlogRedo LogTransaction Log
0 likes · 11 min read
Understanding MySQL Binlog, Redo Log, and Undo Log: Ensuring Data Consistency
Efficient Ops
Efficient Ops
Aug 9, 2020 · Databases

How ClickHouse Replicates MySQL in Real-Time: A Step‑by‑Step Guide

This article explains how ClickHouse can act as a MySQL replica, covering full and incremental synchronization, supported MySQL versions, DDL compatibility, handling of DELETE/UPDATE events, the underlying binlog mechanism, and provides complete code examples to set up both MySQL master and ClickHouse slave.

BinlogClickHouseMaterializeMySQL
0 likes · 11 min read
How ClickHouse Replicates MySQL in Real-Time: A Step‑by‑Step Guide
Big Data Technology & Architecture
Big Data Technology & Architecture
Jul 26, 2020 · Databases

Overview of Canal, Maxwell, Databus, and Alibaba Cloud DTS for MySQL Binlog‑Based Change Data Capture

This article introduces several MySQL binlog-based change data capture solutions—including Canal, Maxwell, Databus, and Alibaba Cloud's Data Transmission Service—explaining their principles, architecture, features, and usage considerations for incremental data subscription and processing.

BinlogCanalChange Data Capture
0 likes · 6 min read
Overview of Canal, Maxwell, Databus, and Alibaba Cloud DTS for MySQL Binlog‑Based Change Data Capture
ITPUB
ITPUB
Jul 18, 2020 · Databases

Why MySQL 5.7 Auto‑Increment Duplicates After Upgrade and How to Diagnose It

After upgrading a MySQL 5.6 master to 5.7, inserts on several InnoDB tables began failing with duplicate‑key errors because the auto_increment value became inconsistent, and the article walks through kernel‑level investigation, reproduction steps, bug analysis, and practical fixes.

BinlogBug AnalysisDuplicate Key
0 likes · 11 min read
Why MySQL 5.7 Auto‑Increment Duplicates After Upgrade and How to Diagnose It
Java Backend Technology
Java Backend Technology
May 26, 2020 · Backend Development

How to Build Scalable Operation Logs: AOP vs Binlog Implementation

This article examines common operation‑log types and compares two implementation approaches—traditional AOP with annotations and a database binlog‑based solution—detailing their advantages, drawbacks, code examples, database design, future enhancements, and practical deployment considerations.

AOPBinlogLogging
0 likes · 10 min read
How to Build Scalable Operation Logs: AOP vs Binlog Implementation
iQIYI Technical Product Team
iQIYI Technical Product Team
May 22, 2020 · Databases

Understanding MySQL Binlog, Redo Log, and Two‑Phase Commit for Event‑Driven Order Processing

The article explains how iQIYI’s order system leverages MySQL binlog and redo log with a two‑phase commit to drive event‑driven processing, reveals hidden consistency gaps where binlog events can precede database state, and proposes retry or direct binlog consumption strategies to ensure reliable order fulfillment.

BinlogEventDrivenRedoLog
0 likes · 15 min read
Understanding MySQL Binlog, Redo Log, and Two‑Phase Commit for Event‑Driven Order Processing
vivo Internet Technology
vivo Internet Technology
May 20, 2020 · Databases

Understanding MySQL Crash‑Safe Mechanism: WAL, Redo/Undo/Binlog, Two‑Phase and Group Commit, and Recovery Process

MySQL achieves crash‑safe durability by employing a write‑ahead log architecture that records changes in redo, undo, and binary logs, coordinates them through two‑phase and group commit to maintain order, and uses a structured recovery process to replay or roll back transactions after any failure.

BinlogCrash SafetyGroup Commit
0 likes · 17 min read
Understanding MySQL Crash‑Safe Mechanism: WAL, Redo/Undo/Binlog, Two‑Phase and Group Commit, and Recovery Process
JavaEdge
JavaEdge
May 17, 2020 · Databases

Mastering MySQL High Availability: Backup, Binlog, and Replication Strategies

This guide explains how to achieve MySQL high availability and scalability through full and incremental backups, binlog-based point‑in‑time recovery, and both asynchronous and synchronous replication, while highlighting trade‑offs, best practices, and practical command examples.

BinlogHigh Availabilitybackup
0 likes · 11 min read
Mastering MySQL High Availability: Backup, Binlog, and Replication Strategies
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 9, 2020 · Databases

Why Xtrabackup’s GTID Mismatch Happens: Deep Dive into MySQL 5.7 & 8.0 Backups

This article analyses why the GTID information recorded by Xtrabackup’s xtrabackup_binlog_info file can differ from the GTID shown by SHOW MASTER STATUS after a restore, comparing the behavior of Xtrabackup 2.4 on MySQL 5.7 and Xtrabackup 8.0 on MySQL 8.0, and explains the underlying backup processes and MySQL internals that cause the discrepancy.

BinlogGTIDXtraBackup
0 likes · 14 min read
Why Xtrabackup’s GTID Mismatch Happens: Deep Dive into MySQL 5.7 & 8.0 Backups
Mafengwo Technology
Mafengwo Technology
Feb 28, 2020 · Backend Development

How We Achieve Real‑Time MySQL‑to‑Elasticsearch Sync with Binlog and Kafka

This article explains how a large e‑commerce platform replaced a MySQL‑centric intermediate table with a binlog‑driven pipeline that streams changes through Kafka into Elasticsearch, ensuring ordered, complete, and low‑latency data synchronization while addressing schema evolution and operational monitoring.

BinlogData synchronizationElasticsearch
0 likes · 11 min read
How We Achieve Real‑Time MySQL‑to‑Elasticsearch Sync with Binlog and Kafka
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 21, 2020 · Databases

Root Cause Analysis of MySQL Crash Triggered by Binlog Errors When the Root Partition Is Full

The article investigates a MySQL crash caused by binlog errors due to a full '/' partition, explains why the error leads to server abort, demonstrates reproducing the issue with large transactions, traces the problem to the my_write function in the source code, and offers mitigation strategies such as reducing transaction size or expanding the temporary directory space.

BinlogCrashdebugging
0 likes · 13 min read
Root Cause Analysis of MySQL Crash Triggered by Binlog Errors When the Root Partition Is Full
Big Data Technology & Architecture
Big Data Technology & Architecture
Feb 10, 2020 · Big Data

Real‑time MySQL Binlog Capture with Canal: Principles, Architecture, Deployment and Comparison with Maxwell

This article explains how to use Alibaba's Canal to capture MySQL binlog changes in real time, covering its underlying protocol, component architecture, HA design with ZooKeeper, configuration steps, deployment examples, and a detailed comparison with alternative tools such as Maxwell and mysql_streamer.

Big DataBinlogCanal
0 likes · 17 min read
Real‑time MySQL Binlog Capture with Canal: Principles, Architecture, Deployment and Comparison with Maxwell
Ziru Technology
Ziru Technology
Sep 6, 2019 · Backend Development

How Alibaba Canal Enables Real-Time MySQL Binlog Replication and Incremental Data Sync

Canal, an open‑source Alibaba project, mimics MySQL slave behavior to subscribe to binlog events, parses them, and supports both standalone and ZooKeeper‑coordinated cluster deployments, offering flexible state storage, message processing pipelines, and integration options such as TCP, Kafka, and RocketMQ for real‑time data synchronization.

BinlogCanalData Replication
0 likes · 11 min read
How Alibaba Canal Enables Real-Time MySQL Binlog Replication and Incremental Data Sync
dbaplus Community
dbaplus Community
Sep 3, 2019 · Backend Development

How We Built Real-Time MySQL-to-Elasticsearch Sync with Binlog and Kafka

To meet growing e‑commerce search demands, the team replaced a MySQL‑based intermediate table with a real‑time binlog‑driven pipeline that streams changes through Kafka into Elasticsearch, detailing design choices, ordering and completeness guarantees, custom modules, and monitoring for sub‑second sync latency.

BinlogData synchronizationElasticsearch
0 likes · 13 min read
How We Built Real-Time MySQL-to-Elasticsearch Sync with Binlog and Kafka
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 2, 2019 · Databases

Understanding MySQL Write‑Set Based Parallel Replication and Last‑Commit Handling

This article explains MySQL's write‑set based parallel replication, detailing how writeset hashes are generated, stored in a historical map, and used to adjust the last‑commit value for improved parallel replay, including configuration parameters, code examples, and the impact of different dependency‑tracking modes.

BinlogDatabase InternalsTransaction Dependency
0 likes · 15 min read
Understanding MySQL Write‑Set Based Parallel Replication and Last‑Commit Handling
Mafengwo Technology
Mafengwo Technology
Jul 11, 2019 · Backend Development

How We Achieved Near‑Real‑Time MySQL‑to‑Elasticsearch Sync Using Binlog and Kafka

This article explains why traditional MySQL queries no longer meet the growing e‑commerce data needs, describes the limitations of a MySQL‑to‑Elasticsearch intermediate table, and details a binlog‑driven, Kafka‑based pipeline with custom modules, upsert handling, filtering, and monitoring to ensure fast, reliable data synchronization.

BinlogElasticsearchbackend
0 likes · 11 min read
How We Achieved Near‑Real‑Time MySQL‑to‑Elasticsearch Sync Using Binlog and Kafka
dbaplus Community
dbaplus Community
Jul 2, 2019 · Databases

Mastering Multi-Active Data Centers: Solving MySQL Data Sync Loops

This article explains the concepts of unitization and multi‑active data centers, analyzes the drawbacks of single‑IDC deployments, and provides a detailed guide on implementing MySQL binlog synchronization while addressing common challenges such as data loops, duplicate inserts, unique‑index conflicts, and DDL handling, including practical solutions like GTID and auxiliary tables.

BinlogData synchronizationDatabase Architecture
0 likes · 24 min read
Mastering Multi-Active Data Centers: Solving MySQL Data Sync Loops
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 25, 2019 · Databases

Performance Analysis of MySQL Row‑Based Binlog Replay for Large Table Delete without WHERE Clause

The article investigates why a DELETE without a WHERE clause on a 500k‑row MySQL table takes over ten hours to replay on a slave, analyzes row‑mode binlog replay mechanisms, compares different slave_rows_search_algorithms, presents test results, and offers practical recommendations for improving replication performance.

Binlogdatabasemysql
0 likes · 10 min read
Performance Analysis of MySQL Row‑Based Binlog Replay for Large Table Delete without WHERE Clause
37 Interactive Technology Team
37 Interactive Technology Team
Jun 21, 2019 · Databases

Understanding MySQL Flashback: Principles, Tools, and Pseudo GTID

MySQL Flashback leverages the ROW‑format binary log to generate inverse DML statements—turning deletes into inserts, updates into reverse updates, and inserts into deletes—while tools parse WriteRows, UpdateRows, and DeleteRows events, using injected Pseudo GTID markers to delimit change ranges and enable automated rollback despite DDL limitations.

BinlogBinlog ParsingDatabase Recovery
0 likes · 6 min read
Understanding MySQL Flashback: Principles, Tools, and Pseudo GTID
JD Retail Technology
JD Retail Technology
Apr 18, 2019 · Big Data

Data Heterogeneity with BinLake, Binlog, and Flink: Approaches for Order, Subscription, and Product Data

The article explains how data heterogeneity is achieved using JD's BinLake to capture MySQL binlogs, with Flink handling sequential and parallel consumption for order, subscription, and product data, discussing challenges such as ordering guarantees, idempotency, IO overhead, and the shift toward stream‑processing architectures.

BinlogElasticsearchFlink
0 likes · 5 min read
Data Heterogeneity with BinLake, Binlog, and Flink: Approaches for Order, Subscription, and Product Data
Youzan Coder
Youzan Coder
Apr 17, 2019 · Big Data

Order Data Synchronization Architecture at YouZan: From MySQL to ES and HBase

YouZan’s order data synchronization moves changes from MySQL through Canal‑parsed binlogs into a message queue, then uses sequential SeqNo‑based optimistic locking and HBase’s column‑version timestamps to guarantee ordering for both single‑ and multi‑table updates, while a Logstash‑style configurable pipeline feeds ES for search and HBase for detail queries, eliminating ordered‑queue bottlenecks and ensuring high‑throughput consistency.

BinlogCanalData synchronization
0 likes · 12 min read
Order Data Synchronization Architecture at YouZan: From MySQL to ES and HBase
Youzan Coder
Youzan Coder
Mar 27, 2019 · Databases

MySQL Slave Crash-Safe Feature Analysis

The article examines MySQL 5.6’s crash‑safe slave replication, explaining how earlier versions’ unsafe relay‑log handling could corrupt position data, describing the atomic update of mysql.slave_relay_log_info via table‑based relay‑log info and transaction coordination, and covering configuration options, recovery behavior, GTID implications, performance trade‑offs, and implementation guidance.

BinlogCrash SafeGTID
0 likes · 9 min read
MySQL Slave Crash-Safe Feature Analysis
Java Backend Technology
Java Backend Technology
Mar 21, 2019 · Databases

Why Does MySQL Skip Redundant UPDATEs in ROW Binlog Mode?

This article tests whether MySQL re‑executes an UPDATE that sets a row to its existing values, comparing the behavior under binlog_format=ROW with binlog_row_image=FULL versus binlog_format=STATEMENT, and explains why redundant updates are ignored in ROW mode.

BinlogInnoDBRow
0 likes · 3 min read
Why Does MySQL Skip Redundant UPDATEs in ROW Binlog Mode?
Java High-Performance Architecture
Java High-Performance Architecture
Mar 4, 2019 · Databases

Data Heterogeneity Explained: Sharding, Query Dimensions & MySQL Binlog with Canal

This article introduces the concept of data heterogeneity in large-scale systems, explains how sharding creates query challenges, describes query‑dimension and aggregation heterogeneity, and details implementation techniques such as subscribing to MySQL binlog and using Alibaba’s Canal for reliable data synchronization and storage.

BinlogCanalData synchronization
0 likes · 7 min read
Data Heterogeneity Explained: Sharding, Query Dimensions & MySQL Binlog with Canal
ITPUB
ITPUB
Dec 10, 2018 · Big Data

How Meituan Syncs MySQL to Hive in Real-Time Using Binlog, Canal, and Camus

This article explains Meituan's architecture for accurately and efficiently moving MySQL data into a Hive data warehouse by capturing binlog streams with Canal, transporting them via Kafka, and restoring them offline with Camus and a merge process that handles inserts, updates, and deletes.

BinlogHivekafka
0 likes · 14 min read
How Meituan Syncs MySQL to Hive in Real-Time Using Binlog, Canal, and Camus
JD Tech
JD Tech
Oct 10, 2018 · Backend Development

Design and Architecture of JD's Virtual Order Center (Hamal)

The article explains the architecture and core mechanisms of JD's Virtual Order Center, describing how the Hamal service leverages MySQL binlog listening, Zookeeper coordination, fast TCP‑based consumption, read‑write separation, and multi‑level search to reliably process billions of virtual orders.

BinlogHigh Availabilitybackend
0 likes · 7 min read
Design and Architecture of JD's Virtual Order Center (Hamal)
System Architect Go
System Architect Go
Aug 4, 2018 · Databases

Synchronizing MySQL Data to Elasticsearch: Methods and Practices

This article reviews various approaches for keeping MySQL data in sync with Elasticsearch, including direct business‑layer hooks, independent synchronization via plugins or custom scripts, and real‑time binlog subscription using tools like zongji, while discussing their advantages, drawbacks, and implementation details.

BinlogData synchronizationElasticsearch
0 likes · 4 min read
Synchronizing MySQL Data to Elasticsearch: Methods and Practices
Tencent Database Technology
Tencent Database Technology
May 15, 2018 · Databases

Improving MySQL Asynchronous Replication by Aligning Read_Master_Log_Pos with Exec_Master_Log_Pos

This article analyzes a MySQL master‑crash scenario where mismatched Read_Master_Log_Pos and Exec_Master_Log_Pos prevent HA failover, explains binlog event structures, and proposes updating Read_Master_Log_Pos only after a full transaction is received to ensure reliable asynchronous replication.

AsynchronousBinlogExec_Master_Log_Pos
0 likes · 9 min read
Improving MySQL Asynchronous Replication by Aligning Read_Master_Log_Pos with Exec_Master_Log_Pos
ITPUB
ITPUB
Jan 18, 2018 · Operations

How to Build Real‑Time User Login Dashboards with MySQL Binlog & Logtail

This guide walks through enabling MySQL binlog, installing Logtail, configuring data collection, indexing, previewing logs, writing custom SQL queries for user login analysis, constructing real‑time dashboards, setting abnormal‑login alerts, and backing up data to OSS for long‑term storage.

AlertingBinlogdashboard
0 likes · 10 min read
How to Build Real‑Time User Login Dashboards with MySQL Binlog & Logtail
21CTO
21CTO
Jul 10, 2017 · Operations

How I Rescued a Production MySQL Database After a Fatal rm -rf Disaster

After a mistaken rm -rf command wiped an entire production server—including MySQL data—the author chronicles a step‑by‑step recovery using ext3grep, custom scripts, and binlog restoration, highlighting lessons learned and best practices for future incident handling.

BinlogData RecoveryLinux
0 likes · 9 min read
How I Rescued a Production MySQL Database After a Fatal rm -rf Disaster
dbaplus Community
dbaplus Community
Apr 25, 2017 · Databases

9 Proven MySQL Data Recovery Techniques Every DBA Should Know

This guide outlines nine practical MySQL recovery methods—including full backup with binlog, business‑logic rollback, flashback tools, innodb_force_recovery, tablespace discard/import, manual ibd editing, extundelete, and Percona's recovery utility—to help DBAs restore data after accidental deletions, corruption, or hardware failures.

BinlogData RecoveryInnoDB
0 likes · 12 min read
9 Proven MySQL Data Recovery Techniques Every DBA Should Know
Qunar Tech Salon
Qunar Tech Salon
Apr 6, 2017 · Databases

Understanding Timestamp and exec_time in MySQL Binlog Events

This article explains how MySQL binlog timestamps are derived from the THD start_time, why all events in a transaction share the same timestamp, how exec_time is calculated, and demonstrates the effect of autocommit and manual commit on binlog timing through concrete examples and source code analysis.

BinlogGTIDTransaction
0 likes · 10 min read
Understanding Timestamp and exec_time in MySQL Binlog Events
MaGe Linux Operations
MaGe Linux Operations
Mar 27, 2017 · Databases

Recover MySQL Data with Binlog: A Step‑by‑Step Guide

This tutorial walks you through locating MySQL binlog files, extracting the faulty statements, converting the logs into SQL scripts, and safely restoring the database while handling duplicates, emphasizing the importance of backups before any operation.

BinlogData Recoverysql script
0 likes · 5 min read
Recover MySQL Data with Binlog: A Step‑by‑Step Guide
ITPUB
ITPUB
Oct 13, 2016 · Databases

MySQL Nontransactional Statements Explained: Effects on binlog Cache Parameters

The article clarifies that nontransactional statements are SQL commands operating on non‑transactional tables such as MyISAM, explains how MySQL parameters max_binlog_stmt_cache_size and max_binlog_cache_size control memory for these statements, and demonstrates the difference with transactional InnoDB tables through concrete command‑line examples.

BinlogInnoDBMyISAM
0 likes · 4 min read
MySQL Nontransactional Statements Explained: Effects on binlog Cache Parameters
ITPUB
ITPUB
Sep 24, 2016 · Databases

Recover a Dropped MySQL Database Using Full Backup and Binlog Incrementals

This guide shows how to restore a MySQL database that was accidentally dropped by combining a nightly full mysqldump backup (with master‑log info) and the subsequent binlog files, extracting only the needed statements and replaying them in order.

BinlogData Recoverybackup
0 likes · 8 min read
Recover a Dropped MySQL Database Using Full Backup and Binlog Incrementals
dbaplus Community
dbaplus Community
Sep 6, 2016 · Databases

Migrating 130 MySQL Instances to Tencent Cloud CDB: Key Lessons and Tips

An experienced Tencent Cloud engineer shares a detailed case study of moving over 130 MySQL instances (20 TB) from on‑premise IDC to CDB for MySQL, covering test cases, migration tool mechanics, multi‑instance concurrency, binlog handling, encountered issues, and practical solutions that ensured a smooth, high‑availability transition.

BinlogCDBMaster‑Slave
0 likes · 10 min read
Migrating 130 MySQL Instances to Tencent Cloud CDB: Key Lessons and Tips
Efficient Ops
Efficient Ops
May 29, 2016 · Databases

Recover Accidentally Deleted MySQL/MariaDB Data with Binlog Flashback

This article explains how to simulate a flashback feature for MySQL and MariaDB by parsing binlogs, allowing you to restore tables after accidental DELETE or UPDATE operations without relying on full backups, and provides step‑by‑step commands and precautions.

BinlogData RecoveryDatabase Administration
0 likes · 6 min read
Recover Accidentally Deleted MySQL/MariaDB Data with Binlog Flashback
ITPUB
ITPUB
Apr 11, 2016 · Databases

Why a MySQL Replica Core Hits 100% CPU and How Adding a Primary Key Fixes It

A MySQL replica was consuming an entire CPU core due to single‑process replication, and analysis of binlog and InnoDB status revealed heavy row locks on a table without a primary key, which was resolved by adding an auto‑increment ID, dropping CPU usage to 3% and eliminating replication lag.

BinlogCPUInnoDB
0 likes · 5 min read
Why a MySQL Replica Core Hits 100% CPU and How Adding a Primary Key Fixes It
ITPUB
ITPUB
Mar 17, 2016 · Databases

Why MySQL Relay Log Settings Cause Duplicate Key Errors and How to Fix Them

The article explains how MySQL replication parameters such as expire_logs_days, relay-log-recovery, and relay-log-info-repository affect binlog cleanup, SQL and I/O thread consistency, and why crashes can produce duplicate‑key errors, then offers configuration fixes including the critical relay‑log cleaning option and the super_read_only setting.

BinlogData ConsistencyDatabase Configuration
0 likes · 5 min read
Why MySQL Relay Log Settings Cause Duplicate Key Errors and How to Fix Them
Architect
Architect
Feb 25, 2016 · Databases

Understanding MySQL 5.6 Parallel Replication (MTS) Architecture and Implementation

This article explains the design, configuration parameters, core data structures, initialization, coordinator distribution, worker execution, checkpointing, and shutdown procedures of MySQL 5.6's Multi‑Threaded Slave (MTS) parallel replication, providing a code‑level walkthrough for developers and DBAs.

BinlogCheckpointMTS
0 likes · 17 min read
Understanding MySQL 5.6 Parallel Replication (MTS) Architecture and Implementation
dbaplus Community
dbaplus Community
Jan 21, 2016 · Databases

How MySQL Parallel Replication Evolved: From 5.5 to 5.7 and Beyond

This article examines the evolution of MySQL parallel replication across versions 5.5, 5.6, MariaDB, and 5.7, comparing their threading strategies, binlog handling, performance trade‑offs, and practical deployment considerations for reducing replication lag.

Binlogmysqlparallel-replication
0 likes · 14 min read
How MySQL Parallel Replication Evolved: From 5.5 to 5.7 and Beyond