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
migrate database from my local to AWSAccepted Answerasked 3 years ago
does AWS DMS support partition tables from postgresasked 5 months ago
How 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 ago
DMS to migrate SQL Server from RDS to EC2asked 2 years ago
about endpoint connectionasked 4 days ago
Migrate tables with LOBs from RDS MySQL to OpenSearch using DMSasked 6 days ago
Is there a service to move a database from MSSQL to MySQL (both hosted on AWS)asked 4 months ago
Data Base Migration from On Prem My SQL Server to AWS RDS using DMSasked a month ago
Is it possible to use AWS RDS SQL Server as an AAG target from on premise primary?asked 7 months ago
Continues Replication between RDS MYsql to Keyspace CassandraAccepted Answerasked 2 months ago