Time to install and configure MySQL

Wow... RHEL 5.7 + MySQL... You'll likely require a large budget + lots of time, as this can be extremely time consuming + expensive.

Tips to make your life easier...

1) Start with a modern OS, like Ubuntu Bionic or RHEL 8.X as your starting point, as this you have this consideration.

RHEL 5.7 last Kernel was 2.6.18-194 released 2011-07-21 which is so old... you'll have massive performance problems which have been since fixed.

RHEL 5.7 reaches EOL (end of life) in January 2019.

Starting a new project with 8x year old tech... ouch...

2) Porting Oracle to MySQL is a hard road. Porting Oracle to MariaDB running in Oracle SQL syntax mode may save you massive code rewrites.

3) Fastest approach is to start with Ubuntu Bionic or RHEL 8 (or CentOS 8), then use MariaDB 10.4.8+ running in Oracle compatibility mode.

Sorry that was a typo. It is RHEL 7.4 Virtual machine.
The connection is high speed up to 100 Mbps per second.
Our servers in data center do not have internet connection out so i have to download to my desktop and then copy the files from my windows 10 machine to server via WinSCP.
The data warehouse is in MySQL so i dont have flexibility in target database.

Is it safe to assume the download and install and configuration of MySQL will take roughly  about 1 day average?
It seem the community version is the only free version. Would i be able to create table and import data, without any size limitation with this version?
Can I still download the standard or enterprise and test those free of charge or you have to pay first before download?

Thanks,

>>will take roughly  about 1 day average?

Last time I installed MySQL it was a couple of hours but that was a straight out-of-the-box database.  If you have specific or custom requirements it might take a little bit longer.

If you've never done it before, even longer if it goes well the first time, which it likely won't.

We cannot say how long it will take you.

I'm not sure there are different binaries between the versions.  You will need to check the Enterprise licensing page to see if there is an evaluation period.

It seems the mysql windows installation is easier than Linux. I am wondering whether i should consider Installing it on windows VM instead of RHEL VM. Would it make a difference for export/import or mySQL workbench and other tools GUIs?

If the target mySQL database is running on RHEL can you still migrate files or mysql tables from windows server to linux or not?

Hi,

Note that in RHEL 7 you have the choice to install MariaDB (a MySQL fork) using the base RHEL 7.x repositories. And it doesn't take long time to install. :)
MariaDB is the default MySQL implementation as of RHEL 7.
I strongly recommend you install MariaDB server using the base repo and try it out. :)
MariaDB has additional functionality and storage engines which could benefit you more than MySQL.

To query for mariadb-server package to see if it isn't already installed you query the repo like this

yum list mariadb*

Select allOpen in new window

as root.
https://www.certdepot.net/rhel7-install-mariadbmysql/

Regards,
    Tomas Helgi

>>whether i should consider Installing it on windows VM instead of RHEL VM

If your final production system is RHEL, then use RHEL for all your testing.

Maria DB would not work because the target data data warehouse which will be created is MySQL (not my decision).

My oracle DEV machine is running on RHEL 7.4,
Would there be any issues to install the MySQL on same VM to test it or it is better to create a new RHEL VM for MySQL?
Creating a new machine would take some time and more storage/cpu/memory allocation as I have to place a new request for VM group.

>>Would there be any issues to install the MySQL on same VM to test it or it is better to create a new RHEL VM for MySQL?

There shouldn't be any issues with Oracle and MySQL running on the same server.

I would recommend a different server just in case things don't go well and you need to keep tearing it down and rebuilding it.  There is zero chance a new machine could trash your existing Oracle machine.

Playing with new toys on a currently solid machine is always a little dangerous.  Putting it on a currently running machine has to potential of affecting the Oracle setup if you aren't 90-100% confident you know what you are doing.

If you do put it on the Oracle machine, I would make 100% sure you snapshot/checkpoint your current machine before you start messing with it so you can make sure you can go back to a consistent state once you are done with MySQL or if things magically stop working.

Would it still be easy to connect from one machine to another to dump the data?

I am not sure how this will work.

We have GUI tools that most run on WIndows and then I have one RHEL VM for oracle and one RHEL for MySQL.

Can I have the GUI tool on my windows 7/10 desktop and connect to both machine to migrate the data?

If you can find a tool to do the migration, then you can run it based on its requirements.  Seems reasonable but I've never used any so cannot recommend any.

DBeaver should be able to connect to both databases.

Looks like DBeaver has some migration capability:
https://github.com/dbeaver/dbeaver/wiki/Data-migration

I cannot say how efficient or accurate it is.

Excellent!

I saw few comments so I thought that I'd also add some informative data here.

- Community is free edition and you can get it here https://dev.mysql.com/downloads/mysql/.  (A whole lot of world using this)
You can find a good guide for installation here: https://dev.mysql.com/doc/refman/5.7/en/linux-installation.html 

- Since MariaDB is already mentioned here I'd add another flavor from Percona: https://www.percona.com/doc/percona-server/5.7/installation/yum_repo.html



You can surely check different places for their comparison, they all are opensource (which doesn't really matter if you're not going to change :P):

https://severalnines.com/database-blog/comparing-oracle-mysql-percona-server-and-mariadb
https://www.atlantic.net/hipaa-compliant-database-hosting/what-is-mysql-vs-mariadb-vs-percona/
https://www.percona.com/blog/2017/11/02/mysql-vs-mariadb-reality-check/

Just note this one too: https://mariadb.com/kb/en/mariadb-vs-mysql-compatibility/

PS: I'd surely choose to download the product from the provider website than any other place.