MariaDB Garlia cluster on the cloud

hi,

anyone use MariaDB Garlia cluster on the cloud ? is it possible ?

it seems that once MySQL move to cloud, the multi master doesn't work any more.
LVL 1
marrowyungSenior Technical architecture (Data)Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Prabhin MPEngineer-TechOPSCommented:
As aws doesn't provide superadmin privileges,so settig up galera cluster in managed services like RDS in AWS is not possible.
You can deploy a VM and setup galera cluster independly.

or otherwise user RDS cluster service.
0
marrowyungSenior Technical architecture (Data)Author Commented:
"As aws doesn't provide superadmin privileges,so settig up galera cluster in managed services like RDS in AWS is not possible."

same as MySQL multi master then.

"RDS cluster service."

what is the different between RDS cluster service and RDS AWS service in this case ? what is the diff on setting it up.

but one thing, MS SQL's Always on automatically support on RDS or must be in Azure to AOG in the cloud to work?

how about DB2's HADR and purescale ? and oracle'S RAC?
0
Prabhin MPEngineer-TechOPSCommented:
AWS cluster service is a service with databases service is deployed on multiple servers on different availability zones for High availability.

AWS RDS instance, we will create standalone instance of elected database version.
Later on we can setup replica, AWS  support only read only replica.
0
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

marrowyungSenior Technical architecture (Data)Author Commented:
"AWS cluster service is a service with databases service is deployed on multiple servers on different availability zones for High availability."

it fit all DB technology, MS SQL, oracle and. ?

"AWS RDS instance, we will create standalone instance of elected database version. "

so SQL AOG can't move to AWS RDS ? only Azure?

"Later on we can setup replica, AWS  support only read only replica."

so when MariaDB move to RDS, the Galeria cluster can only have one read/write nodes and the rest of nodes is read only ?
0
Prabhin MPEngineer-TechOPSCommented:
aws RDS provides oracle, mysql, mariaDB, aurora ms sql

so SQL AOG can't move to AWS RDS ? only Azure?

Im not aware of this..

so when MariaDB move to RDS, the Galeria cluster can only have one read/write nodes and the rest of nodes is read only ?

galera not possible in RDS,
AWS RDS provide read replica setup thats what you can do.
0
marrowyungSenior Technical architecture (Data)Author Commented:
"aws RDS provides oracle, mysql, mariaDB, aurora ms sql"

yes but what i mean is, once they move to RDS, any feature lost ? like MariaDB can't setup multi master, etc. ?

 I am expecting that Oracle RAC or MS SQL AOG all working fine after that...

"AWS RDS provide read replica setup thats what you can do."

so it is not a multi master once move MariaDB to the cloud, right?
0
Prabhin MPEngineer-TechOPSCommented:
so it is not a multi master once move MariaDB to the cloud, right?
It's not multi master

yes but what i mean is, once they move to RDS, any feature lost ? like MariaDB can't setup multi master, etc. ?

you can add global parameters like enabling slow query, etc, using parameter groups attached to the instance.
Manual setting up of replication is not possible, we have to use only the services that aws provides,

AWS does not provide super user privileges for root user.
0
marrowyungSenior Technical architecture (Data)Author Commented:
"It's not multi master"

MariaDB cluster is not multi master? they say multi master. or you are saying

"Manual setting up of replication is not possible,"

only setting up VM and install MariaDB ourselves can make this works ?
0
Prabhin MPEngineer-TechOPSCommented:
https://aws.amazon.com/about-aws/whats-new/2017/11/sign-up-for-the-preview-of-amazon-aurora-multi-master/
for aurora they provides

"only setting up VM and install MariaDB ourselves can make this works ?"

yeah
0
marrowyungSenior Technical architecture (Data)Author Commented:
"for aurora they provides"

so even oracle can't ? so must be VM for oracle installation again ?
0
Prabhin MPEngineer-TechOPSCommented:
aurora supports oracle
0
marrowyungSenior Technical architecture (Data)Author Commented:
ok. so all DB run on aurora can keep ALL existing feature ?

multi master, AOG, replication, Galeria cluster?
0
Prabhin MPEngineer-TechOPSCommented:
Actually i haven'tn worked on multi master in AWS RDS Aurora, the feature says it support.

