Raspberry Pi - $35 Linux computer

  • Thread starter Thread starter daz
  • Start date Start date
/home/pi/.xbmc/userdata/Database

Delete MyVideos75.db

Can you run a MySQL server in UnRaid?

Thanks for this, I'll give it a try this evening and let you know...

Yep, Unraid is just slackware linux underneath as far as I can tell, so you can install anything you like... it also has a one-click install for MySQL under its WebGUI making things easier... Would you recommend keeping the database on the server rather than the Pi's USB/SD?
 
It was marginally faster running from mysql for me.

It also means multiple devices share the database,which allows you to stop on one device and resume on another.

I swapped to a USB install the other day and the menus a drastically more fluid.
 
It does but its a minor annoyance. My FreeNAS server takes a while to boot as its an ESXI VM so the Pi always boots before it can connect to the database. All you need to do is go into the shutdown menu and Exit Raspbmc, it auto restarts and will connect to the database
 
Hmm okay, I'll look into it... to be honest now that I think about it why would I ever turn the Pi on when the media server (its only source of media) isn't also on? :p

Does it also mean when you re-install or update or switch the OS on your Pi you can just re-connect to the MySQL database and have all your media info back again instantly?

I guess there must be some guides around for how to set it up?
 
Hmm okay, I'll look into it... to be honest now that I think about it why would I ever turn the Pi on when the media server (its only source of media) isn't also on? :p

Does it also mean when you re-install or update or switch the OS on your Pi you can just re-connect to the MySQL database and have all your media info back again instantly?

I guess there must be some guides around for how to set it up?


That's another bonus ,reinstall pi copy across advanced settings file library is there straight away.

there's a guide in the first post of the xbmc thread in audio/visual subforum
 
Hey again, cheers for the tips - deleting that file cleared things out nicely

Unfortunately I don't think I can easily go the MySQL route, because the way UnRAID seems to work it effectively "installs" itself afresh on the USB stick every time it boots, which means certain services and things are difficult to persist between reboots unless you install them to a specific drive (and they recommend avoiding using the data array itself for this because if you do the drives will keep getting spun up)

Perhaps in the future if I decide to install a cache drive for UnRAID or find a different solution I'll switch, but for now I'll leave it on the Pi (I only have 1 for now anyway)
 
Hey again, cheers for the tips - deleting that file cleared things out nicely

Unfortunately I don't think I can easily go the MySQL route, because the way UnRAID seems to work it effectively "installs" itself afresh on the USB stick every time it boots, which means certain services and things are difficult to persist between reboots unless you install them to a specific drive (and they recommend avoiding using the data array itself for this because if you do the drives will keep getting spun up)

Perhaps in the future if I decide to install a cache drive for UnRAID or find a different solution I'll switch, but for now I'll leave it on the Pi (I only have 1 for now anyway)

Buy another Pi and install MySQL on that ;)
 
Perhaps in the future if I decide to install a cache drive for UnRAID or find a different solution I'll switch, but for now I'll leave it on the Pi (I only have 1 for now anyway)

For a long time I ran unRAID without a cache and had loads of extra applications installed. You can install to your boot USB but it's not generally advised due to the number of extra writes to the drive and the reduction in lifetime as a consequence.

One (low cost) solution is to mount a dedicated "apps" USB stick at boot (using the Go script) and hold your programmes and data there.

Find me on the unRAID forums if you want any help :)
 
For a long time I ran unRAID without a cache and had loads of extra applications installed. You can install to your boot USB but it's not generally advised due to the number of extra writes to the drive and the reduction in lifetime as a consequence.

One (low cost) solution is to mount a dedicated "apps" USB stick at boot (using the Go script) and hold your programmes and data there.

Find me on the unRAID forums if you want any help :)

Yep that's pretty much what I read - don't want to overload the boot stick... I hadn't thought about using another USB stick as essentially a poor-mans SSD though, with the price of a small-ish one being pretty low I could probably do that... Then just backup a copy of the database to the array now and then in case the stick ever dies and I need to restore it I guess

I didn't really want to bother with a cache drive because the read/write speeds are good enough for what I need and I'd rather have the extra bay for more storage

Thanks for the advice :D
 
I have been using my Raspberry Pi to run XBMC since I got it a while back, and I have been very happy with it, quite impressed. But she is about to be made redundant. I have a new TV (huge :D) coming with smart features so won't need the Pi.

So ... what do I get her doing?
 
Just noticed that a lot of RPi specific optimisations have been merged into the XBMC master branch over the weekend. It's basically an optimised pipeline to handle jpeg decode/resize/convert entirely within the GPU, instead of bouncing stuff between the CPU and GPU.
Hopefully this will really make a difference to the UI speed, like in this demo video: http://www.raspberrypi.org/archives/4986

This latest version of XBMC is not integrated into OpenELEC yet, but hopefully it won't be too long.
 
Installed Openvpn on my pi that's running raspbmc last night as I need secure tunnel to an ssh server. Works a charm and a fairly painful install. Might add Ethernet bridging later so I can pull files from my NAS securely too.
 
Not sure if it works with the BT sport APP.

But stuff like youtube/twitch/facebook vids, I just airplay them from my iPhone to the Pi running Open-Elec.
 
Back
Top Bottom