Skip to main content

Questions tagged [aurora]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
24 views

Getting OOM when trying to change id from int to bigint in MySQL w/ percona

We have 2.5tb table with id column as int in Aurora 3 (MySQL 8.0.26). We need to change it to bigint as ids will run out soon. We tested it with pt-online-schema-change and the server crashed because ...
Nir's user avatar
  • 533
1 vote
0 answers
91 views

Force index not working in Aurora MySQL 8

I have recently upgraded to Aurora MySQL engine version 8.0.mysql_aurora.3.05.2 from Aurora MySQL 5.7. I see huge performance issue after upgrading. Recently I found that I have queries whose indexes ...
Ali Mehdi's user avatar
0 votes
0 answers
10 views

Aurora3 RDS MySQL Stored function/trigger performance when using information_schema

Since moving to Aurora3 RDS (MySQL 8 based) vs Aurora 2 (MySQL 5.7 based) noticed that execution time of certain triggers and stored functions performance has degraded. Correlation between triggers ...
BigKiwiDev's user avatar
3 votes
2 answers
4k views

What's the advantage of sharding in AWS Aurora?

AWS' RDS docs on multi-master Aurora state the following: In an Aurora multi-master cluster, each shard is managed by a specific DB instance, and a DB instance can be responsible for multiple shards. ...
rinogo's user avatar
  • 437
0 votes
3 answers
591 views

Create user on Master does not create it on Slave

We have mysql replication set between two aurora clusters. Everything looks good and the replication is working well. However, I created a few hours ago a user on the master and I still don't see it ...
Nir's user avatar
  • 533
0 votes
0 answers
438 views

Fastest way to migrate largish (15 TB) PostgreSQL 11 instance to Aurora 14 in AWS

We have an AWS RDS PostgreSQL 11 cluster (currently version 11.13), in which we have a few databases and some 1500 tables. The RDS cluster is of size "db.r5.xlarge", with 4 vCPUs, 32 GB RAM ...
Robert's user avatar
  • 13
0 votes
1 answer
394 views

Does Aurora Serverless support Babelfish?

If running Amazon Aurora Serverless on PostgreSQL, is it possible to use the Babelfish for PostgreSQL feature?
SilentSteel's user avatar
1 vote
0 answers
3k views

How can I downgrade an AWS Aurora MySQL 5.7 2.09.2 to an earlier 5.7 version?

During a test, I applied a branch of our Terraform description that upgraded a couple Auroras from 5.7 2.04.x to 5.7 2.09.2 without losing the data (as expected). When attempting to apply the main ...
rbanffy's user avatar
  • 111
0 votes
0 answers
33 views

Setup amazon aurora as replica to mariadb master [duplicate]

I am trying to setup replication between MariaDB 10.4.17 and Aurora 5.7.12 MySQL, with Mariadb as master and aurora as replica. I am following this aws article I noted the file name and position +-----...
DB guy's user avatar
  • 69
0 votes
1 answer
1k views

AWS Aurora Mysql different instance types for writer/reader

I have a db.r5.large for the master/writer. I want to add some readers. Do they need to be the same instance type as the master? Or can i add for example 3x db.t3.medium ?
AFRC's user avatar
  • 101
0 votes
1 answer
241 views

How to keep history of MySQL/Aurora stored procedure revisions? [closed]

We need to maintain the history of the procedures. I think it will be easier to save the history in a table so every time someone either deletes or modifies the content of the procedure it will go and ...
user6163241's user avatar
0 votes
1 answer
548 views

Aurora vacuum not deleting frozen empty pages?

I recently ended up deleting most of the data in one of our tables, on purpose. Normally the table is append-mostly, with a short window during which updates might happen after the original insert. ...
Tuure Laurinolli's user avatar
0 votes
1 answer
1k views

What is the difference between Aurora Mysql 5.7.x and Aurora 2.x.x

