MySQL for solus

jungrishi

there is MariaDb and Postgres provided by the Solus but how do I get mysql
Is there a way to get mysql-server in my solus machine

synth-ruiner

jungrishi mariadb-server is compatible with MySQL (it's basically the open-source continuation of MySQL since MySQL got bought out, I think?) 😁

I haven't tried it on Solus, but I know on CentOS the mariadb-server repository provides the binaries mysql and mysqld

ShikiSuen

synth-ruiner

This is a serious reply telling you that mariadb is not a replacement of MySQL for every purpose.
Some PHP apps utilize NGRAM which is only available in MySQL since MySQL 5.7, and it looks like MariaDB still refuses to introduce NGRAM support: https://jira.mariadb.org/browse/MDEV-10267
This means that it is impossible to operate a forum server (in CJK languages) on Solus until MySQL 5.7 or above become available in eopkg repository. // Unless implementing ElasticSearch. Till now only XenForo has a paid DLC supporting ElasticSearch. Also, ElasticSearch brings more vulnerabilities and is only useful for giant forums.

I am still testing an alternative method (described below), wondering whether it works. I'll update later.

@jungrishi

Please try installing MySQL through LinuxBrew which is another package manager on Linux.
https://brew.sh
(You may want to run sudo eopkg install -c system.devel PRIOR to installing homebrew on Linux.)
This will compile MySQL on your computer, and it requires (maybe dozens of) hours of time and computing power.

I recommend introducing ALISQL to Solus EOPKG Repository since it is more efficient than MySQL:
https://github.com/alibaba/AliSQL

jungrishi

Thank you for your feedback!
I read a article here
As per this article they(Maria and MySQL) are different!!
wont it be a problem while developing an application as they are different tech stack
or am I wrong

synth-ruiner

jungrishi I've been working with MariaDB for 3 years and haven't run into any real problems. pretty much any time I look something up and (for example) there's a StackOverflow post talking about MySQL, it'll still be applicable. 😁

if you need any of the MySQL-specific features listed there then I'm sure there are ways to install it. If you can't install it on Solus then running it in a virtual machine is a possibility.

kyrios

jungrishi Basically the devs of MariaDB are the ones who created and developed MySQL until is was acquired by Oracle Corp.

You can use a docker image for MySQL 8. MariaDB can be used as a drop-in replacement of older MySQL versions.

DataDrake

jungrishi I have used both and I can say that with the exception of a few core internal settings for the server itself, almost all of the queries and table management are identical. If you are using a language-specific library for MySQL it will also most-likely be directly compatible with MariaDB. They even use all of the same ports.

jungrishi

So let me get it straight:
Is there a way to install Mysql-server specifically for my Solus machine!!

JoshStrobl

You've already been informed on what is available in the repo and what your other options are. Please read the replies to your post.

synth-ruiner

ShikiSuen This is a serious reply telling you that mariadb is not a replacement of MySQL for every purpose

I never said it was!

JoshStrobl

ShikiSuen

This means that it is impossible to operate a forum server (in CJK languages) on Solus until MySQL 5.7

Repeat after me: Solus is not a server operating system. I'm not sure why you decided to necro something 7 months later with a usecase that is complete invalid.

ShikiSuen

@jungrishi

Good news: You can install Docker through EOPKG and then use official MySQL docker images instead:
https://hub.docker.com/_/mysql

Also, if you have interests in AliSQL, you can use this docker image:
https://hub.docker.com/r/tekintian/alisql/dockerfile

I forgot to tell you that you have to run this command once after installing homebrew:
echo "export PATH=$PATH:/home/linuxbrew/.linuxbrew/bin/" >> ~/.profile

Looks like MySQL on my virtual machine successfully built within 20min but has to be manually run.
MySQL, after installation through Homebrew, locates in /home/linuxbrew/.linuxbrew/bin/mysql.

See this screenshot: