Hey @db108, technically it's not possible. This is because Fivetran would need some permissions such as INSERT, UPDATE, DELETE etc which typically come under writer permissions.
Replica servers are typically set up in a master-slave replication configuration, where:
- The master server: is the primary server where all write operations (inserts, updates, deletes) occur.
- The replica server: passively receives the changes made on the master server and applies them to its own database, but cannot initiate write operations itself.
So you can still read data from a replica server, which is something we support for MySQL as a source but we cannot write into a server where write permissions are not possible.
We would like to suggest that you replicate data via Fivetran into a destination where INSERT, UPDATE, DELETE etc permissions can be provided. You can then create a replica of that server and have the downstream applications / users utilize the read replica for their own perusal.
It's a WIN WIN.
Additional Reference:
We support a wide variety of MySQL Databases as a source such as:
We can read from both the primary instance as well as the read replica (for a few) so the data source is covered.
Coming towards the destination, here are the different MySQL variants that we support:
Looking forward to hearing from you.
Thanks!
