kamilosxd678
Posts: 5
Joined: Sun Dec 10, 2017 3:57 pm

REAL MySQL instead of MariaDB

Sun Dec 10, 2017 4:03 pm

Hi,

For some reason that is unknown to me someone thought it would be a good idea to put mariadb instead of mysql as default for stretch. Unfortunately Oracle itself does not provide .deb files for armhf in their official repo and building from sources doesn't cut it because the compilation process requires more than 1GB of RAM :-(

So onto my question - does any kind soul here have a solution for it? Or even self-prepared .deb with mysql-server 5.7?

Thanks a lot

Best regards
Kamil

User avatar
rpdom
Posts: 12004
Joined: Sun May 06, 2012 5:17 am
Location: Essex, UK

Re: REAL MySQL instead of MariaDB

Sun Dec 10, 2017 6:31 pm

What is wrong with using mariadb? It's a drop-in replacement for mysql.

User avatar
fruitoftheloom
Posts: 15444
Joined: Tue Mar 25, 2014 12:40 pm
Location: Bognor Regis UK

Re: REAL MySQL instead of MariaDB

Sun Dec 10, 2017 8:10 pm

My only "PC" is an Asus ChromeBit running ChromeOS, cloudcentric at its best !
Rockchip Quad-Core RK3288C ARM32 SoC as used in ASUS Chromebook C201 & Chromebook Flip C100PA as well as the Tinker SBC.
3 Mobile Huawei E5330 Mobile Mi-Fi

kamilosxd678
Posts: 5
Joined: Sun Dec 10, 2017 3:57 pm

Re: REAL MySQL instead of MariaDB

Sun Dec 10, 2017 10:15 pm

I know that it has been changed and act as a replacement of MySQL, but as most of my Linux machines are using MySQL I have big compatibility issues with this MariaDB with both queries and tools. I have perfectly working solutions for one and true MySQL and I never wanted this cheap replacement shoved down my throat.

mfa298
Posts: 1047
Joined: Tue Apr 22, 2014 11:18 am

Re: REAL MySQL instead of MariaDB

Sun Dec 10, 2017 11:13 pm

