Deploying a Test TiDB Cluster: Is This Setup Okay?

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: 部署一套测试的Tidb集群,各位大佬看看这样可以吗

| username: 气死人的萌新

The table is an initial plan, with 1 PD and TiDB sharing, 3 TiKV, and it’s not yet decided whether to add a new node for monitoring or to share. The character set is default utf8mb4, with two collation rules.

| username: Fly-bird | Original post link

For production use, it is recommended to deploy 3 PDs.

| username: 气死人的萌新 | Original post link

Used in testing, write a test case.

| username: 气死人的萌新 | Original post link

Forgot to mention, the version used is 6.5.4.

| username: 气死人的萌新 | Original post link

Is it feasible for monitoring and PD to share a single node?

| username: tidb菜鸟一只 | Original post link

If it’s a test environment, there’s no problem at all. Just put the monitoring on the PD and TiDB nodes.

| username: 气死人的萌新 | Original post link

So, should we follow the standardized deployment for this kind of testing environment, instead of using the quick start method?

| username: tidb菜鸟一只 | Original post link

Just create the cluster normally with your configuration. Tiup playground is only suitable for learning or reproducing specific bug issues.

| username: 气死人的萌新 | Original post link

Okay, thank you, expert.

| username: 气死人的萌新 | Original post link

Hello, may I ask you a question? Can the collation used in TiDB v6.0 and above be changed to MySQL 8.0’s collation? I checked the official documentation but couldn’t find a way to modify it. As shown in the picture, can the default collation of TiDB be changed to utf8mb4_0900_ai_ci?

| username: tidb菜鸟一只 | Original post link

TiDB does not support the utf8mb4_0900_ai_ci collation.

| username: zhanggame1 | Original post link

It’s okay for general testing, but under high load, the TiDB server can’t handle it and needs to be scaled up.

| username: zhanggame1 | Original post link

Wait for the new version at the end of the year, it will support MySQL 8 later.

| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.