Parler

Mon Jan 11 12:48:08 UTC 2021

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