Re: Performance comparison of Oracle Vs Aurora MySQL

Hi Neil,

Thanks for the response.

Agree with your statement on badly written queries against a badly designed schema.

Coming to the drivers, they are planning on using something similar, which comes in by default with MySQL.

https://dev.mysql.com/doc/connector-j/5.1/en/connector-j-master-slave-replication-connection.html

On Fri, Apr 13, 2018 at 11:38 AM, Neil Chandler <neil_chandler_at_hotmail.com> wrote:

> 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.
>
>
> ------------------------------
> *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
>
> 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>
> wrote:
>
> How will replicas help with the OLTP database?
>
> Regards
>
>
> On 04/09/2018 02:35 PM, Ravi Teja Bellamkonda wrote:
> > 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
>
>
>

-- 
Thanks & Regards,
Ravi Teja Bellamkonda

--
http://www.freelists.org/webpage/oracle-l