Questions tagged [aurora]

The tag has no usage guidance.

25 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3
votes
0answers
955 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&...
1
vote
0answers
19 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 ...
1
vote
1answer
85 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 ...
1
vote
0answers
286 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
184 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
56 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
144 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
0answers
23 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 ...
0
votes
1answer
25 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. ...
0
votes
0answers
31 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
0answers
15 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
23 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
49 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
46 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
11 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
28 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
34 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
55 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
616 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
139 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
71 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
38 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
62 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
890 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/...