I have an RDS instance with Aurora Mysql 5.7.12 and I noticed that there are other versions of Aurora Mysql 5.7, but I don't understand what is the difference between them. Some of the version ...
Roberto Briones Argüelles's user avatar
3 votes
2 answers
2k views

PostgreSQL 9.6.12 autovacuum constantly running on system tables

I come from a SQL Server, Oracle, Sybase DBA background but I am now looking into an AWS Aurora cluster running PostgreSQL 9.6.12 and have noticed something which I think is odd, but maybe it's not, ...
dodgybugga's user avatar
0 votes
1 answer
1k views

Question marks instead Hebrew characters after mysql dump and import

I tried to migrate my AWS RDS instance from Aurora to MySQL. I created a dump file from the Aurora and imported it into the MySQL instance. Both instances have the same characters set. mysql> ...
Omri's user avatar
  • 353
1 vote
1 answer
2k views

Is it possible that information_schema.columns doesn't hold an user table column information?

I am facing a strange issue here. I have a table which is not visible in information_schema.columns view. What could be the reason for that. Note: I am using RDS Aurora Postgresql 9.6.12
RBB's user avatar
  • 785
4 votes
0 answers
2k views

Error in ALTER DEFAULT PRIVILEGES

I'm trying to create a new user in AWS Aurora Postgres DB. Create user worked fine and I can login to the DB using that account. granting permissions to it isn't. First: GRANT ALL on ALL tables in ...
OLS's user avatar
  • 149
0 votes
1 answer
3k views

Aurora PostgreSQL CPU usage stuck at 100% for 8 hours

One of our Aurora PostgreSQL database's(48 cores) CPU usage stuck at 100% for nearly 8 hours. These situation happened 3 times in the past 4 months. We are using AWS's business support plan, in the ...
chengevo's user avatar
0 votes
0 answers
731 views

Cannot connect to RDS Aurora Mysql Database Even Though It Exists

We have an RDS aurora mysql instance that has been up and running for a while without issue, however, today our application's connection to the db failed, with error ERROR 1049 (42000): Unknown ...
user193130's user avatar
1 vote
1 answer
257 views

Should I add my index after the table is populated or before (MySQL. Aurora)

I know this has been asked in the past, but sometimes things change over time and I wanted to double check. I have a table with about 9 Billion rows. Should I add the index before inserting the data ...
John's user avatar
  • 11
4 votes
2 answers
6k views

Difference between Aurora Global database and Aurora regional database with multiple read replicas?

I am planning to migrate my 300GB RDS PostgreSql database to Aurora MySql using SCT and DMS. RDS Postgresql is in seven regions in current setup. Datapipelines are used to ingest data in these ...
Pravs_thedataguy's user avatar
0 votes
1 answer
466 views

Aurora postgres grant permission to pg_attribute

In the process of migration from local postgres version to and RDS aurora postgres version. I'm using temporal tables and do for that reason have temporal tables that are inhirited from the origin. ...
Peter Mølgaard Pallesen's user avatar
4 votes
1 answer
3k views

AWS aurora (postgres) proper value for the shared_buffers parameter

I think it's fairly well known that a normal PostgreSQL database has a starting value of 25% of system memory for its shared_buffers parameter, but I haven't been able to find anything regarding a ...
user188401's user avatar
0 votes
0 answers
528 views

AWS aurora mysql is restarted unexpectedly

In our system one of aurora mysql instances was't available for short period. because this instance suddenly restarted at 08/14/2019 3:56JST. we already checked error log for aurora. but i found ...
shunsuke_stackoverflow's user avatar
0 votes
1 answer
316 views

Is it possible to commit a transaction that is waiting to RollBack?

I'm using Aurora MySql 5.6.10a and a query that was loading a table with 700 million rows crashed and now it's rolling back. I turned autocommit off to try to speed the data load up, but now it's ...
Yago Carvalho's user avatar
2 votes
1 answer
2k views

