MariaDB and mongo DB

hi,

anyone know how to intergrate MariaDB and Mongo DB so that they work together well ?

how about MariaDB and hadoop?
LVL 1
marrowyungSenior Technical architecture (Data)Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
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.

nociSoftware EngineerCommented:
Not sure what you want....
MariaDB, MongoDB, Hadoop all are DIFFERENT databases.  and all Are completely independant from each other.
MariaDB cannot use the others as backend or something like that.
(that that goes for all....)
They all have their own Pro's & Con's and can work together very well (independent from each other) if there is sufficient Disk, memory & CPU bandwidth available.
0
marrowyungSenior Technical architecture (Data)Author Commented:
"MariaDB, MongoDB, Hadoop all are DIFFERENT databases."

of course they are! but different database can work with each other, like oracle, via gateway, can query MS SQL servers, MS SQL server also can query Oracle too by ETL.

"They all have their own Pro's & Con's and can work together very well (independent from each other)
"

can or can't  ? as you said:

MariaDB cannot use the others as backend or something like that.

Open in new window

0
nociSoftware EngineerCommented:
Now your question makes more sense:

MariaDB has several storage engines:   InnoDB, MyISAM, XtraDB + a few lets used
it can connect to others:  Hadoop isn't mentioned.

https://mariadb.com/kb/en/library/connect-table-types/

Recent version  (10.1+) of MariaDB has an option to access MongoDB see: https://mariadb.com/kb/en/library/connect-mongo-table-type/

so for Mongo Can..., for hadoop?
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

marrowyungSenior Technical architecture (Data)Author Commented:
"Recent version  (10.1+) of MariaDB has an option to access MongoDB see: https://mariadb.com/kb/en/library/connect-mongo-table-type/"

how about Mongo DB to mariaDB, this is bi direction like replication ?

"MariaDB has several storage engines:   InnoDB, MyISAM, XtraDB + a few lets used
it can connect to others:  Hadoop isn't mentioned."

storage type should not be that matter, right? so InnoDb do'nt support data from MongoDB?\
0
nociSoftware EngineerCommented:
Ill look into MongoDb -> MariaDB...

Lets put it this way: MariaDB either uses a storage engine (which provides a buffered & searchable page store, [ implement IO, indexes, search strategies ] )  and has sideways connections to others.  With Storage engines there is more intimate contact & knowledge of internal structures that can help search strategies.   With connected databases there only is the API that everyone uses.
InnoDB, MyISAM etc. cannot be used as a separate database, it can only be used behind Mysql, same for all MySQL storage engines.
0
marrowyungSenior Technical architecture (Data)Author Commented:
you concern about storage type because of the search efficiency ?
0
marrowyungSenior Technical architecture (Data)Author Commented:
the answer should be the same for MySQL, right?
0
nociSoftware EngineerCommented:
I think there is more effort done on MariaDB than on MySQL, i didn't verify if plugins for MariaDB also work on MySQL.
Oracle bought several companies to only let their products decay... (Sun Solaris, OpenOffice, .. and some other Sun products Gone..., now Java partly gone) so not sure what MySQL's fate will be. Most environments i dealt with moved from MySQL -> MariaDB.
It looks like there is more development with MariaDB.  (For performance maybe Percona can be an option as well).

Mongo seems to have plugable Storage engines..., But the mogodb engine is a monolithic image. So the need to be built in.., hardly what i would call a plugin... All references i could find are how mongoDB could be queried from an SQL likte frontend through ODBC linking.
One example is rocksdb integration, but it needs to be built in when building mongodb.

(BTW in an SQL environment is MongoDb not very useful as such. As references may only be strictly one directional...
see also this article: http://www.sarahmei.com/blog/2013/11/11/why-you-should-never-use-mongodb/ )
I think it is too harsh on mongodb it has its usecases but it is not as versatile as SQL.
Imho it is easier to build a KV store in Mysql en a relational DB in Mongo.
0
marrowyungSenior Technical architecture (Data)Author Commented:
"now Java partly gone"

Java still here and java programmer paid high ! :):)

"so not sure what MySQL's fate will be"

I agree that, MySQL 5.5.28 (after Oracle buy it), is not even stable than 5.0

"It looks like there is more development with MariaDB.  (For performance maybe Percona can be an option as well)."

yes! What is the diff between MariaDB and Percona anyway ? I heard very little diff

"Imho it is easier to build a KV store in Mysql en a relational DB in Mongo.
"
what is KV ? what is en? on, right?

"BTW in an SQL environment is MongoDb not very useful as such. As references may only be strictly one directional..."

that's why it is usually one direction only >?
0
nociSoftware EngineerCommented:
Oracle stopped the Java EE, another party is now responsible AFAIK.... I am following a usually reliable source on this, that also told me Solaris was dead (as in almost all its developers got a pink slip) about a month before it was public knowledge...

Percona published a lot of improvements that didn't make it into MySQL (not sure for what version i think 5.x)
MariaDB started accepting all kind of changes. So i think there not be a lot of differences why not incorporate good patches i didn't study too deeply though.
wrt. SQL/NO-SQL:  (MySQL / MongoDB).
Yep, but real world problems tend to get relational after a while, please do read the article i posted with it.
That article is too much B/W, but it does describe exactly that....
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
marrowyungSenior Technical architecture (Data)Author Commented:
"Percona published a lot of improvements that didn't make it into MySQL (not sure for what version i think 5.x)"

Any MySQL deviation not owned by oracle will be good ! This is a dump action by oracle, we still can get good MySQL without oracle ! what is the point ?

"Yep, but real world problems tend to get relational after a while, please do read the article i posted with it."

 I am sorry if I missed anything, where is your article ?

"Imho it is easier to build a KV store in Mysql en a relational DB in Mongo.
"
what is KV ?
0
nociSoftware EngineerCommented:
From #42547329

see also this article: http://www.sarahmei.com/blog/2013/11/11/why-you-should-never-use-mongodb/ )

KV = Key Value Store.... MongoDB only has One lookup item (Key) and a document (Value)  is under it.
0
marrowyungSenior Technical architecture (Data)Author Commented:
tks.
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.