Question : This question already has an answer here: Indexes: integer vs string performance if the number of nodes is […]
Tag: amazon-rds-aurora
Can AWS Aurora High Availability allow different Schema on Replicas?
Question : Our company is thinking of migrating from SQL Server to Amazon AuroraDB. In SQL Server, there are AlwaysOn […]
Is it possible to add Postgres extensions to AWS Aurora?
Question : I am trying to futureproof a Postgres database so it can be transferred to AWS Aurora. I am […]
Performance issues from RDS Aurora 5.6 to Aurora 5.7
Question : Recently upgraded one of my RDS instances to aurora mysql 5.7 from 5.6 and I’ve had to triple […]
Row size too large (> 8126) – 5.7.mysql_aurora.2.10.0
Question : CreateTableConstraintStep ddlList = (CreateTableConstraintStep) dslContext .createTableIfNotExists(getDSLTableName(List)) .columns(fields) .constraints(primaryKey(ID_COLUMN)) .storage(“ROW_FORMAT=COMPRESSED”); I’m trying to create a table with 250 columns […]
Aurora vacuum not deleting frozen empty pages?
Question : I recently ended up deleting most of the data in one of our tables, on purpose. Normally the […]
Aurora MySQL: how do I keep binlogs around after reboot?
Question : We have a request to enable binlogs on an Aurora MySQL instance and to keep those logs around […]