Re: Performance comparison of Oracle Vs Aurora MySQL
Date: Fri, 13 Apr 2018 18:38:29 +0000
Message-ID: <HE1PR1001MB1243F5D8FD8E936444DD066085B30_at_HE1PR1001MB1243.EURPRD10.PROD.OUTLOOK.COM>
Ravi,
I assume you are looking to use something like Maxscale to redirect connections? Whilst they are pretty smart, tools like Maxscale (and ScaleARC) aren't magic and they won't fix all situations. They will add a little latency to your queries - the Maxscale engine needs to decide where to send the queries and perform redirection, so you have an extra hop and decision to make rather than straight to DB.
You also need to consider the impact on the master database of maintaining replicas and ensuring that those replicas are up to date.
And then the's cost of having 15 copies of your database on 15 servers. That's not trivial.
And finally, if your queries are slow because they are poorly written queries against a badly designed schema, this probably isn't going to help at all.
regards
Neil.
Hi Mladen,
They are trying to use these MySQL drivers which can direct DML operations to a Master Instance and Reads to Read Replicas.
Thanks.
On Tue, Apr 10, 2018, 8:54 AM Mladen Gogala <gogala.mladen_at_gmail.com<mailto:gogala.mladen_at_gmail.com>> wrote:
How will replicas help with the OLTP database?
Regards
On 04/09/2018 02:35 PM, Ravi Teja Bellamkonda wrote:
From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Ravi Teja Bellamkonda <raviteja.bellamkonda7_at_gmail.com>
Sent: 10 April 2018 16:57
To: gogala.mladen_at_gmail.com
Cc: oracle-l
Subject: Re: Performance comparison of Oracle Vs Aurora MySQL
> Robert,
>
> They are working on POC right now and just a blind guess on their end
> that I can create up to 15 Read Replicas and that will solve my
> database problems.
--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Apr 13 2018 - 20:38:29 CEST