Questions tagged [aurora]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
316 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.
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
2k 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. ...
4
votes
2answers
10k 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 ...
1
vote
0answers
177 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, ...
1
vote
1answer
824 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
2