vojthor
Posts: 3
Joined: Thu Jul 02, 2015 4:09 pm

MySQL 5.6 on Pi 2

Thu Jul 02, 2015 4:13 pm

Hi,

we need database with fractional seconds for our project, from the docs it´s supported only by MySQL 5.6.

Is it possible make stable server with this version at the moment? I also read MariaDB could handle it but I don´t figure how to make it working on Pi 2.

We using Raspbian but we can switch it to another distribution.

Thanks!

myoung008
Posts: 55
Joined: Mon Mar 18, 2013 9:56 pm

Re: MySQL 5.6 on Pi 2

Fri Jul 03, 2015 6:36 am

MariaDB makes a great replacement for MySQL and is stable. It's available for Raspbian Jessie (MariaDB 10.0 ~= Mysql 5.6). It's probably available somewhere for Raspbian Wheezy as well.

I've run it on a few Pis and other arm boards with great stability. I'm not using Raspbian for those machines, but I would expect it to work just fine anyway.

ame
Posts: 3172
Joined: Sat Aug 18, 2012 1:21 am
Location: New Zealand

Re: MySQL 5.6 on Pi 2

Fri Jul 03, 2015 6:45 am

What are you using fractional seconds for? Do you need them in a TIME field, or can you just store them in a DECIMAL field?

vojthor
Posts: 3
Joined: Thu Jul 02, 2015 4:09 pm

Re: MySQL 5.6 on Pi 2

Fri Jul 03, 2015 7:22 am

@ame: We measure light intensity from sensor and then link it with stored GPS location of car to generate heatmaps of town. On 5.5 version number is rounded and it looks really bad.

We now using Windows PC for it with MySQL 5.6.x and it works well, but we want to transfer database to Pi 2.

User avatar
DougieLawson
Posts: 39626
Joined: Sun Jun 16, 2013 11:19 pm
Location: A small cave in deepest darkest Basingstoke, UK
Contact: Website Twitter

Re: MySQL 5.6 on Pi 2

Fri Jul 03, 2015 9:00 am

myoung008 wrote:MariaDB makes a great replacement for MySQL and is stable. It's available for Raspbian Jessie (MariaDB 10.0 ~= Mysql 5.6). It's probably available somewhere for Raspbian Wheezy as well.
It's not available with Wheezy. You need to use the Jessie repo to get MariaDB.
Note: Any requirement to use a crystal ball or mind reading will result in me ignoring your question.

Criticising any questions is banned on this forum.

Any DMs sent on Twitter will be answered next month.
All fake doctors are on my foes list.

Return to “Networking and servers”