Is there a version of MYSQL which would work on Drobo? I would love to use it as a backup for a mysql server i have running, by running a cronjob which uses mysqldump to copy the db every week or so to the drobo! If thats not possible I guess I could just RSYNC over the resulting .sql backup sql file, but I would like to skip the step if possible and maby even connect applications directly to the mysql on drobo.
Thanks,
Getting MySQL to work on the ARM architecture is challenging.
We having it working on Fedora, but with some compile tests disabled.
Short answer, its’ possible but nontrivial.
Also, keep in mind that the FS has only about 180 MB RAM available to all processes, so it’ll most likely be a terrible MySQL server.
I got MySQL 5.5.9 cross-compiled and packaged as a DroboApp. You can find it here: http://www.droboports.com/app-repository/mysql-5-5-9
nice one Ricardo
1 quick question though… i though you said “it takes about 270 MB of memory” … how does that work if the FS only has 180mb of ram?
Swapfile and shared libraries.
oh, thanks
So I’m looking at this link, and I want to set up MySQL for XBMC as detailed here:
http://www.lifehacker.com.au/2010/09/how-to-sync-your-xbmc-media-centres/
Now, do I need to do that whole thing listed on the link you have, or just grap the app and drop it in the folder?
Well, do you trust me not to have compiled a virus/trojan with the app? If you are paranoid (like me), then you probably would prefer to do it yourself from scratch to make sure that no funny business is going on.
Otherwise, yes, the TGZ file at the bottom of the page is all you need to deploy MySQL on your DroboFS. It should be pretty much ready to go.
similar to frostywolf, i’m looking to get XMBC and Mysql working together, but i’m an absolute MySQL+linux noob - especially on the drobo.
i’ve got mysql installed and running on the drobo. Ps identifies it running, and a quick nmap from another machine confirms that 3306 is open on the drobo. however, whenever i try to use something like mysql workbench, i get a ‘host blah is not allowed to connect to this Mysql server’.
all the info i seem to be finding indicates i need to be using either mysql or mysqladmin to create a new user or adding a line into my.conf to allow mysql to bind to an external ip or something. however i’m getting in over my head pretty quickly, and i’m hoping you can provide me with some standard commands to allow some remote access.
i’m not fussed about security here, ease of use is the aim. to be honest just getting access from a windows machine running mysql workbench would be enough, as i’m fairly certain i can work out the rest
Are you able to provide any info on granting access?
Thanks, however my problem at this point is that i don’t seem to be able to connect to mysql via commandline or remotely at all.
What commands do you use to run\connect to mysql or mysqladmin, and where are you running them from?
If i SSH in, change to \Droboshare\Droboapps\mysql\bin and run mysqladmin, i get the following:
-sh: mysqladmin: not found
Same goes for most anything located there. I’m sure its just a syntax thing i’m messing up.
Have you tried “./mysqladmin” (without the quotes, but with the ./)?
Also, are you trying to run this on a DroboShare? I’m pretty sure it won’t work, since it was compiled for the DroboFS.
Ahhh, the ./ was my problem. Running ‘./mysql’ or ‘./mysqladmin’ all works.
Yes, it is a drobofs, however now i’ve got access to mysql command-line, i’ve had no issues with configuring it so far, so i’m guessing your cross-compilation skillz are all powerful 
thanks.
You, sir, just made my day. 
Out of curiousity BlackDal, did this end up working out? I’m looking at doing the same thing for the same setup, wondering what kind of performance you’re getting running off the SQL database on the drobo as opposed to building my own NAS server.
Out of curiousity BlackDal, did this end up working out? I’m looking at doing the same thing for the same setup, wondering what kind of performance you’re getting running off the SQL database on the drobo as opposed to building my own NAS server.
yep. got it up and running. resource useage isn’t too bad, but the XBMC database hosted on it is pretty low-level stuff and is pretty static in nature. i haven’t tried to do anything more complicated with mysql, so don’t know how it would hold up under anything powerful.
I can’t seem to find a version of MYSQL compiled for the droboshare. I want to do this same thing, but have the original drobo. Any help?
I don’t think there is a version of MySQL for the DroboShare. The instructions at http://www.droboports.com/app-repository/mysql-5-5-20 should work fine, as long as you get the proper compiler for the DroboShare.