Web Application VS Windows Application
-
@IT-ADMIN said:
is there any diffirence btw mysql on linux and mysql on windows in term of performance and reliability ?? the same question for apach ??
Yes, MariaDB (what you call MySQL) is faster and more stable on Linux. It's also much easier.
yum -y install mariadb
That's all you need.
-
@IT-ADMIN said:
but i do not know in which one i should host my future database
i have one in windows in easyPHP, and i have apache and mysql and phpmyadmin on ubuntu
WHy would you install PHP on Windows? That makes no sense. PHP and MariaDB and Apache all run better and have more support and are easier on Linux. And... FREE!!!
-
Don't install with "easy" stack tools. Those are almost always a huge disaster.
-
-
@JaredBusch said:
@IT-ADMIN said:
on both
No. MySQL is a database. SQL Server is a database.
Neither one is the OS.
sorry Mr @JaredBusch , i think there is a confusion here, i said i have 2 servers: windows and ubuntu, i have mysql on both OS, i hope my idea is clear now
-
@IT-ADMIN said:
@JaredBusch said:
@IT-ADMIN said:
on both
No. MySQL is a database. SQL Server is a database.
Neither one is the OS.
sorry Mr @JaredBusch , i think there is a confusion here, i said i have 2 servers: windows and ubuntu, i have mysql on both OS, i hope my idea is clear now
That helps. Why do you have a database on both?
-
i have mysql on windows a long ago, but recently i installed one application that work only on linux platform so i installed mysql in ubuntu along side with this linux application,
-
Okay.. so only the MariaDB on Ubuntu is what matters here, right? The MySQL on Windows is a red herring?
-
ok, but i just search on the internet about this mariaDB, i found that it is different than mysql
-
Ok, let us just keep simplicity, let's call it mysql, i do not want to confuse myself especially i'm about to start a new project, i have to stick to what is familiar to me so that i can move forward
-
so ok, now for the DBMS we know that mysql on ubuntu is better than the one in windows and better than MS SQL Server, great
-
also there is a software called lamp (similar to wamp in windows) i guess installing apache and mysql seperatly is more reliable than just install this ready to use application (i guess lamp only for testing and dev, in production envirnemnt we have to install things seperatly, isn't it)
-
@IT-ADMIN said:
ok, but i just search on the internet about this mariaDB, i found that it is different than mysql
Yes, it is better. But it is what people CALL MySQL, you see. It's a fork that replaced it. Nearly all Linux distros ship MariaDB as MySQL.
-
@IT-ADMIN said:
Ok, let us just keep simplicity, let's call it mysql, i do not want to confuse myself especially i'm about to start a new project, i have to stick to what is familiar to me so that i can move forward
You need to understand this now, it will be worse later. MySQL is really silly to be discussing. You should be on MariaDB, it's that simple.
-
@IT-ADMIN said:
so ok, now for the DBMS we know that mysql on ubuntu is better than the one in windows and better than MS SQL Server, great
Yes, and MySQL on Ubuntu is MariaDB.
-
@IT-ADMIN said:
also there is a software called lamp (similar to wamp in windows)
LAMP is what there always was. WAMP was copying the Linux ecosystem to Windows for people who just refused to leave Windows. WAMP is a horrible idea Even Microsoft would say that.
-
@IT-ADMIN said:
i guess installing apache and mysql seperatly is more reliable than just install this ready to use application (i guess lamp only for testing and dev, in production envirnemnt we have to install things seperatly, isn't it)
WAMP is not a package, it is installing the components separately.
LAMP on Ubuntu is this command...
apt-get install mariadb httpd php
That's it.
-
oh great, so what a about connecting to MariaDB, is it the same as mysql, the syntax, is it similar to mysql in every aspect ?? if no what are the differences ??
-
@scottalanmiller said:
@IT-ADMIN said:
i guess installing apache and mysql seperatly is more reliable than just install this ready to use application (i guess lamp only for testing and dev, in production envirnemnt we have to install things seperatly, isn't it)
WAMP is not a package, it is installing the components separately.
LAMP on Ubuntu is this command...
apt-get install mariadb httpd php
That's it.
Sure you manually have to install the components separately on Windows, but that command installs three things on Linux, you just are fortunate and able to install all of them in one command.
They are still three separate things. -
@scottalanmiller but i remember when i installed that linux application i type the following command (in their documentation)
apt-get -y install php5-gd php5-mysql php5 php5-cli apache2 libapache2-mod-php5 tshark mtr mysql-server php5-mcrypt librsvg2-bin gsfontsso i think this command installed mysql not MariaDB, so i have to upgrade or something ??
i fear if i change mysql to MariaDB, this application will stop