Questions tagged with Migration & Transfer

Two questions. First, if you create a network on Amazon Managed Blockchain, then do you necessarily need to use AWS cloud storage? Or would it be possible to divide up the cloud storage among different providers? Second, Do all other members of an AMB network also need to use AWS cloud storage? If organization B wanted to join the network and insisted on using some other cloud storage provider, would it be possible for them to join the network? Or would the network operator need to launch a peer node on their behalf, using another AWS account?

Hello, I'm trying to migrate 5 local servers to the cloud, I'm using AWS Application migration service, I started with 4 servers for example servers: A, B, C and D and All the 4 servers replicated at 100% successfully. Then I ran the replication Agent in the 5th server "E" but as soon as I did this server B got replaced by the new server E. Server B got deleted from the source servers list. I tried re-installing the replication agent again in server B but now server E got replaced by server B. If I check the server info tab I see the IP and disk from server E but if a check the Disk settings tab I see the server B disks. I dont know what is happening, please help.

After migrating the SLES15 SP2 to SLES15 SP3, when I rebooted the system that time we are receiving below error message and its not booting up: ``` Cannot get hvm parameter CONSOLE_EVTCHN (18): -22! ``` How to resolve this issue?

How do I configure GP3 for SAP HANA? NOTE: This is a common question asked by AWS customers. The AWS team is posting it to provide an answer that can benefit everyone.

Hi Currently we have two dbs in AWS RDS (Postgres). One for Demo (Internal Testing) and another for beta environment. Both dbs have a schema called "strapi" which contains common data to display to user. Our use case is that whenever the admin updates the strapi data in demo db, it should reflect in beta as well. So I was searching for AWS services that supports our use case. Searched for similar questions and I found people recommending AWS DMS. So went ahead and created endpoints and initially ran the task with "Do Nothing" option for Target Table Preparation Mode. Later ran the full load task with "Truncate" option for Target Table Preparation Mode . The task failed with following error "RetCode: SQL_ERROR SqlState: 0A000 NativeError: 1 Message: ERROR: cannot truncate a table referenced in a foreign key constraint; Error while executing the query [1022502] (ar_odbc_stmt.c:4828). Failed to truncate table strapi.programs [1022502] (odbc_endpoint_imp.c:4372)" Tried setting session_replication_role parameter to replica on target database in RDS and still getting the same error. Any help would be appreciated. Note: I still am not sure whether AWS DMS is a good service for our use case. Thanks in Advance.

Hi, today is 05/02/2022 this document : https://aws.amazon.com/rds/faqs/?nc1=h_ls says: Q: What happens when an Amazon RDS DB engine version is deprecated? When a minor version of a database engine is deprecated in Amazon RDS, we will provide a three (3) month period after the announcement before beginning automatic upgrades. At the end of this period, all instances still running the deprecated minor version will be scheduled for automatic upgrade to the latest supported minor version during their scheduled maintenance windows. We are using PostgreSQL 10.14 (deprecated). run upon some db.m5.2xlarge and db.t2.micro instances. Does the above statement mean AWS have a process in place to automatic upgrade our PostgreSQL from 10.14 to 10.17 without human interaction? I just ran a select version() and the output still says 10/14 : PostgreSQL 10.14 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.3 20140911 (Red Hat 4.8.3-9), 64-bit Will AWS upgrade from deprecated minor version to highest non-deprecated minor it could find (which is 10/20) or the lowest non-deprecated minor version (which is 10.17)? When was the exact announced date for 10.14 deprecation? Is there any web page to show exact deprecated date for all deprecation version? Or how could I find such information?

Hi, We are not using RDS Servless but dedicated instance: We are deploying a new environment with PostgreSQL 10.14 on db.m5.xlarge with multi-zone and got the following error. We are using terraform to deploy all our resources: creating DB Instance: InvalidParameterCombination: Cannot find version 10.14 for postgres status code: 400, request id: 5c429ea1-4668-4b15-a43f-cd3e07ed09e3 I double checked here : https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Concepts.DBInstanceClass.html and it said db.m5.xlarge does support Postgres 10.4 above. However, 10.14 is deprecated. Is that the reason we got "cannot find version 10.14 for Postgres"? this command : aws rds describe-db-engine-versions --default-only --engine postgres only shows version 13 and 14. Are these the only 2 supported by AWS currently? I am actually curious about the most effortless upgrade path if we need to upgrade. this page : https://docs.aws.amazon.com/AmazonRDS/latest/PostgreSQLReleaseNotes/postgresql-versions.html#postgresql-versions-version10 seems indicating we can upgrade from 10.14 to 10.20. Is Amazon going to support 10.x for long time? Or it's wiser to upgrade to 14.x? Thank you!

