Questions tagged [aurora]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
7
votes
1answer
2k 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; ...
6
votes
1answer
634 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 ...
4
votes
1answer
2k 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/...
3
votes
1answer
490 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 ------- ...
3
votes
1answer
3k views

Stale table lock in AWS Aurora?

We have an AWS Aurora (MySQL engine, r3.large) we are using to test a migration. We have noticed a couple of queries that simply don't appear to run. When I run show engine innodb status; it ...
3
votes
2answers
7k views

Aurora / MySQL 5.6 process list thousands of threads in state 'cleaned up'

I have a scaling issue with an application, it uses Aurora as the DB and uses Slick as the ORM. I am not sure where the issue lies but I have a question releated to MySQL / Aurora that I hope will ...
3
votes
0answers
699 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 ...
3
votes
0answers
1k 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&...
2
votes
1answer
62 views

How to optimize this select with join and order-by?

We have two tables: CREATE TABLE `messages` ( `id` int(11) NOT NULL AUTO_INCREMENT, `created` int(10) unsigned DEFAULT '0', `user_id` int(11) DEFAULT '0', .... `subject_id` int(11) unsigned ...
2
votes
3answers
133 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 ...
2
votes
2answers
664 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, ...
1
vote
1answer
992 views

Should I use UUIDs or integer primary keys to optimize for massive writes of relational data?

I am working on a computer vision data pipeline and am unsure of how to structure my database to optimize for writes. I have massive amounts of image data that is being collected on an ongoing basis. ...
1
vote
1answer
2k views

How many databases can an Amazon Aurora instance hold?

When the word database is defined for table-families, Can an Aurora instance hold more than a database? Does any Aurora instance even has the concept of separated database(table family)? Thanks
1
vote
1answer
96 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 ...
1
vote
1answer
138 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 ...
1
vote
1answer
665 views

Is inserting into a table with a foreign key constraint slower than inserting without constraint?

When using MySQL (actually, Aurora), will inserting into a table with a foreign key constraint be slower than the same table without the constraint?
1
vote
1answer
69 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)....
1
vote
1answer
191 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 ...
1
vote
1answer
508 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 ...
1
vote
2answers
404 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 ...
1
vote
1answer
2k 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 ...
1
vote
2answers
552 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....
1
vote
2answers
7k views

How to avoid lock wait timeout exceed and improve MySQL InnoDB write speed

I ran a multi-threaded client spawning 25 threads to make concurrent API calls and insert data to AWS Aurora server. After some time, I started to see timeout error: lock wait timeout exceeded try ...
1
vote
1answer
2k views

MySQL default wait_timeout is 28800 but in my server I can see more than that value

Im using AWS MySQL Aurora, the current wait_timeout is 28800 which is the default one, and interactive_waitimeout is also 28800. But I can see more than the default value.
1
vote
0answers
224 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 ...
1
vote
1answer
149 views

Amazon's Aurora PostgreSQL

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
0answers
50 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 ...
1
vote
0answers
130 views

MySQL partition on 2 tables one with millions of rows the other with 100's of millions

I have two mostly de-normalized tables in Amazon Aurora (MySQL). The first table had mostly dimensions that are used for selecting the proper data. Examples might be station, program name, operator, ...
0
votes
1answer
235 views

Convert Code from SQL Server to MySQL [closed]

What will be the MySQL code for below code in SQL Server. SELECT @cols = STUFF((SELECT ',' + QUOTENAME(col+cast(rn as Nvarchar(max))) from ( SELECT row_number() over(partition by ...
0
votes
1answer
291 views

What are the advantages of going with AWS aurora DB with Mysql backend over AWS aurora DB with Postgresql backend [closed]

What are the advantages of going with AWS Aurora DB with Mysql backend over AWS Aurora DB with Postgresql backend? It's great if someone can share your experience or point out a document.
0
votes
1answer
219 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,...
0
votes
1answer
185 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 ...
0
votes
1answer
236 views

percona-online-schema-change is taking a lot of time

We have a table with 600M+ records and using AWS Aurora with master-slave replication. Requirement: We need to add two columns with index in customer table. Aurora Instance Specs: Ram: 30.5 GB ...
0
votes
0answers
11 views

aurora postgresql logs

We are in the process of sending logs of Aurora PostgreSQL to a SIEM log management solution. However, there doesn't seem to be a option to publish Aurora PostgreSQL to Cloudwatch log group. Is there ...
0
votes
0answers
21 views

Amazon Aurora Cross Region Replica Not read only

I am doing a cross region replica of an aurora 5.6 database. When I connect to the reader end point I can still edit. For read_only the value is {TrueIfReplica}. If I change it to 1 it is then read ...
0
votes
0answers
28 views

Amazon Aurora Single vs multi az deployemnt

I am looking to switch from mysql rds to aurora rds. Right now I use mysql multi-AZ. When reading about Aurora I noted that the storage layer is stored in 3 AZ's. If an aurora instance fails the time ...
0
votes
0answers
35 views

Aurora Global Database Multi-AZ

When setting up a global database for Aurora I get the following option: Multi AZ: Create an Aurora Replica/Reader node in a different AZ (recommended for scaled availability) Will this create a ...
0
votes
0answers
10 views

Amazon aurora run without read replica?

If my application can run with 10 minutes of downtime on instance crash do I need a read replica for production aurora instance? It is important I never lose data. A read replica would reduce downtime ...
0
votes
0answers
24 views

Disable aurora failover

I will be stopping replication on a reader instance for aurora and want to prevent failover to this reader or any reader in cluster How do I do this?
0
votes
0answers
27 views

estimating I/O for aurora from current mysql rds instance

If I have the following averages over the last 4 weeks for mysql rds instance db 1 77.7 writes/second, 8.54 reads/second db 2 108 writes second, 8.56 reads/second (2629746 = seconds in a month) ...
0
votes
0answers
45 views

amazon aurora read_only {TrueIfReplica}

I have {TrueIfReplica} for read_only in parameter group for Aurora. I setup my aurora to replicate from an external master but it is 0 when I look at read_only in show variables. Why is this?
0
votes
1answer
232 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 ...
0
votes
0answers
111 views

Finding Aurora functions (PostgreSQL)

On Amazon Aurora in the PostgreSQL (10) flavor there is a function names aurora_replica_status() documented. I can use the function and look at its definition: postgres=> select * from ...
0
votes
1answer
442 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 ...
0
votes
1answer
55 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 ...
0
votes
1answer
37 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 ...
0
votes
1answer
53 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. ...
0
votes
1answer
811 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/...