How do I view a read-only instance in TencentDB for SQL Server?
1. Log in to the TencentDB for SQL Server console. In the instance list, instances with an R tag are read-only instances. Click the ID of a read-only instance or Manage in the Operation column to enter its details page. 2. On the primary instance details page, you can enter the read-only instance details page from the topology diagram of the primary instance.
Note：
Some features on the read-only instance details page cannot be modified, which actually displays the configurations of the corresponding primary instance. If necessary, you can modify them on the primary instance details page. For details, see Managing Read-Only Instance. Does TencentDB for SQL Server support read/write separation?
Yes. TencentDB for SQL Server doesn't support unified read/write separation addresses, that is, read and write requests are separated automatically. Currently, the read-only instance needs to be accessed through a separate IP and port. After creating a read-only instance, you need to configure the connection addresses for both the primary instance and each read-only instance in your application. This configuration allows you to send write requests to the primary instance and read requests to the read-only instances. For more information, see Read-Only Instance Overview. How do I create a read-only instance in TencentDB for SQL Server?
1. Log in to the TencentDB for SQL Server console. In the instance list, click the ID of an instance or Manage in the Operation column to enter its details page. 2. Click Add Read-Only Instance in the Instance Architecture Diagram on the instance details page or click Create on the Read-Only Instance page to enter the purchase page. For more information, see Managing Read-Only Instances. How do I create an RO group in TencentDB for SQL Server?
TencentDB for SQL Server allows you to create one or multiple read-only instances to form an RO group, which is suitable for read/write separation and one-primary-multiple-replica scenarios and capable of greatly enhancing the read load capacity of your database. For more information, see Read-Only Group. How long is the sync delay between the TencentDB for SQL Server primary and read-only instances?
SQL Server versions earlier than 2017 adopt replication sync, which has a delay of 3–5 seconds. If you use the Always On read-only replica feature of SQL Server 2017 and 2019, the sync delay will be 1–2 seconds.
Is there any difference between the read-only instances of various versions? How do I select the version of TencentDB for SQL Server if a read-only feature is required?
Read-only instances vary by version. If your business requires read-only instances, we recommend that you choose instances on v2017 or later for the following reasons:
On versions earlier than 2017, the publish/subscribe mode is used to create read-only instances, and data can be synced at the object level with a delay of 3–5 seconds. To use read-only instances, we recommend that you upgrade the primary instance to v2017 or later first in order to guarantee an efficient and stable data sync.
In the two-node architecture (formerly high availability/cluster edition) on 2017 Enterprise and later versions, the Always On mode is used to create read-only instances, and data sync is more efficient and stable with a delay of 1–2 seconds.
Can I use accounts created in the primary instance in read-only instances?
Accounts created in the primary instance will be synced to read-only instances but cannot be managed there. They support only read but not write operations in read-only instances.
How many read-only instances can I create for a TencentDB for SQL Server primary instance at most?
You can create up to five read-only instances for a primary instance. To create more, submit a ticket for assistance. Does TencentDB for SQL Server support data migration to read-only instances?
No.
Do TencentDB for SQL Server read-only instances support database creation/deletion?
No. If needed, do so in the primary instance.
Do TencentDB for SQL Server read-only instances support account creation/deletion?
Read-only instances don't support account creation/deletion/authorization or account name/password change. If needed, do so in the primary instance.
Do TencentDB for SQL Server read-only instances support backup and rollback?
No. If needed, do so in the primary instance.
Do I need to enable load rebalancing after customizing weights in TencentDB for SQL Server?
Modifying weight will only affect new loads if rebalancing is disabled. The operation has no impact on read-only instances accessed by existing persistent connections and does not cause momentary database disconnection. If rebalancing is enabled, all connections to the database will be temporarily disconnected, and the loads of newly added connections will be balanced according to the set weights. You can choose whether to enable load balancing again as needed.