Link to home
Start Free TrialLog in
Avatar of marrowyung
marrowyung

asked on

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.
Avatar of Prabhin MP
Prabhin MP
Flag of India image

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.
Avatar of marrowyung
marrowyung

ASKER

"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?
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.
"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 ?
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.
"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?
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.
"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 ?
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
"for aurora they provides"

so even oracle can't ? so must be VM for oracle installation again ?
aurora supports oracle
ok. so all DB run on aurora can keep ALL existing feature ?

multi master, AOG, replication, Galeria cluster?
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
" RDS Aurora,"

you are saying before that RSD and Aurora is diff thing, why RDS can't but Aurora can, I don't understand.
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.
so  Aurora is amazon's own DB? that's why they allow full configuration ?
Yeah it's their own
oh, that's why.. I don't use that one then.... what can proof it is stable..
It's compaitable with postgrey, MySQL/mariadb Oracle etc
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 ?
you can scale vertical and horizontal(using read replica)
but must use their own management tools ?
ASKER CERTIFIED SOLUTION
Avatar of Prabhin MP
Prabhin MP
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
please help to answer this one if you have an idea:

i don't have any idea about this?
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.
can u share me you linkedin profile
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 ?
OK FINE....
you know even MS don't keep updating linkedin App for Windows phone, I hate that app.
linkedin famous in your side ?
yeah its famous, where are you from???
HK . visit before ? it is a international city .. more and more Hollywood movie start to take here.
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 ?
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 ?
"are you looking for workbench, sqlyog type of tools ?"

Business intelligence and reporting.
No idea about that
I am worrying about no one use this kind of thing on MariaDB, but it is not possible , right?
yeah!!!!
I am asking MariaDB corporation. let's see what they are going to reply.
GOOOD