Aurora MySQL can absolutely be replicated with on-prem SQL, we did it at $dayjob.
Sent from my iPhone > On Jan 11, 2021, at 12:03 AM, William Herrin <b...@herrin.us> wrote: > > On Sun, Jan 10, 2021 at 8:32 PM <sro...@ronan-online.com> wrote: >>> On Jan 10, 2021, at 1:45 PM, Michael Thomas <m...@mtcc.com> wrote: >>>>> On 1/10/21 10:21 AM, William Herrin wrote: >>>>> Are you sure about that? Consider your database. Suppose you want to >>>>> run your primary database in AWS with a standby replica in Azure. As >>>>> long as you install your own database software in both, you can do >>>>> that. But if you want to leverage AWS' RDS products too, you're mostly >>>>> out of luck. >>> >>> Is RDS based on something else? I find it hard to believe that they wrote a >>> rdb from scratch. But yes, once they own your db they own you. I've looked >>> before how to migrate from mysql to postgres and was shocked at how little >>> there seems to be out there to even do even the easier stuff let alone the >>> proprietary extensions. > >> They have Amazon Aurora versions of many popular databases which are binary >> compatible with the standard versions. So you can run standard Postgres on >> one cloud and Aurora Postgres in AWS. > > > Look closer. The AWS RDS version of mysql is unable to replicate with > your version of mysql. The configuration which would permit it is not > exposed to you. > > Unless something has changed in the last couple years? > > Regards, > Bill Herrin > > > > -- > Hire me! https://bill.herrin.us/resume/
