We help IT Professionals succeed at work.

installation guide for MongoDB to use with MySQL InnodB and MariaDB

High Priority
184 Views
Last Modified: 2020-02-04
Hi,

Any good installation guide, operation guide and optimization guide for MongoDB to use with MySQL InnodB and MariaDB?
Comment
Watch Question

Database Administrator / Software Engineer
CERTIFIED EXPERT
Commented:
marrowyungSenior Technical architecture (Data)

Author

Commented:
"To install MongoDB on RHEL follow the online guide"

you are referring this : https://docs.mongodb.com/manual/tutorial/install-mongodb-on-red-hat/?
marrowyungSenior Technical architecture (Data)

Author

Commented:
what you use mongoDB for ?
Tomas Helgi JohannssonDatabase Administrator / Software Engineer
CERTIFIED EXPERT
Commented:
Hi,

Yes I'm referring to the online documentation.
I use MongoDB to store JSON documents (it is designed to do so ) and have been experimenting with that database for a while.
What are you planning to use MongoDB for ?

Regards,
    Tomas Helgi
marrowyungSenior Technical architecture (Data)

Author

Commented:
"What are you planning to use MongoDB for ?
"

as MonoGO is a on RAM DB and it usually served as a RAM file system. Here in my city a lot of use case is file system to store our app!

by the way, why monoGO always use with MysQL? as this kind of on RAM files system DB is free ? and only monogo DB is stable ?
 it just start to have ACID capability !

can monogo DB failover and cluster?
Tomas Helgi JohannssonDatabase Administrator / Software Engineer
CERTIFIED EXPERT

Commented:
Hi,

Have you considered Apache Ignite or Redis for your solution ? They are also in memory databases.
Take a look at the db comparison to match your needs.
Al of them have replication and cluster capabilities and MongoDB and Ignite are ACID compliant.

>by the way, why monoGO always use with MysQL?

As shown in the comparison (link above) MongoDB is a Document Store Database and not RDBMS as MySQL and MariaDB are.
Thus in some use cases you need both MongoDB and MySQL to suite your needs.
Note that Ignite is in memory RDBMS as well as in memory key-value store.

Regards,
   Tomas Helgi
marrowyungSenior Technical architecture (Data)

Author

Commented:
"Have you considered Apache Ignite or Redis for your solution ? "

no.

better than MonogoDB ?
Tomas Helgi JohannssonDatabase Administrator / Software Engineer
CERTIFIED EXPERT

Commented:
Hi,

It depends highly on your application/system/programming overall requirements.
MongoDB, Ignite and Redis have all replication, in-memory and sharding capabilities. They run on same or similar hardware but have different amount of supported programming languages and API's. See the comparison link that I provided in earlier comment.

Regards,
    Tomas Helgi
marrowyungSenior Technical architecture (Data)

Author

Commented:
"but have different amount of supported programming languages and API's."

do you mean this is the key part of comparison ?
Tomas Helgi JohannssonDatabase Administrator / Software Engineer
CERTIFIED EXPERT
Commented:
Hi,

>do you mean this is the key part of comparison ?
As I said before, it depends highly on your application/system/programming overall requirements.
There are a lot of considerations you need to take into account when choosing one or more database systems that suites your requirements.
"What APIs and programming languages does it support ?" is one of them and it should match your systems API's and programming language requirements.

Regards,
    Tomas Helgi
marrowyungSenior Technical architecture (Data)

Author

Commented:
""What APIs and programming languages does it support ?" is one of them and it should match your systems API's and programming language requirements. "

if so, we finally do not need to study it at all but just install and test it ourselves , right?

is it possible to install and run 4 x proxies on the SAME VM machine ? with different port ?
marrowyungSenior Technical architecture (Data)

Author

Commented:
any update for me ?
Tomas Helgi JohannssonDatabase Administrator / Software Engineer
CERTIFIED EXPERT

Commented:
Hi,

>if so, we finally do not need to study it at all but just install and test it ourselves , right?
Yes.

>is it possible to install and run 4 x proxies on the SAME VM machine ? with different port ?
Yes. This can be done and achieved by installing and using Linux containers (Linux LXD)  inside a Linux VM or a Linux Host (residing on hardware). And I recommend using the zfs filesystem under the LXD containers.

Regards,
    Tomas Helgi
marrowyungSenior Technical architecture (Data)

Author

Commented:
" inside a Linux VM or a Linux Host (residing on hardware). And I recommend using the zfs filesystem under the LXD containers.
"

we are using LInux VM for sure and any guide to show me how to install more than one proxy on the SAME linux VM ?

"Thus in some use cases you need both MongoDB and MySQL to suite your needs.
"

by this what I meant is, why people use MySQL usually install MongoDB too to work with MySQL ?
Tomas Helgi JohannssonDatabase Administrator / Software Engineer
CERTIFIED EXPERT

Commented:
Hi,

>by this what I meant is, why people use MySQL usually install MongoDB too to work with MySQL ?
I think I answered this in previous commment. Thus due to the fact that MySQL is a relational database and MongoDB is a Document Store database then if your requirements assume that you need both document store and relational storage then you need both MySQL and MongoDB.

This guide can help you to setup Linux containers in RHEL and you install each proxy in separate container.

Regards,
    Tomas Helgi
marrowyungSenior Technical architecture (Data)

Author

Commented:
"I think I answered this in previous commment."

nono. What I am referring to is why ALWAYS MongoDB but not other noSQL, this is what I mean?

should i say only MongoDB is famous ?
Tomas Helgi JohannssonDatabase Administrator / Software Engineer
CERTIFIED EXPERT
Commented:
Hi,

>nono. What I am referring to is why ALWAYS MongoDB but not other noSQL, this is what I mean?
>should i say only MongoDB is famous ?

Perhaps that's the case. MongoDB is ranked no. 1 in Document Store DBMS at db-engines.com.
 However that does not mean that you shouldn't consider using other Document Store or equivalent databases that suites your requirements.
There are a lot of different document store dbms out there and you can compare them on this site.

Regards,
    Tomas Helgi
Tomas Helgi JohannssonDatabase Administrator / Software Engineer
CERTIFIED EXPERT
Commented:
Hi,

Do you need more help on this ?

Regards,
    Tomas Helgi
marrowyungSenior Technical architecture (Data)

Author

Commented:
"And I recommend using the zfs filesystem under the LXD containers."

actually why ZfS files system?
marrowyungSenior Technical architecture (Data)

Author

Commented:
tks.
Tomas Helgi JohannssonDatabase Administrator / Software Engineer
CERTIFIED EXPERT

Commented:
Hi,

>actually why ZfS files system?

The zfs file system is both filesystem and volume manager and is in my opinion a superb filesystem in relation to taking snapshots, scaleability, compression and high storage capacities. And the most attractive part is the extensive protection against data corruption and automatic repair.
 
I have recently started to use it with the Linux Containers and it makes backup of containers, cloning and other container management related to filesystems very easy.
Backup of the whole database filesystem becomes very easy and by having a database inside a container or a database cluster inside multiple Linux containers then management of database in such cluster becomes easy in my opinion.

Regards,
    Tomas Helgi
marrowyungSenior Technical architecture (Data)

Author

Commented:
marrowyungSenior Technical architecture (Data)

Author

Commented: