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 <bill@herrin.us> wrote:
On Sun, Jan 10, 2021 at 8:32 PM <sronan@ronan-online.com> wrote:
On Jan 10, 2021, at 1:45 PM, Michael Thomas <mike@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/