All Questions
Tagged with amazon-rds migration
20 questions
0
votes
1
answer
206
views
Is it possible to query Oracle system tables (DBA_USERS,dba_role_privs,dba_tab_privs) Using Db_link?
Is it possible to query Oracle system tables (DBA_USERS,dba_role_privs,dba_tab_privs) Using Db_link?
I am getting ORA-00942: table or view does not exist when tried to query the same.
- 13
1
vote
1
answer
1k
views
AWS RDS MySQL upgrade from 5.7 to 8 failing due to ROW_FORMAT
We need to upgrade our DB to version 8, but we're getting an error in the migration log that's preventing us from upgrading.
Creating indexes larger than 767 bytes on tables with redundant row format ...
user3411972
0
votes
0
answers
476
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 ...
- 125
0
votes
1
answer
114
views
Do MySQL limitations apply to MariaDB as well on AWS RDS
I am thinking of migrating MariaDB 10.3.13 to RDS, I want to do an analysis of what limitation can be caused by migrating to RDS, I could find no documentation by AWS for MariaDB for issues and ...
- 69
0
votes
3
answers
136
views
Is there performance loss in out of sequence inserted rows (MySQL InnoDB)
I am trying to migrate from a MySQL AWS RDS instance with a huge SSD and too much excess space down to a small one, and data migration is the only method. There are four tables in the range of 330GB-...
- 223
0
votes
1
answer
59
views
Migrate Oracle 12c to 18c in AWS RDS
Currently we have an Amazon RDS Oracle 12c instance and we need to upgrade it to Oracle 18c in a new RDS instance.
What is the correct approach to do this?
Can we set up an 18c instance staright ...
- 147
4
votes
1
answer
885
views
Migrate large (200GB) mysql databases to new hosts with as little downtime as possible
My question is about migrating large amounts of MySQL data with as little downtime as possible.
I have 3 MySQL databases that need to be moved from one RDS instance inside a VPC into a brand new AWS ...
0
votes
1
answer
576
views
MySQL DB Migration from on-premises to AWS through replication
I am having a production MySQL server with set of 20 databases in on-premises server. Now I require to migrate few databases from production server to AWS RDS without disturbing other databases in one-...
- 1,007
0
votes
1
answer
86
views
MySQL how to migrate to new server without data lost?
I'm using AWS RDS, with 1 master & 1 slave.
Just now I alter 1 of the table and hangup halfway, so I force stop the process. Now the database got some problem.
Let say I wanted to instantiate a ...
- 121
9
votes
2
answers
4k
views
Postgres 9.4 wal_level=logical increases disk space
I am trying to use the AWS Database Migration Service to migrate data from an RDS Postgres instance to an Aurora MySQL instance.
Database Migration Service requires the wal_level to be set as logical ...
- 271
1
vote
1
answer
144
views
Migrating PostgreSQL DB from AWS to Alibaba Cloud
I'm migrating PostgreSQL RDS instance from AWS located in Frankfurt to the RDS instance in Alibaba Cloud also located in Frankfurt.
I use Data Transmission tool from Alibaba Cloud. It connects both DB ...
1
vote
1
answer
2k
views
Moving a PostgreSQL database to a different AWS RDS instance
I have an AWS RDS instance with multiple PostgreSQL databases in there including an application database and a monitoring database. The problem is that the monitoring database is consuming lots of ...
- 111
-1
votes
1
answer
518
views
Move data chunk from table with 200+million rows to a new table MySQL
Our DB is hosted in AWS MySQL RDS. The data is such that each company that signs up gets its own set of tables which then receive enormous amount of data in them.
Currently we want to move a chunk of ...
- 1
2
votes
1
answer
466
views
Why is my dev server faster than a much more powerful RDS?
I'm running a huge data migration. Probably ~100 million rows total across a few dozen tables.
There is a lot of reformatting. About 50% of it is done through PHP while the rest uses INSERT INTO... ...
- 141
0
votes
1
answer
866
views
How long will it take to migrate a 5 GB Database to Amazon RDS [closed]
I just need an estimation.
How long will / can it take to move a 5 GB big database from an external source to amazon RDS. What is best practise to do it?
I just moved succesfully a few days ago a ...
- 103
1
vote
2
answers
774
views
SQL Azure Migration Wizard - Duplicate Primary Key
Just did a test at migrating a 120gb database onto RDS using SQL Azure Migration Wizard
Because we can't afford any downtime for "just" a test we ran the tool on the live database (meaning ...
- 175
1
vote
2
answers
3k
views
How to migrate postgreSQL on EC2 instance to AWS RDS?
I have a large PostgreSQL DB (around 100GB) which is on EC2. I want to migrate it to RDS.
How can I achieve this with minimal downtime?
- 11
2
votes
1
answer
12k
views
How can I synchronize data between two RDS MySQL databases
I have 2 Amazon RDS MySQL instances, one is MySql v5.5 and the new one is 5.6.
I want to upgrade the 5.5 to the 5.6 but you cannot do upgrades at this time, so we are trying to migrate the data. I ...
- 123
0
votes
1
answer
285
views
Looking for suggestions to Migrate Amazon RDS Large Instance to non-amazon host - Live
We have an Amazon RDS Large instance with a database of about 20GB that needs to be migrated without having to take our website down or minimize downtime to less than a couple of hours.
And I am ...
- 123
4
votes
1
answer
930
views
Migrating development and production databases to AWS
After careful thinking and asking on meta.stackoverflow, I'm posting this question on the DBA site. If anyone thinks this question should be on serverfault or any other site, feel free to close and ...
- 2,837