[dms cost]( https://aws.amazon.com/dms/pricing/) According to the above web page on DMS costs, the listed fees are added on an hourly basis depending on the instance type. Question. Is there a charge for just having a replication instance (even if the database migration task is not running)? Or is the fee charged only when the database migration task is running? For example, if I create a replication instance and run the database migration task for 2 hours a day with an api like boto3 below, do I have to pay for only 2 hours of usage? [boto3 api]( https://boto3.amazonaws.com/v1/documentation/api/latest/reference/services/dms.html#DatabaseMigrationService.Client.start_replication_task)

We are running DMS task which is ingesting from the on-prem mssql table with over 200mil records and has LOBs in it. Ingestion takes ~ 33 hours On-prem DB has a backup that happens after midnight and the task is failing right after that. Below are the logs: ``` [SOURCE_UNLOAD ]D: Network error encountered [SOURCE_UNLOAD ]D: Is connection error? TRUE [SOURCE_UNLOAD ]D: Endpoint is disconnected [1020414] (endpointshell.c:3807) [SOURCE_UNLOAD ]W: Error was encountered while FETCH-ing data from table ... [SOURCE_UNLOAD ]D: Error executing source loop [1020414] ``` I haven't tried the executeTimeout in the source endpoint connection attributes yet and wanted to ask what would be the suggested option to get around the timeout on the source issue

I am migrating data from a MySQL DB to DynamoDB. I am using object-mapping rule to transform the data to match my needs. However I have a EPOCH timestamp stored in MySQL DB that I would like to transform to Datetime before loading into my DynamoDB. I see there is a transformation rule I could use to by leveraging SQLite expressions. However I couldnt use transformation rules in conjunction with object-mapping. Is there any other way I could transform my date field by still using 'object-mapping' rule ?

We are planning on spinning down a few of our hosted AWS virtual machines, but wanted to be able to download them to later be launched/run locally as a VMWare vmdk or Microsoft VDI. What's the most common method for doing this?

A Linux box has one 500GB hard disk, 200GB is the "/" partition, 10GB is "swap" partition, remaining is "unallocated" space. I am using MGN to lift and shift this Linux box to AWS, but agent always migrates the entire disk including the "unallocated" space. To save the storage cost, can I just migrate specific partition? Thanks in advance!

Hi Team, Please clarify below as I fail to search suitable answers in documentations / Knowledge center - 1. how to Move AWS Environment to a new AWS Environment 2. how to Migrate servers own VPC and account 3. how to create DC Controller (new domain) in AWS ? 4. how to create brand new servers in the new AWS account (further to Q1) 5. hot to Create images and move them to the new account (further toQ4) 6. how to do DNS change for new account? 7. If I create a new domain on GoDaddy and want to move to AWS new account (created in Q1) , how to move the registered domain? 8. How to ensure that all users (from old AWS / from Godaddy) are in the new domain? 9. How to ensure successful migration from old AWS to new AWS ?

I am trying to understand what size instances I would need to run the Oracle Fusion Middleware products within AWS. Currently, they sit on premise and they have massive boxes that are not overly taxed. The issue is that the way they have them configured on VMware; they have a huge heap file that is designated at startup, which makes the box look like it is using more resources than it actually is. Does anyone have insight into how this software might run in AWS and how to properly size the target EC2?

Hello, We are looking for migrating existing 3 tier angular java and db2 application into server less AWS architecture. What are the best practices we should consider? Any reference or pointers for documentation would help. This is what we are thinking as part of POCs to start with, 1. POC 1 - Migration of DB2 to Aurora (Not sure, which one we should go with, Aurora provisioned or server less) 2. POC 2 - Angular - AWS s3 Java - Lambda and API gateway DB2 - Aurora Thanks in advance.

My client has 4000+ VMs running over the OpenStack Environment. Can Migration Evaluator be used here for Discovery purpose

Hello, I created my OVA file for my VM via VirtualBox and loaded it to S3. After importing it to Image Builder to create an AMI, I get the 'ClientError: Unsupported kernel version 5.10.0-10-amd64' error after some time during the import, the operation aborts. I selected the Amazon Linux 2 OS and I was under the impression that this OS was upgraded to 5.10 back in November 2021 per this post: https://aws.amazon.com/about-aws/whats-new/2021/11/amazon-linux-2-ami-kernel-5-10/ Can someone point out how this issue can be resolved? Or is there no solution at the moment to resolve this issue. Thanks for any feedback and let me know if you need any further information.

I've got a VPC in an account atm, seems I need to move/recreate my VPC, all my subnets, routes, basic security groups etc. wonder if there is a tool that can create the cloud formation script know there is a vanilla cloud formation yaml file, which you can configure... hoping there is a tool that can create the file based on a current VPC.

Hello, As I know, we can create a replication in any EFS to replicate the data to another EFS in another region. Is this approach available for Replication across accounts ? If not, what the best practice to replicate EFS accross accounts? Thanks

I'm looking for the info formerly included in an old forum thread that has disappeared with the migration to the new AWS re:Post forum. Is it possible to find the info in this thread? https://forums.aws.amazon.com/thread.jspa?threadID=261247 I'm looking for info on migrating our existing Simple AD directory to a new AWS Managed Microsoft AD directory.

Can someone help me with the best options to migrate SAP HANA to AWS cloud.

Hello, I just have my domain with email service integrated. Should I move only 2 emails from this service to Amazon Workmail? Thank you

I have set up S3 replication from a version bucket to another (versioned) bucket on the same account (SRR). A tag is used to scope the replicated file(s). Every night, a new version of each file is uploaded to the source bucket, and this new version becomes the current version (versioned backups). With a batch operation, I have replicated the current version of the file to the destination bucket without problems, so permissions are set correctly. I understood only current versions will be replicated, not previous versions. However, replication does not seem to take place at all when a new version is uploaded to the source bucket. The destination bucket only has the version from the batch operation, which is 4 versions behind on the source bucket. Why are the new versions not replicated?

If DataSync is configured with an on-prem NFS mount as the source, and EFS as the target, will changes to the EFS volume be reflected on-prem?

I have data in mongodb and I want to use some of the properties saved in that database to start and maintain a graph database using amazon neptune. I can use aws dms to get the initial batch of data, but how about maintaining and updating the data as it changes in mongodb? Essentially I need to keep the neptune database synced up with the mongodb database because mongodb remains my primary database. As a simple example, consider that mongodb contains, among other things, users' lists of subscribers. I want this info available for graph queries in neptune, but changes to that info are saved in mongodb primiarily so they need to be forwarded to neptune to keep neptune current. Is there a best-practice for doing something like this? The bulk loader and dms options implicitly assume that I'd be inserting large amounts of data at a time, but these may be simple small changes like one user subscribing to another user. What's the best/correct/recommended way to go about this?

According to https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.Migrating.html#AuroraPostgreSQL.Migrating.RDSPostgreSQL.Replica.Create I should be able to create a Aurora Postgres Read Replica from RDS Postgres 11.12 instance. But the option does not exist in the dropdown menu when the DB primary is selected (or read replicas). The region is us-east-1, N. Virginia. Thanks for the help!

Has anyone successful migrate a linux VM, which using overlayfs (read only) to AWS EC2?

Hello, What is the recommended way to create a snapshot (for backup) of an RDS Postgres instance to apply schema changes? We want to maintain both replicas in sync, minimize downtime and keep the new replica up to date. We want to create and keep a snapshot in case we need to rollback these schema changes. I have made research and found https://aws.amazon.com/getting-started/hands-on/move-to-managed/migrate-postgresql-to-amazon-rds/ not sure if this feature can be used for this purpose. Will live schema changes break the migration? Our schema changes are simple, we are adding nullable new columns to existing tables and we are also creating new tables. Thank you in advance.

I plan on deleting/deactivating my instances of EC2, but before I do so, I want to transfer all my existing data from EC2 to S3 so I have a copy for permanent storage. How do I do this?

We need to replicate data between two collections in AWS documentDB to get rid of duplicate documents. Source and Target is AWS documentDB instances version 4.0.0. I've created a unique index in target table to only allow non-duplicate values. I needed to create index before migrating the data to new target, because our data size in ~1TB and index creation on source collection is impossible. Full load fails after the following error. Task status becomes table error and no data is migrated further to that collection. ``` 2022-03-23T03:13:57 [TARGET_LOAD ]E: Execute bulk failed with errors: 'Multiple write errors: "E11000 duplicate key error collection: reward_users_v4 index: lockId", "E11000 duplicate key error collection: reward_users_v4 index: lockId"' [1020403] (mongodb_apply.c:153) 2022-03-23T03:13:57 [TARGET_LOAD ]E: Failed to handle execute bulk when maximum events per bulk '1000' was reached [1020403] (mongodb_apply.c:433) ``` ``` "ErrorBehavior": { "FailOnNoTablesCaptured": false, "ApplyErrorUpdatePolicy": "LOG_ERROR", "FailOnTransactionConsistencyBreached": false, "RecoverableErrorThrottlingMax": 1800, "DataErrorEscalationPolicy": "SUSPEND_TABLE", "ApplyErrorEscalationCount": 1000000000, "RecoverableErrorStopRetryAfterThrottlingMax": true, "RecoverableErrorThrottling": true, "ApplyErrorFailOnTruncationDdl": false, "DataTruncationErrorPolicy": "LOG_ERROR", "ApplyErrorInsertPolicy": "LOG_ERROR", "ApplyErrorEscalationPolicy": "LOG_ERROR", "RecoverableErrorCount": 1000000000, "DataErrorEscalationCount": 1000000000, "TableErrorEscalationPolicy": "SUSPEND_TABLE", "RecoverableErrorInterval": 10, "ApplyErrorDeletePolicy": "IGNORE_RECORD", "TableErrorEscalationCount": 1000000000, "FullLoadIgnoreConflicts": true, "DataErrorPolicy": "LOG_ERROR", "TableErrorPolicy": "SUSPEND_TABLE" }, ``` How can I configure AWS DMS to continue even if such duplicate key errors keep on happening. I tried modifying the TableErrorEscalation count and many other error counts but loading always stops at first duplicate key error. I have 580k Documents in test workload for this task.

Hello, I'm attempting to install the AWS **Legacy** Replication Agent on a Windows 2008 R2 server but it fails with the error message: `This agent installer is not suitable for the current operating system. You can d ownload the appropriate installer from: https://aws-application-migration-service-us-west-2.s3.amazonaws.com/latest/wind ows/AwsReplicationInstaller.exe ` I did attempt to install the non-legacy installer just to try, but it expectedly failed with the following. `AwsReplicationWindowsInstaller.exe Traceback (most recent call last): File "build\installer_utils\uuid_monkey.py", line 19, in <module> File "c:\build\prod_windows_installer\.python-3.8.10-32bit\lib\site-packages\P yInstaller\loader\pyimod03_importers.py", line 623, in exec_module File "ctypes\__init__.py", line 7, in <module> ImportError: DLL load failed while importing _ctypes: The parameter is incorrect [1568] Failed to execute script uuid_monkey ` I've tried downloading and installing the legacy agent from multiple regions, the primary being ap-east-1 (Hong Kong) and the test being us-east-2 (Oregon), but it fails regardless of the region. Does anyone have any experience successfully installing the agent on Windows Server 2008 R2 or is there an older version of the agent that actually install successfully and I can download? Thanks!

I want to migrate emails from AWS Workmail to NameCheap Cpanel hosting. How can I do that?

we had used Server Migration Service in past to migrate On Premise servers to AWS and this activity created many AMI with name *Created by SMS* can we delete that?

Hi Guy I need some help / advise. Is it possibe to install really old service portal on AWS? Apache 2.0 Handler PHP Version 5.3.3-7+squeeze9 PGSQL v. 8.4 I have to somehow take over it from the last owner and install somewhere. Just to ask you if you think it is doable? Thanks Marta

Hi, I am trying to import the Oracle data dump file using S3 integration. We received the Dump file via SFTP from other customer and I could successfully copy it to DATA_PUMP_DIR, but when I try to import it using DBMS_DATAPUMP operation, I am getting the below error saying ORA-31694 : XXXX table "DBNAME.SYS_IMPORT_SCHEMA_02" failed to load/unload, ORA-02369: internal number in header in file <**.dmp> is not valid. did anyone face this issue before? if yes, can you plz provide some insights? I want to rule out RDS side of issues before asking the customer to check the file on their side

Hi, I have a DMS task to move data from Oracle CDC to Redshift. (Full Load and ongoing changes). During the full load, the task just keeps on running and is not reaching a 100%. In the target, I can see the row count is already 4 times the row count in the source. There are 4x full row duplicates in the target. Can anyone please guide what could be the issue here and how to debug? thnx.

Customer wants to migrate 900 TB of unstructured data( file data) and this data continues to change/update. We are thinking to use snowball for the data migration and datasync to sync the incremental data after the migration. Can we use DataSync to transfer any incremental changes after the migration (something like DMS used to migrate database CDC) ? what are the other options to sync the incremental changes ?

Hello, By using [https://documentation.suse.com/suse-distribution-migration-system/15/single-html/distribution-migration-system/index.html#_run_the_migration](), I have migrated EC2 Instance which is running on SLES12 SP3 --> SLES12 SP4 --> SLES12 SP5 to SLES15 SP1. Now we would like to migrate from SLES15 SP1 to SLES15 SP2 and then to SLES15 SP3. To do so when we fire command "zypper migration", below mentioned error is occurring: ``` Can't get available migrations from server: SUSE::Connect::ApiError: The requested products 'HPC Module 12 x86_64' are not activated on the system. '/usr/lib/zypper/commands/zypper-migration' exited with status 1' ``` All repositories are of SLES15 SP1 in the output of "zypper repos". However SUSE Registration status shows, the product 'HPC Module 12 x86_64' as not registered. Please guide me to fix the issue and migrate from SLES15 SP1 to SLES15 SP2.

We want to migrate our physical server to AWS it is not hosted on any Hypervisor.

I keep getting SafeMode activated message on my Wordpress website, even after I have tried to transfer connection or create a new connection. My brother has helped my set up the hosting and we did it following the instructions on AWS Lightsail. So we set it up with the IP address 18.168.98.182 and I first logged in to my dashboard via this link http://18.168.98.182/wp-admin/ . I have installed jetpack and woocommerce payments plugins. Then I’ve got my own domain name beadembroideryart.com and I think this created a duplicate page or something like that. Now I login to my dashboard via http://beadembroideryart.com/wp-admin/ . But the problem is that every now and again I get a notification SafeMode activated transfer your connection from 18.168.98.182 to beadembroideryart.com or create new one. When I click transer connection it goes away for a short time and comes back again in a while. When I do a new connection it’s the same and the only difference is that I need to set up my payments again from the start. I don’t know what am I doing wrong as there is no other option to choose from. Does this mean that the IP doesn’t redirect to the domain and this causes a duplicate connection conflict for WooCommerce Payment detection?

Hello, I am wondering if there is a way to recover data/information or migrate a EC2 server (that I can no longer access due to issues with MRD) to another AWS EC2 server?

Need guidance regarding most common issues while migrating, and things to take care of

Hi all, Is there a master's degree anywhere that teaches AWS Solution Architect - Professional content? I'm looking for a master's degree that will make it easier for me to pass the exam. I've seen many online courses, but I think it takes too little time. Two years, I think it's appropriate to be able to sit the AWS Professional Exam and also get a master's degree. Thank you very much.

Hi All, I am looking for guidance/ inputs in selecting an **opensource tool for assessment** of application software (multi program language supported) by scanning **code from Git repos** to derive dependencies in terms of connectivity in multi-tier architecture (between web-app-db, caching, message broker, external integrations etc.). Idea here is to prepare target AWS architecture + migration approach based on assessment report. Appreciate if anybody has any suggestion on tool or how to handle assessment? Thanks.

Trying to upgrade our Aurora Clusters finally. Got them recently updated to 11.13, but every attempt I make to upgrade to 12.8 fails with **"Database cluster is in a state that cannot be upgraded: Postgres cluster is in a state where pg_upgrade can not be completed successfully."** Here are the logs which I think point to the culprit: **2022-02-11 22:37:53.514 GMT [5276] ERROR: could not access file "$libdir/postgis-2.4": No such file or directory 2022-02-11 22:37:53.514 GMT [5276] STATEMENT: LOAD '$libdir/postgis-2.4' 2022-02-11 22:37:53.515 GMT [5276] ERROR: could not access file "$libdir/rtpostgis-2.4": No such file or directory 2022-02-11 22:37:53.515 GMT [5276] STATEMENT: LOAD '$libdir/rtpostgis-2.4'** command: "/rdsdbbin/aurora-12.8.12.8.0.5790.0/bin/pg_ctl" -w -D "/rdsdbdata/db" -o "--config_file=/rdsdbdata/config_new/postgresql.conf --survivable_cache_mode=off" -m fast stop >> "pg_upgrade_server.log" 2>&1 waiting for server to shut down....2022-02-11 22:37:53.541 GMT [5185] LOG: received fast shutdown request 2022-02-11 22:37:53.541 GMT [5185] LOG: aborting any active transactions 2022-02-11 22:37:53.542 GMT [5237] LOG: shutting down ................sh: /rdsdbbin/aurora-12.8.12.8.0.5790.0/bin/curl: /apollo/sbin/envroot: bad interpreter: No such file or directory 2022-02-11 22:38:10.305 GMT [5185] FATAL: Can't handle storage runtime process crash 2022-02-11 22:38:10.305 GMT [5185] LOG: database system is shut down -------- I found several other articles that point to issues with Postgis, so I followed what they suggest, but no luck. First our cluster is running Postgis 2.4.4. So I went ahead and updated this to 3.1.4, tried the approach to restart the instance and validate its really using Postgis 3 and that all looks fine. Nothing helps though. If anyone has suggestions, I am happy to try. Thanks Thomas

Hello: --- We have 18 DMS replicate tasks with origin endpoints from SQL server databases on premises to target ec2 SQL server endpoints. Same database versions. All tasks are replicating with this red status: "Running with errors". we have 2 x r5.2xlarge replication instances. cloudwatch logs are reporting always the same error. [DATA_STRUCTURE]E:SQLite general error. Code <19>, Message<UNIQUE constraint failed: events.identifier, events.eventType, events.detailMessage> What is causing this error? We dont know if the replication is going well

We are currently on mysql 8.0.16 on a t2.2xlarge instance. We have automatic updated turned OFF. According to the documentation here: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_UpgradeDBInstance.Maintenance.html#Mandatory_OS_Updates we are not affected by this. however.... We have tried creating a new replica on the new minimum required mysql version (8.0.23). We are in a situation where replication is broken due to collation problems (even through the replica is based on a fresh snapshot of our primary). It appears to be a problem with the scenario: primary (8.0.16) -> replica (>= 8.0.23) We are now worried that we will be forcibly upgrades (OS and mysql version) next month, leaving us in a broken state. Can anyone shed some light on this and what course of action we must take? Many thanks.

Just started a new instance to run my python3 script. I need several libraries which I can install with pip3 (pip3 install requests runs well) but I can't get logging library installed. I have this output: $ pip3 install logging > ``` Defaulting to user installation because normal site-packages is not writeable Collecting logging Using cached logging-0.4.9.6.tar.gz (96 kB) ERROR: Command errored out with exit status 1: command: /usr/bin/python3 -c 'import sys, setuptools, tokenize; sys.argv[0] = '"'"'/tmp/pip-install-_n141mbi/logging/setup.py'"'"'; __file__='"'"'/tmp/pip-install-_n141mbi/logging/setup.py'"'"';f=getattr(tokenize, '"'"'open'"'"', open)(__file__);code=f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'"');f.close();exec(compile(code, __file__, '"'"'exec'"'"'))' egg_info --egg-base /tmp/pip-pip-egg-info-pxlnpi1y cwd: /tmp/pip-install-_n141mbi/logging/ Complete output (48 lines): running egg_info creating /tmp/pip-pip-egg-info-pxlnpi1y/logging.egg-info writing /tmp/pip-pip-egg-info-pxlnpi1y/logging.egg-info/PKG-INFO writing dependency_links to /tmp/pip-pip-egg-info-pxlnpi1y/logging.egg-info/dependency_links.txt writing top-level names to /tmp/pip-pip-egg-info-pxlnpi1y/logging.egg-info/top_level.txt writing manifest file '/tmp/pip-pip-egg-info-pxlnpi1y/logging.egg-info/SOURCES.txt' Traceback (most recent call last): File "<string>", line 1, in <module> File "/tmp/pip-install-_n141mbi/logging/setup.py", line 13, in <module> packages = ["logging"], File "/usr/lib64/python3.7/distutils/core.py", line 148, in setup dist.run_commands() File "/usr/lib64/python3.7/distutils/dist.py", line 966, in run_commands self.run_command(cmd) File "/usr/lib64/python3.7/distutils/dist.py", line 985, in run_command cmd_obj.run() File "/usr/lib/python3.7/site-packages/setuptools/command/egg_info.py", line 297, in run self.find_sources() File "/usr/lib/python3.7/site-packages/setuptools/command/egg_info.py", line 304, in find_sources mm.run() File "/usr/lib/python3.7/site-packages/setuptools/command/egg_info.py", line 535, in run self.add_defaults() File "/usr/lib/python3.7/site-packages/setuptools/command/egg_info.py", line 571, in add_defaults sdist.add_defaults(self) File "/usr/lib64/python3.7/distutils/command/sdist.py", line 226, in add_defaults self._add_defaults_python() File "/usr/lib/python3.7/site-packages/setuptools/command/sdist.py", line 135, in _add_defaults_python build_py = self.get_finalized_command('build_py') File "/usr/lib64/python3.7/distutils/cmd.py", line 298, in get_finalized_command cmd_obj = self.distribution.get_command_obj(command, create) File "/usr/lib64/python3.7/distutils/dist.py", line 857, in get_command_obj klass = self.get_command_class(command) File "/usr/lib/python3.7/site-packages/setuptools/dist.py", line 768, in get_command_class self.cmdclass[command] = cmdclass = ep.load() File "/usr/lib/python3.7/site-packages/pkg_resources/__init__.py", line 2461, in load return self.resolve() File "/usr/lib/python3.7/site-packages/pkg_resources/__init__.py", line 2467, in resolve module = __import__(self.module_name, fromlist=['__name__'], level=0) File "/usr/lib/python3.7/site-packages/setuptools/command/build_py.py", line 16, in <module> from setuptools.lib2to3_ex import Mixin2to3 File "/usr/lib/python3.7/site-packages/setuptools/lib2to3_ex.py", line 13, in <module> from lib2to3.refactor import RefactoringTool, get_fixers_from_package File "/usr/lib64/python3.7/lib2to3/refactor.py", line 19, in <module> import logging File "/tmp/pip-install-_n141mbi/logging/logging/__init__.py", line 618 raise NotImplementedError, 'emit must be implemented '\ ^ SyntaxError: invalid syntax ---------------------------------------- ERROR: Command errored out with exit status 1: python setup.py egg_info Check the logs for full command output. ``` I can't understand why this happens. Anybody has an idea how to install logging ? Thanks

I am exploring DMS for migrating RDS to Aurora database. Can someone please explain how this migration type works: "Migrate existing data and replicate on-going changes" Time T1 - So, my application is talking Source database Time T2 - I use DMS to migrate data from source to target database. Time T3 - Data migration completes.. Time T4 - I change my application to use target database by changing the endpoint of the database My question is - Is the above correct ? What happens to data writes between Time T3 and T4 ? Does. "replicate on-going changes" , means, it will keep replicating the data from Source to Target till it is not stopped , and will make sure all writes get replicated to Target database ?

For Major version upgrades in Aurora cluster, AWS documentation says: "*To safely upgrade your DB instances, Aurora PostgreSQL uses the pg_upgrade utility described in the PostgreSQL documentation. After the writer upgrade completes, **each reader instance experiences a brief outage** while it's upgraded to the new major version automatically*." Document link: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/USER_UpgradeDBInstance.PostgreSQL.html If the cluster has 10 replicas is it possible to do the upgrade in batches or one-by-one, so that the clients dependent on the replicas do not experience downtime ?

DMS load fails from Oracle NUMBER(38) source to Aurora Postgres BIGINT (INT8) target. Passes premigration assessment. All values being migrated are below 2,000,000,000 (~BIGINT limit). The load succeeds if the target datatype is changed to Postgres NUMERIC. Inserting "102675852.0000000000" manually (using SQL) to the same column defined as BIGINT also works without error. The full error is "ERROR: 22P02: invalid input syntax for type bigint: "102675852.0000000000" ("LOCATION: scanint8, int8.c:127", "STATEMENT: COPY "(table name)"."(column name)" FROM STDIN WITH DELIMITER ',' CSV NULL 'attNULL' ESCAPE '\'"). Could work around by changing datatype after load, but the table is quite large so this takes much too long for our purposes.

Hi all, I'm trying to convert VMware virtual machines to EC2 instances, but the import always fails with "ClientError: Unknown OS / Missing OS files." Here's my process: 0) I start with a CentOS 7.9 VM on ESXi (supported according to [https://docs.aws.amazon.com/vm-import/latest/userguide/vmie_prereqs.html#vmimport-operating-systems]()). The VM is bootable, has only one volume (MBR, ext4) and otherwise nothing special. 1) I use ovftools to export the VM from ESXi to .ova: ``` /usr/lib/vmware-ovftool/ovftool --X:logFile=mytestvm-log.txt --X:logLevel=warning --noSSLVerify --powerOffSource vi://$user:$pass@vmhost/mytestvm /volumes/vmexport/mytestvm.ova Opening VI source: vi://$user@vmhost:443/mytestvm Opening OVA target: /volumes/vmexport/mytestvm.ova Writing OVA package: /volumes/vmexport/mytestvm.ova Transfer Completed Completed successfully ``` I tried this as well as exporting to OVF and then manually creating a tar file from it - same result. There's nothing in the log that indicates any problem. I can re-import the ova file and run it on ESXi, so it doesn't seem to be broken in any way. 2) Upload the .ova to S3: ``` aws s3 cp --sse --acl private /vm/mytestvm.ova s3://mv-ova-test ``` 3) Create a presigned URL for the file: ``` aws s3 presign s3://mv-ova-test/mytestvm.ova --expires-in 86400 ``` 4) Make a .json to describe the import: ``` [ { "Description": "ova-import-test", "Format": "ova", "Url": "https://mv-ova-test.s3.eu-central-1.amazonaws.com/mytestvm.ova?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential={the rest of the URL}" } ] ``` 5) Start the import: ``` aws ec2 import-image --description "ova import test" --disk-containers "file://mytestvm.json" { "Description": "test ova import", "ImportTaskId": "import-ami-06c5fc120d02749d7", "Progress": "1", "SnapshotDetails": [ { "Description": "mytestvm", "DiskImageSize": 0.0, "Format": "OVA", "Url": "https://mv-ova-test.s3.eu-central-1.amazonaws.com/mytestvm.ova?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential={the rest of the URL}", "UserBucket": {} } ], "Status": "active", "StatusMessage": "pending" } ``` 6) Check the import task: ``` { "ImportImageTasks": [ "Description": "test ova import", "ImportTaskId": "import-ami-06c5fc120d02749d7", "Progress": "19", "SnapshotDetails": [ { "DiskImageSize": 7062419968.0, "Format": "VMDK", "Status": "active", "Url": "https://mv-ova-test.s3.eu-central-1.amazonaws.com/mytestvm.ova?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential={the rest of the URL}", "UserBucket": {} } ], "Status": "active", "StatusMessage": "converting", "Tags": [] } ] } ``` 7) And in the end I get: ``` { "ImportImageTasks": [ { "Description": "test ova import", "ImportTaskId": "import-ami-06c5fc120d02749d7", "SnapshotDetails": [ { "DeviceName": "/dev/sde", "DiskImageSize": 7062419968.0, "Format": "VMDK", "Status": "completed", "Url": "https://mv-ova-test.s3.eu-central-1.amazonaws.com/mytestvm.ova?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential={the rest of the URL}", "UserBucket": {} } ], "Status": "deleted", "StatusMessage": "ClientError: Unknown OS / Missing OS files.", "Tags": [] } ] } ``` 8) Trying to import the vmdk alone makes no difference: ``` { "ImportImageTasks": [ { "Description": "test vmdk import", "ImportTaskId": "import-ami-0e1dc2522176e0cdf", "SnapshotDetails": [ { "Description": "test-vm", "DeviceName": "/dev/sde", "DiskImageSize": 7062419968.0, "Format": "VMDK", "Status": "completed", "Url": "https://mv-ova-test.s3.eu-central-1.amazonaws.com/mytestvm.ova?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential={the rest of the URL}", "UserBucket": {} } ], "Status": "deleted", "StatusMessage": "ClientError: Unknown OS / Missing OS files.", "Tags": [] } ] } ``` So. What could be the cause for "ClientError: Unknown OS / Missing OS files" if I use a supported OS and the .ova seems to be intact? Would I have the same issue if I tried using MGN for this? Thanks, Marc

In AWS CloudFront, at the origin server, the content is divided into media segments which are further distributed through edge locations. But there does not seem to be any details to indicate that the privacy protections envelopes/details were also injected from the content source along with the file segments. Since the origin server adds the privacy protection envelopes to the consecutive segments, can it be inferred that the origin server also injects the privacy protection envelope along with the consecutive file segments? Thank you so much for your quick and timely response.

Hi, I have an existing (and old) site, avidcruiser.com. I am looking for someone to help me migrate from either Codeguard or where the site is currently hosted, Littlebizzy.com. The database is large - 20.4 gb - and files are 10 gb. The site gets about 11,000 page views a month. It could increase if cruise ships return to service and our site gets busy again. I have set up a LIghtsail instance with Wordpress and am trying to figure out what I need. Could anyone recommend what I need? I believe it’s a container and database. I would also need backups. Thank you.

Hi, We are looking to migrate all our Oracle applications - Oracle Fusion Middleware, Oracle SOA Suite 12c, Oracle OBIEE 12c, Oracle OID, Oracle ODI etc and also Oracle databases (19c) from Oracle Cloud Infrastructure to AWS. All of them are running on Oracle Linux 7. We have terraform scripts used to deploy those infrastructure components. We want to know if the same terraform scripts we used to deploy those infrastructure components into Oracle Cloud can be used to deploy/migrate to AWS or do we need to rewrite everything. Anyone done anything like this and any documentation/guidance on this would be of great help. If we can reuse the terraform script we used in Oracle Cloud with some modifications, is there any guidance on what/how to modify those terraform scripts. Hope my question is clear, but any more clarification, please let us know. Thanks

I am trying to migrate MySQL ( version 8) which is hosted in Azure Redhat VM to the RDS instance using Database Migration Services. 1. I have created both source and target endpoints - connections are successful 2. Replication Instance has been created 3. Migration Task has been created. 4. However the progress of the task is 0 % from last 4 hours and not sure what is happening. Please help me with the same.

Hi I'm try migrating my website wordpress to aws, I try 3 plugins, didnt work, because size limite, other empty, Could you please help me migrate my wordpress to lightsail using wordpress too, all wp migation, updraflus these plugins not working. I will appreciate your help thanks

I am experiencing an issue after the MYSQL upgrade from version 5.7 to 8 on AWS RDS. Before the upgrade, my server used to work properly but immediately after getting the database updated to version 8, it appears to be broken. The error is as follows: ``` Connections could not be acquired from the underlying database! ``` I am fairly new to MYSQL and I could not find a suitable online solution to solve this issue. Ideally, I would like to know if there is a proper way to view an "in-depth" log about any exceptions causing this as it is the only error message I am getting. Or perhaps, I am looking for some guidance about what might cause this failure in the database connection, please. I am lost at this point. Your help will be much more appreciated! I wish to thank you in advance for your help.

We have a database on a SQL Server Standard Edition version 2016 on an EC2 Instance and we have continuous replication for a small portion of the data over to an Aurora Postgres Database using DMS. Sometimes out of the blue, we notice that our data on Aurora has fallen behind, by as much as 90 mins, i.e. data was added in SQL Server but 90 mins later still has not been migrated over by DMS. This can happen times when there is not much a load on either database, i.e. there be only a few transactions to replicate over but nothing is happening. When looking at the logs of the DMS instance we do see this: "Reading from source is paused. Total storage used by swap files exceeded the limit 1048576000 bytes" but as I mentioned there is not much data to replicate and the DMS instance does not seem to be under much stress. Any ideas of what might be causing this would be most welcome. Thanks

In AWS CloudFront, at the origin server, the content is divided into media segments which are further distributed through edge locations. But there does not seem to be any details to indicate that the privacy protections envelopes/details were also injected from the content source along with the file segments. Since the origin server adds the privacy protection envelopes to the consecutive segments, can it be inferred that the origin server also injects the privacy protection envelope along with the consecutive file segments? Thank you so much for your quick and timely response.

Hello, Is anyone aware of how to convert SEsparce VMware images into AMIs? Doesn't look like it's supported in the [VM Import/Export tool](https://docs.aws.amazon.com/vm-import/latest/userguide/what-is-vmimport.html).

Hi, According to https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.Migrating.html#AuroraPostgreSQL.Migrating.RDSPostgreSQL.Import.Console it's possible to migrate PostgreSQL RDS (12.7) to Aurora by adding Aurora Read Replica. But I have no such option for my PostgreSQL RDS. Is it has some problems in this feature? I tried other options "Migrating an RDS for PostgreSQL DB instance using a snapshot", but it also inacitvated button in my dashboard. Is it possible that the feature was announced but isn't available yet?

Workdocs Migration from S3 - Subscription Email Never Arrives for Workdocs Migration When selecting "Migrations" under "Apps", when logged in as a WorkDocs Admin. I get the message on the screen "Checking if you are subscribed to receive...." from here I get the message below Subscribe to email notification Subscribe to the email notification to receive migration status updates. Click on Subscribe to send subscription email to your inbox. Then, confirm the subscription via email and click on Continue. But the email never arrives and the page never progresses to the next point, so I have 800GB of files in an S3 bucket that I want to bring into Workdocs... I didn't think this was so difficult? am I missing something here? from reading the admin docs, this approval email starts the whole process and I can't progress without it. I have checked the Forms and can't seem to find an answer to this issue. The Admin guide for the Workdocs migration, Step 3. Scheduling a migration - stats that this email approval step needs to be completed to proceed. Any assistance will be appreciated.

we need to migrate our windows 10 pro VM from VMware to AWS we can able move the same but the question is how we can manage license part as AWS doesn't provide license to win 10 client OS how do I proceed then? thanks in advance

I am consistently unable to start a Datasync task to transfer from a local NAS (Synology) to s3. Tried dozen of times with slight changes, NFS versions, squash options, agent reboot, etc... with no success. The tasks all have the unavailable status, with an error message "mount.nfs: access denied by server while mounting..." Setup: - DataSync agent running as a KVM VM on ubuntu 20.04 LTS - DataSync agent connected - NFS share on a Synology NAS on the local network - NFS share permissions provided for the agent IP (and even for the local network) - DataSync agent connectivity and NFS connectivity tests are all successful - mounting the NFS share on ubuntu 20.04 LTS works perfectly Could you please help? What is going on?

i am facing some issues in installing AWS migrating tool in red hat 6.9, **URLError: <urlopen error unknown url type: https>**

I have a migration job for a Windows machine that's failing to launch the test/cutover instance using the Application Migration Service and is spitting this out: **Error: An error occurred (InvalidParameter) when calling the RunInstances operation: The AssociatePublicIpAddress parameter is only supported for VPC launches.** The destination subnet is a public one and is configured to assign public IPs on launch; manually launching an instance in the subnet does get assign an ephemeral public IP. Any help would be greatly appreciated.

We have a PostgreSQL DB with single-tenant structure that include around 15k schemas. The data size is around 3 TB. We want to replicate the data of those schemas into one big MySQL multi-tenant DB. Note: all schemas have the same tables' structure, and the same for the target DB. Can DMS help us achieving that?

Hello, I have the Oracle 19c that running on my laptop, and I can connect to it from other laptops. Then I setup a endpoint to access to this Oracle, and provided my public ip address that I got it from [https://whatismyipaddress.com/]() , port, user and password. Then I tried to test this endpoint with created replication instance to check connection but received error **"Application-Status: 1020912"** and** "Login timeout"** Note: I disabled firewall on my laptop. And add rule to outbound with my public IP address in security group to allow connection access to my laptop. I'm going to use DMS for data migration from on-premise to Oracle RDS, so want to do some steps with my laptop in advance. Are there more steps I need to do at AWS then can access to my Oracle on my laptop? Please advise. Thank you.

How do I enable partitioning from console? In other words there is no ay to set the following using website... --s3-settings '{"DatePartitionEnabled": true, "DatePartitionSequence": "YYYYMMDD", "DatePartitionDelimiter": "SLASH"}'

We have two separate accounts in different regions. My team works with the destination account and we want a database from source account which has PostgreSQL 11.5 standard Linux Ubuntu installation on EC2. In the destination we are RDS, so we want to essentially migrate from EC2 to RDS cross region and cross account. I know you can create a database in RDS from snapshot. I like that idea but can we create a database from the Postgres EC2 snapshot/data dump? If we can’t then what’s the best solution, the data size is 15 TB. And I have seen the migration from EC2 postgres dump to RDS postgres but I'm not sure if this can be done cross. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/PostgreSQL.Procedural.Importing.EC2.html

I need to migrate my AWS storage file gateway to a new one because the running one is being deprecated. Following this https://docs.aws.amazon.com/storagegateway/latest/userguide/migrate-data.html#migrate-data-file-gateway And not finding it clear Current gateway runs on vmware, 4 disks. By step 4 I have a powered off old vm and removed all 4 virtual disks from it. deployed a new ova in step 5 Step 6 tells you to configure the network on the new vm, give it a static IP if necessary. Then Step 7 is turn it on. Not sure how you can configure an IP before turning it on, but that's fine it still makes sense. Step 8 is to attach the old disks to the new vm. Question - do I remove the disk that's already there on this new vm? Or attached all 4 old disks so I now have 5 attached? Why am I told to attach them with the vm running? Step 9 is go to a url the example given is http://198.51.100.123/migrate?gatewayId=sgw-12345678 The IP used must be my new VM ip (can be the same as the old one) and the gatewayid is the exisiting gateway ID? Now step 11 is stop the new vm Step 12 is to detach the old gateway's root disk. So my new vm is back to 4 disks? Is that right? I'm a little confused. Anyone been able to do this procedure?

Hello, I have two questions regarding the tableau Server and Installation Can we install Tableau on AWS Elastic Beanstalk Environment running Ec2 instance? Also is there a way to install Tableau Server on Serverless Environments such as AWS Lamda or AWS Fargate?

HI, a client has implemented the following solution. https://aws.amazon.com/solutions/implementations/cross-region-replication-monitor/ No error at installation, however some fields of the dynamoDB table are not updated (replication status being one of them). I have been trying to find what could be the reason but without success. wondering if any one faced the same issue before ? Thanks

I'm trying to import a vps from Hetzner to AWS, I created an OVA file using VMWARE converter and generated OVA file using VMWARE ovf tool, at on-premise environment the VM boots without any problem, but when I'm trying to import to AWS using aws ec2 import-image it seeams to get stucked updating at 27" The VM it's a debian 8, how can get more log to see in depth which is the problem. Many thanks for your help Best regards

Hi all, We are currently facing some issues with connecting our on-premises SAP system to AWS via AWS AppFlow. We decided to use the OData interface as described [here in the official AWS documentation](https://docs.aws.amazon.com/appflow/latest/userguide/sapodata.html). The interface (for now) is publicly accessible and can be called via Postman for example. When we try to set up the connection via AWS Appflow we receive the following error: ``` Error while communicating to connector: Client error: The request to SAP failed with the status code: 400 and error message: Unable to find valid certification path to requested target and response: (Service: SandstoneBridgeService; Status Code: 400; Error Code: ConnectorClientException; Request ID: b54c78ce-1264-401c-b889-81b1252f3a8c; Proxy: null) ``` On the [common errors page](https://docs.aws.amazon.com/appflow/1.0/APIReference/CommonErrors.html) for AppFlow I can't find this error and also searching community forums didn't really help so far. Has anyone ever experienced this problem or has any suggestion how to resolve this? Any help is very much appreciated. Thanks in advance! Patrick

Hi, I am looking for a prescriptive guide or a methodology white paper that discusses the steps in migrating existing EC2 application workload to ECS/EKS.

A customer wants to move its IPV installation (with data) from on-prem to AWS. The storage layer on premise relies on their own object storage solution which has an S3 compatible API (https://docs.ceph.com/en/latest/radosgw/s3/). Now the customer wants to move 70 TB of content to AWS together with the whole IPV suite. While the compute related part has been solved (they have been in contact with IPV and sized accordingly to their needs) the migration of the data is still open. We have discussed both DataSync and SnowBall. DataSync can support [on prem object store as source][1] and keep the metadata intact and it could work for a full migration and eventually scheduled syncs until the cut-over happens, but moving 70TB takes 8-9 days with a dedicated 1Gbit/s connection. I assume he also needs to purchase a Direct Connect too to ensure this expected speed. My preferred option for this customer however would be to use SnowBall for the initial heavy bulky migration and then use DataSync to keep the data in sync later on. Does SnowBall allow to copy the on-prem object store with their metadata and move them to S3? [1]: https://aws.amazon.com/blogs/aws/aws-datasync-adds-support-for-on-premises-object-storage/

I am using *AWS DMS* to perform migration from on premise **SQL Server to Aurora PostgreSQL**. 1/ After performing the data migration task step, I am seeing same table name twice in PostgreSQL database. One table was created during schema conversion tool and 2nd table was created during data migration task. Is there any option in data migration task to prevent creation of new table,if it exists. 2/ I am also facing issues when converting the schema using AWS Schema Conversion Tool.It seems SCT is not supporting auto conversion of computed fields, temp tables and trigger objects to targeted Aurora PostgreSQL database. Does SCT automate part of the process, and not all of the process.

How can I use the Cisco CSR1000V to extend L2 network from on-premises to AWS, e.g. to support migration use cases with hardcoded IP addresses?

I am currently migrating an Amazon RDS for PostgreSQL database from Amazon EC2 to Amazon Aurora PostgreSQL-Compatible Edition. I am using AWS DMS and have encountered the following issue: One of the columns in a particular table stores the values of water pressure measured within a second. This column is an array of decimal numbers (Ex: {2.44, 5.66, 8.55}). I received the following error message during the migration from AWS DMS: "1 unsupported data type '_float4' on table 'data1', column 'pressure'". Does AWS DMS support ARRAY data type for double or floating point numbers? The AWS documentation indicates that the arrays can't be migrated. However, further down on the same page, it's mentioned that AWS DMS supports arrays from a source RDS for PostgreSQL database and that arrays are mapped to CLOBs in AWS DMS. I'm looking for some guidance on whether ARRAY data type is supported by AWS DMS during migration. The reports return the following error: Note: You can see that the pressure column is indicated with real[] . 1 unsupported data type '_float4' on table 'data1', column 'pressure' pipeminder=# \d data1 Table "public.data1" Column | Type | Modifiers ---------------+--------------------------+----------- device_id | bigint | not null timestamp | timestamp with time zone | not null pressure | real[] | not null pressure_min | real | not null pressure_mean | real | not null pressure_max | real | not null flow | real | not null Indexes: "data1_unique_device_time" UNIQUE CONSTRAINT, btree (device_id, "timestamp")

Customer that is testing the migration process from Oracle On-premises to Oracle on EC2. They're performing: 1. backup using RMAN from an Oracle Database 11GR2 on-premises. 2. Restore it on Oracle 18c with upgrade option on EC2. 3. Start a replication from on-premises 11G to ec2 18c AWS using SCN. Does it work? As I could see in our documentation we can do it using datapump: https://aws.amazon.com/blogs/database/migrating-oracle-databases-with-near-zero-downtime-using-aws-dms/ But can we do the same steps and instead of datapump use rman? Thank you very much!

Hi, Customer wants to migrate a storage gateway between accounts. Do we have other way to do it besides copying the data between the accounts? What would be the best practice? Thinking about possible cost/performance tradeoffs. Thank you.

hello Im trying out a migration approach where a oracle database backup has been exported to an S3 bucket. I created my target Oracle RDS instance with S3 Integration option. I Imported the oracle dump from S3 using S3 integration import command and run data pump to restore the database to my target Oracle RDS. I then run DMS to sync the delta from the source database using an SCN starting point which was provided after the dump was created. So far it looks good and my Oracle RDS is able to sync the delta changes after the dump was created. I used a small database data for this demo. I want to get some insights on this approach and if you would still recommend using DMS when importing data from S3 instead of S3 integration? I like how this approach I used where I never have to manually create table objects. It would be good if someone can point out some AHAs! I might be missing? or was there someone who did a similar approach before on a production environment?? thanks

My customer wants ultimately to migrate multiple CloudFront Distributions from one AWS Account to another but realize [it’s not quite possible](https://aws.amazon.com/premiumsupport/knowledge-center/cloudfront-migrate-account/). Right now their CloudFront Distribution is configured this way: - CNAME of the CloudFront Distribution is the same as a production customer-facing FQDN (e.g.: download-office.customer.com) - in Route53 customer-facing FQDN is pointed to CloudFront Distribution FQDN using CNAME record (e.g.: download-office.customer.com CNAME d11ipsxxxxxxx.cloudfront.net) What they want to do is to introduce an intermediate FQDN and place it in between the customer-facing FQDN and CloudFront Distribution FQDN using Route53 Alias Records. So the configuration would look like: - CNAME of the CloudFront Distribution is the same as a intermediate FQDN (e.g.: balancer-download-office.customer.com) - in Route53 intermediate FQDN is pointed to CloudFront Distribution FQDN using ALIAS record (e.g.: balancer-download-office.customer.com ALIAS d11ipsxxxxxxx.cloudfront.net) - in Route53 customer-facing FQDN is pointed to intermediate FQDN using ALIAS record (e.g.: download-office.customer.com ALIAS balancer-download-office.customer.com) It's working in their QA environment but they would like feedback on any issues. However, they are finding from support engineers that the only way to swap a CloudFront distribution without downtime is specifically [through a support case](https://aws.amazon.com/premiumsupport/knowledge-center/resolve-cnamealreadyexists-error/). The question is: **what is the best way for my customer to seamlessly switch between CloudFront distributions, and ultimately move to a CloudFront distribution in another account without downtime?**

A customer is running ~60 MySQL databases (the majority are 5.5, the rest are 5.6) on-prem and are using GCP for DR/backup site (they do not perform local backups in their DC). Their database vary in size and can reach up to 3 TB. The way they sync the data with the DR site is by backing up the databases on-prem using Percona XtraBackup, copy the backup files to the cloud and import into the databases in the cloud from these backup files. They then use statement based replication (SBR) for updating the DR site continuously. Same mechanism is used to migrate data back to their data center when they need to recover a database from backup or when they will need to fail back after a DR. To perform backups, they just create volume snapshots at different intervals on the cloud (hourly for the first day, daily for the fist week, weekly for the first month and then monthly for 6 months). They want to migrate the DR/backup site to AWS. They could use a similar approach and use MySQL on EC2, but there is not much benefit for them in this, so they are willing to move only if they can use managed services (Aurora MySQL, RDS MySQL). I need to come with a solution that will address their requirements: - Use Percona XtraBackup and not mysqldump due to the format of the files and the time it takes to seed a database from dump files - Continuous replication (to achieve near zero RPO), using statement based replication - Ability to move back to on-prem in short time when needed - Use managed services If I understand correctly, they can use the same mechanism for 5.6 using Aurora. They can import into an Aurora cluster from XtraBackup files and then they can set up SBR from on-prem to AWS. However, this solution does not solve the other direction. They can't backup Aurora (or RDS) using XtraBackup. This means that they will either need to use mysqldump, which they don't want to use as they claim it takes way too long. As an alternative they can create a MySQL Instance as a replica of Aurora and then use it to create the backup. Q1: Are there any other options to achieve what they need? Q2: How long should it take to create an Aurora replica on EC2 from a large database? Q3: Can the same mechanism be used to migrate from 5.5 on prem to Aurora 5.6? (and vice versa) Q4: Assuming that the answer to Q3 is yes, how backwards compatible is 5.6? Will the applications that use 5.5 work against 5.6 or will they need to be rewritten? Assuming there are issues with replicating from 5.5 to 5.6, they will need to use RDS MySQL 5.5 on AWS. My understand is that 5.5 does not support importing XtraBackup files. Q5: Is there a way to use XtraBackup with 5.5? If the answer to Q5 is no, they could use mysqldump or DMS to replicate from on-prem to the cloud. The initial seeding will be slower than XtraBackup if I understand correctly. Q6: Is there a preferred solution for the initial seeding? DMS? mysqldump, mydumper, etc.? Can they use SBR after the initial seeding? Q7: How to move back the data from RDS 5.5? Q8: I guess what I am asking is: What is the best solution for them for 5.5 (and maybe also 5.6)?

I am looking for best practices on the process of migrating MySQL RDS to Aurora Serverless while minimizing any downtime.

Is there an easy way to migrate from Aurora Postgres to RDS Postgres? My customer has several Aurora instances overprovisioned (the smallest available aurora instance type is way bigger than what they need), and wants to migrate them to regular RDS. I can think only of pg_dump or Database Migration Service. Are there any other ways that I'm missing?

A customer of mine is interested in switching from Amazon RDS (MYSQL) to Amazon RDS (Aurora). His concern: The RDS instances that he is currently using are not in a VPC. When he started using the instances the default was not a VPC. Will that have any implications on the DB migration tool? It was not 100% clear to me in the documentation. Thank you

What type of guidance we can provide to a customer who is looking to migrate hundreds of VMs running Windows server. Is dedicated host the only option to reuse those licenses? Is there an internal expert who can guide them through the process and evaluate options? Regards