Questions tagged [aurora]
The aurora tag has no usage guidance.
62
questions
1
vote
2
answers
2k
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.
...
- 397
0
votes
3
answers
174
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 ...
- 473
0
votes
0
answers
243
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 ...
- 13
0
votes
1
answer
261
views
Does Aurora Serverless support Babelfish?
If running Amazon Aurora Serverless on PostgreSQL, is it possible to use the Babelfish for PostgreSQL feature?
- 103
1
vote
0
answers
2k
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 ...
- 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
+-----...
- 69
0
votes
1
answer
764
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 ?
- 101
0
votes
1
answer
153
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 ...
0
votes
1
answer
398
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. ...
- 103
0
votes
1
answer
884
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 ...
3
votes
2
answers
1k
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, ...
- 31
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> ...
- 343
1
vote
1
answer
1k
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
- 745
3
votes
0
answers
1k
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 ...
- 39
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 ...
- 1
0
votes
0
answers
646
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 ...
1
vote
1
answer
165
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 ...
- 11
3
votes
2
answers
4k
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 ...
- 525
0
votes
1
answer
377
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. ...
4
votes
1
answer
2k
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 ...
- 41
0
votes
0
answers
348
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 ...
0
votes
1
answer
202
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 ...
2
votes
1
answer
1k
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 ...
- 21
0
votes
1
answer
615
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,...
1
vote
1
answer
968
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)....
- 227
3
votes
2
answers
5k
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 ...
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 ...
- 241
1
vote
1
answer
594
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 ...
- 11
1
vote
1
answer
3k
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 ...
- 13
1
vote
1
answer
4k
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 ...
- 247
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, ...
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 ...
- 129
8
votes
1
answer
5k
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 ...
- 247
2
votes
0
answers
776
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 ...
- 141
31
votes
3
answers
29k
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;
...
- 411
0
votes
1
answer
568
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 ...
3
votes
1
answer
8k
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 ...
- 133
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
-------
...
- 43
4
votes
1
answer
7k
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/...
- 141
1
vote
1
answer
692
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 ...
1
vote
1
answer
339
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
...
2
votes
3
answers
645
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 ...
- 395
1
vote
0
answers
95
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 ...
- 119
0
votes
1
answer
71
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 ...
- 525
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&...
- 395
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....
- 418
1
vote
1
answer
446
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 ...
- 703
0
votes
1
answer
162
views
Amazon Aurora MySQL conditional comment queries
How does Amazon Aurora handle conditional queries based on MySQL version? I was unable to find any documentation on this.
For example, the code below inserts into a database for MySQL 5.6.4 or newer. ...
- 703
0
votes
1
answer
1k
views
Cannot connect to Aurora RDS using workbench over ssh
I set up an environment on AWS that consists of a VPC with a private and public subnet following the instructions for Magento Quick Start: http://docs.aws.amazon.com/quickstart/latest/magento/...
- 1
0
votes
1
answer
287
views
Amazon Aurora MySQL5.6 Performance Schema column datatype modified and can't be corrected
I'm having trouble getting performance_schema to work in a few of my Aurora instances. Brand new instances where I enable performance_schema work just fine, but several instances that I've had for ...
- 223