MariaDB On Premise Master to AWS EC2 RDP Slave Replication via Site-to-Site VPN

Hello AWS Customer

I understand that you could not find my.cnf file on your AWS RDS instance and when you use the change master to command, it says you need to have "super" rights and you would like to know if there is a different set of instruction that you need to follow.

AWS RDS does not support native MySQL installations on EC2 instances. However, you can generally access the my.cnf file on the AWS EC2 instance by executing the following command[1]:

cd /etc

Kindly note that AWS RDS is a managed service and it has some limitations. One of them being that AWS RDS does not provide "Super" privileges and users do not have access to the underlyig host, you may refer to the below link for available permissions and privileges for master user[2]. May you refer to the below AWS documention on how GTID-based replication works on a MariaDB DB instance on Amazon RDS[3]

Wishing you a great day ahead.

References:

[1]How to Setup MySQL’s my.cnf for Micro AWS EC2 Instance -https://silicondales.com/tutorials/aws-ec2/setup-mysqls-cnf-micro-aws-ec2-instance/ [2]Master user account privileges - https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/UsingWithRDS.MasterAccounts.html [3]Configuring GTID-based replication with an external source instance - https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MariaDB.Procedural.Replication.GTID.html