Thanks for that reminder Jeremiah, I seem to recall hearing that before,
but haven't tried it yet.
Now I want to give it a try 🙂
On Fri, Nov 19, 2021 at 08:30 Jeremiah Wilton <jcwilton93@xxxxxxxxx> wrote:
I agree with questioning whether RAC is the right solution, but someJared Still
customers have their reasons.
But I want to point out that you don't have to do any of those hacky
things from my old blog post, because AWS now supports multi-volume attach
and multicast.
https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/ebs-volumes-multi.html
https://docs.aws.amazon.com/vpc/latest/tgw/working-with-multicast.html
Jeremiah
On Fri, Nov 19, 2021 at 8:24 AM Jared Still <jkstill@xxxxxxxxx> wrote:
RAC is really quite complex, as you likely already know.
As a fun project, I would consider setting it up with a free tool for
multicast. Jeremiah Wilton wrote a paper on doing that.
But running RAC on EC2 in production sounds like something that would
generate a lot of unnecessary work and anxiety.
Q: Why do you use RAC?
Is it because the extra nodes are required to meet CPU and/or memory
needs?
Or is it for the failover?
If it is for the failover, then perhaps consider sizing the server large
enough to run all apps, and use DataGuard for HA. Perhaps 2 of them, one
in a different AZ.
Just a thought
On Thu, Nov 18, 2021 at 10:59 Sandra Becker <sbecker6925@xxxxxxxxx>
wrote:
Current OS: RHEL6Jared Still
Oracle version: 11g (11.2.0.3 and 11.2.0.4)
We have started a project to move our 50 or so on-prem RAC databases to
AWS EC2 servers. Some use ASM, others do not. (I think the motto of
previous DBAs was "consistency is for the weak.".) We cannot upgrade the
databases (or the OS) due to a host of constraints put on us by the
applications and stakeholders. Using FlashGrid also is out of the question
since it would be an additional software cost.
I'm looking for good documents to read/follow that would tell us how to
set up ASM on the EC2 instances as well as the best method to move the RAC
databases. Has anyone done this that can point me to good documentation?
I also have some non-RAC databases to move. I was thinking of creating the
standby on the EC2 then doing a switchover during a migration window to
minimize downtime. Is this approach feasible? Would another approach be
preferable?
Thank you for any suggestions,
--
Sandy B.
--
Certifiable Oracle DBA and Part Time Perl Evangelist
Principal Consultant at Pythian
Oracle ACE Alumni
Pythian Blog http://www.pythian.com/blog/author/still/
Github: https://github.com/jkstill
--