AWS Aurora MySQL Serverless CPU utilization is growing for unknown reason

We have been using Aurora serverless databases in staging and production environments for a few months now, and find the CPU remains in the range 15-20% almost all the time. However in the past week ...
Phil192's user avatar
  • 21
0 votes
1 answer
629 views

How can we publish Aurora (Postgres compatible) logs to Cloudwatch?

I'm looking for a way to publish Aurora (pg compatible) db logs to cloudwatch. In Postgres RDS, there is an option when we "modify" the instance to enable publishing db and upgrade logs to cloudwatch,...
user2011104's user avatar
1 vote
1 answer
1k views

Recommended postgres parameters for index creation with 244gb RAM and 32 CPUs?

I have a 200 GB database with 26 tables that I need to create indexes on. Currently index creation takes a long time on the biggest tables, as they have ~12gb and 400,000,000 rows in them (>4 hours)....
JonLuca's user avatar
  • 237
3 votes
2 answers
6k views

Are the MariaDB and MySql drivers interchangeable when connecting to a MySQL backend Aurora cluster?

I saw a similar question asked before but I didn't get enough supporting information Does anyone know any new information on this? Can MariaDB connector (driver) be used instead of the MySQL ...
Hariharan Thavachelvam's user avatar
7 votes
1 answer
1k views

What is the apgcc schema in Amazon RDS Postgresql?

Recently a mysterious new schema called apgcc appeared in every database in our testing Aurora Postgresql cluster (eu-west region). It is owned by the rdsadmin account. What is it, and where did it ...
Adrian Cox's user avatar
1 vote
1 answer
616 views

migrating from a local PostgreSQL database to Amazon Aurora

I have a local PostgreSQL database and I want to migrate it to Amazon Aurora, how do I do that? I found a documentation on how to migrate from RDS PostgreSQL database, however, mine is local and I ...
blackfox's user avatar
1 vote
1 answer
4k views

Error log flooding with aborted connections (Aurora 2.03 - MySQL 5.7.12)

Here's some contextual information: I have a multi-tenant, WordPress MU installation running on Elastic Beanstalk, scaled up to 2 instances minimum. These are connected to the RDS database and are ...
Curtis's user avatar
  • 13
1 vote
1 answer
5k views

Is Postgres sharding available on Aurora (AWS)

I need to shard and/or partition my largeish Postgres db tables. The Postgres partitioning functionality seems crazy heavyweight (in terms of DDL). I see talk from <=2015 about pg_shard, but am ...
Mark Gerolimatos's user avatar
3 votes
1 answer
4k views

Aurora MySQL 5.7 randomly fails

This is the 5th time. It happens once a week (Tuesday or Wednesday within 03:00-07:00 UTC+0). On the console, it shows available but inaccessible. We try to wait if the instance will recover itself, ...
John Paulo Rodriguez's user avatar
2 votes
2 answers
2k views

MySQL tuning: INNODB_BUFFER_POOL_SIZE not found?

My replicator MySQL db, hosted by Amazon-RDS-Aurora is performing poorly. The DB is quite powerful so performance shouldn't be an issue. When I executed SHOW VARIABLES; I could not find ...
ColinMac's user avatar
  • 129
8 votes
1 answer
6k views

Why is Insert-Ignore so expensive in MySQL?

TL;DR: Inserting a large number of rows with no collisions is MUCH faster than (not) re-inserting the same rows, BOTH using the INSERT IGNORE syntax. Why is this? I would assume that the index lookup ...
Mark Gerolimatos's user avatar
2 votes
0 answers
958 views

How do you capture blocked transactions

I can run SELECT r.trx_id waiting_trx_id, r.trx_mysql_thread_id waiting_thread, r.trx_query waiting_query, b.trx_id blocking_trx_id, b.trx_mysql_thread_id blocking_thread, b.trx_query ...
bubba's user avatar
  • 141
33 votes
3 answers
40k views

