Relational Database Service
Relational Database Service
Todos os resultados de "
" dentro deste produto
Todos os resultados de "
" dentro deste produto
Visão geral de serviço
O que é o RDS?
Conceitos básicos
Vantagens
Gerenciamento fácil
Desempenho alto
Segurança alta
Confiabilidade alta
Comparação entre bancos de dados do RDS e próprios
Séries do produto
Primeiros passos da instância de banco de dados
Comparação de funções
Funções das versões do RDS for SQL Server
O RDS for SQL Server 2012
O RDS for SQL Server 2014
O RDS for SQL Server 2016
O RDS for SQL Server 2017
O RDS for SQL Server 2019
Diferenças de função entre as edições Web, Standard e Enterprise
Descrição da instância de banco de dados
Tipos de instância de banco de dados
Tipos de armazenamento de instância de banco de dados
Mecanismo de banco de dados e versões
Status de instâncias de banco de dados
Classe de instância de banco de dados
Classes de instância do RDS for MySQL
Classes de instância do RDS for PostgreSQL
Classes de instância do RDS for SQL Server
Casos de usos típicos
Redução da pressão de leitura com a divisão de leitura/gravação do RDS
Armazenamento de diversos tipos de dados com o RDS e outros serviços
Gerenciamento de permissões
Restrições
Restrições do RDS for MySQL
Restrições do RDS for PostgreSQL
Restrições do RDS for SQL Server
Cobrança
Serviços relacionados
Histórico de alterações
Primeiros passos
Primeiros passos com RDS for MySQL
Guia de operação
Passo 1: comprar uma instância de BD
Passo 2: conectar-se a uma instância de BD
Visão geral
Conexão a uma instância de BD do RDS for MySQL por meio do DAS (recomendada)
Conexão a uma instância de BD do RDS for MySQL por meio de uma rede privada
Visão geral
Conexão a uma instância de BD a partir de um ECS do Linux
Conexão a uma instância de BD a partir de um ECS do Windows
Configuração de regras de grupo de segurança
Conexão a uma instância de BD do RDS for MySQL por meio de uma rede pública
Visão geral
Vinculação de um EIP
Conexão a uma instância de BD a partir de um ECS do Linux
Conexão a uma instância de BD a partir de um servidor Windows
Configuração de regras de grupo de segurança
Exemplo: comprar e conectar-se a uma instância de BD do RDS for MySQL
Primeiros passos com RDS for PostgreSQL
Guia de operação
Passo 1: comprar uma instância de BD
Passo 2: conectar-se a uma instância de BD
Visão geral
Conexão a uma instância de BD por meio do DAS (recomendada)
Conexão a uma instância de BD por meio de uma rede privada
Visão geral
Configuração de regras de grupo de segurança
Conexão a uma instância de BD usando psql
Conexão a uma instância de BD por meio de uma rede pública
Visão geral
Vinculação de um EIP
Configuração de regras de grupo de segurança
Conexão a uma instância de BD usando psql
Exemplo: comprar e conectar-se a uma instância de BD do RDS for PostgreSQL
Primeiros passos com RDS for SQL Server
Guia de operação
Passo 1: comprar uma instância de BD
Passo 2: conectar-se a uma instância de BD
Visão geral
Conexão a uma instância de BD por meio do DAS (recomendada)
Conexão a uma instância de BD por meio de uma rede privada
Conexão a uma instância de BD por meio de uma rede privada
Configuração de regras de grupo de segurança
Conexão a uma instância de BD por meio de uma rede privada
Conexão a uma instância de BD por meio de uma rede pública
Conexão a uma instância de BD por meio de uma rede pública
Vinculação de um EIP
Configuração de regras de grupo de segurança
Conexão a uma instância de BD por meio de uma rede pública
Example: comprar and Connect to an RDS for SQL Server DB Instance
História de mudanças
Melhores práticas
Visão geral
RDS for MySQL
Sugestões sobre o uso do RDS for MySQL
Migração de dados de bancos de dados MySQL autogerenciados para RDS for MySQL
Visão geral
Planejamento de recursos
Processo de operação
Migração para a nuvem
Criação de uma instância do RDS
Criação de uma tarefa de migração
Confirmação dos resultados da migração
Configuração de DR monoativa remota para uma instância do RDS for MySQL usando DRS
Visão geral
Planejamento de recursos
Processo de operação
Configuração de uma instância do RDS for MySQL no centro de produção
Criação de uma VPC e um grupo de segurança
Criação de um EIP
Criação de uma instância do RDS for MySQL
Configuração de uma instância do RDS for MySQL no centro de recuperação de desastres
Criação de uma VPC e um grupo de segurança
Criação de uma instância do RDS for MySQL
Configuração da recuperação de desastres remota
Criação de uma tarefa de recuperação de desastres do DRS
Configuração da tarefa de recuperação de desastres
Execução de uma alternância primária/em espera
Migração de bancos de dados MySQL de outras nuvens para RDS for MySQL
Visão geral
Planejamento de recursos
Processo de operação
Criação de uma VPC e um grupo de segurança
Criação de uma instância do RDS for MySQL
Configuração de uma instância do MySQL em outra nuvem
Migração para a nuvem
Criação de uma tarefa de migração do DRS
Verificação dos resultados da migração
Uso do RDS for MySQL para configurar WordPress
Uso do RDS for MySQL para configurar Discuz!
Descrição de innodb_flush_log_at_trx_commit e sync_binlog
Resolução de falhas de operação de banco de dados causadas por bloqueios de metadados no RDS for MySQL
Como usar o conjunto de caracteres utf8mb4 para armazenar emojis em uma instância de BD do RDS for MySQL?
Manipulação de transações longas do RDS for MySQL
Ajuste de desempenho
Identificação do motivo pelo qual o uso da CPU de instâncias de BD do RDS for MySQL é alto e fornecimento de soluções
Ajuste de desempenho do RDS for MySQL – resolução de problemas de armazenamento insuficiente
Ajuste de desempenho do RDS for MySQL – resolução de problemas de alto uso de memória
Ajuste de desempenho do RDS for MySQL – resolução de problemas de I/O alta
Solução de problemas de SQL lentos para instâncias de BD do RDS for MySQL
Melhores práticas de segurança
RDS for PostgreSQL
Criação de bancos de dados
Regras de nomeação de banco de dados
Criação de um banco de dados por meio de DAS
Opções de CREATE DATABASE
Opção de TEMPLATE
Opções de LC_COLLATE e LC_CTYPE
Pergunta frequente
Como exibir os bancos de dados criados e informações dos conjuntos de caracteres, de LC_COLLATE e LC_CTYPE dos bancos de dados?
O que fazer se o conjunto de caracteres não corresponder à localidade durante a criação do banco de dados?
Como criar um banco de dados usando uma interface de linha de comando (CLI)?
Quais são as restrições nos conjuntos de caracteres?
Execução de operações básicas usando pgAdmin
Conexão a uma instância do RDS for PostgreSQL
Criação de um banco de dados
Criação de uma tabela
Uso da Query Tool para executar instruções SQL
Monitoramento de bancos de dados
Backup e restauração de dados
Uso do PoWA
Visão geral
Métricas de desempenho
Métricas de desempenho do banco de dados
Métricas de desempenho da instância
Modelos de implementação do PoWA
Introdução à implementação remota
Configuração da implementação remota
Acesso ao PoWA
Exemplo de uso do PoWA
Outros plug-ins de extensão
Referências de operação
Instalação do Python 3.9.9
Publicações e assinaturas do RDS for PostgreSQL
Exibição de logs de consultas lentas de instâncias de BD do RDS for PostgreSQL
Uso de drivers de cliente para implementar failover e separação de leitura/gravação
Conversão de tipo de dados definida pelo usuário
Melhores práticas de segurança
RDS for SQL Server
Restauração de dados de arquivos de backup para instâncias de BD do RDS Microsoft SQL Server
Migração de dados de um banco de dados do SQL Server autogerenciado em um ECS para uma instância de BD do RDS for SQL Server
Modificação de parâmetros de instâncias do RDS for SQL Server
Suporte a DMVs
Uso da função de importar e exportar para migrar dados de um banco de dados local para uma instância de BD de Microsoft SQL Server do RDS
Criação de uma subconta do rdsuser
Criação de arquivos tempdb
Publicação e assinatura do Microsoft SQL Server
Instalação de um assembly CLR C# no RDS for SQL Server
Criação de um servidor vinculado para uma instância de BD do RDS for SQL Server
Implementação do SQL Server Reporting Services (SSRS) no RDS for SQL Server
Redução de um banco de dados do RDS for SQL Server
Uso do DAS para criar e configurar o trabalho de agente e DBLink nos bancos de dados principal e secundário para instâncias do RDS for SQL Server
Criação um trabalho para manutenção de instância programada
Uso de eventos estendidos
Referência de API
Antes de começar
Visão geral
Chamada de API
Pontos de extremidade
Restrições
Conceitos
Tipos de API
Visão geral de API
Chamada de APIs
Criação de uma solicitação de API
Autenticação
Resposta
API v3 (recomendada)
Consulta de informações de versão sobre APIs
Consulta de versões de API
Consulta de uma versão especificada de API
Consulta de informações de versão sobre um mecanismo de banco de dados
Consulta de especificações de banco de dados
Consulta do tipo de armazenamento de um banco de dados
Gerenciamento de instâncias de banco de dados
Criação de uma instância de banco de dados
Interrompimento de uma instância
Inicialização de uma instância
Alteração de um nome de instância de banco de dados
Alteração da descrição de uma instância de banco de dados
Solicitação de um nome de domínio privado
Modificação de um nome de domínio privado
Alteração de especificações da instância de banco de dados
Expansão do espaço de armazenamento de uma instância de banco de dados
Alteração de uma instância de banco de dados única para instâncias de banco de dados primárias/em espera
Reinicialização de uma instância de banco de dados
Exclusão de uma instância de banco de dados
Consulta de instâncias de banco de dados
Vinculação e desvinculação de um EIP
Alteração da prioridade de failover
Alteração manual de instâncias de banco de dados primárias/em espera
Alteração do modo de replicação de dados de instâncias de banco de dados primárias/em espera
Migração de uma instância de banco de dados em espera
Configuração da janela de manutenção
Atualização de uma versão secundária
Instâncias de DR
Configuração do recurso de DR para uma instância de banco de dados primária
Configuração do recurso de DR para uma instância de DR
Promoção de uma instância de DR para ser a instância de banco de dados primária
Consulta do status de replicação de DR
Segurança de banco de dados
Configuração de SSL
Alteração de uma porta de banco de dados
Alteração de um grupo de segurança
Alteração de um endereço IP flutuante
Configuração de parâmetros
Obtenção de uma lista de modelos de parâmetro
Criação de um modelo de parâmetro
Modificação de um modelo de parâmetro
Aplicação de um modelo de parâmetro
Modificação de parâmetros de uma instância especificada
Obtenção do modelo de parâmetro de uma instância de banco de dados especificada
Obtenção de parâmetros em um modelo de parâmetro especificado
Exclusão de um modelo de parâmetro
Backup e restauração
Definição de uma política de backup automático
Definição de uma política de backup entre regiões
Obtenção de uma política de backup automático
Consulta de informações sobre uma política de backup entre regiões
Criação de um backup manual
Obtenção de backups
Consulta de backups entre regiões
Consulta de instâncias de banco de dados para as quais backups entre regiões são criados
Obtenção do link para baixar um arquivo de backup
Exclusão de um backup manual
Consulta do intervalo de tempo de restauração
Consulta do intervalo de tempo de restauração de um backup entre regiões
Restauração de dados em uma nova instância de banco de dados
Restauração de dados em uma instância de banco de dados existente
Restauração de tabelas para um ponto no tempo especificado (MySQL)
Consultas de informações de log
Consulta de logs de erro de banco de dados
Consulta de logs de erro de banco de dados (MySQL)
Consulta de logs lentos de banco de dados (MySQL)
Mostra de logs originais (RDS for MySQL)
Obtenção de estatísticas de log de consulta lenta
Obtenção de links para download de logs de consulta lenta
Configuração da auditoria do SQL
Consulta da política para logs de auditoria do SQL
Obtenção de uma lista de logs de auditoria
Obtenção do link para baixar um log de auditoria
Definição do período de retenção local de binlogs
Obtenção do período de retenção local de binlogs
Gerenciamento de bancos de dados e contas (MySQL)
Precauções
Criação de um banco de dados
Consulta de detalhes sobre um banco de dados (Descartado)
Consulta de detalhes sobre bancos de dados
Consulta de bancos de dados autorizados de um usuário especificado
Modificação das observações de banco de dados de uma instância de banco de dados especificada
Exclusão de um banco de dados
Criação de uma conta de bancos de dados
Consulta de detalhes sobre um usuário de banco de dados (Descartado)
Consulta de usuários de banco de dados
Consulta de usuários autorizados de um banco de dados especificado
Exclusão de uma conta de banco de dados
Definição de uma senha para uma conta de banco de dados
Autorização de uma conta de banco de dados
Revogação de permissões de uma conta de banco de dados
Redefinição de uma senha para o usuário root
Gerenciamento de bancos de dados e contas (PostgreSQL)
Criação de um banco de dados
Criação de uma conta de banco de dados
Criação de um esquema de banco de dados
Autorização de uma conta de banco de dados
Redefinição de uma senha para uma conta de banco de dados
Consulta de bancos de dados
Consulta de usuários de banco de dados
Consulta de esquemas de banco de dados
Gerenciamento de bancos de dados e contas (Microsoft SQL Server)
Consulta do conjunto de caracteres disponíveis do SQL Server
Criação de um banco de dados
Consulta de bancos de dados
Exclusão de um banco de dados
Criação de uma conta de banco de dados
Consulta de usuários de banco de dados
Consulta de usuários autorizados de um banco de dados especificado
Exclusão de uma conta de banco de dados
Autorização de uma conta de banco de dados
Revogação de permissões de uma conta de banco de dados
Reciclagem de uma instância de banco de dados
Modificação da política de reciclagem
Gerenciamento de tags
Adição de tags em lotes
Exclusão de tags em lotes
Consulta de tags de projeto
Gerenciamento de cotas
Consulta de cotas de recurso
Obtenção de informações de tarefa
Obtenção de informações sobre uma tarefa com um ID especificado
Obtenção de informações de tarefa de uma instância de banco de dados do SQL Server especificada em um intervalo de tempo especificado
API v3 (indisponível em breve)
Consulta de versões de API
Consulta de logs lentos de banco de dados
Restauração de dados para uma instância de banco de dados existente
Aplicação de um modelo de parâmetro
Modificação de parâmetros de uma instância de banco de dados especificada
Exclusão de um banco de dados (RDS for SQL Server)
Proxy de banco de dados (PostgreSQL)
Ativação do proxy de banco de dados
Desativação do proxy de banco de dados
Consulta de informações sobre proxy de banco de dados
Modificação do peso de leitura
Alteração do limite de atraso da divisão de leitura/gravação
Alteração da classe de instância de uma instância de proxy de banco de dados
Consulta de classes de instância disponíveis para uma instância de proxy de banco de dados
Políticas de permissões e ações suportadas
Primeiros passos
Ações do RDS
Apêndice
Resultados anormais da solicitação
Códigos de status
Códigos de erro
Obtenção de um ID de projeto
Modo de replicação
Descrição de métricas de monitoramento do RDS
Histórico de alterações
Perguntas frequentes
Consultoria de produto
O que devo prestar atenção ao usar o RDS?
Qual é a disponibilidade de instâncias de BD do RDS?
Como distinguir entre instâncias de uso geral e dedicadas do RDS for MySQL usando SSDs de nuvem?
Minhas instâncias de BD do RDS serão afetadas pelas instâncias de BD do DDS de outros usuários?
O RDS oferece suporte à alta disponibilidade entre AZs?
As instâncias de BD primárias/em espera do RDS podem ser alteradas para instâncias de BD únicas?
O que fazer sobre a resposta lenta de sites quando eles usam RDS?
Posso alterar o modo de replicação entre instâncias de BD primárias e réplicas de leitura?
Qual é o atraso de tempo para replicação primária/em espera?
Vários ECSs podem se conectar à mesma instância de BD do RDS?
Posso criptografar o disco após comprar uma instância de BD do RDS?
Os backups serão criptografados depois que a criptografia de disco for ativada para minha instância do RDS?
O RDS for MySQL oferece suporte às funções de criptografia?
What Are the Restrictions on RDS for MySQL DB Instances After GTID Is Enabled?
Diferentes instâncias de BD do RDS compartilharão recursos de CPU e memória?
Quantos bancos de dados podem ser executados em uma instância de BD do RDS?
Se RDS for MySQL é compatível com MariaDB?
O RDS for MySQL oferece suporte a TokuDB?
Qual é o tamanho máximo permitido para uma única tabela em instâncias do RDS for MySQL?
Congelamento, liberação, interrupção, exclusão e cancelamento da assinatura de recursos
Gerenciamento de recursos e disco
Quanto tempo leva para criar uma instância de BD?
Quais tipos de logs e arquivos ocupam espaço de armazenamento RDS?
O RDS oferece suporte à redução do espaço de armazenamento de instâncias de BD?
Quais itens ocupam o espaço de armazenamento das instâncias de BD do RDS?
Quanto espaço de armazenamento é necessário para operações DDL?
Como evitar um aumento acentuado no uso do espaço em disco de dados se eu quiser enviar uma grande quantidade de dados para minha instância do RDS for SQL Server em um curto período de tempo?
Conexão de banco de dados
O que fazer se não conseguir me conectar a uma instância de BD do RDS?
Um servidor externo pode acessar o banco de dados do RDS?
O que fazer se o número de conexões de banco de dados do RDS atinge o limite superior?
Qual é o número máximo de conexões com uma instância de BD do RDS?
Como criar e me conectar a um ECS?
O que fazer se um ECS não puder se conectar a uma instância de BD do RDS por meio de uma rede privada?
O que fazer se um problema de cliente de banco de dados causar uma falha de conexão?
O que fazer se um problema no banco de dados do RDS causar uma falha de conexão?
Como minhas aplicações acessam uma instância de BD do RDS em uma VPC?
As aplicações precisam dar suporte à reconexão automática à instância de BD do RDS?
Por que não é possível executar o ping do meu EIP depois que ele está vinculado a uma instância de BD?
Como obter o endereço IP de uma aplicação?
O que fazer se uma instância de BD do RDS for SQL Server não for conectada?
Posso acessar uma instância de BD do RDS em uma conexão de intranet entre regiões?
Uma conexão SSL com uma instância de BD é interrompida após uma alternância ou failover primário/em espera?
Meu acesso será restrito por largura de banda quando me conectar à minha instância de um ECS em uma rede privada?
Por que a nova senha não entrou em vigor depois que redefini a senha do administrador?
Serei desconectado se a conexão às instâncias do RDS for SQL Server expirar?
Como definir o formato de codificação do conjunto de caracteres do MySQL 8.0?
O que fazer se o ECS e o RDS forem implementados em VPCs diferentes e não puderem se comunicar entre si?
Como visualizar todos os endereços IP conectados a um banco de dados?
Posso acessar instâncias de BD do RDS em espera?
Como verificar as conexões com uma instância do RDS for MySQL?
Migração de banco de dados
Por que preciso usar as ferramentas mysqldump ou pg_dump para migração?
O que fazer quando um grande número de arquivos Binlog causa insuficiência de espaço de armazenamento durante uma migração de instância do RDS MySQL?
Quais tipos de mecanismos de BD do RDS oferece suporte para importação de dados?
Permissão do banco de dados
Por que o usuário raiz não tem as super permissões?
Quais são as diferenças entre ManageAccess do RDS e permissões do DAS?
Contas integradas do RDS for MySQL
O RDS for MySQL suporta várias contas?
Vários usuários podem fazer logon no DAS ao mesmo tempo? As contas serão bloqueadas se eu digitar senhas erradas várias vezes seguidas?
Por que não conseguir criar um objeto no banco de dados postgres como um usuário comum?
O que fazer se uma função falhar ao ser excluída de uma instância do RDS for PostgreSQL?
Por que minha migração do RDS for PostgreSQL falhou?
Como conceder a permissão REPLICATION a um usuário de banco de dados RDS for PostgreSQL?
Por que um erro é relatado quando tentar alterar um proprietário de tabela do banco de dados RDS for PostgreSQL?
Como as permissões Login Name das instâncias de BD primárias/em espera do RDS for SQL Server 2017 Enterprise Edition são sincronizadas com suas réplicas de leitura?
Depois que uma conta de instância primária é excluída e recriada no RDS for SQL Server, as permissões serão sincronizadas automaticamente?
Como exibir bancos de dados autorizados depois que um cliente local é conectado a uma instância de BD?
Armazenamento de banco de dados
Quais mecanismos de armazenamento são compatíveis com o RDS for MySQL?
Quais tipos de armazenamento o RDS usa?
O RDS for MySQL oferece suporte a procedimentos e funções armazenados?
O que fazer se meus dados excederem o armazenamento disponível de uma instância do RDS for MySQL?
Como ver o uso de armazenamento da minha instância do RDS?
Onde são armazenados os arquivos de banco de dados criados em minha instância do RDS for SQL Server?
Instalação do cliente
Como instalar o cliente de MySQL?
Como instalar um cliente de PostgreSQL?
Como instalar o SQL Server Management Studio?
Uso do banco de dados
O MySQL 8.0 oferece suporte à pesquisa de texto completo?
Como usar o DAS para consultar instruções SQL?
Como usar a ferramenta mysqlbinlog?
Como exibir IDs de sessão e tempo de logon e logout de um banco de dados?
Como criar uma tarefa agendada?
O que fazer se caracteres ilegíveis forem exibidos após os resultados da consulta SQL serem exportados para um arquivo do Excel?
A operação OPTIMIZE TABLE bloqueia tabelas em uma instância de BD do RDS?
Por que um erro é relatado quando tentar excluir um banco de dados das instâncias de BD primárias/em espera do RDS for SQL Server?
O que fazer se minha conta root foi excluída por engano?
Backup e restauração
Por quanto tempo o RDS armazena dados de backup?
Como limpar o espaço de backup do RDS?
Minha instância ainda pode ser usada na janela de backup?
Como os dados de backup do RDS são cobrados?
Como ver meu uso de armazenamento de backup?
Como fazer backup de um banco de dados do RDS em um ECS?
Os backups serão retidos depois que minha instância do RDS for excluída?
Como recuperar os bancos de dados e tabelas excluídos por engano?
Como os backups não sincronizados são gerados para instâncias de BD do RDS for SQL Server?
Por que meu backup automatizado falhou?
Por que uma tabela ou dados estão faltando no meu banco de dados?
Como restaurar um backup de banco de dados local para RDS?
O RDS for PostgreSQL oferece suporte à tabela PITR?
Posso despejar arquivos de backup para buckets do OBS?
O RDS for MySQL oferece suporte ao backup em nível de tabela para um bucket do OBS especificado?
Posso excluir a política de backup do RDS for MySQL?
Réplicas de leitura e separação de leitura/gravação
O RDS suporta separação de leitura/gravação?
O RDS for MySQL oferece suporte à fragmentação e separação de leitura/gravação?
Posso solicitar vários endereços de separação de leitura/gravação para minha instância do RDS for MySQL?
Monitoramento de banco de dados
Quais métricas de monitoramento de instância de BD precisar prestar atenção?
Como calcular o uso de memória de uma instância de BD do RDS?
Como configurar uma regra de alarme para o atraso de replicação entre instâncias de BD primárias e em espera?
Expansão de capacidade e alteração de especificação
Minhas instâncias de BD do RDS ainda estão disponíveis durante a expansão do armazenamento e a alteração da classe da instância?
Por que a instância de BD se torna defeituosa depois que a porta de banco de dados original é alterada?
Posso alterar a VPC à qual minha instância de BD do RDS pertence?
Modificação de parâmetro de base de dados
Quais configurações de parâmetros inadequadas causam a indisponibilidade do banco de dados RDS for PostgreSQL?
Como alterar o fuso horário?
Como configurar uma política de expiração de senha para instâncias de BD do RDS for MySQL?
Como alterar o nível de isolamento da transação do RDS?
Como garantir que o conjunto de caracteres de um banco de dados RDS MySQL está correto?
O RDS for PostgreSQL oferece suporte ao plug-in test_decoding?
Como usar o conjunto de caracteres utf8mb4 para armazenar emojis em uma instância de BD do RDS for MySQL?
Onde devo armazenar arquivos NDF para RDS for SQL Server?
Posso usar comandos SQL para modificar parâmetros globais?
Como modificar o agrupamento de RDS for SQL Server?
Como definir a diferenciação de maiúsculas e minúsculas para nomes de tabela do RDS for MySQL?
Posso ativar o cache de consulta para minha instância do RDS for MySQL?
Gerenciamento de logs
Quanto tempo é o atraso para logs de consulta lenta do RDS MySQL?
Como visualizar todos os logs de SQL executados pelo RDS for MySQL?
Como obter logs de erros do RDS for SQL Server usando comandos?
Como visualizar os logs de deadlock do RDS for MySQL?
Segurança de rede
Quais políticas de proteção de segurança o RDS possui?
Como a segurança dos dados pode ser garantida durante a transmissão quando eu acesso o RDS através de um EIP?
Como evitar que endereços IP de origem não confiável acessem o RDS?
Como configurar um grupo de segurança para habilitar o acesso a instâncias de BD do RDS?
Como importar o certificado raiz para um sistema operacional Windows ou Linux?
Como identificar o período de validade de um certificado raiz SSL?
Quais são as possíveis causas para a corrupção de dados?
Atualização de versão
Como visualizar a versão de uma instância de BD do RDS?
O RDS for MySQL oferece suporte às atualizações de versão?
O RDS for MySQL suporta downgrades de versão?
O RDS for PostgreSQL oferece suporte a atualizações de versão principais?
APIs e SDKs relacionados ao desenvolvedor
História de mudanças
What's New
Function Overview
Product Bulletin
Vulnerability Notice
Vulnerability Fixing Policies
Product Notices
[Product Discontinuation Notice] RDS for PostgreSQL 12 Will Be Discontinued on May 1, 2025, 00:00:00 GMT+08:00
[Offline Notice] RDS for PostgreSQL 10 and 11 Will Go Offline on November 1, 2024, 00:00:00 GMT+08:00
[Product Discontinuation Notice] RDS for MySQL 5.6 Will Be Discontinued on July 1, 2024, 00:00:00 GMT+08:00
[Product Discontinuation Notice] RDS for PostgreSQL 10 and 11 Will Be Discontinued on July 1, 2024, 00:00:00 GMT+08:00
[Offline Notice] RDS for PostgreSQL 9.5 and 9.6 Will Go Offline on July 1, 2024, 00:00:00 GMT+08:00
[Notice] OBT for Memory Acceleration of RDS for MySQL Starts from May 28, 2024
Product Release Notes
RDS for MySQL Version Release Notes
RDS for MySQL Lifecycle
RDS for MySQL Kernel Release History
RDS for PostgreSQL Version Release Notes
RDS for PostgreSQL Versioning Policy
RDS for PostgreSQL Kernel Release History
RDS for SQL Server Versioning Policy
Billing
Billed Items
Billing Modes
Comparison of Billing Modes
Yearly/Monthly Billing
Pay-per-Use Billing
Billing Examples
Billing Mode Changes
Pay-per-Use to Yearly/Monthly
Yearly/Monthly to Pay-per-Use
Renewing Subscriptions
Manually Renewing a DB Instance
Auto-renewing a DB Instance
Bills
Arrears
Billing Termination
Cost Management
Cost Composition
Cost Allocation
Cost Analysis
Cost Optimization
Kernels
RDS for MySQL Kernel
RDS for MySQL Kernel Version Description
Main Kernel Functions
Connection Thread Pool
MDL Views
Online Varchar Length Increase
Ending Idle Transactions
DDL Progress Display
RDS for PostgreSQL Kernel
RDS for PostgreSQL Kernel Version Description
Main Kernel Functions
Failover Slot for Logical Subscriptions
RDS for MariaDB Kernel
Change History
User Guide
Working with RDS for MySQL
Permissions Management
Creating a User and Granting Permissions
RDS Custom Policies
Buying an RDS for MySQL DB Instance
Instance Connection
Overview
Connecting to an RDS for MySQL Instance Through DAS (Recommended)
Connecting to an RDS for MySQL Instance Through the MySQL CLI Client
Using MySQL CLI to Connect to an Instance Through a Private Network
Using MySQL CLI to Connect to an Instance Through a Public Network
Installing a MySQL Client
Connecting to an RDS for MySQL Instance Through the GUI
Connecting to an RDS for MySQL Instance Through JDBC
Connection Management
Viewing and Changing a Floating IP Address
Applying for and Changing a Private Domain Name
Changing a Database Port
Binding and Unbinding an EIP
Applying for and Changing a Public Domain Name
Configuring a Certificate
Configuring a Security Group Rule
Database Usage
Suggestions on Using RDS for MySQL
Instance Usage Suggestions
Database Usage Suggestions
Database Management
Creating a Database
Modifying Database Remarks
Granting Database Permissions
Deleting a Database
Enabling or Disabling Event Scheduler
Account Management (Non-Administrator)
Creating a Database Account
Resetting a Password for a Database Account
Changing Permissions for a Database Account
Modifying Host IP Addresses
Deleting a Database Account
Database Migration
Migration Solution Overview
Migrating Data to RDS for MySQL Using mysqldump
Migrating Data to RDS for MySQL Using the Export and Import Functions of DAS
Version Upgrade
Upgrading a Minor Version
Upgrading an RDS for MySQL Instance from 5.7 to 8.0
Upgrading an RDS for MySQL Instance from 5.6 to 5.7
Instance Management
Instance Lifecycle
Buying a Same DB Instance as an Existing DB Instance
Stopping an Instance
Starting an Instance
Rebooting DB Instances or Read Replicas
Selecting Displayed Items
Exporting DB Instance Information
Deleting Pay-per-Use DB Instances or Read Replicas
Recycling a DB Instance
Instance Modifications
Changing a DB Instance Name
Changing a DB Instance Description
Changing the Replication Mode
Changing the Failover Priority
Changing Read/Write Permissions
Changing a DB Instance Class
Changing a Storage Type
Scaling Up Storage Space
Configuring Storage Autoscaling
Changing the Maintenance Window
Changing a DB Instance Type from Single to Primary/Standby
Promoting a Read Replica to Primary
Manually Switching Between Primary and Standby DB Instances
Changing the AZ of a Standby DB Instance
Updating the OS of a DB Instance
Data Backups
Introduction to Backups
Backup Types
Performing Backups
Configuring an Intra-Region Backup Policy
Configuring a Cross-Region Backup Policy
Creating a Manual Backup
Replicating a Backup
Managing Backups
Downloading a Full Backup File
Downloading a Binlog Backup File
Checking and Exporting Backup Information
Using mysqlbinlog to View Binlogs
Deleting a Manual Backup
Clearing Binlogs
Setting a Local Retention Period for RDS for MySQL Binlogs
Clearing Binlogs from DB Instances
Data Restorations
Restoration Solutions
Restoring Data to RDS for MySQL
Restoring a DB Instance from Backups
Restoring a DB Instance to a Point in Time
Restoring Databases or Tables to a Point in Time
Restoring Data Across Regions
Restoring Data to an On-Premises MySQL Database
Read Replicas
Introduction to Read Replicas
Creating an HA Read Replica
Creating a Single Read Replica
Changing a Single Read Replica to an HA Read Replica
Creating Read Replicas in Batches
Managing a Read Replica
Database Proxy (Read/Write Splitting)
Introduction to RDS for MySQL Database Proxy
Constraints on Database Proxy
Using RDS for MySQL Database Proxies for Read/Write Splitting
Database Proxy Configurations
Configuring Transaction Splitting
Configuring Connection Pools
Modifying Read/Write Splitting Parameters
Configuring the Delay Threshold and Routing Policy
Enabling or Disabling Access Control
Changing the Read/Write Splitting Address
Applying for and Changing a Private Domain Name for a Database Proxy
Changing the Read/Write Splitting Port
Changing the Number of Proxy Nodes
Changing the Instance Class of a DB Proxy Instance
Configuring Multi-Statement Processing Modes
Changing a Proxy from Pay-per-Use to Yearly/Monthly
Database Proxy Lifecycle
Restarting a Database Proxy
Disabling Read/Write Splitting
Database Proxy Kernel Versions
Kernel Versions
Upgrading the Kernel Version of Database Proxy
Best Practices for Database Proxy
Problem Diagnosis and SQL Analysis
Function Overview
Performance Monitoring
Viewing the Overall Status of a DB Instance
Viewing Performance Metrics of a DB Instance
Problem Diagnosis
Managing Real-Time Sessions
Managing Disk Capacity
Managing Locks & Transactions
Daily Reports
Managing Anomaly Snapshots
SQL Analysis
Viewing Slow Query Logs of a DB Instance
Viewing Top SQL Statements of a DB Instance
Creating a SQL Insights Task
Creating a Concurrency Control Rule
Configuring Auto Flow Control
Common Performance Problems
High CPU Usage of RDS for MySQL Instances
High Memory Usage of RDS for MySQL Instances
Full Storage of RDS for MySQL Instances
RDS for MySQL Metadata Locks
Troubleshooting Slow SQL Issues for RDS for MySQL DB Instances
Security and Encryption
Database Account Security
Resetting the Administrator Password to Restore Root Access
Changing a Security Group
Performing a Server-Side Encryption
Configuring an SSL Connection
Configuring the TDE Function
Configuring a Password Expiration Policy
Unbinding an EIP
Using the Database of the Latest Version
Using DBSS (Recommended)
Parameters
Modifying Parameters of an RDS for MySQL Instance
Managing Parameter Templates
Creating a Parameter Template
Applying a Parameter Template
Replicating a Parameter Template
Resetting a Parameter Template
Comparing Parameter Templates
Exporting a Parameter Template
Importing a Parameter Template
Modifying a Parameter Template Description
Deleting a Parameter Template
Suggestions on RDS for MySQL Parameter Tuning
Log Management
Log Reporting
Viewing and Downloading Error Logs
Viewing and Downloading Slow Query Logs
Viewing Failover/Switchover Logs
Enabling SQL Audit
Downloading SQL Audit Logs
Metrics and Alarms
Configuring Displayed Metrics
Viewing Monitoring Metrics
Setting Alarm Rules
Configuring Alarm Reporting
Configuring Monitoring by Seconds
Event Monitoring
Introduction to Event Monitoring
Viewing Event Monitoring Data
Creating an Alarm Rule to Monitor an Event
Events Supported by Event Monitoring
Billing Management
Renewing DB Instances
Changing the Billing Mode from Pay-per-Use to Yearly/Monthly
Changing the Billing Mode from Yearly/Monthly to Pay-per-Use
Unsubscribing from a Yearly/Monthly Instance
Interconnection with CTS
Key Operations Supported by CTS
Viewing Tracing Events
Task Center
Viewing a Task
Deleting a Task Record
RDS for MySQL Tags
RDS for MySQL Quotas
Memory Acceleration
Memory Acceleration Overview
Enabling Memory Acceleration
Managing Mapping Rules
Memory Acceleration Management
Working with RDS for MariaDB
Suggestions on Using RDS for MariaDB
Instance Usage Suggestions
Database Usage Suggestions
Instance Connection
Connecting to an RDS for MariaDB Instance
Connecting to an RDS for MariaDB Instance Through the MySQL CLI Client
Using MySQL CLI to Connect to an Instance Through a Private Network
Using MySQL CLI to Connect to an Instance Through a Public Network
Connecting to an RDS for MariaDB Instance Through JDBC
Connecting to an RDS for MariaDB Instance Through DAS
Performance Tuning
What Is the Maximum Number of IOPS Supported by RDS?
How Do I Improve the Query Speed of My RDS Database?
Identifying Why CPU Usage of RDS for MariaDB Instances Is High and Providing Solutions
RDS for MariaDB Memory Usage Too High
What Should I Do If an RDS DB Instance Is Abnormal Due to Full Storage Space?
Troubleshooting Slow SQL Issues for RDS for MariaDB Instances
Resolving Insufficient Storage Issues for RDS for MariaDB Instances
Permissions Management
Creating a User and Granting Permissions
RDS Custom Policies
Instance Lifecycle
Rebooting DB Instances or Read Replicas
Selecting Displayed Items
Exporting DB Instance Information
Deleting a Pay-per-Use DB Instance or Read Replica
Modifying Recycling Policy
Rebuilding a DB Instance
Instance Modifications
Upgrading a Minor Version
Changing a DB Instance Name
Changing a DB Instance Description
Changing the Replication Mode
Changing the Failover Priority
Changing a DB Instance Class
Scaling Up Storage Space
Storage Autoscaling
Manually Switching Between Primary and Standby DB Instances
Changing the Maintenance Window
Read Replicas
Introducing Read Replicas
Creating a Read Replica
Creating Read Replicas in Batches
Managing a Read Replica
Data Backups
Backup Solutions
Configuring an Intra-Region Backup Policy
Creating a Manual Backup
Checking and Exporting Backup Information
Downloading a Full Backup File
Downloading a Binlog Backup File
Setting a Local Retention Period for RDS for MariaDB Binlogs
Replicating a Backup
Deleting a Manual Backup
Data Restorations
Restoration Solutions
Restoring a DB Instance from a Backup
Restoring a DB Instance to a Point in Time
Parameter Templates
Creating a Parameter Template
Modifying RDS for MariaDB Instance Parameters
Exporting a Parameter Template
Importing a Parameter Template
Comparing Parameter Templates
Viewing Parameter Change History
Replicating a Parameter Template
Resetting a Parameter Template
Applying a Parameter Template
Viewing Application Records of a Parameter Template
Modifying a Parameter Template Description
Deleting a Parameter Template
Connection Management
Viewing and Changing a Floating IP Address
Binding and Unbinding an EIP
Changing a Database Port
Downloading a Certificate
Configuring a Security Group Rule
Database Management
Creating a Database
Granting Database Permissions
Deleting a Database
Enabling or Disabling Event Scheduler
Account Management (Non-Administrator)
Creating a Database Account
Resetting a Password for a Database Account
Changing Permissions for a Database Account
Modifying Host IP Addresses for a Database Account
Deleting a Database Account
Account and Network Security
Database Account Security
Resetting the Administrator Password to Restore root Access
Configuring an SSL Connection
Configuring a Password Expiration Policy
Unbinding an EIP
Using DBSS (Recommended)
Metrics and Alarms
Configuring Displayed Metrics
Viewing Monitoring Metrics
Setting Alarm Rules
Event Monitoring
Introduction to Event Monitoring
Viewing Event Monitoring Data
Creating an Alarm Rule to Monitor an Event
Events Supported by Event Monitoring
Interconnection with CTS
Key Operations Supported by CTS
Viewing Traces
Log Management
Viewing and Downloading Error Logs
Viewing and Downloading Slow Query Logs
Enabling or Disabling SQL Audit
Downloading SQL Audit Logs
DBA Assistant
Function Overview
Viewing the Overall Status of a DB Instance
Managing Real-Time Sessions
Viewing Session Statistics
Setting a Slow Session Threshold
Viewing Performance Metrics
Subscribing to Intelligent O&M
Viewing Storage Usage
Viewing Table Diagnosis Results
Setting a Diagnosis Threshold
Viewing Top Databases and Tables by Physical File Size
Viewing Slow Query Logs
Concurrency Control
Auto Flow Control
Managing Diagnosis Reports
Viewing Diagnosis Reports
Subscribing to Diagnosis Reports
Task Center
Viewing a Task
Deleting a Task Record
Managing Tags
Managing Quotas
Working with RDS for PostgreSQL
Suggestions on Using RDS for PostgreSQL
Instance Usage Suggestions
Database Usage Suggestions
Instance Connection
Connecting to an RDS for PostgreSQL Instance
Connecting to an RDS for PostgreSQL Instance Through DAS (Recommended)
Connecting to an RDS for PostgreSQL Instance Through the psql CLI Client
Connecting to a DB Instance from a Linux ECS
Connecting to a DB Instance from a Linux ECS
Installing a PostgreSQL Client
Connecting to an RDS for PostgreSQL Instance Through the GUI
Connecting to an RDS for PostgreSQL Instance Through JDBC
Connecting to an RDS for PostgreSQL Instance Using Python
Database Migration
Migration Solution Overview
Migrating Data to RDS for PostgreSQL Using psql
Migrating Data to RDS for PostgreSQL Using the Export and Import Functions of DAS
Performance Tuning
Suggestions on RDS for PostgreSQL Parameter Tuning
Troubleshooting High CPU Usage
Troubleshooting High Memory Usage
Troubleshooting Database Age Increase Problem
Troubleshooting High Storage Space Usage
Troubleshooting Abnormal Connections and Active Connections
Troubleshooting Long-Running Transactions
Troubleshooting Inactive Logical Replication Slots
Troubleshooting High Oldest Replication Slot Lag or Replication Lag
Troubleshooting SQL Statements That Have Been Executed for 3s or 5s
RDS for PostgreSQL Enhanced Edition
Introduction to RDS for PostgreSQL Enhanced Edition
Functions
System Views
Data Types
Implicit Type Conversion
Predefined Parameters
Macro Variables
Operators
Syntax
Permissions Management
Creating a User and Granting Permissions
RDS Custom Policies
Instance Lifecycle
Buying a Same DB Instance as an Existing DB Instance
Stopping an Instance
Starting an Instance
Rebooting DB Instances or Read Replicas
Selecting Displayed Items
Exporting DB Instance Information
Deleting a Pay-per-Use DB Instance or Read Replica
Recycling a DB Instance
Instance Modifications
Upgrading a Minor Version
Changing a DB Instance Name
Changing a DB Instance Description
Changing the Replication Mode
Changing the Failover Priority
Changing a DB Instance Class
Changing the Storage Type
Scaling Storage Space
Storage Autoscaling
Changing the Maintenance Window
Changing a DB Instance Type from Single to Primary/Standby
Manually Switching Between Primary and Standby DB Instances
Changing the AZ of a Standby DB Instance
Updating the OS of a DB Instance
Read Replicas
Introducing Read Replicas
Creating a Read Replica
Managing a Read Replica
Configuring Replication Delay for a Read Replica
DR Management
Creating a DR Relationship
Promoting a DR Instance to Primary
Removing a DR Relationship
Data Backups
Backup Solutions
Configuring an Automated Backup Policy
Creating a Manual Backup
Downloading a Full Backup File
Downloading an Incremental Backup File
Checking and Exporting Backup Information
Replicating a Backup
Deleting a Manual Backup
Data Restorations
Restoration Solutions
Restoring from Backup Files to RDS for PostgreSQL Instances
Restoring Data to an On-Premises PostgreSQL Database from a Full Backup
Restoring a DB Instance to a Point in Time
Restoring Databases or Tables to a Point in Time
Parameters
Creating a Parameter Template
Modifying Parameters of an RDS for PostgreSQL Instance
Importing a Parameter Template
Exporting a Parameter Template
Comparing Parameter Templates
Viewing Parameter Change History
Replicating a Parameter Template
Resetting a Parameter Template
Applying a Parameter Template
Viewing Application Records of a Parameter Template
Modifying a Parameter Template Description
Deleting a Parameter Template
Connection Management
Viewing and Changing a Floating IP Address
Changing a Private Domain Name
Configuring SSL Encryption
Binding and Unbinding an EIP
Changing a Database Port
Connecting to a DB Instance Through pgAdmin
Extension Management
Installing and Uninstalling an Extension on the RDS Console
Installing and Uninstalling an Extension Using SQL Commands
Supported Extensions
pg_profile_pro
pg_repack
pgl_ddl_deploy
pgvector
pgAudit
pglogical
pg_stat_statements
rds_hwdrs_ddl
rds_hwdrs_privs
HypoPG
pg_cron
dblink
rds_pg_sql_ccl
Tablespace Management
Databases
Creating a Database
Modifying Database Remarks
Deleting a Database
Accounts (Non-Administrator)
Creating a Database Account
Resetting a Password for a Database Account
Modifying Remarks of a Database Account
Deleting a Database Account
Modifying pg_hba.conf
Viewing the pg_hba.conf Change History
Security and Encryption
Database Account Security
Resetting the Administrator Password to Restore Root Access
Changing a Security Group
Performing a Server-Side Encryption
Using DBSS (Recommended)
Metrics and Alarms
Configuring Displayed Metrics
Viewing Monitoring Metrics
Setting Alarm Rules
Event Monitoring
Introduction to Event Monitoring
Viewing Event Monitoring Data
Creating an Alarm Rule to Monitor an Event
Events Supported by Event Monitoring
Interconnection with CTS
Key Operations Supported by CTS
Viewing Tracing Events
Log Management
Log Reporting
Viewing and Downloading Error Logs
Viewing and Downloading Slow Query Logs
Enabling SQL Audit
Downloading SQL Audit Logs
Task Center
Viewing a Task
Deleting a Task Record
Billing Management
Renewing DB Instances
Changing the Billing Mode from Pay-per-Use to Yearly/Monthly
Changing the Billing Mode from Yearly/Monthly to Pay-per-Use
Unsubscribing from a Yearly/Monthly Instance
Major Version Upgrade
Upgrading the Major Version of a DB Instance Using SQL Commands
Upgrading the Major Version of a DB Instance on the Console
RDS for PostgreSQL Tags
RDS for PostgreSQL Quotas
Working with RDS for SQL Server
Suggestions on Using RDS for SQL Server
Instance Connection
Connecting to an RDS for SQL Server Instance
Connecting to an RDS for SQL Server Instance Through DAS (Recommended)
Connecting to an RDS for SQL Server Instance Through the SQL Server Management Studio Client
Connecting to a DB Instance from a Windows ECS
Connecting to a DB Instance from a Windows Server
Installing SQL Server Management Studio
Database Migration
Migration Solution Overview
Migrating Data to RDS for SQL Server Using the Export and Import Functions of DAS
Performance Tuning
High CPU Usage of RDS for SQL Server Instances
Full Storage of RDS for SQL Server Instances
Instance Lifecycle
Buying a Same DB Instance as an Existing DB Instance
Stopping an Instance
Starting an Instance
Rebooting DB Instances or Read Replicas
Selecting Displayed Items
Exporting DB Instance Information
Deleting a Pay-per-Use DB Instance or Read Replica
Recycling a DB Instance
Instance Modifications
Changing a DB Instance Name
Changing a DB Instance Description
Changing the Failover Priority
Cloning a DB Instance
Changing a DB Instance Class
Scaling Up Storage Space
Configuring Autoscaling
Changing the Maintenance Window
Changing a DB Instance Type from Single to Primary/Standby
Manually Switching Between Primary and Standby DB Instances
Updating the DB Engine and OS of a DB Instance
Read Replicas
Managing a Read Replica
Data Backups
Backup Solutions
Configuring an Intra-Region Backup Policy
Creating a Manual Backup
Downloading a Backup File
Checking and Exporting Backup Information
Replicating a Backup
Deleting a Manual Backup
Data Restorations
Restoration Solutions
Restoring from Backup Files to RDS for SQL Server Instances
Restoring from Backup Files to a Self-Built SQL Server Database Using SSMS
Restoring a DB Instance to a Point in Time
Parameters
Creating a Parameter Template
Modifying RDS for SQL Server Instance Parameters
Exporting a Parameter Template
Comparing Parameter Templates
Viewing Parameter Change History
Replicating a Parameter Template
Resetting a Parameter Template
Applying a Parameter Template
Viewing Application Records of a Parameter Template
Modifying a Parameter Template Description
Deleting a Parameter Template
Connection Management
Viewing and Changing a Floating IP Address
Applying for and Changing a Private Domain Name
Applying for and Changing a Public Domain Name
Binding and Unbinding an EIP
Changing a Database Port
Accounts (Non-Administrator)
Creating a Database Account
Resetting a Password for a Database Account
Deleting a Database Account
Databases
Creating a Database
Granting Database Permissions
Deleting a Database
Copying a Database
Viewing Database Properties
Security and Encryption
Database Account Security
Resetting the Administrator Password
Changing a Security Group
Performing a Server-Side Encryption
Configuring the TDE Function
Using DBSS (Recommended)
Distributed Transactions
SQL Server Integration Services (SSIS)
Metrics and Alarms
Configuring Displayed Metrics
Viewing Monitoring Metrics
Setting Alarm Rules
Event Monitoring
Introduction to Event Monitoring
Viewing Event Monitoring Data
Creating an Alarm Rule to Monitor an Event
Events Supported by Event Monitoring
Interconnection with CTS
Key Operations Supported by CTS
Viewing Tracing Events
Log Management
Viewing and Downloading System Logs
Viewing and Downloading Audit Logs
Viewing and Downloading Slow Query Logs
DBA Assistant
Function Overview
Sessions
Storage Analysis
Real-Time Top SQL
Slow Query Log
Deadlocks
Publications and Subscriptions
Creating a Publication
Creating a Subscription
Monitoring Jobs
Task Center
Viewing a Task
Deleting a Task Record
Authorizing a Task
Billing Management
Unsubscribing from a Yearly/Monthly Instance
Enabling or Disabling FileStream
CLR Integration
Default Language Setting for RDS for SQL Server
Usage of Stored Procedures
Creating a Database Account
Granting SSIS Permissions to a Domain Account
Deploying an SSIS Project
Changing Custom Database Names
Viewing Error Logs
Tracing Flags
Capturing Change Data
Removing a Custom Database from an Availability Group
Replicating Databases
Granting Database Permissions to Subaccounts
Deleting Custom Databases
Updating Database Statistics
Cycling SQL Server Agent Error Logs
Cycling SQL Server Error Logs
Creating Alerts
Setting Up Notifications for Alert
Creating Operators for Alerts and Jobs
Updating Alert Settings
Updating Alert Notification Methods
Updating Information About Operators for Alerts and Jobs
Removing Alerts
Removing SQL Server Agent Notification Definitions for Specific Alerts and Operators
Removing Operators
Shrinking Databases
Changing the Permission to View All Databases
Granting Permissions of Database-Level db_owner Role
RDS for SQL Server Tags
RDS for SQL Server Quotas
Performance White Paper
RDS for MySQL
Test Method
RDS for MySQL 5.6 Test Data
General-Enhanced DB Instances
General-Purpose DB Instances
Dedicated DB Instances
RDS for MySQL 5.7 Test Data
General-Enhanced DB Instances
General-Purpose DB Instances
Dedicated DB Instances
Kunpeng General-Enhanced DB Instances
RDS for MySQL 8.0 Test Data
General-Purpose DB Instances
Dedicated DB Instances
RDS for PostgreSQL
Test Method
RDS for PostgreSQL 9.6 Test Data
RDS for PostgreSQL 11 Test Data
General-Purpose DB Instances
Dedicated DB Instances
RDS for PostgreSQL 12 Test Data
General-Purpose DB Instances
Dedicated DB Instances
RDS for PostgreSQL 13 Test Data
General-Purpose DB Instances
Dedicated DB Instances
RDS for PostgreSQL 14 Test Data
General-Purpose DB Instances
Dedicated DB Instances
RDS for PostgreSQL 15 Test Data
General-Purpose DB Instances
Dedicated DB Instances
RDS for SQL Server
Test Method
Test Data
SDK Reference
SDK Overview
Troubleshooting
RDS for MySQL
Backup and Restoration Issues
No SUPER Permissions When Restoring an RDS for MySQL Full Backup to a Local MySQL Database
Backup Failures Due to DDL Operations
Restoring an On-Premises or Huawei Cloud Backup File to an RDS DB Instance
RDS for MySQL Backup Job Failure
Manual Backups Taking More Time Than Automated Full Backups
Incorrect Login Password During Data Restoration from a Local Backup File
Automated Incremental Backup Failed Due to Full Storage
RDS Point-in-Time Restoration Task Failure
SQL Statements Such as SET @@SESSION.SQL_LOG_BIN Displayed After You Run mysqldump
Insufficient Permissions During Data Export Using mysqldump
Key Invalid or Deleted During Table-Level PITR
Primary/Standby Replication Issues
How Primary/Standby Replication Works
Automatic Recovery of Extended Primary/Standby Replication Delay
Primary/Standby Replication Delay Scenarios and Solutions
Abnormal Replication Between Primary and Standby RDS DB Instances
Primary/Standby Replication Delay Increases Sharply and Then Decreases
Insufficient Permissions Reported for Canal
Canal Fails to Parse Binlogs
RDS for MySQL Binlog Issues
Parameter-related Issues
long_query_time Changes Fail to Be Applied
Incorrect GROUP_CONCAT Results
[ERROR] 1071 Reported When an Index Creation Fails for RDS for MySQL
Tables Failed to Be Found After Case-Sensitivity Setting Changes for RDS for MySQL
Timeout Parameters
Global Parameters Fail to Change
Performance Issues
High CPU Usage
Out of Memory (OOM) Errors
Insufficient Disk Bandwidth
Slow SQL Statements Due to Improper Composite Index Settings
DB Instance Becoming Read-Only Due to Insufficient Storage
High Storage Usage Due to Uncleared Old Binlogs
Slow Response Due to Deadlocks
Read Replica Uses Far More Storage Than the Primary Instance
CPU Usage Increase
Slow SQL Execution Due to Hot and Cold Data Problems
High Table Fragmentation Rate
Full Storage Caused by Complex Queries
Why Is My SQL Query So Slow?
Instance Class Change or Minor Version Upgrade Failure Caused by Long Transactions
Native Error 1461 Reported by an RDS for MySQL DB Instance
System Inaccessible After Field Addition to an RDS for MySQL Database Table
Storage Filled Up by Undo Logs Due to Long Transactions
Locating Long Transactions
Sharp Increase in the Commit Time of Some SQL Statements
ibdata1 Too Big
SQL Issues
Double Quotation Marks Cannot Be Identified During SQL Statement Execution
Error 1366 Reported When Data Containing Emojis Is Updated
Failed to Change the varchar Length Due to the Index Length Limit
Invalid TIMESTAMP Default Value during Table Creation
AUTO_INCREMENT Not Displayed in the Table Structure
Slow Stored Procedure Execution Due to Inconsistent Collations
ERROR [1412] Reported for a DB Instance
Error Message "Too many keys specified" Displayed When a Secondary Index Is Created
Failed to Delete a Table with a Foreign Key
DISTINCT and GROUP BY Optimization
Character Set and Collation Settings
An Error Message Is Displayed When a User Is Created for a DB Instance
Slow SQL Queries After a Large Amount of Data Is Deleted from a Large Table
Event Scheduler Not Taking Effect Immediately After Being Enabled
Equivalent Comparison Failures with Floating-Point Numbers
A Large Number of SELECT Requests Routed to The Primary Instance After Database Proxy Is Enabled
RENAME USER Execution Failure
ERROR[1451] Reported When a Table with Foreign Keys Cannot Be Deleted
Solution to the Failure of Converting the Field Type
"Row size too large" Reported When an RDS for MySQL Table Failed to Be Created
ERROR [1412] Reported by an RDS for MySQL DB Instance
Instance Reboot Failure or ERROR 1146: Table 'xxx' doesn't exist Reported During Table Operations
Error Reported During Pagination Query
Error Reported During User Creation
Syntax Error Reported When GRANT Is Used to Grant All Privileges
Error Reported During Table Creation for an RDS for MySQL 5.6 DB Instance
Inconsistent Data Obtained on the Primary and Standby Nodes When a Query Is Performed Using an Auto-Increment Primary Key Value
"Data too long for column" Displayed When Data Is Inserted into an RDS for MySQL Instance
Connection Issues
"Access denied" Displayed During Database Connection
Failed to Connect to a Database Using mariadb-connector in SSL Mode
Error Message "connection established slowly"
Login Failed After ssl_type of root Is Changed to ANY
Error Reported During Login to a DB Instance Through DAS
"Your password does not satisfy the current policy requirements" Displayed When Permissions Are Granted or Revoked on DAS
SSL Connection Failed Due to Inconsistent TLS Versions
Failed to Connect to a Database as root
RDS for MySQL Client Automatically Disconnected from a DB Instance
RDS for MySQL DB Instance Inaccessible
Login Failed After the authentication_string Field Is Changed to Display the Password for RDS for MySQL
MySQL-server Connection Failure After a Version Upgrade of RDS for MySQL
Connection Exit Due to Improper Timeout Parameter Settings
Database Connection Through Code (php/java/python) Failed After SSL Is Enabled
There Is a Disconnection Every 45 Days Due to the istio-citadel Certificate System
Error 1251 Reported During Login to a DB Instance on the Navicat Client After the Database Version Is Upgraded
Other Issues
No Scanned Rows Recorded in Slow Query Logs
Rows Recorded in the SQL Diagnosis Result Far Less Than the Scanned Rows Recorded in Slow Query Logs
Millisecond-Level SQL Statements Recorded in Slow Query Logs
Viewing Storage of RDS DB Instances
"The table is full" Displayed in Error Logs
Audit Log Upload Policy Description
Auto-increment Field Values
Starting Value and Increment of AUTO_INCREMENT
AUTO_INCREMENT Value Exceeding the Maximum Value of This Field plus 1
Auto-Increment Field Value Jump
Changing the AUTO_INCREMENT Value of a Table
Failed to Insert Data Because Values for the Auto-increment Primary Key Field Reach the Upper Limit
The Impact of Creating an Empty Username
Connection to a Primary/Standby DB Instance Suspended Using pt-osc
Error Reported During Payment for a DB Instance
Failed to Change a Database Name
Error Reported When a DB Instance Is Purchased
RDS for PostgreSQL
A Large Number of Schemas Whose Owner Is rdsadmin
Index Name Containing a Schema Name During Index Creation
Authentication Not Supported When a DB Instance Is Accessed Through an Application
Error Reported When a Request Is Executed Through an Existing Connection
Slow Instance Reboot Due to Too Many Inodes
RDS for SQL Server
Account Creation Failure for a Microsoft SQL Server Database Migrated from Alibaba Cloud to Huawei Cloud
Error Reported When a New Account Is Used to Log In to an RDS for SQL Server Instance
Failed to Change the Instance Class of an RDS for SQL Server Instance or Perform a Primary/Standby Switchover
How Do I Remove and Re-establish a Replication of My RDS for SQL Server Instance?
Change History
Videos
Glossary
More Documents
User Guide (ME-Abu Dhabi Region)
Introduction
What Is RDS?
Basic Concepts
Advantages
Easy Management
High Security
High Reliability
Comparison Between RDS and Self-Built Databases
Product Series
DB Instance Introduction
Function Comparison
DB Instance Description
DB Instance Types
DB Instance Classes
DB Engines and Versions
DB Instance Statuses
Typical Applications
Read/Write Splitting
Constraints
MySQL Constraints
PostgreSQL Constraints
Microsoft SQL Server Constraints
Related Services
Getting Started with RDS for MySQL
Connecting to a DB Instance
Connecting to a MySQL DB Instance Through a Private Network
Overview
Step 1: Create a DB Instance
Step 2: Configure Security Group Rules
Step 3: Connect to a DB Instance Through a Private Network
Connecting to a MySQL DB Instance Through a Public Network
Overview
Step 1: Create a DB Instance
Step 2: Bind an EIP
Step 3: Configure Security Group Rules
Step 4: Connect to a DB Instance Through a Public Network
Getting Started with RDS for PostgreSQL
Connecting to a DB Instance
Connecting to a PostgreSQL DB Instance Through a Private Network
Overview
Step 1: Create a DB Instance
Step 2: Configure Security Group Rules
Step 3: Connect to a DB Instance Through psql
Connecting to a PostgreSQL DB Instance Through a Public Network
Overview
Step 1: Create a DB Instance
Step 2: Bind an EIP
Step 3: Configure Security Group Rules
Step 4: Connect to a DB Instance Through psql
Getting Started with RDS for SQL Server
Connecting to a DB Instance
Connecting to a DB Instance Through a Private Network
Overview
Step 1: Create a DB Instance
Step 2: Configure Security Group Rules
Step 3: Connect to a DB Instance Through a Private Network
Connecting to a DB Instance Through a Public Network
Overview
Step 1: Create a DB Instance
Step 2: Bind an EIP
Step 3: Configure Security Group Rules
Step 4: Connect to a DB Instance Through a Public Network
Working with RDS for MySQL
Data Migration
Migrating Data to RDS for MySQL Using mysqldump
Instance Management
Creating a Same DB Instance
Rebooting a DB Instance
Selecting Displayed Items
Exporting DB Instance Information
Deleting a DB Instance or Read Replica
Instance Modifications
Changing a DB Instance Name
Changing the Failover Priority
Changing a DB Instance Class
Scaling Up Storage Space
Changing the Maintenance Window
Changing a DB Instance Type from Single to Primary/Standby
Manually Switching Between Primary and Standby DB Instances
Read Replicas
Introducing Read Replicas
Creating a Read Replica
Managing a Read Replica
Backups and Restorations
Working with Backups
Configuring an Intra-Region Backup Policy
Creating a Manual Backup
Downloading a Backup File
Downloading a Binlog Backup File
Setting a Local Retention Period for MySQL Binlogs
Restoring from Backup Files to RDS for MySQL
Restoring a DB Instance to a Point in Time
Restoring a Table to a Specified Point in Time
Replicating a Backup
Deleting a Manual Backup
Parameter Template Management
Suggestions on Tuning MySQL Parameters
Creating a Parameter Template
Modifying Parameters
Exporting a Parameter Template
Comparing Parameter Templates
Viewing Parameter Change History
Replicating a Parameter Template
Resetting a Parameter Template
Applying a Parameter Template
Viewing Application Records of a Parameter Template
Modifying a Parameter Template Description
Deleting a Parameter Template
Connection Management
Configuring and Changing a Floating IP Address
Binding and Unbinding an EIP
Changing the Database Port
Downloading a Certificate
Configuring a Security Group Rule
Database Management
Creating a Database
Granting Permissions to a User
Deleting a Database
Enabling or Disabling Event Scheduler
Account Management (Non-Administrator)
Creating a Database Account
Resetting a Password
Changing Permissions
Deleting an Account
Database Account Security
Data Security
Resetting the Administrator Password
Changing a Security Group
Metrics
Configuring Displayed Metrics
Setting Alarm Rules
Viewing Monitoring Metrics
Log Management
Viewing and Downloading Error Logs
Viewing and Downloading Slow Query Logs
Viewing Failover/Switchover Logs
Enabling the SQL Audit Function
Downloading SQL Audit Logs
Task Center
Viewing a Task
Deleting a Task Record
Managing Tags
Working with RDS for PostgreSQL
Data Migration
Migrating Data to RDS for PostgreSQL Using psql
PostgreSQL Enhanced Edition
Introduction to PostgreSQL Enhanced Edition
Functions
System Views
Data Types
Implicit Type Conversion
Predefined Parameters
Macro Variables
Operators
Syntax
Enhanced Functions
Security Hardening
Other Functions
Instance Management
Creating a Same DB Instance
Rebooting a DB Instance
Selecting Displayed Items
Exporting DB Instance Information
Deleting a DB Instance or Read Replica
Instance Modifications
Changing a DB Instance Name
Changing the Failover Priority
Changing a DB Instance Class
Scaling Up Storage Space
Changing the Maintenance Window
Changing a DB Instance Type from Single to Primary/Standby
Manually Switching Between Primary and Standby DB Instances
Read Replicas
Introducing Read Replicas
Creating a Read Replica
Managing a Read Replica
Backups and Restorations
Working with Backups
Configuring an Intra-Region Backup Policy
Creating a Manual Backup
Restoring a DB Instance to a Point in Time
Restoring from Backup Files to RDS for PostgreSQL
Downloading a Backup File
Downloading an Incremental Backup File
Replicating a Backup
Deleting a Manual Backup
Parameter Template Management
Creating a Parameter Template
Modifying Parameters
Exporting a Parameter Template
Comparing Parameter Templates
Viewing Parameter Change History
Replicating a Parameter Template
Resetting a Parameter Template
Applying a Parameter Template
Viewing Application Records of a Parameter Template
Modifying a Parameter Template Description
Deleting a Parameter Template
Connection Management
Configuring and Changing a Floating IP Address
Binding and Unbinding an EIP
Changing the Database Port
Connecting to a DB Instance Through pgAdmin
Database Account Security
Data Security
Resetting the Administrator Password
Changing a Security Group
Metrics
Configuring Displayed Metrics
Setting Alarm Rules
Viewing Monitoring Metrics
Log Management
Viewing and Downloading Error Logs
Viewing and Downloading Slow Query Logs
Task Center
Viewing a Task
Deleting a Task Record
Plugin Management
Creating and Deleting a Plugin
Plugins Supported By RDS for PostgreSQL
Managing Tags
Working with RDS for SQL Server
Instance Management
Creating a Same DB Instance
Rebooting a DB Instance
Selecting Displayed Items
Exporting DB Instance Information
Deleting a DB Instance or Read Replica
Recycling a DB Instance
Instance Modifications
Changing a DB Instance Name
Changing the Failover Priority
Changing a DB Instance Class
Scaling Up Storage Space
Changing a DB Instance Type from Single to Primary/Standby
Manually Switching Between Primary and Standby DB Instances
Read Replicas
Introduction to Read Replicas
Creating a Read Replica
Managing a Read Replica
Backups and Restorations
Working with Backups
Configuring an Intra-Region Backup Policy
Creating a Manual Backup
Restoring from Backup Files to RDS for SQL Server
Downloading a Backup File
Replicating a Backup
Deleting a Manual Backup
Parameter Template Management
Creating a Parameter Template
Modifying Parameters
Exporting a Parameter Template
Comparing Parameter Templates
Viewing Parameter Change History
Replicating a Parameter Template
Resetting a Parameter Template
Applying a Parameter Template
Viewing Application Records of a Parameter Template
Modifying a Parameter Template Description
Deleting a Parameter Template
Connection Management
Configuring and Changing a Floating IP Address
Binding and Unbinding an EIP
Changing the Database Port
Data Security
Resetting the Administrator Password
Changing a Security Group
Metrics
Configuring Displayed Metrics
Setting Alarm Rules
Viewing Monitoring Metrics
Log Management
Viewing and Downloading System Logs
Viewing and Downloading Slow Query Logs
Task Center
Viewing a Task
Deleting a Task Record
Usage of Stored Procedures
Creating an Account
Updating Information About Operators for Alerts and Jobs
Removing Alerts
Removing SQL Server Agent Notification Definitions for Specific Alerts and Operators
Removing Operators
Managing Tags
FAQs
Product Consulting
What Precautions Should Be Taken When Using RDS?
What Is the Availability of RDS DB Instances?
Can I Use a Template to Create DB Instances?
What Are the Differences Between RDS and Other Database Solutions?
Will My RDS DB Instances Be Affected by Other Users' DB Instances?
Does RDS Support Cross-AZ High Availability?
Can RDS Primary/Standby DB Instances Be Changed to Single DB Instances?
What Should I Do If Garbled Characters Are Displayed After SQL Query Results Are Exported to an Excel File?
What Can I Do About Websites Responding Slower After Using RDS?
How Does a Cloud Database Perform a Primary/Standby Switchover?
Can Multiple ECSs Connect to the Same RDS DB Instance?
Why an Error is Reported When I Attempt to Delete a Database from RDS SQL Server Primary/Standby DB Instances?
Can Primary and Standby RDS DB Instances Be Deployed in the Same AZ?
Resource and Disk Management
Which Types of Logs and Files Occupy RDS Storage Space?
Which Items Occupy the Storage Space of My RDS DB Instances?
What Overhead Does the Storage Space Have After I Applied for an RDS DB Instance?
How Much Storage Space Is Required for DDL Operations?
How Many DB Instances Can Run on RDS?
How Many Databases Can Run on an RDS DB Instance?
Database Connection
Can an External Server Access the RDS Database?
How Do I Troubleshoot If the Number of RDS Database Connections Reaches the Upper Limit?
What Is the Maximum Number of Connections to an RDS DB Instance?
How Can I Create and Connect to an ECS?
What Should I Do If an ECS Cannot Connect to an RDS DB Instance?
What Should I Do If a Database Client Problem Causes a Connection Failure?
What Should I Do If an RDS Database Problem Causes a Connection Failure?
How Do My Applications Access an RDS DB Instance in a VPC?
Do Applications Need to Support Reconnecting to the RDS DB Instance Automatically?
How Can I Connect to a PostgreSQL Database Through JDBC?
What Should I Do If an RDS Microsoft SQL Server DB Instance Failed to Be Connected?
Can I Access an RDS DB Instance Over an Intranet Across Regions?
Is an SSL Connection to a DB Instance Interrupted After a Primary/Standby Switchover or Failover Occurs?
Does MySQL Support SSL Connections?
Why Does the New Password Not Take Effect After I Reset the Administrator Password?
Database Migration
Why Do I Need to Use the mysqldump and pg_dump Tools for Migration?
What Types of DB Engines Does RDS Support for Importing Data?
Database Permission
Why Does the Root User Not Have the Super Permission?
Database Storage
What Storage Engines Does the RDS for MySQL Support?
What Is the RDS DB Instance Storage Configuration?
Can I Change the Storage Type of an RDS DB Instance from Common I/O to Ultra-high I/O?
What Should I Do If My Data Exceeds the Database Storage Space of an RDS DB Instance?
Client Installation
How Can I Install the MySQL Client?
How Can I Install the PostgreSQL Client?
How Can I Install SQL Server Management Studio?
Backup and Restoration
How Long Does RDS Store Backup Data?
Can My Database Be Used in the Backup Window?
How Can I Back Up RDS Databases to an ECS?
Why Has My Automated Backup Failed?
What Happens to Database Backups After an RDS DB Instance Is Deleted?
Will My Backups Be Deleted If I Delete My Cloud Account?
Why Is a Table or Data Missing from My Database?
Database Monitoring
Which DB Instance Monitoring Metrics Do I Need to Pay Most Attention To?
Capacity Expansion and Specification Change
Are My RDS DB Instances Available When Scaling?
Why Does the DB Instance Become Faulty After the Original Database Port Is Changed?
Database Parameter Modification
What Inappropriate Parameter Settings Cause Unavailability of the PostgreSQL Database?
Where Should I Store the NDF Files for Microsoft SQL Server?
Log Management
How Long Is the Delay of RDS MySQL Slow Query Logs?
What's the Slow Query Threshold for Microsoft SQL Server?
How Can I Obtain Microsoft SQL Server Error Logs Using Commands?
Can I Export Statistics on RDS Slow Query Logs?
Network Security
What Security Protection Policies Does RDS Have?
How Can I Ensure the Security of RDS DB Instances in a VPC?
How Can Data Security Be Ensured During Transmission When I Access RDS Through an EIP?
How Can I Prevent Untrusted Source IP Addresses from Accessing RDS?
How Can I Import the Root Certificate to the Windows or Linux OS?
How Can I Identify Data Corruption?
API Reference (ME-Abu Dhabi Region)
Before You Start
Overview
API Calling
Endpoints
Constraints
Concepts
Selecting an API Type
API Overview
Calling APIs
Making an API Request
Authentication
Obtaining an API Version
Querying API Versions
Querying a Specified API Version
API v3 (Recommended)
Querying Version Information About a DB Engine
Querying Database Specifications
Querying the Storage Type of a Database
DB Instance Management
Creating a DB Instance
Changing DB Instance Specifications
Scaling Up Storage Space of a DB Instance
Changing a Single DB Instance to Primary/Standby DB Instances
Rebooting a DB Instance
Querying the Available SQL Server Character Set
Deleting a DB Instance
Querying Details About DB Instances
Binding and Unbinding an EIP
Resetting a Database Password
Changing the Failover Priority
Manually Switching Primary/Standby DB Instances
Changing the Data Synchronize Model of Primary/Standby DB Instances
Migrating a Standby DB Instance
Configuring the Maintenance Window
Database Security
Configuring SSL
Changing a Database Port
Changing a Security Group
Changing a Private IP Address
Parameter Configuration
Obtaining a Parameter Template List
Creating a Parameter Template
Modifying a Parameter Template
Applying a Parameter Template
Modifying Parameters of a Specified DB Instance
Obtaining the Parameter Template of a Specified DB Instance
Obtaining Parameters in a Specified Parameter Template
Deleting a Parameter Template
Backup and Restoration
Setting an Automated Backup Policy
Obtaining an Automated Backup Policy
Creating a Manual Backup
Obtaining Details About Backups
Obtaining the Link for Downloading a Backup File
Deleting a Manual Backup
Querying the Restoration Time Range
Restoring Data to a New DB Instance
Restoring Data to an Existing DB Instance
Restoring Tables to a Specified Point in Time (MySQL)
Log Information Queries
Querying Database Error Logs
Querying Database Slow Logs
Database and Account Management (MySQL)
Precautions
Creating a Database
Querying Details About Databases
Querying Authorized Databases of a Specified User
Deleting a Database
Creating a Database Account
Querying Details About Database Users
Querying Authorized Users of a Specified Database
Deleting a Database Account
Configuring a Password for a Database Account
Authorizing a Database Account
Revoking Permissions of a Database Account
Database and Account Management (Microsoft SQL Server)
Querying Details About Databases
Creating a Database Account
Querying Details About Database Users
Querying Authorized Users of a Specified Database
Deleting a Database Account
Authorizing a Database Account
Revoking Permissions of a Database Account
Appendix
Abnormal Request Results
Status Codes
Error Codes
Obtaining a Project ID
Replication Mode Table
RDS Monitoring Metrics Description
User Guide (Paris Region)
Introduction
What Is RDS?
Basic Concepts
Advantages
Easy Management
High Security
High Reliability
Comparison Between RDS and Self-Built Databases
Product Series
DB Instance Introduction
Function Comparison
DB Instance Description
DB Instance Types
DB Instance Classes
DB Engines and Versions
DB Instance Statuses
Typical Applications
Read/Write Splitting
Constraints
MySQL Constraints
PostgreSQL Constraints
Related Services
Getting Started with RDS for MySQL
Connecting to a DB Instance
Connecting to a MySQL DB Instance Through a Private Network
Overview
Step 1: Create a DB Instance
Step 2: Configure Security Group Rules
Step 3: Connect to a DB Instance Through a Private Network
Connecting to a MySQL DB Instance Through a Public Network
Overview
Step 1: Create a DB Instance
Step 2: Bind an EIP
Step 3: Configure Security Group Rules
Step 4: Connect to a DB Instance Through a Public Network
Getting Started with RDS for PostgreSQL
Connecting to a DB Instance
Connecting to a PostgreSQL DB Instance Through a Private Network
Overview
Step 1: Create a DB Instance
Step 2: Configure Security Group Rules
Step 3: Connect to a DB Instance Through psql
Connecting to a PostgreSQL DB Instance Through a Public Network
Overview
Step 1: Create a DB Instance
Step 2: Bind an EIP
Step 3: Configure Security Group Rules
Step 4: Connect to a DB Instance Through psql
Working with RDS for MySQL
Instance Management
Changing a DB Instance Name
Changing the Failover Priority
Changing a DB Instance Class
Scaling Up Storage Space
Rebooting a DB Instance
Changing a DB Instance Type from Single to Primary/Standby
Manually Switching Between Primary and Standby DB Instances
Selecting Displayed Items
Exporting DB Instance Information
Creating a Same DB Instance
Deleting a DB Instance or Read Replica
Read Replicas
Introducing Read Replicas
Creating a Read Replica
Managing a Read Replica
Backups and Restorations
Working with Backups
Configuring an Automated Backup Policy
Creating a Manual Backup
Downloading a Backup File
Downloading a Binlog Backup File
Restoring a DB Instance from a Backup
Restoring a DB Instance to a Point in Time
Replicating a Backup
Deleting a Manual Backup
Parameter Template Management
Suggestions on Tuning MySQL Parameters
Creating a Parameter Template
Modifying Parameters
Exporting a Parameter Template
Comparing Parameter Templates
Viewing Parameter Change History
Replicating a Parameter Template
Resetting a Parameter Template
Applying a Parameter Template
Viewing Application Records of a Parameter Template
Modifying a Parameter Template Description
Deleting a Parameter Template
Connection Management
Configuring and Changing a Floating IP Address
Binding and Unbinding an EIP
Changing the Database Port
Configuring a Security Group Rule
Data Migration
Migrating Data to RDS for MySQL Using mysqldump
Data Security
Resetting the Administrator Password
Changing a Security Group
Metrics and Alarms
Configuring Displayed Metrics
Setting Alarm Rules
Viewing Monitoring Metrics
Log Management
Viewing Error Logs
Viewing Slow Query Logs
Viewing Failover/Switchover Logs
Task Center
Viewing a Task
Deleting a Task Record
Working with RDS for PostgreSQL
Instance Management
Changing a DB Instance Name
Changing the Failover Priority
Changing a DB Instance Class
Scaling Up Storage Space
Rebooting a DB Instance
Changing a DB Instance Type from Single to Primary/Standby
Manually Switching Between Primary and Standby DB Instances
Selecting Displayed Items
Exporting DB Instance Information
Creating a Same DB Instance
Deleting a DB Instance or Read Replica
Read Replicas
Introducing Read Replicas
Creating a Read Replica
Managing a Read Replica
Backups and Restorations
Working with Backups
Configuring an Automated Backup Policy
Creating a Manual Backup
Restoring a DB Instance to a Point in Time
Restoring a DB Instance from a Backup
Downloading a Backup File
Replicating a Backup
Deleting a Manual Backup
Parameter Template Management
Creating a Parameter Template
Modifying Parameters
Exporting a Parameter Template
Comparing Parameter Templates
Viewing Parameter Change History
Replicating a Parameter Template
Resetting a Parameter Template
Applying a Parameter Template
Viewing Application Records of a Parameter Template
Modifying a Parameter Template Description
Deleting a Parameter Template
Connection Management
Configuring and Changing a Floating IP Address
Binding and Unbinding an EIP
Changing the Database Port
Connecting to a DB Instance Through pgAdmin
Data Migration
Migrating Data to RDS for PostgreSQL Using psql
Data Security
Resetting the Administrator Password
Changing a Security Group
Metrics and Alarms
Configuring Displayed Metrics
Setting Alarm Rules
Viewing Monitoring Metrics
Log Management
Viewing Slow Query Logs
Task Center
Viewing a Task
Deleting a Task Record
Plugin Management
Creating and Deleting a Plugin
Plugins Supported By RDS for PostgreSQL
FAQs
Product Consulting
What Precautions Should Be Taken When Using RDS?
What Is the Availability of RDS DB Instances?
Can I Use a Template to Create DB Instances?
What Are the Differences Between RDS and Other Database Solutions?
Will My RDS DB Instances Be Affected by Other Users' DB Instances?
Does RDS Support Cross-AZ High Availability?
Can RDS Primary/Standby DB Instances Be Changed to Single DB Instances?
What Should I Do If Garbled Characters Are Displayed After SQL Query Results Are Exported to an Excel File?
How Do I Create an AD Domain?
What Can I Do About Websites Responding Slower After Using RDS?
How Does a Cloud Database Perform a Primary/Standby Switchover?
Can Multiple ECSs Connect to the Same RDS DB Instance?
Can Primary and Standby RDS DB Instances Be Deployed in the Same AZ?
Resource and Disk Management
Which Types of Logs and Files Occupy RDS Storage Space?
Which Items Occupy the Storage Space of My RDS DB Instances?
What Overhead Does the Storage Space Have After I Applied for an RDS DB Instance?
How Much Storage Space Is Required for DDL Operations?
How Many DB Instances Can Run on RDS?
How Many Databases Can Run on an RDS DB Instance?
Database Connection
Can an External Server Access the RDS Database?
How Do I Troubleshoot If the Number of RDS Database Connections Reaches the Upper Limit?
What Is the Maximum Number of Connections to an RDS DB Instance?
How Can I Create and Connect to an ECS?
What Should I Do If an ECS Cannot Connect to an RDS DB Instance?
What Should I Do If a Database Client Problem Causes a Connection Failure?
What Should I Do If an RDS Database Problem Causes a Connection Failure?
How Do My Applications Access an RDS DB Instance in a VPC?
Do Applications Need to Support Reconnecting to the RDS DB Instance Automatically?
How Can I Connect to a PostgreSQL Database Through JDBC?
Can I Access an RDS DB Instance Over an Intranet Across Regions?
Is an SSL Connection to a DB Instance Interrupted After a Primary/Standby Switchover or Failover Occurs?
Does MySQL Support SSL Connections?
Why Does the New Password Not Take Effect After I Reset the Administrator Password?
Database Migration
Why Do I Need to Use the mysqldump and pg_dump Tools for Migration?
What Types of DB Engines Does RDS Support for Importing Data?
Database Permission
Why Does the Root User Not Have the Super Permission?
Database Storage
What Storage Engines Does the RDS for MySQL Support?
What Is the RDS DB Instance Storage Configuration?
Can I Change the Storage Type of an RDS DB Instance from Common I/O to Ultra-high I/O?
What Should I Do If My Data Exceeds the Database Storage Space of an RDS DB Instance?
Client Installation
How Can I Install the MySQL Client?
How Can I Install the PostgreSQL Client?
Backup and Restoration
How Long Does RDS Store Backup Data?
Can My Database Be Used in the Backup Window?
How Can I Back Up RDS Databases to an ECS?
Why Has My Automated Backup Failed?
What Happens to Database Backups After an RDS DB Instance Is Deleted?
Will My Backups Be Deleted If I Delete My Cloud Account?
Why Is a Table or Data Missing from My Database?
Database Monitoring
Which DB Instance Monitoring Metrics Do I Need to Pay Most Attention To?
Capacity Expansion and Specification Change
Are My RDS DB Instances Available When Scaling?
Why Does the DB Instance Become Faulty After the Original Database Port Is Changed?
Database Parameter Modification
What Inappropriate Parameter Settings Cause Unavailability of the PostgreSQL Database?
Log Management
How Long Is the Delay of RDS MySQL Slow Query Logs?
Can I Export Statistics on RDS Slow Query Logs?
Network Security
What Security Protection Policies Does RDS Have?
How Can I Ensure the Security of RDS DB Instances in a VPC?
How Can Data Security Be Ensured During Transmission When I Access RDS Through an EIP?
How Can I Prevent Untrusted Source IP Addresses from Accessing RDS?
How Can I Import the Root Certificate to the Windows or Linux OS?
How Can I Identify the Validity Period of an SSL Root Certificate?
How Can I Identify Data Corruption?
API Reference (Paris Region)
Before You Start
Overview
API Calling
Endpoints
Constraints
Concepts
Selecting an API Type
API Overview
Calling APIs
Making an API Request
Authentication
Response
Obtaining an API Version
Querying API Versions
Querying a Specified API Version
API v3 (Recommended)
Querying Version Information About a DB Engine
Querying Database Specifications
DB Instance Management
Creating a DB Instance
Changing DB Instance Specifications
Scaling Up Storage Space of a DB Instance
Changing a Single DB Instance to Primary/Standby DB Instances
Rebooting a DB Instance
Deleting a DB Instance
Querying Details About DB Instances
Parameter Configuration
Obtaining a Parameter Template List
Creating a Parameter Template
Modifying a Parameter Template
Applying a Parameter Template
Modifying Parameters of a Specified DB Instance
Obtaining the Parameter Template of a Specified DB Instance
Obtaining Parameters in a Specified Parameter Template
Deleting a Parameter Template
Backup and Restoration
Setting an Automated Backup Policy
Obtaining an Automated Backup Policy
Creating a Manual Backup
Obtaining Details About Backups
Obtaining the Link for Downloading a Backup File
Deleting a Manual Backup
Querying the Restoration Time Range
Restoring Data to a New DB Instance
Restoring Data to an Existing or Original DB Instance
Log Information Queries
Querying Database Error Logs
Querying Database Slow Logs
Tag Management
Adding Tags in Batches
Deleting Tags in Batches
Querying Project Tags
Obtaining Task Information
Obtaining Information About a Task with a Specified ID
Appendix
Abnormal Request Results
Status Codes
Error Codes
Obtaining a Project ID
Replication Mode Table
RDS Monitoring Metrics Description
User Guide (Kuala Lumpur Region)
Introduction
What Is RDS?
Basic Concepts
Advantages
Easy Management
High Security
High Reliability
Comparison Between RDS and Self-Built Databases
Product Series
DB Instance Introduction
Function Comparison
DB Instance Description
DB Instance Types
DB Instance Classes
DB Engines and Versions
DB Instance Statuses
Typical Applications
Read/Write Splitting
Constraints
MySQL Constraints
PostgreSQL Constraints
Microsoft SQL Server Constraints
Related Services
Getting Started with RDS for MySQL
Operation Guide
Step 1: Create a DB Instance
Step 2: Connect to a DB Instance
Connecting to a DB Instance
Connecting to a DB Instance Through a Private Network
Connecting to a DB Instance Through a Private Network
Configuring Security Group Rules
Connecting to a DB Instance Through a Private Network
Connecting to a DB Instance Through a Public Network
Connecting to a DB Instance Through a Public Network
Binding an EIP
Configuring Security Group Rules
Connecting to a DB Instance Through a Public Network
Getting Started with RDS for PostgreSQL
Operation Guide
Step 1: Create a DB Instance
Step 2: Connect to a DB Instance
Connecting to a DB Instance
Connecting to a PostgreSQL DB Instance Through a Private Network
Connecting to a DB Instance Through a Private Network
Configuring Security Group Rules
Connecting to a DB Instance Through psql
Connecting to a PostgreSQL DB Instance Through a Public Network
Connecting to a DB Instance Through a Public Network
Binding an EIP
Configuring Security Group Rules
Connecting to a DB Instance Through psql
Getting Started with RDS for SQL Server
Operation Guide
Step 1: Create a DB Instance
Step 2: Connect to a DB Instance
Connecting to a DB Instance
Connecting to a DB Instance Through a Private Network
Connecting to a DB Instance Through a Private Network
Configuring Security Group Rules
Connecting to a DB Instance Through a Private Network
Connecting to a DB Instance Through a Public Network
Connecting to a DB Instance Through a Public Network
Binding an EIP
Configuring Security Group Rules
Connecting to a DB Instance Through a Public Network
Working with RDS for MySQL
Data Migration
Migrating Data to RDS for MySQL Using mysqldump
Parameter Tuning
Suggestions on MySQL Parameter Tuning
Instance Lifecycle
Creating a Same DB Instance as an Existing DB Instance
Rebooting DB Instances or Read Replicas
Selecting Displayed Items
Exporting DB Instance Information
Deleting a DB Instance or Read Replica
Recycling a DB Instance
Instance Modifications
Upgrading a Major Version
Changing a DB Instance Name
Changing the Failover Priority
Changing a DB Instance Class
Scaling up Storage Space
Changing the Maintenance Window
Changing a DB Instance Type from Single to Primary/Standby
Promoting a Read Replica Into a Single DB Instance
Manually Switching Between Primary and Standby DB Instances
Migrating a Standby DB Instance
Read Replicas
Introducing Read Replicas
Creating a Read Replica
Managing a Read Replica
Backups and Restorations
Working with Backups
Configuring an Automated Backup Policy
Setting a Cross-Region Backup Policy
Creating a Manual Backup
Downloading a Backup File
Downloading a Binlog Backup File
Setting a Local Retention Period for MySQL Binlogs
Restoring from Backup Files to DB Instances
Restoring from Backup Files to a Self-Built MySQL Database
Restoring a DB Instance to a Point in Time
Replicating a Backup
Parameter Template Management
Creating a Parameter Template
Modifying Parameters
Exporting a Parameter Template
Comparing Parameter Templates
Viewing Parameter Change History
Replicating a Parameter Template
Resetting a Parameter Template
Applying a Parameter Template
Viewing Application Records of a Parameter Template
Modifying a Parameter Template Description
Deleting a Parameter Template
Connection Management
Configuring and Changing a Floating IP Address
Binding and Unbinding an EIP
Changing a Database Port
Downloading a Certificate
Configuring a Security Group Rule
Database Management
Creating a Database
Granting Database Permissions
Deleting a Database
Enabling or Disabling Event Scheduler
Account Management (Non-Administrator)
Creating a Database Account
Resetting a Password for a Database Account
Changing Permissions for a Database Account
Deleting a Database Account
Database Account Security
Data Security
Resetting the Administrator Password
Changing a Security Group
Metrics and Alarms
Configuring Displayed Metrics
Setting Alarm Rules
Viewing Monitoring Metrics
Interconnection with CTS
Viewing Tracing Events
Log Management
Viewing and Downloading Error Logs
Viewing and Downloading Slow Query Logs
Viewing Failover/Switchover Logs
Enabling the SQL Audit Function
Downloading SQL Audit Logs
Task Center
Viewing a Task
Deleting a Task Record
Working with RDS for PostgreSQL
Data Migration
Migrating Data to RDS for PostgreSQL Using psql
Parameter Tuning
Suggestions on PostgreSQL Parameter Tuning
PostgreSQL Enhanced Edition
Introduction to PostgreSQL Enhanced Edition
Functions
System Views
Data Types
Implicit Type Conversion
Predefined Parameters
Macro Variables
Operators
Syntax
Enhanced Functions
Security Hardening
Other Functions
Instance Lifecycle
Creating a Same DB Instance as an Existing DB Instance
Rebooting DB Instances or Read Replicas
Selecting Displayed Items
Exporting DB Instance Information
Deleting a Pay-per-Use DB Instance or Read Replica
Recycling a DB Instance
Instance Modifications
Changing a DB Instance Name
Changing the Failover Priority
Changing a DB Instance Class
Scaling up Storage Space
Changing a DB Instance Type from Single to Primary/Standby
Manually Switching Between Primary and Standby DB Instances
Migrating a Standby DB Instance
Read Replicas
Introducing Read Replicas
Creating a Read Replica
Managing a Read Replica
Backups and Restorations
Working with Backups
Configuring an Automated Backup Policy
Set a Cross-Region Backup Policy
Creating a Manual Backup
Downloading a Full Backup File
Downloading an Incremental Backup File
Restoring from Backup Files to RDS for PostgreSQL
Restoring a DB Instance to a Point in Time
Replicating a Backup
Parameter Template Management
Creating a Parameter Template
Modifying Instance Parameters
Exporting a Parameter Template
Comparing Parameter Templates
Viewing Parameter Change History
Replicating a Parameter Template
Resetting a Parameter Template
Applying a Parameter Template
Viewing Application Records of a Parameter Template
Modifying a Parameter Template Description
Deleting a Parameter Template
Connection Management
Configuring and Changing a Floating IP Address
Binding and Unbinding an EIP
Changing a Database Port
Connecting to a DB Instance Through pgAdmin
Plugin Management
Creating or Deleting a Plugin
Supported Plugins
Database Account Security
Data Security
Resetting the Administrator Password
Changing a Security Group
and AlarmsMetrics and Alarms
Configuring Displayed Metrics
Setting Alarm Rules
Viewing Monitoring Metrics
Interconnection with CTS
Viewing Tracing EventsViewing Tracing EventsViewing Log Records
Task Center
Viewing a Task
Deleting a Task Record
Working with RDS for SQL Server
Instance Lifecycle
Creating a Same DB Instance as an Existing DB Instance
Rebooting DB Instances or Read Replicas
Selecting Displayed Items
Exporting DB Instance Information
Deleting a Pay-per-Use DB Instance or Read Replica
Recycling a DB Instance
Instance Modifications
Changing a DB Instance Name
Changing the Failover Priority
Changing a DB Instance Class
Scaling up Storage Space
Changing a DB Instance Type from Single to Primary/Standby
Manually Switching Between Primary and Standby DB Instances
Read Replicas
Introducing Read Replicas
Creating a Read Replica
Managing a Read Replica
Backups and Restorations
Working with Backups
Configuring an Automated Backup Policy
Creating a Manual Backup
Downloading a Backup File
Restoring from Backup Files to RDS for SQL Server
Restoring from Backup Files to a Self-Built SQL Server Database
Replicating a Backup
Parameter Template Management
Creating a Parameter Template
Modifying Parameters
Exporting a Parameter Template
Comparing Parameter Templates
Viewing Parameter Change History
Replicating a Parameter Template
Resetting a Parameter Template
Applying a Parameter Template
Viewing Application Records of a Parameter Template
Modifying a Parameter Template Description
Deleting a Parameter Template
Connection Management
Configuring and Changing a Floating IP Address
Binding and Unbinding an EIP
Changing a Database Port
Data Security
Resetting the Administrator Password
Changing a Security Group
and AlarmsMetrics and Alarms
Configuring Displayed Metrics
Setting Alarm Rules
Viewing Monitoring Metrics
Interconnection with CTS
Viewing Tracing EventsViewing Tracing EventsViewing Log Records
Task Center
Viewing a Task
Deleting a Task Record
Usage of Stored Procedures
Creating a Database Account
Updating Information About Operators for Alerts and Jobs
Removing Alerts
Removing SQL Server Agent Notification Definitions for Specific Alerts and Operators
Removing Operators
FAQs
Product Consulting
What Should I Pay Attention to When Using RDS?
What Is the Availability of RDS DB Instances?
Can I Use a Template to Create DB Instances?
What Are the Differences Between RDS and Other Database Solutions?
Will My RDS DB Instances Be Affected by Other User Instances?
Does RDS Support Cross-AZ High Availability?
Can RDS Primary/Standby DB Instances Be Changed to Single DB Instances?
What Should I Do If Garbled Characters Are Displayed After SQL Query Results Are Exported to an Excel File?
How Do I Create an AD Domain?
What Can I Do About Slow Respond of Websites When They Use RDS?
How Does a Cloud Database Perform a Primary/Standby Switchover?
Can Multiple ECSs Connect to the Same RDS DB Instance?
Why Is an Error Reported When I Attempt to Delete a Database from RDS SQL Server Primary/Standby DB Instances?
Resource and Disk Management
Which Types of Logs and Files Occupy RDS Storage Space?
Which Items Occupy the Storage Space of My RDS DB Instances?
What Overhead Does the Storage Space Have After I Applied for an RDS DB Instance?
How Much Storage Space Is Required for DDL Operations?
How Many DB Instances Can Run on RDS?
How Many Databases Can Run on an RDS DB Instance?
Database Connection
Can an External Server Access the RDS Database?
What Do I Do If the Number of RDS Database Connections Reaches the Upper Limit?
What Is the Maximum Number of Connections to an RDS DB Instance?
How Can I Create and Connect to an ECS?
What Should I Do If an ECS Cannot Connect to an RDS DB Instance Through a Private Network?
What Should I Do If a Database Client Problem Causes a Connection Failure?
What Should I Do If an RDS Database Problem Causes a Connection Failure?
How Do My Applications Access an RDS DB Instance in a VPC?
Do Applications Need to Support Reconnecting to the RDS DB Instance Automatically?
How Can I Connect to a PostgreSQL Database Through JDBC?
What Should I Do If an RDS Microsoft SQL Server DB Instance Failed to Be Connected?
Can I Access an RDS DB Instance Over an Intranet Connection Across Regions?
Is an SSL Connection to a DB Instance Interrupted After a Primary/Standby Switchover or Failover?
Does MySQL Support SSL Connections?
Why Did the New Password Not Take Effect After I Reset the Administrator Password?
Database Migration
Why Do I Need to Use the mysqldump or pg_dump Tools for Migration?
What Types of DB Engines Does RDS Support for Importing Data?
Database Permission
Why Does the Root User Not Have the Super Permissions?
Database Storage
What Storage Engines Does the RDS for MySQL Support?
What Is the RDS DB Instance Storage Configuration?
Can I Change the Storage Type of an RDS DB Instance from Common I/O to Ultra-high I/O?
What Should I Do If My Data Exceeds the Available Storage of an RDS DB Instance?
Client Installation
How Can I Install the MySQL Client?
How Can I Install the PostgreSQL Client?
How Can I Install SQL Server Management Studio?
Backup and Restoration
How Long Does RDS Store Backup Data For?
Can My Database Be Used in the Backup Window?
How Can I Back Up an RDS Database to an ECS?
Why Has My Automated Backup Failed?
What Happens to Database Backups After an RDS DB Instance Is Deleted?
Will My Backups Be Deleted If I Delete My Cloud Account?
Why Is a Table or Data Missing from My Database?
Database Monitoring
Which DB Instance Monitoring Metrics Do I Need to Pay Attention To?
Capacity Expansion and Specification Change
Are My RDS DB Instances Available When Scaling?
Why Does the DB Instance Become Faulty After the Original Database Port Is Changed?
Database Parameter Modification
What Inappropriate Parameter Settings Cause Unavailability of the PostgreSQL Database?
Where Should I Store the NDF Files for Microsoft SQL Server?
How Do I Configure a Password Expiration Policy for RDS for MySQL DB Instances?
Log Management
How Long Is the Delay for RDS MySQL Slow Query Logs?
What's the Slow Query Threshold for Microsoft SQL Server?
How Can I Obtain Microsoft SQL Server Error Logs Using Commands?
Can I Export Statistics on RDS Slow Query Logs?
Network Security
What Security Protection Policies Does RDS Have?
How Can I Ensure the Security of RDS DB Instances in a VPC?
How Can Data Security Be Ensured During Transmission When I Access RDS Through an EIP?
How Can I Prevent Untrusted Source IP Addresses from Accessing RDS?
How Can I Import the Root Certificate to a Windows or Linux OS?
How Can I Identify the Validity Period of an SSL Root Certificate?
How Can I Identify Data Corruption?
API Reference (Kuala Lumpur Region)
Before You Start
Overview
API Calling
Endpoints
Constraints
Concepts
Selecting an API Type
API Overview
Calling APIs
Making an API Request
Authentication
Response
Obtaining an API Version
Querying API Versions
Querying a Specified API Version
API v3 (Recommended)
Querying Version Information About a DB Engine
Querying Database Specifications
Querying the Storage Type of a Database
DB Instance Management
Creating a DB Instance
Changing DB Instance Specifications
Scaling Up Storage Space of a DB Instance
Changing a Single DB Instance to Primary/Standby DB Instances
Rebooting a DB Instance
Querying the Available SQL Server Character Set
Deleting a DB Instance
Querying Details About DB Instances
Binding and Unbinding an EIP
Resetting a Database Password
Changing the Failover Priority
Manually Switching Primary/Standby DB Instances
Changing the Data Synchronize Model of Primary/Standby DB Instances
Migrating a Standby DB Instance
Database Security
Configuring SSL
Changing a Database Port
Changing a Security Group
Changing a Private IP Address
Parameter Configuration
Obtaining a Parameter Template List
Creating a Parameter Template
Modifying a Parameter Template
Applying a Parameter Template
Modifying Parameters of a Specified DB Instance
Obtaining the Parameter Template of a Specified DB Instance
Obtaining Parameters in a Specified Parameter Template
Deleting a Parameter Template
Backup and Restoration
Setting an Automated Backup Policy
Obtaining an Automated Backup Policy
Creating a Manual Backup
Obtaining Details About Backups
Obtaining the Link for Downloading a Backup File
Deleting a Manual Backup
Querying the Restoration Time Range
Restoring Data to a New DB Instance
Restoring Data to an Existing DB Instance
Restoring Tables to a Specified Point in Time (MySQL)
Log Information Queries
Querying Database Error Logs
Querying Database Slow Logs
Obtaining Slow Query Log Statistics
Obtaining Links for Downloading Slow Query Logs
Setting SQL Audit
Querying the Policy for SQL Audit Logs
Obtaining an Audit Log List
Obtaining the Link for Downloading an Audit Log
Database and Account Management (MySQL)
Precautions
Creating a Database
Querying Details About Databases
Querying Authorized Databases of a Specified User
Deleting a Database
Creating a Database Account
Querying Details About Database Users
Querying Authorized Users of a Specified Database
Deleting a Database Account
Configuring a Password for a Database Account
Authorizing a Database Account
Revoking Permissions of a Database Account
Database and Account Management (Microsoft SQL Server)
Creating a Database
Querying Details About Databases
Deleting a Database
Tag Management
Adding Tags in Batches
Deleting Tags in Batches
Querying Project Tags
Obtaining Task Information
Obtaining Information About a Task with a Specified ID
Obtaining Task Information of a Specified SQL Server DB Instance in a Specified Time Range
Appendix
Abnormal Request Results
Status Codes
Error Codes
Obtaining a Project ID
Replication Mode Table
RDS Monitoring Metrics Description
User Guide (Ankara Region)
Introduction
What Is RDS?
Basic Concepts
Advantages
Easy Management
High Security
High Reliability
Comparison Between RDS and Self-Built Databases
Product Series
DB Instance Introduction
Function Comparison
DB Instance Description
DB Instance Types
DB Instance Classes
DB Engines and Versions
DB Instance Statuses
Typical Applications
Read/Write Splitting
Permissions Management
Constraints
RDS for MySQL Constraints
RDS for PostgreSQL Constraints
Related Services
Getting Started with RDS for MySQL
Operation Guide
Step 1: Create a DB Instance
Step 2: Connect to a DB Instance
Connecting to a DB Instance
Connecting to an RDS for MySQL DB Instance Through a Private Network
Connecting to a DB Instance Through a Private Network
Configuring Security Group Rules
Connecting to a DB Instance Through a Private Network
Connecting to an RDS for MySQL DB Instance Through a Public Network
Connecting to a DB Instance Through a Public Network
Binding an EIP
Configuring Security Group Rules
Connecting to a DB Instance Through a Public Network
Getting Started with RDS for PostgreSQL
Operation Guide
Step 1: Create a DB Instance
Step 2: Connect to a DB Instance
Connecting to a DB Instance
Connecting to a DB Instance Through a Private Network
Connecting to a DB Instance Through a Private Network
Configuring Security Group Rules
Connecting to a DB Instance Through psql
Connecting to a DB Instance Through a Public Network
Connecting to a DB Instance Through a Public Network
Binding an EIP
Configuring Security Group Rules
Connecting to a DB Instance Through psql
Working with RDS for MySQL
Database Migration
Migrating Data to RDS for MySQL Using mysqldump
Migrating Data to RDS for MySQL Using the Export and Import Functions of DAS
Parameter Tuning
Suggestions on RDS for MySQL Parameter Tuning
Permissions Management
Creating a User and Granting Permissions
RDS Custom Policies
Instance Lifecycle
Creating a Same DB Instance as an Existing DB Instance
Rebooting DB Instances or Read Replicas
Selecting Displayed Items
Exporting DB Instance Information
Deleting a DB Instance or Read Replica
Instance Modifications
Changing a DB Instance Name
Changing the Failover Priority
Changing a DB Instance Class
Scaling up Storage Space
Changing the Maintenance Window
Changing a DB Instance Type from Single to Primary/Standby
Promoting a Read Replica Into a Single DB Instance
Manually Switching Between Primary and Standby DB Instances
Migrating a Standby DB Instance
Read Replicas
Introducing Read Replicas
Creating a Read Replica
Managing a Read Replica
Backups and Restorations
Working with Backups
Configuring an Automated Backup Policy
Setting a Cross-Region Backup Policy
Creating a Manual Backup
Downloading a Backup File
Downloading a Binlog Backup File
Restoring from Backup Files to DB Instances
Restoring a DB Instance to a Point in Time
Restoring a Table to a Point in Time
Replicating a Backup
Deleting a Manual Backup
Parameter Template Management
Creating a Parameter Template
Modifying Parameters
Exporting a Parameter Template
Comparing Parameter Templates
Viewing Parameter Change History
Replicating a Parameter Template
Resetting a Parameter Template
Applying a Parameter Template
Viewing Application Records of a Parameter Template
Modifying a Parameter Template Description
Deleting a Parameter Template
Connection Management
Configuring and Changing a Floating IP Address
Binding and Unbinding an EIP
Changing a Database Port
Configuring a Security Group Rule
Database Proxy (Read/Write Splitting)
Introducing Read/Write Splitting
Best Practices for Database Proxy
Enabling Read/Write Splitting
Configuring Delay Threshold and Distributing Read Weight
Changing the Read/Write Splitting Address
Changing the Instance Class of a DB Proxy Instance
Upgrading the Kernel Version of Database Proxy
Enabling or Disabling Access Control
Disabling Read/Write Splitting
Rules for Distributing Weights
Testing Read/Write Splitting Performance
Data Security
Resetting the Administrator Password
Changing a Security Group
Metrics and Alarms
Configuring Displayed Metrics
Setting Alarm Rules
Viewing Monitoring Metrics
Log Management
Viewing and Downloading Error Logs
Viewing and Downloading Slow Query Logs
Viewing Failover/Switchover Logs
Enabling the SQL Audit Function
Downloading SQL Audit Logs
Task Center
Viewing a Task
Deleting a Task Record
Working with RDS for PostgreSQL
Database Migration
Migrating Data to RDS for PostgreSQL Using psql
Migrating Data to RDS for PostgreSQL Using the Export and Import Functions of DAS
Parameter Tuning
Suggestions on RDS for PostgreSQL Parameter Tuning
Permissions Management
Creating a User and Granting Permissions
RDS Custom Policies
Instance Lifecycle
Creating a Same DB Instance as an Existing DB Instance
Rebooting DB Instances or Read Replicas
Selecting Displayed Items
Exporting DB Instance Information
Deleting a DB Instance or Read Replica
Instance Modifications
Changing a DB Instance Name
Changing the Failover Priority
Changing a DB Instance Class
Scaling up Storage Space
Changing the Maintenance Window
Changing a DB Instance Type from Single to Primary/Standby
Manually Switching Between Primary and Standby DB Instances
Migrating a Standby DB Instance
Read Replicas
Introducing Read Replicas
Creating a Read Replica
Managing a Read Replica
Backups and Restorations
Working with Backups
Configuring an Automated Backup Policy
Set a Cross-Region Backup Policy
Creating a Manual Backup
Downloading a Full Backup File
Downloading an Incremental Backup File
Restoring from Backup Files to RDS for PostgreSQL
Restoring a DB Instance to a Point in Time
Replicating a Backup
Deleting a Manual Backup
Parameter Template Management
Creating a Parameter Template
Modifying Instance Parameters
Exporting a Parameter Template
Comparing Parameter Templates
Viewing Parameter Change History
Replicating a Parameter Template
Resetting a Parameter Template
Applying a Parameter Template
Viewing Application Records of a Parameter Template
Modifying a Parameter Template Description
Deleting a Parameter Template
Connection Management
Configuring and Changing a Floating IP Address
Binding and Unbinding an EIP
Changing a Database Port
Connecting to a DB Instance Through pgAdmin
Plugin Management
Creating or Deleting a Plugin
Supported Plugins
Using pg_repack
Tablespace Management
Data Security
Resetting the Administrator Password
Changing a Security Group
Metrics and Alarms
Configuring Displayed Metrics
Setting Alarm Rules
Viewing Monitoring Metrics
Log Management
Viewing Error Logs
Viewing Slow Query Logs
Task Center
Viewing a Task
Deleting a Task Record
FAQs
Product Consulting
What Should I Pay Attention to When Using RDS?
What Is the Availability of RDS DB Instances?
Does RDS Support Cross-AZ High Availability?
What Can I Do About Slow Responses of Websites When They Use RDS?
Can I Change the Replication Mode Between Primary DB Instances and Read Replicas?
What Is the Time Delay for Primary/Standby Replication?
What Are the Restrictions on MySQL DB Instances After GTID Is Enabled?
How Many Databases Can Run on an RDS DB Instance?
What Is the Maximum Size Allowed for a Single Table in MySQL Instances?
Resource and Disk Management
How Long Does It Take to Create a DB Instance?
Which Types of Logs and Files Occupy RDS Storage Space?
Which Items Occupy the Storage Space of My RDS DB Instances?
How Much Storage Space Is Required for DDL Operations?
Database Connection
What Should I Do If I Can't Connect to My RDS DB Instance?
Can an External Server Access the RDS Database?
What Do I Do If the Number of RDS Database Connections Reaches the Upper Limit?
What Is the Maximum Number of Connections to an RDS DB Instance?
How Can I Create and Connect to an ECS?
What Should I Do If an ECS Cannot Connect to an RDS DB Instance Through a Private Network?
What Should I Do If a Database Client Problem Causes a Connection Failure?
What Should I Do If an RDS Database Problem Causes a Connection Failure?
Do Applications Need to Support Reconnecting to the RDS DB Instance Automatically?
How Can I Connect to an RDS for PostgreSQL Database Through JDBC?
Why Cannot I Ping My EIP After It Is Bound to a DB Instance?
How Can I Obtain the IP Addreenabled SQL auditss of an Application?
Can I Access an RDS DB Instance Over an Intranet Connection Across Regions?
Why Did the New Password Not Take Effect After I Reset the Administrator Password?
How Do I Set the Encoding Format of the MySQL 8.0 Character Set?
What Should I Do If the ECS and RDS Are Deployed in Different VPCs and They Cannot Communicate with Each Other?
How Do I View All IP Addresses Connected to a Database?
Can I Access Standby RDS DB Instances?
How Do I Check the Connections to an RDS for MySQL Instance?
Database Migration
Why Do I Need to Use the mysqldump or pg_dump Tools for Migration?
What Should I Do When a Large Number of Binlog Files Cause Storage Space Insufficiency During an RDS MySQL Instance Migration?
What Types of DB Engines Does RDS Support for Importing Data?
Database Permission
Why Does the Root User Not Have the Super Permissions?
RDS for MySQL Built-in Accounts
Does RDS for MySQL Support Multiple Accounts?
How Do I View Authorized Databases After a Local Client Is Connected to a DB Instance?
Database Storage
What Storage Engines Does RDS for MySQL Support?
What Types of Storage Does RDS Use?
Does RDS for MySQL Support Stored Procedures and Functions?
What Should I Do If My Data Exceeds the Available Storage of an RDS for MySQL Instance?
How Do I View the Storage Usage of My RDS Instance?
Client Installation
How Can I Install the MySQL Client?
How Can I Install a PostgreSQL Client?
Database Usage
Does MySQL 8.0 Support Full-Text Search?
How Do I Use the mysqlbinlog Tool?
How Do I View Session IDs and Login and Logout Time of a Database?
Does the OPTIMIZE TABLE Operation Lock Tables on an RDS DB Instance?
Backup and Restoration
How Long Does RDS Store Backup Data For?
How Do I Clear RDS Backup Space?
Can My Database Be Used in the Backup Window?
How Do I View My Backup Storage Usage?
How Can I Back Up an RDS Database to an ECS?
Will Backups Be Retained After My RDS Instance Is Deleted?
Why Has My Automated Backup Failed?
Why Is a Table or Data Missing from My Database?
How Do I Restore a Local Database Backup to RDS?
Does RDS for PostgreSQL Support Table PITR?
Can I Dump Backup Files to OBS Buckets?
Does RDS for MySQL Support Table-Level Backup to a Specified OBS Bucket?
Can I Delete the RDS for MySQL Backup Policy?
Database Monitoring
Which DB Instance Monitoring Metrics Do I Need to Pay Attention To?
How Can I Calculate the Memory Usage of an RDS DB Instance?
How Do I Set an Alarm Rule for the Replication Delay Between Primary and Standby DB Instances?
Capacity Expansion and Specification Change
Are My RDS DB Instances Still Available During Storage Scale-up and Instance Class Change?
Why Does the DB Instance Become Faulty After the Original Database Port Is Changed?
Can I Change the VPC that My RDS DB Instance Belongs To?
Database Parameter Modification
What Inappropriate Parameter Settings Cause Unavailability of the RDS for PostgreSQL Database?
How Can I Change the Time Zone?
How Do I Configure a Password Expiration Policy for RDS for MySQL DB Instances?
How Do I Change the RDS Transaction Isolation Level?
Does RDS for PostgreSQL Support the test_decoding Plugin?
How Do I Use the utf8mb4 Character Set to Store Emojis in an RDS for MySQL DB Instance?
Can I Use SQL Commands to Modify Global Parameters?
How Do I Set Case Sensitivity for RDS for MySQL Table Names?
Can I Enable Query Caching for My RDS for MySQL Instance?
Network Security
What Security Protection Policies Does RDS Have?
How Can Data Security Be Ensured During Transmission When I Access RDS Through an EIP?
How Can I Prevent Untrusted Source IP Addresses from Accessing RDS?
How Do I Configure a Security Group to Enable Access to RDS DB Instances?
How Can I Import the Root Certificate to a Windows or Linux OS?
How Can I Identify the Validity Period of an SSL Root Certificate?
What Are the Possible Causes for Data Corruption?
Version Upgrade
Does RDS for MySQL Support Version Upgrades?
Does RDS for MySQL Support Version Downgrades?
Change History
API Reference (Ankara Region)
Before You Start
Overview
API Calling
Endpoints
Constraints
Concepts
API Overview
Calling APIs
Making an API Request
Authentication
Response
API v3 (Recommended)
Querying Version Information About APIs
Querying API Versions
Querying a Specified API Version
Querying Version Information About a DB Engine
Querying Database Specifications
Querying the Storage Type of a Database
DB Instance Management
Creating a DB Instance
Stopping an Instance
Starting an Instance
Changing DB Instance Specifications
Scaling Up Storage Space of a DB Instance
Changing a Single DB Instance to Primary/Standby DB Instances
Rebooting a DB Instance
Deleting a DB Instance
Querying Details About DB Instances
Binding and Unbinding an EIP
Changing the Failover Priority
Manually Switching Primary/Standby DB Instances
Changing the Data Replication Mode of Primary/Standby DB Instances
Migrating a Standby DB Instance
Configuring the Maintenance Window
Database Security
Configuring SSL
Changing a Database Port
Changing a Security Group
Changing a Private IP Address
Parameter Configuration
Obtaining a Parameter Template List
Creating a Parameter Template
Modifying a Parameter Template
Applying a Parameter Template
Modifying Parameters of a Specified Instance
Obtaining the Parameter Template of a Specified DB Instance
Obtaining Parameters in a Specified Parameter Template
Deleting a Parameter Template
Backup and Restoration
Setting an Automated Backup Policy
Setting a Cross-Region Backup Policy
Obtaining an Automated Backup Policy
Querying Information About a Cross-Region Backup Policy
Creating a Manual Backup
Obtaining Details About Backups
Querying Details About Cross-Region Backups
Querying Details About DB Instances for Which Cross-Region Backups Are Created
Obtaining the Link for Downloading a Backup File
Deleting a Manual Backup
Querying the Restoration Time Range
Querying the Restoration Time Range of a Cross-Region Backup
Restoring Data to a New DB Instance
Restoring Data to an Existing or Original DB Instance
Restoring Tables to a Specified Point in Time (MySQL)
Log Information Queries
Querying Database Error Logs
Querying Database Slow Logs
Obtaining Slow Query Log Statistics
Obtaining Links for Downloading Slow Query Logs
Setting SQL Audit
Querying the Policy for SQL Audit Logs
Obtaining an Audit Log List
Obtaining the Link for Downloading an Audit Log
Database and Account Management (MySQL)
Precautions
Creating a Database
Querying Details About a Database
Querying Details About Databases
Querying Authorized Databases of a Specified User
Deleting a Database
Creating a Database Account
Querying Details About a Database User
Querying Details About Database Users
Querying Authorized Users of a Specified Database
Deleting a Database Account
Configuring a Password for a Database Account
Authorizing a Database Account
Revoking Permissions of a Database Account
Resetting the Password for User Root
Obtaining Task Information
Obtaining Information About a Task with a Specified ID
Appendix
Abnormal Request Results
Status Codes
Error Codes
Obtaining a Project ID
Replication Mode
RDS Monitoring Metrics Description
Change History