I'm struggling with the time synchronization of the PD servers, can't figure out a good way to guarantee the precision of it. Does anyone know the answers to the above two questions?
1
There are 1 best solutions below
Related Questions in TIDB
- How to set tidb global system variables in filesystem
- In TiDB how do you work around the issue where even for indexes, you can't write continuous values to avoid hotspots?
- For TiDB, does incremental value in secondary index cause hotspots too?
- Does TiDB's range based sharding nature have actual read workload benefits?
- In TiDB, how to use snowflake style uuid without causing hot spot by doing bit reverse?
- How to work around TiCDC atomic transactional limitations?
- How does the tide-operator start a pd cluster?
- Error P1001: Unable to reach database server when following Prisma's Start from Scratch guide for relational databases with Node.js and MySQL
- Flink: binlog transformation to multiple DTO and transformation method in flink
- What are the effects of rolling updates TiDB？
- What are the semantics of not using "FTWL to guarantee that the dump file is consistent with metadata"?
- tidb - how to solve node_exporter up timeout
- Error GC life time is shorter than transaction duration while writing to TiDB using Spark
- How to model "dimension" tables in TiDB?
- Why reverseSeek not supported in tikv?
Related Questions in TIDB-PD
- How does the tide-operator start a pd cluster?
- Is the number of replicas in each Region configurable? If yes, how to configure it?
- Why the `etcd cluster ID mismatch` message is displayed when starting PD?
- How to check the health status of the whole TiDB cluster?
- TIKV java client on MacOS: Failed to init client for PD cluster
- Increased replication in TiKV cluster, but storage use did not increase after applying
- `ERROR 9001 (HY000): PD server timeoutstart timestamp may fall behind safepoint` in TiDB
- Why the modified `toml` configuration for TiKV/PD does not take effect?
- How to delete the monitoring data of a cluster node that is offline?
- Couldn't connect to the PD Server using `127.0.0.1` in TiDB
- How precise does the time synchronization of a PD cluster need to be? What happens if the time in the PD servers is not consistent?
- About the number of machines in rolling update of TiDB
- Is it safe to restart servers for maintenance in tikv cluster?
- how to remove ghost peers from a failed TiDB scale-in operation
- How do I connect existing TiKV nodes to a new cluster of PDs in TiDB?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
It's recommended to use NTP to guarantee the time synchronization of PD servers, because the current time synchronization precision that NTP achieves can satisfy the time synchronization requirement of PD servers.
Inconsistent time in the PD servers might produce a smaller TSO after switching the leader, and thus applying for TSO is temporarily out of service. On the application level, it returns an error code.
Theoretically, the smaller of the tolerance for time synchronization error of PD, the better. During leader changes, if the clock goes back, the process won't proceed until it catches up with the previous leader. PD can tolerate any synchronization error, but a larger error value means a longer period of service stop during the leader change.