- 产品简介
- 购买指南
- 快速入门
- 操作指南（InnoDB）
- 实践教程
- 安全白皮书
- 开发指南
- API 文档
- History
- Introduction
- API Category
- Security Group APIs
- Making API Requests
- TDSQL APIs
- ActiveHourDCDBInstance
- CancelDcnJob
- CloneAccount
- CloseDBExtranetAccess
- CopyAccountPrivileges
- CreateAccount
- CreateDedicatedClusterDCDBInstance
- DeleteAccount
- DescribeAccountPrivileges
- DescribeAccounts
- DescribeDBLogFiles
- DescribeDBParameters
- DescribeDBSlowLogs
- DescribeDBSyncMode
- DescribeDBTmpInstances
- DescribeDCDBInstanceNodeInfo
- DescribeDCDBInstances
- DescribeDCDBPrice
- DescribeDCDBShards
- DescribeDatabaseObjects
- DescribeDatabaseTable
- DescribeDatabases
- DescribeDcnDetail
- DescribeFileDownloadUrl
- DescribeFlow
- DescribeLogFileRetentionPeriod
- DescribeOrders
- DestroyDCDBInstance
- DestroyHourDCDBInstance
- GrantAccountPrivileges
- InitDCDBInstances
- IsolateDedicatedDBInstance
- IsolateHourDCDBInstance
- ModifyAccountDescription
- ModifyDBInstanceName
- ModifyDBInstancesProject
- ModifyDBParameters
- ModifyDBSyncMode
- ModifyInstanceVip
- ModifyInstanceVport
- ResetAccountPassword
- SwitchDBInstanceHA
- TerminateDedicatedDBInstance
- UpgradeDedicatedDCDBInstance
- UpgradeHourDCDBInstance
- CreateDCDBInstance
- CreateHourDCDBInstance
- DescribeDCDBInstanceDetail
- ModifyAccountConfig
- OpenDBExtranetAccess
- IsolateDCDBInstance
- Other APIs
- Data Types
- Error Codes
- 常见问题
- 通用参考
- 词汇表
- 公告
- 联系我们
- 产品简介
- 购买指南
- 快速入门
- 操作指南（InnoDB）
- 实践教程
- 安全白皮书
- 开发指南
- API 文档
- History
- Introduction
- API Category
- Security Group APIs
- Making API Requests
- TDSQL APIs
- ActiveHourDCDBInstance
- CancelDcnJob
- CloneAccount
- CloseDBExtranetAccess
- CopyAccountPrivileges
- CreateAccount
- CreateDedicatedClusterDCDBInstance
- DeleteAccount
- DescribeAccountPrivileges
- DescribeAccounts
- DescribeDBLogFiles
- DescribeDBParameters
- DescribeDBSlowLogs
- DescribeDBSyncMode
- DescribeDBTmpInstances
- DescribeDCDBInstanceNodeInfo
- DescribeDCDBInstances
- DescribeDCDBPrice
- DescribeDCDBShards
- DescribeDatabaseObjects
- DescribeDatabaseTable
- DescribeDatabases
- DescribeDcnDetail
- DescribeFileDownloadUrl
- DescribeFlow
- DescribeLogFileRetentionPeriod
- DescribeOrders
- DestroyDCDBInstance
- DestroyHourDCDBInstance
- GrantAccountPrivileges
- InitDCDBInstances
- IsolateDedicatedDBInstance
- IsolateHourDCDBInstance
- ModifyAccountDescription
- ModifyDBInstanceName
- ModifyDBInstancesProject
- ModifyDBParameters
- ModifyDBSyncMode
- ModifyInstanceVip
- ModifyInstanceVport
- ResetAccountPassword
- SwitchDBInstanceHA
- TerminateDedicatedDBInstance
- UpgradeDedicatedDCDBInstance
- UpgradeHourDCDBInstance
- CreateDCDBInstance
- CreateHourDCDBInstance
- DescribeDCDBInstanceDetail
- ModifyAccountConfig
- OpenDBExtranetAccess
- IsolateDCDBInstance
- Other APIs
- Data Types
- Error Codes
- 常见问题
- 通用参考
- 词汇表
- 公告
- 联系我们
功能简介
当处理大数据量读请求的压力大、要求高时，可以通过读写分离功能将读的压力分布到各个从节点上。
TDSQL MySQL 版默认支持读写分离功能，架构中的每个从机都能支持只读能力，如果配置有多个从机，将由网关集群（TProxy）自动分配到低负载从机上，以支撑大型应用程序的读取流量。
基本原理
读写分离基本的原理是让主节点（Master）处理事务性增、改、删操作（INSERT、UPDATE、DELETE），让从节点（Slave）处理查询操作（SELECT）。
只读账号
说明：
若您的实例架构为一主一从，只读分离功能仅可用作低负载只读任务，请避免大事务等较高负载任务，影响从机备份任务及可用性。
只读账号是一类仅有读权限的账号，默认从数据库集群中的从机（或只读实例）中读取数据。
通过只读账号，对读请求自动发送到备机，并返回结果。
是
否
本页内容是否解决了您的问题？