Setup amazon aurora as replica to mariadb master

I am trying to setup replication between MariaDB 10.4.17 and Aurora 5.7.12 MySQL, with Mariadb as master and aurora as replica. I am following this aws article

I noted the file name and position

+---------------+----------+--------------+------------------+ | File          | Position | Binlog_Do_DB | Binlog_Ignore_DB | +---------------+----------+--------------+------------------+ | binlog.000169 |  1387829 |              |                  | +---------------+----------+--------------+------------------+ 

I created mysql dump from mariadb and loaded that into aurora. after which I created a replication user on the master instance like this

CREATE USER 'replication_aurora'@'%' IDENTIFIED BY 'repl_pass';

GRANT REPLICATION CLIENT, REPLICATION SLAVE ON *.* TO 'replication_aurora'@'%';

and called the procedure on Aurora

CALL mysql.rds_set_external_master ('ip of master', 3306,     'replication_aurora', '<password>', 'binlog.000169', 1387829, 0); 

more about the above procedure here then i called this procedure

CALL mysql.rds_start_replication; 

This was supposed to start replication but I am getting this when i run SHOW SLAVE STATUS \G;

*************************** 1. row ***************************                Slave_IO_State:                   Master_Host: master_ip                   Master_User: replication_aurora                   Master_Port: 3306                 Connect_Retry: 60               Master_Log_File: binlog.000169           Read_Master_Log_Pos: 1387829                Relay_Log_File: relaylog.000001                 Relay_Log_Pos: 4         Relay_Master_Log_File: binlog.000169              Slave_IO_Running: No             Slave_SQL_Running: Yes               Replicate_Do_DB:           Replicate_Ignore_DB:            Replicate_Do_Table:        Replicate_Ignore_Table: mysql.rds_replication_status,mysql.rds_monitor,mysql.rds_sysinfo,mysql.rds_configuration,mysql.rds_history       Replicate_Wild_Do_Table:   Replicate_Wild_Ignore_Table:                    Last_Errno: 0                    Last_Error:                  Skip_Counter: 0           Exec_Master_Log_Pos: 1387829               Relay_Log_Space: 2754               Until_Condition: None                Until_Log_File:                 Until_Log_Pos: 0            Master_SSL_Allowed: No            Master_SSL_CA_File:            Master_SSL_CA_Path:               Master_SSL_Cert:             Master_SSL_Cipher:                Master_SSL_Key:         Seconds_Behind_Master: NULL Master_SSL_Verify_Server_Cert: No                 Last_IO_Errno: 1593                 Last_IO_Error: Fatal error: The slave I/O thread stops because a fatal error is encountered when it tries to get the value of SERVER_UUID variable from master.                Last_SQL_Errno: 0                Last_SQL_Error:   Replicate_Ignore_Server_Ids:              Master_Server_Id: 1                   Master_UUID:              Master_Info_File: mysql.slave_master_info                     SQL_Delay: 0           SQL_Remaining_Delay: NULL       Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates            Master_Retry_Count: 86400                   Master_Bind:       Last_IO_Error_Timestamp: 210424 15:42:38      Last_SQL_Error_Timestamp:                Master_SSL_Crl:            Master_SSL_Crlpath:            Retrieved_Gtid_Set:             Executed_Gtid_Set:                 Auto_Position: 0          Replicate_Rewrite_DB:                  Channel_Name:            Master_TLS_Version: 

I am thinking error could be while creating the user I created 'replication_aurora'@'%' instead of creating 'replication_aurora'@'replica ip' is this the issue?

I am unable to check because the connection endpoint aurora gives is more than 60characters long so i cannot create a user with that endpoint on my mariadb master.

Question.

  1. is not giving replica ip in user is the issue?
  2. is compatibility the issue?
  3. should i also create the same user on replica?

I am sort of at a dead end here please help any article or video would be helpful

How to migrate a SQL Server Erwin Mart to database to Aurora (Amazon RDS)

I want to migrate a SQL Server Erwin data Mart database to Aurora and trying to figure out what the easiest/quickest way to do that is.

Options to me seem to be:

  1. Saving models to the file system, repoint the application to the new mart database, then loading from the file system to the new database. https://support.erwin.com/hc/en-us/articles/360003443452-Java-scripts-that-automatically-save-a-mart-s-models-offline-to-a-drive [support.erwin.com] https://support.erwin.com/hc/en-us/articles/115002674131-ERWIN-DATA-MODELER-MART-API-RESOURCE-PAGE [support.erwin.com]

Has anyone got any experience using these apis?

  1. Export/Import. Mysql migration tool. https://www.mysql.com/products/workbench/migrate/
    Amazon migration tool Does anyone know if the schema is the same, can I simply export/import the data?