kamilosxd678 wrote:
Sun Dec 10, 2017 10:15 pm
I have perfectly working solutions for one and true MySQL and I never wanted this cheap replacement shoved down my throat.
Maybe you should read a bit about MariaDB and it's history before being so dismissive of it. To save you a bit of effort:
MariaDB Server is one of the most popular database servers in the world. It’s made by the original developers of MySQL and guaranteed to stay open source. Notable users include Wikipedia, WordPress.com and Google.
It could be argued that MariaDB is the true MySQL (with what's called MySQL being the product of Oracles takeover dealings).

kamilosxd678
Posts: 5
Joined: Sun Dec 10, 2017 3:57 pm

Re: REAL MySQL instead of MariaDB

Mon Dec 11, 2017 7:07 pm

I have a lot of issues with MariaDB, I don't like it and I want to install MySQL. My question was - Does anyone successfully installed it on RPi? That was all, I don't want to be converted - I want a simple answer - I need a QEMU expert or cross-compilation expert - not MariaDB evangelists

User avatar
DougieLawson
Posts: 30960
Joined: Sun Jun 16, 2013 11:19 pm
Location: Basingstoke, UK
Contact: Website

Re: REAL MySQL instead of MariaDB

Mon Dec 11, 2017 7:10 pm

You'll need to build MySQL from source code, it's no longer built as part of DebIan.

While you're doing that you should compare the source code to MariaDB and you'll be 100% astonished that it's EXACTLY THE SAME CODE as MySQL with a few siginificant enhancements.
Microprocessor, Raspberry Pi & Arduino Hacker
Mainframe database troubleshooter
MQTT Evangelist
Twitter: @DougieLawson

Since 2012: 1B*5, 2B*2, B+, A+, Zero*2, 3B*3

Please post ALL technical questions on the forum. Do not send private messages.

kamilosxd678
Posts: 5
Joined: Sun Dec 10, 2017 3:57 pm

Re: REAL MySQL instead of MariaDB

Mon Dec 11, 2017 7:19 pm

Okay, can I at least get 10.2.x version on RPi, as it seems to not need as many changes as 10.1.x to get my SQL to work?

User avatar
rpdom
Posts: 12004
Joined: Sun May 06, 2012 5:17 am
Location: Essex, UK

Re: REAL MySQL instead of MariaDB

Mon Dec 11, 2017 7:24 pm

I'm surprised that it would need any changes at all. I use the same code for both my old MySQL server and my new MariaDB ones.

kamilosxd678
Posts: 5
Joined: Sun Dec 10, 2017 3:57 pm

Re: REAL MySQL instead of MariaDB

Mon Dec 11, 2017 7:30 pm

The original MySQL in ver 5.7 has more than ex. 767 limit on key length, as I see it was "fixed" in MariaDB 10.2.6
Last edited by kamilosxd678 on Mon Dec 11, 2017 7:48 pm, edited 1 time in total.

User avatar
DougieLawson
Posts: 30960
Joined: Sun Jun 16, 2013 11:19 pm
Location: Basingstoke, UK
Contact: Website

Re: REAL MySQL instead of MariaDB

Mon Dec 11, 2017 7:32 pm

It's a drop in replacement, so unless your SQL is completely off the wall it's going to "just work".

AriaDB is a massive improvement on InnoDB.
Microprocessor, Raspberry Pi & Arduino Hacker
Mainframe database troubleshooter
MQTT Evangelist
Twitter: @DougieLawson

Since 2012: 1B*5, 2B*2, B+, A+, Zero*2, 3B*3

Please post ALL technical questions on the forum. Do not send private messages.

JorgeP
Posts: 7
Joined: Thu Dec 07, 2017 12:37 am

Re: REAL MySQL instead of MariaDB

Tue Dec 12, 2017 12:28 pm

Not sure which Pi you are using or what version of raspbian you have. I have a Pi 3 with the latest raspbian and MySQL is available, it;s about 150-200mb from what it looks like for me. Both client and server.

Code: Select all

sudo apt-get update
sudo apt-get upgrade
sudo apt-get install mysql-server-5.5 mysql-client-5.5 mysql-workbench
don't know why nobody just told you instead of ranting about what they feel is better, although you could have found this out by doing a few searches.

User avatar
rpdom
Posts: 12004
Joined: Sun May 06, 2012 5:17 am
Location: Essex, UK

Re: REAL MySQL instead of MariaDB

Tue Dec 12, 2017 12:36 pm

JorgeP wrote:
Tue Dec 12, 2017 12:28 pm
Not sure which Pi you are using or what version of raspbian you have. I have a Pi 3 with the latest raspbian and MySQL is available, it;s about 150-200mb from what it looks like for me. Both client and server.

Code: Select all

sudo apt-get update
sudo apt-get upgrade
sudo apt-get install mysql-server-5.5 mysql-client-5.5 mysql-workbench
don't know why nobody just told you instead of ranting about what they feel is better, although you could have found this out by doing a few searches.
Because that's wrong. As the OP pointed out, MySQL is not available in Raspbian Stretch.

Ok, show the output from this:

Code: Select all

apt-cache policy mysql-server-5.5 mysql-client-5.5

DirkS
Posts: 7733
Joined: Tue Jun 19, 2012 9:46 pm
Location: Essex, UK

Re: REAL MySQL instead of MariaDB

Tue Dec 12, 2017 12:39 pm

JorgeP wrote:
Tue Dec 12, 2017 12:28 pm
Not sure which Pi you are using or what version of raspbian you have. I have a Pi 3 with the latest raspbian and MySQL is available, it;s about 150-200mb from what it looks like for me. Both client and server.

Code: Select all

sudo apt-get update
sudo apt-get upgrade
sudo apt-get install mysql-server-5.5 mysql-client-5.5 mysql-workbench
don't know why nobody just told you instead of ranting about what they feel is better, although you could have found this out by doing a few searches.
Are you sure you're running the Raspbian Jessie?
AFAICT these packages are not in the Stretch repo.

Code: Select all

pi@raspi3b:~$ apt-cache policy mysql-server-5.5
mysql-server-5.5:
  Installed: (none)
  Candidate: (none)
  Version table:

JorgeP
Posts: 7
Joined: Thu Dec 07, 2017 12:37 am

Re: REAL MySQL instead of MariaDB

Tue Dec 12, 2017 12:47 pm

I have it fine, installed and running!

Image

JorgeP
Posts: 7
Joined: Thu Dec 07, 2017 12:37 am

Re: REAL MySQL instead of MariaDB

Tue Dec 12, 2017 1:01 pm

Are you sure you're running the Raspbian Jessie?
AFAICT these packages are not in the Stretch repo
Yes, current Jessie. I purchased an nRF52 Dev board and tried installing the arm development software, somehow I ended up with "Synaptic Package Manager" I saw mysql and installed it. I forgot that step until I took the screenshot, I forgot that I didn't install MySQL from the command line.

But regardless it is running fine.

mfa298
Posts: 1047
Joined: Tue Apr 22, 2014 11:18 am

Re: REAL MySQL instead of MariaDB

Tue Dec 12, 2017 1:04 pm

JorgeP wrote:
Tue Dec 12, 2017 1:01 pm
Are you sure you're running the Raspbian Jessie?
AFAICT these packages are not in the Stretch repo
Yes, current Jessie.
That's not the latest Raspbian release!

Code: Select all

pi@raspberrypi:~ $ lsb_release -a
No LSB modules are available.
Distributor ID: Raspbian
Description:    Raspbian GNU/Linux 9.1 (stretch)
Release:        9.1
Codename:       stretch
(and that's not been updated for a month or so).

JorgeP
Posts: 7
Joined: Thu Dec 07, 2017 12:37 am

Re: REAL MySQL instead of MariaDB

Tue Dec 12, 2017 1:11 pm

mfa298 wrote:
JorgeP wrote:
Tue Dec 12, 2017 1:01 pm
Are you sure you're running the Raspbian Jessie?
AFAICT these packages are not in the Stretch repo
Yes, current Jessie.
That's not the latest Raspbian release!

Code: Select all

pi@raspberrypi:~ $ lsb_release -a
No LSB modules are available.
Distributor ID: Raspbian
Description:    Raspbian GNU/Linux 9.1 (stretch)
Release:        9.1
Codename:       stretch
(and that's not been updated for a month or so).
'
Turns out your right about my versions, I've been installing and updating using the Synaptic Package Manager. Here are the Repositories it is using.

Image

I am sure I am missing something, my version is Raspbian Jessie 8.0

mfa298
Posts: 1047
Joined: Tue Apr 22, 2014 11:18 am

Re: REAL MySQL instead of MariaDB

Tue Dec 12, 2017 3:40 pm

JorgeP wrote:
Tue Dec 12, 2017 1:11 pm
I am sure I am missing something, my version is Raspbian Jessie 8.0
Jessie (the previous release of Debian/Raspbian) has the original MySQL as bought out by Oracle, Stretch (the latest release of Debian/Raspbian) has switched to the fully opensource variant (as have most Linux Distributions) which is maintained by the original author of MySQL and is forked from just before Oracle got their hands on it.

As to which is better who knows (both add their own enhancements and some will be ported over to the other variant). However most Linux Distributions have switched to MariaDB as they generally prefer things which are fully opensource and are likely to stay that way.

Return to “Advanced users”

Who is online

Users browsing this forum: No registered users and 27 guests