Data Base Migration from On Prem My SQL Server to AWS RDS using DMS
I wanted to migrate Database from On-Prem which is My SQL Server to AWS Managed RDS using DMS which can support database partitioning. I migrated My SQL server to AWS Aurora(MY SQL) using DMS but this is not supporting database partitioning. So is there any new version of AWS MY SQL supports data partitioning? or how can we migrate using DMS from on prem MY SQL Server to AWS Managed RDS (Any suggestion of RDS) which support Database partitioning along with performance.
Database partitioning is typically used as a technique for configuring a database in order to speed up queries.
Given that the objective is to ensure that your queries run faster, there are a couple of approaches you could use, whilst at the same time preserving the MySQL interface for your application:
a) Load your data into an Aurora MySQL database (without database partitioning) and try running bench-mark tests. Amazon Aurora database engine is designed to be wire-compatible with MySQL 5.6 and 5.7 using the InnoDB storage engine. I have seen quotes that in some cases Aurora can be 5 times faster than on-premises MySQL. It is possible that you will find you get the performance you need from Aurora, without having to resort to database partitioning. Have a look at https://aws.amazon.com/rds/aurora/getting-started/ Don't forget that you could just terminate the benchmark database once you have completed your tests, one of the benefits of using AWS is that you only need to pay for what you use.
b) see if turning on Aurora MySQL parallel query will improve your performance. Parallel Query can be enabled and disabled dynamically at both the global and session level using the aurora_pq parameter. Have a look at https://aws.amazon.com/rds/aurora/faqs/
c) if you are using lots of reads in your application, compared with writes, try introducing Aurora read replicas. https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Replication.html
It might also be worth reviewing the following best practices: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.BestPractices.html
Hope this helps
Relevant questions
migrate database from my local to AWS
Accepted Answerasked 3 years agodoes AWS DMS support partition tables from postgres
asked 5 months agoHow to migrate DB on premise Oracle to Microsoft SQL Server DB in AWS. We see SCT will not allow MS SQL Server as Target when source is Oracle. Looking for tools like SCT to move Schema from Oracle.
asked 19 days agoDMS to migrate SQL Server from RDS to EC2
asked 2 years agoabout endpoint connection
asked 4 days agoMigrate tables with LOBs from RDS MySQL to OpenSearch using DMS
asked 6 days agoIs there a service to move a database from MSSQL to MySQL (both hosted on AWS)
asked 4 months agoData Base Migration from On Prem My SQL Server to AWS RDS using DMS
asked a month agoIs it possible to use AWS RDS SQL Server as an AAG target from on premise primary?
asked 7 months agoContinues Replication between RDS MYsql to Keyspace Cassandra
Accepted Answerasked 2 months ago