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?
 
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
 
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
Network Scalability - Handle Complex Environments

Monitor your entire network from a single platform. Free 30 Day Trial Now!

 
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
 
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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.