Mengkueri status dan konfigurasi instans replikasi native.
Deskripsi operasi
Mesin yang berlaku
ApsaraDB RDS for MySQL
Dokumentasi terkait
Coba sekarang
Test
RAM authorization
Parameter permintaan
|
Parameter |
Type |
Required |
Description |
Example |
| RegionId |
string |
Yes |
ID wilayah. Anda dapat memanggil DescribeRegions untuk mengkueri ID wilayah. |
cn-hangzhou |
| DBInstanceId |
string |
Yes |
ID instans. Anda dapat memanggil DescribeDBInstances untuk mengkueri ID instans. |
rm-uf6wjk5**** |
| ResourceGroupId |
string |
No |
ID kelompok sumber daya. Parameter ini dapat dikosongkan. |
rg-acfmx**** |
Elemen respons
|
Element |
Type |
Description |
Example |
|
object |
Parameter tanggapan. |
||
| RequestId |
string |
ID permintaan. |
847BA085-B377-4BFA-8267-F82345ECE1D2 |
| ExternalReplication |
string |
Apakah mode replikasi native diaktifkan. Nilai valid:
|
ON |
| ReplicationSource |
string |
Sumber replikasi native. |
192.168.XX.XX |
| ReplicationState |
string |
Status replikasi saat ini. Nilai valid:
|
Stopped |
| ReplicationDelay |
string |
Latensi replikasi saat ini, dalam detik. |
0 |
| ReplicationErrorMessage |
string |
Paket error replikasi. |
Got fatal error 1236 from master when reading data from binary log... |
| ReplicationIp |
string |
Alamat IP titik akhir replikasi. |
192.168.10.x |
| ReplicationPort |
string |
Port titik akhir replikasi. |
3306 |
| GtidExecuted |
string |
Pengenal transaksi global yang telah dieksekusi. |
bd2a34b9-8b8d-11ef-8917-00163e1298b9:1-20567 |
| ImportStatus |
string |
Status impor, yang menunjukkan apakah data penuh berhasil diimpor. |
COMPLETED |
| SlaveStatusList |
array<object> |
[{"SlaveIoRunning": "Yes", "SlaveSqlRunning": "Yes", "SecondsBehindMaster": 0, "SlaveIoState": "Waiting for master to send event", "SlaveSqlRunningState": "Slave has read all relay log; waiting for more updates", "ExecutedGtidSet": "bd2a34b9-8b8d-11ef-8917-00163e1298b9:1-20567", "MasterHost": "192.168.10.100", "MasterUser": "repl_user", "MasterUuid": "bd2a34b9-8b8d-11ef-8917-00163e1298b9", "LastErrno": 0, "LastSqlErrno": 0, "LastIoErrno": 0, "LastSqlError": "", "LastIoError": "", "ChannelName": "my_test_channel", "ReplicateDoDb": "test_db,test_db_1", "ReplicateIgnoreDb": "information_schema,performance_schema", "ReplicateDoTable": "test_table,test_table_1", "ReplicateIgnoreTable": "temp_table,temp_table_1", "ReplicateWildDoTable": "test_table.%", "ReplicateWildIgnoreTable": "temp_table.%"}] |
|
|
object |
|||
| SlaveIoRunning |
string |
Yes: Berjalan. No: Berhenti. |
Yes |
| SlaveSqlRunning |
string |
Yes: Berjalan. No: Berhenti. |
Yes |
| SecondsBehindMaster |
integer |
0 |
|
| SlaveIoState |
string |
Waiting for master to send event |
|
| SlaveSqlRunningState |
string |
Slave has read all relay log; waiting for more updates |
|
| ExecutedGtidSet |
string |
bd2a34b9-8b8d-11ef-8917-00163e1298b9:1-20567 |
|
| MasterHost |
string |
192.168.10.100 |
|
| MasterUser |
string |
repl_user |
|
| MasterUuid |
string |
bd2a34b9-8b8d-11ef-8917-00163e1298b9 |
|
| LastErrno |
integer |
0 menunjukkan tidak ada error. Nilai lain menunjukkan kode error tertentu. |
0 |
| LastSqlErrno |
integer |
0 menunjukkan tidak ada error. Nilai lain menunjukkan kode error thread SQL. |
0 |
| LastIoErrno |
integer |
0 menunjukkan tidak ada error. Nilai lain menunjukkan kode error thread I/O. |
0 |
| LastSqlError |
string |
Paket error thread SQL. |
|
| LastIoError |
string |
Paket error thread I/O. |
|
| ChannelName |
string |
my_test_channel |
|
| ReplicateDoDb |
string |
test_db,test_db_1 |
|
| ReplicateIgnoreDb |
string |
information_schema,performance_schema |
|
| ReplicateDoTable |
string |
test_table,test_table_1 |
|
| ReplicateIgnoreTable |
string |
temp_table,temp_table_1 |
|
| ReplicateWildDoTable |
string |
test_table.% |
|
| ReplicateWildIgnoreTable |
string |
temp_table.% |
Contoh
Respons sukses
JSONformat
{
"RequestId": "847BA085-B377-4BFA-8267-F82345ECE1D2",
"ExternalReplication": "ON",
"ReplicationSource": "192.168.XX.XX",
"ReplicationState": "Stopped",
"ReplicationDelay": "0",
"ReplicationErrorMessage": "Got fatal error 1236 from master when reading data from binary log...",
"ReplicationIp": "192.168.10.x",
"ReplicationPort": "3306",
"GtidExecuted": "bd2a34b9-8b8d-11ef-8917-00163e1298b9:1-20567",
"ImportStatus": "COMPLETED",
"SlaveStatusList": [
{
"SlaveIoRunning": "Yes",
"SlaveSqlRunning": "Yes",
"SecondsBehindMaster": 0,
"SlaveIoState": "Waiting for master to send event",
"SlaveSqlRunningState": "Slave has read all relay log; waiting for more updates",
"ExecutedGtidSet": "bd2a34b9-8b8d-11ef-8917-00163e1298b9:1-20567",
"MasterHost": "192.168.10.100",
"MasterUser": "repl_user",
"MasterUuid": "bd2a34b9-8b8d-11ef-8917-00163e1298b9",
"LastErrno": 0,
"LastSqlErrno": 0,
"LastIoErrno": 0,
"LastSqlError": "",
"LastIoError": "",
"ChannelName": "my_test_channel",
"ReplicateDoDb": "test_db,test_db_1",
"ReplicateIgnoreDb": "information_schema,performance_schema",
"ReplicateDoTable": "test_table,test_table_1",
"ReplicateIgnoreTable": "temp_table,temp_table_1",
"ReplicateWildDoTable": "test_table.%",
"ReplicateWildIgnoreTable": "temp_table.%"
}
]
}Kode kesalahan
|
HTTP status code |
Error code |
Error message |
Description |
|---|---|---|---|
| 400 | Order.ComboInstanceNotAllowOperate | A package instance is not allowed to operate independently. | |
| 400 | Price.PricingPlanResultNotFound | Pricing plan price result not found. | |
| 400 | Order.NoRealNameAuthentication | You have not passed the real-name authentication and do not meet the purchase conditions. Please log in to the user center for real-name authentication. | |
| 400 | InsufficientAvailableQuota | Your account quota limit is less than 0, please recharge before trying to purchase. | |
| 400 | CommodityServiceCalling.Exception | Failed to call commodity service. | |
| 400 | RegionDissolvedEOM | Dear customer, Alibaba Cloud plans to optimize and adjust the current region. Cloud services in this region will cease operations. You are currently unable to operate new purchase orders. Thank you for your understanding and support. | |
| 400 | Commodity.InvalidComponent | The module you purchased is not legal, please buy it again. | |
| 400 | RegionEndTimeDissolvedAustralia | Cloud services in the Australia (Sydney) region will be discontinued. Set the validity date to September 30, 2024 or earlier than September 30, 2024. | |
| 400 | Price.CommoditySys | Commodity system call exception. | |
| 400 | Pay.InsufficientBalance | Insufficient available balance. | |
| 400 | Order.PeriodInvalid | There is a problem with the period you selected, please choose again. | |
| 400 | Order.InstHasUnpaidOrder | There is an unpaid order for the service you have purchased. Please pay or void it before placing the order. | |
| 400 | BasicInfoUncompleted | Your information is incomplete. Complete your information before the operation. | |
| 400 | Risk.RiskControlRejection | Your account is abnormal, please contact customer service for details. | |
| 400 | Api.NotSupport | Specified api is not supported. | |
| 400 | ContainForbiddenLabelError | There is a label that prohibits placing orders. Please contact your distributor for assistance. | |
| 400 | InvalidDBInstanceId.NotFound | The DBInstanceId provided does not exist in records. | |
| 400 | InvalidInstanceLevel.DiskType | Specified instance level not support request disk type | |
| 400 | InvalidParam | Sepcified wal level Parameter is invalid. There are still logical slots in instance, so it can not be set as replica. | |
| 400 | KmsApiError | User secret key invalid. | |
| 400 | System.SaleValidateFailed | Sales expression validation system error. | |
| 400 | Abs.InvalidAccount.NotFound | account is not found. | |
| 400 | SqlExecuteFailedOrTimeout | sql command execution failed or timed out:%s. | |
| 400 | ColdData.EngineVersionNotSupport | The current instance engine version not support coldDataEnabled. | |
| 400 | ColdData.MinorVersionNotSupport | The current instance minor version not support coldDataEnabled. | |
| 400 | IncorrectTargetClasscode | The current instance type does not support this operation. | |
| 400 | InvalidConnectionString.Duplicate | Specified connection string already exists in the RDS. | |
| 400 | RequiredParam.NotFound | Required input param is not found. | |
| 400 | Parameters.Invalid | Parameter error, please check the parameters. | |
| 400 | BackupPolicyNotSupport | Cold Data won't open with CrossBackup or Flash Backup, please check Backup Policy. | |
| 400 | InvalideStatus.Format | The instance status does not support this operation. | |
| 400 | InvalidReleasedKeepPolicy.Format | Specified Released Keep Policy is not valid. | |
| 400 | InvalidDBInstanceEngineType.Format | the DB instance engine type does not support this operation. | |
| 400 | Pay.NoCreditCard | No credit cards. | |
| 400 | VpcNetworkTypeNotSupport | The vpc network type instance does not support this operation. | |
| 400 | MirrorInsExists | Specified DB instance mirror ins already existed. | |
| 400 | UnsupportedClassCode | The specified DB instance class stops selling. | |
| 400 | InvalidBackupSet | The specified database does not exist in the backup set. | |
| 400 | OrdTCommodityQueryError | Failed to query for product. | |
| 400 | ProductInstanceReleased | The instance has been released. Please check before placing the order. | |
| 400 | RegionEndTimeDissolvedIndia | The region is no longer supported. | |
| 500 | ExternalFailure | The request processing has failed due to external service failure. | |
| 500 | RequestMetaDataFailed | The service request failed. Please try again later or contact service personnel. | |
| 500 | InvokeProxyFailure | The request processing has failed due to service failure of rds api. | |
| 403 | OrderStatus.UnPaid | The specified db instance has unpaid order. | |
| 403 | InvalidReduceDiskSize | The storage capacity after the scale-down must be larger than the used amount. | |
| 403 | CloudSSDNotSupport | Cloud ssd does not support this operation, please upgrade to essd. | |
| 403 | InvalidUserOperatorPermission | The user permission does not support this operation. | |
| 403 | InvalidVswitchId | Specified conn vswitch id is not valid. | |
| 403 | IncorrectMinorVersion | Current engine minor version does not support operations. | |
| 403 | OperationDenied.ZoneResource | There is no available zone for inventory. | |
| 403 | NotInFlowController | Sorry,no permission. | |
| 403 | InvalidKmsKey | Kms key is disabled. | |
| 403 | InvalidInstanceLevel.Malformed | Current DB instance level does not support this operation. | |
| 403 | IncorrectDBInstanceType | Current DB instance type does not support this operation. | |
| 404 | InvalidClusterKms | The current instance does not authorized to access the Key Management Service. | |
| 404 | Request.NotFound | The requested resource is not available. | |
| 404 | HostInfo.NotFound | The specified host info is not found. | |
| 404 | InvalidReplicationChannel.NotFound | Specified replication channel does not exist. |
Lihat Error Codes untuk daftar lengkap.
Catatan rilis
Lihat Release Notes untuk daftar lengkap.