Not sure hove they configured ie, using galera or something else
0
marrowyungSenior Technical architecture (Data)Author Commented:
" RDS Aurora,"

you are saying before that RSD and Aurora is diff thing, why RDS can't but Aurora can, I don't understand.
0
Prabhin MPEngineer-TechOPSCommented:
Amazon RDS is available on several database instance types - optimized for memory, performance or I/O - and provides you with six familiar database engines to choose from, including Amazon Aurora, PostgreSQL, MySQL, MariaDB, Oracle, and Microsoft SQL Server.
0
marrowyungSenior Technical architecture (Data)Author Commented:
so  Aurora is amazon's own DB? that's why they allow full configuration ?
0
Prabhin MPEngineer-TechOPSCommented:
Yeah it's their own
0
marrowyungSenior Technical architecture (Data)Author Commented:
oh, that's why.. I don't use that one then.... what can proof it is stable..
0
Prabhin MPEngineer-TechOPSCommented:
It's compaitable with postgrey, MySQL/mariadb Oracle etc
0
marrowyungSenior Technical architecture (Data)Author Commented:
what is  compaitable means here?

we can use the same MS SQL SSMS to manage it ?

how about ETL , hadoop layer , horizontal scale out thing ?
0
Prabhin MPEngineer-TechOPSCommented:
you can scale vertical and horizontal(using read replica)
0
marrowyungSenior Technical architecture (Data)Author Commented:
but must use their own management tools ?
0
marrowyungSenior Technical architecture (Data)Author Commented:
0
Prabhin MPEngineer-TechOPSCommented:
but must use their own management tools ?

what type of tools are looking for?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Prabhin MPEngineer-TechOPSCommented:
please help to answer this one if you have an idea:

i don't have any idea about this?
0
marrowyungSenior Technical architecture (Data)Author Commented:
That Amazon DB management tools ? I am not sure how to manage that but you said compatible with other DB, I'd like to see how compatible it is .

"
i don't have any idea about this?"

I am sorry that I see no one update on that so I ask you for help.. I am not sure why that one has no one answer.
0
Prabhin MPEngineer-TechOPSCommented:
can u share me you linkedin profile
0
marrowyungSenior Technical architecture (Data)Author Commented:
I am sorry sir, as I am a starter of MariaDB, did I make you unhappy in anyway ?

this is the first time someone ask me for a linked in profile. here nearly no one use that kind of thing.  we use whatsapp, this app should be very famous in US, right ?
0
Prabhin MPEngineer-TechOPSCommented:
OK FINE....
0
marrowyungSenior Technical architecture (Data)Author Commented:
you know even MS don't keep updating linkedin App for Windows phone, I hate that app.
0
marrowyungSenior Technical architecture (Data)Author Commented:
linkedin famous in your side ?
0
Prabhin MPEngineer-TechOPSCommented:
yeah its famous, where are you from???
0
marrowyungSenior Technical architecture (Data)Author Commented:
HK . visit before ? it is a international city .. more and more Hollywood movie start to take here.
0
marrowyungSenior Technical architecture (Data)Author Commented:
please help on this :
https://www.experts-exchange.com/questions/29101394/Business-intelligence-and-report-for-MariaDB.html

I need to know what good reporting tools mariaDB use, are you using that too ?
0
Prabhin MPEngineer-TechOPSCommented:
HK . visit before ? it is a international city .. more and more Hollywood movie start to take here.

No i haven't visited HK.


I need to know what good reporting tools mariaDB use, are you using that too ?

are you looking for workbench, sqlyog type of tools ?
0
marrowyungSenior Technical architecture (Data)Author Commented:
"are you looking for workbench, sqlyog type of tools ?"

Business intelligence and reporting.
0
Prabhin MPEngineer-TechOPSCommented:
No idea about that
0
marrowyungSenior Technical architecture (Data)Author Commented:
I am worrying about no one use this kind of thing on MariaDB, but it is not possible , right?
0
Prabhin MPEngineer-TechOPSCommented:
yeah!!!!
0
marrowyungSenior Technical architecture (Data)Author Commented:
I am asking MariaDB corporation. let's see what they are going to reply.
0
Prabhin MPEngineer-TechOPSCommented:
GOOOD
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MariaDB

From novice to tech pro — start learning today.