Database
AWS features the broadest selection of purpose-built databases for all of your application needs. With 15+ database engines to choose from, hundreds of thousands of customers rely on AWS databases to build use case driven, highly scalable, and distributed applications.
Recent questions
see all1/18
- I'm trying to update RDS mysql version checking the compatibility report then showing below error 2) MySQL 8.0 syntax check for routine-like...
- 2) MySQL 8.0 syntax check for routine-like objects https://dev.mysql.com/doc/refman/8.0/en/keywords.html More Information: https://dev.mysql.com/doc/refman/en/keywords.html mysql.flush_rewrite_rules -...
- I am trying to do something simple. I need to make sure at the time of registration in my app, that the Username they request is not used in my AWS backend. To complete this, I have a small table in...
- a company's SQL developer has left and I've been asked to build a series of queries for their postgres DB on an Aurora Postgres server in the interim. I can log into the RDS interface, but the query...
- I'm using an Amazon Aurora PostgreSql DB cluster and I am receiving the following error after a failover: "PG::ReadOnlySqlTransaction: ERROR: cannot execute UPDATE in a read-only transaction" I'm...
- Now that AWS offers MRR for Keyspaces, is a CQL Alter Table supported? From what I can tell it is not supported since I get this error: ``` InvalidRequest: Error from server: code=2200 [Invalid...
- Hi, I am querying an external partitioned table in redshift spectrum and it throws an error. The data is stored in S3, parquet files and one of the column is 'BINARY'. If i remove the partition column...
- Hello Team I want to upgrade my MySQL database from version 5.7 major to version 8.0 RDS. I made a two-way attempt. 1. In place upgrade: Modify Cluster not worked 2. Created new Database form Snap...
- Hi everyone, I continue to have problems with zero-ETL, which ends on its own in three days. even though both sides of those services are currently active. Can someone please assist us with a...
- how to determine the size of a dynamo DB attribute or to know the record that is the largest in the table. Are there any JS AWS SDK libraries that are helpful for these...
- Hello, I have parquets files in S3 that i parse using Glue Crawler and query in Athena. I found that some files have two columns "x" and "y" that have a type **int64** while other files have them as...
- I have a 5.7.mysql_aurora.2.12.2 cluster and both cluster and instance are using default parameter group `default.aurora-mysql5.7`. After created and selected AuroraDB for MySQL8.0 compatible cluster...
- Trying to connect to redshift database in python shell jobs. Tried with packages like psycopg2, redshift connector and pg. All of them gave similar error, hence I'm assuming problem is to establish...
- Hi all, Following this tutorial https://docs.aws.amazon.com/opensearch-service/latest/developerguide/configure-client-ddb.html. I have shared opensearch pipeline configuration for sinking all dynamoDB...
- If I have a cluster with two instances, one called 'reader' and the other 'primary.' If the reader experiences a 99% spike, the primary should step in to share the load?
- Background: I have a cluster of "Aurora MySQL", with "Credentials management" set to "Managed in AWS Secrets Manager". My service is a spring boot service, that takes the DB password via ENV vars on...
- We have a snapshot of RDS version 8.0.33 and we want to migrate to any potential version of Aurora MySQL. The problem is that on the migration screen there are Aurora MySQL 3.05.2 and 3.06.00 which...
- I've been getting a slew of INSUFFICIENT errors from CloudFront in the last week. I'm attempting to use Athena to discover what is happening with these 5xx Error Rates. I have a database already...
Recent Knowledge Center content
see all1/18
- AWS OFFICIALUpdated 2 months ago
- AWS OFFICIALUpdated 3 months ago
How do I end long-running queries in my Amazon RDS for PostrgreSQL or Aurora PostgreSQL DB instance?
AWS OFFICIALUpdated 3 months ago- AWS OFFICIALUpdated 6 months ago
- AWS OFFICIALUpdated 7 months ago
- AWS OFFICIALUpdated 7 months ago
- AWS OFFICIALUpdated 8 months ago
Recent community articles
see all1/18
- EXPERTpublished 10 hours ago0 votes70 views
- EXPERTpublished 2 months ago0 votes1525 views
- EXPERTpublished 2 months ago5 votes1775 views
- EXPERTpublished 5 months ago1 votes6828 views
- EXPERTpublished 5 months ago0 votes13788 views
- EXPERTpublished 5 months ago0 votes1696 views
- EXPERTpublished 7 months ago2 votes1478 views
- EXPERTpublished 7 months ago1 votes1929 views
- EXPERTpublished 8 months ago0 votes2493 views
- EXPERTpublished 8 months ago1 votes2193 views
- EXPERTpublished 8 months ago0 votes28614 views
Recent selections
see all1/4
- AWS OFFICIALUpdated 2 months ago0 votes4973 views
1/18
Riku_Kobayashi
EXPERTGary Mclean
EXPERTBrettski-AWS
EXPERTAntonio_Lagrotteria
EXPERTOsvaldo Marte
EXPERTGiovanni Lauria
EXPERTLeeroy Hannigan
EXPERTIndranil Banerjee AWS
EXPERTAWS-User-Nitin
EXPERTAdeleke Adebowale J
EXPERTMassimilianoAWS
EXPERTAWS-User-alantam
EXPERTGK
EXPERTFabrizio@AWS
EXPERTKallu
EXPERTAndrii S
EXPERT