Premium Business For Sale Amazon & eBay Affiliate Website Daily Auto Updates

This is the perfect Website for beginners wanting to create an online income with a blog and affiliate store combo. Everything is set up for you and ready to go!

Ready to Start A New Hassle-free Online Income? Then Read On!

PaintBrushSet.shop is a stunning affiliate blog + store built using WordPress and the Intelligent Fresh Store System. It is fully loaded with Amazon and eBay products and is ready to go.

No maintenance needed – everything is…

Premium Business For Sale Amazon & eBay Affiliate Website Daily Auto Updates

Premium Amazon & eBay Affiliate Website Daily Auto Updates 6 Months Free Hosting

This is the perfect Website for beginners wanting to create an online income with a blog and affiliate store combo. Everything is set up for you and ready to go!

Ready to Start A New Hassle-free Online Income? Then Read On!

ChinaMarkers.com is a stunning affiliate blog + store built using WordPress and the Intelligent FSI System. It is fully loaded with Amazon and eBay products and is ready to go.

No maintenance needed – everything is updated…

Premium Amazon & eBay Affiliate Website Daily Auto Updates 6 Months Free Hosting

New Premium Niche Blog eBay & Amazon Affiliate Website Auto Updates Free Hosting

This is the perfect Website for beginners wanting to create an online income with a blog and affiliate store combo. Everything is set up for you and ready to go!

Ready to Start A New Hassle-free Online Income? Then Read On!

FloorCordCovers.com is a stunning affiliate blog + store built using WordPress and the Intelligent Fresh Store System. It is fully loaded with Amazon and eBay products and is ready to go.

No maintenance needed – everything is…

New Premium Niche Blog eBay & Amazon Affiliate Website Auto Updates Free Hosting

Premium Amazon & eBay Affiliate Website Daily Auto Updates 6 Months Free Hosting

This is the perfect Website for beginners wanting to create an online income with a blog and affiliate store combo. Everything is set up for you and ready to go!

Ready to Start A New Hassle-free Online Income? Then Read On!

LivingRoomTableSets.com is a stunning affiliate blog + store built using WordPress and the Intelligent Fresh Store System. It is fully loaded with Amazon and eBay products…

Premium Amazon & eBay Affiliate Website Daily Auto Updates 6 Months Free Hosting

Premium Amazon & eBay MAKEUP Affiliate Website Daily Auto Updates Free Hosting

This is the perfect Website for beginners wanting to create an online income with a blog and affiliate store combo. Everything is set up for you and ready to go!

Ready to Start A New Hassle-free Online Income? Then Read On!

LipstickPrimer.com is a stunning affiliate blog + store built using WordPress and the Intelligent Fresh Store System. It is fully loaded with Amazon and eBay products and is ready to go.

No maintenance needed – everything is…

Premium Amazon & eBay MAKEUP Affiliate Website Daily Auto Updates Free Hosting

Premium LANDSCAPING eBay & Amazon Affiliate Website Auto Updates Free Hosting

This is the perfect Website for beginners wanting to create an online income with a blog and affiliate store combo. Everything is set up for you and ready to go!

Ready to Start A New Hassle-free Online Income? Then Read On!

LawnTractorAttachments.com is a stunning affiliate blog + store built using WordPress and the Intelligent Fresh Store System. It is fully loaded with Amazon and eBay products and is ready to go.

No maintenance needed – everything…

Premium LANDSCAPING eBay & Amazon Affiliate Website Auto Updates Free Hosting

Premium Amazon & eBay Affiliate Website Daily Auto Updates 6 Months Free Hosting

This is the perfect Website for beginners wanting to create an online income with a blog and affiliate store combo. Everything is set up for you and ready to go!

Ready to Start A New Hassle-free Online Income? Then Read On!

SpringScales.com is a stunning affiliate blog + store built using WordPress and the Intelligent Fresh Store System. It is fully loaded with Amazon and eBay products and is ready to go.

No maintenance needed – everything is updated…

Premium Amazon & eBay Affiliate Website Daily Auto Updates 6 Months Free Hosting

Premium eBay & Amazon HEALTHY FOOD Affiliate Website Auto Updates Free Hosting

This is the perfect Website for beginners wanting to create an online income with a blog and affiliate store combo. Everything is set up for you and ready to go!

Ready to Start A New Hassle-free Online Income? Then Read On!

WholegrainMustard.com is a stunning affiliate blog + store built using WordPress and the Intelligent Fresh Store System. It is fully loaded with Amazon and eBay products and is ready to go

No maintenance needed – everything is…

Premium eBay & Amazon HEALTHY FOOD Affiliate Website Auto Updates Free Hosting