Why do I get a PostgreSQL permission error when specifying a tablespace in the "create database" command?

When I create a database in PostgreSQL without explicitly specifying a default tablespace the database is created without issue (I'm logged in as the pgsys user): postgres=> create database rich1; ...
HuggieRich's user avatar
0 votes
1 answer
774 views

How do I truncate performance_schema tables on a read replica?

On occasion, you have to truncate events_statements_summary_by_digest, when it's hit the row limit. On a write master, this is easy, but on a read replica, there doesn't seem to be a way to do it. The ...
Sniggerfardimungus's user avatar
4 votes
1 answer
10k views

Necessity of having two instances (Reader and Writer) in Amazon Aurora

I'm managing an Amazon Aurora account. Somebody set it up months ago. The service has TWO instances (same AZ): - project - project-eu-central-1b Same class (db.t2.small), but different "Replication ...
Gorgo's user avatar
  • 143
4 votes
1 answer
3k views

SELECT COUNT(*) returning incorrect results

I am seeing some very strange behavior on PostgreSQL 9.6.3 on RDS Aurora. I am getting duplicate results from certain queries: => select count(id) from foos where id = 'deadbeef'; count ------- ...
RUN-CMD's user avatar
  • 43
4 votes
1 answer
8k views

How to enable force ssl on AWS Aurora Postgres?

In AWS's direct postgres offering RDS Postgres, you can require SSL by setting the parameter group item rds.force_ssl to 1. This is as per the RDS postgres documentation: https://docs.aws.amazon.com/...
JK.'s user avatar
  • 141
1 vote
1 answer
1k views

How to tell if I'm connected to an Amazon Aurora PostgreSQL cluster?

I've created few different instances, one instance is of Amazon Aurora PostgreSQL and other instances are of PostgreSQL, MySQL etc. How do I find our the Postgres instance is running within an AWS ...
Dharmik Gadhiya's user avatar
1 vote
1 answer
366 views

I can not find any document regarding to shared_heap_size

I am new to Postgres and recently I ran one command show all; It returned me a csv file with three columns name, settings, description. There are more than 200 results and out of which one result is ...
Dharmik Gadhiya's user avatar
2 votes
3 answers
856 views

MySQL Why is updating 0 rows slow?

Update: The where clauses are the same. The results are as outlined below. The following query runs within 0.1s and returns 0 results. SELECT id from content WHERE compliance_overridden = 1 AND ...
kev's user avatar
  • 397
1 vote
0 answers
106 views

How to find queries that use a given index for mysql?

I am looking to change indices on my MySQL table. My hunch was that one of the indices, that I am looking to remove, shouldn't be used. But it is being used, based on ...
Rahul's user avatar
  • 119
0 votes
1 answer
98 views

Single slave for multiple masters in AWS AuroraDB

We are planning to use AWS Aurora(MySQL version) as our relational database. There will be three masters in different regions. We need the data from these masters replicated in a single slave. I think ...
Pravs_thedataguy's user avatar
3 votes
0 answers
3k views

RDS Aurora 5.6 died (randomly?)

Aurora MySQL 5.6.10a I can see these events in the console: February 20, 2018 at 4:27:24 PM UTC+11 <server>-production DB instance restarted February 20, 2018 at 4:26:52 PM UTC+11 <server&...
kev's user avatar
  • 397
1 vote
2 answers
2k views

mysql access denied from localhost

I've a very weird problem on mysql/Aurora 1.14 I have installed on a Linux EC2 instance on AWS. I have an user able to connect remotely to the instance but not locally. select user,host from mysql....
Glasnhost's user avatar
  • 478
1 vote
1 answer
486 views

Migrating from MySQL RDS to Aurora RDS with CNAME record

I understand migrating to Aurora is simply a matter of creating read replica from MySQL source and then promoting when caught up and stopping writes on MySQL RDS previous master. I use Route 53 DNS ...
Chris Muench's user avatar