amuck-landowner

BuyVM offloaded SQL

NodeBytes

Dedi Addict
Has anyone used BuyVM's offloaded SQL? I'm thinking about using it for a couple small project sites. Any thoughts?

Thanks.
 

drmike

100% Tier-1 Gogent
Yeah, MannDude uses it for vpsBoard still.

Has been alright, but some performance issues with it.   Francisco knows and is babysitting it and I think has plans to beef the server up more.

I frown about offloading MySQL, especially to a shared server with who knows who doing who knows what.  Latency in offloading is high and network stack isn't the best way to move data quickly.

But yeah, it works and BuyVM hardly charges a thing for the service.  I can't complain about that.
 

willie

Active Member
I haven't directly used it but have followed some of its history.  Overall I think it's a good idea, if as you say you're running some small sites and you want to minimize hassle for yourself.  A db is one of the more complex moving parts in an application stack and they tend to need attention at unpredictable and usually inconvenient times.  The other thing is that lots of db users simply aren't skilful at db operations and will tend to run very inefficient queries (usually due to lack of indexes) or other stuff that bogs down entire servers.  That's one of the reasons BuyVM charges so little for the offload: it saves them hassle caused by improperly-run user-operated db's. 

However, if you know what you're doing and don't mind having to put more attention into keeping your db running, then self-hosting gives you more control and might be preferable in some circumstances.  If your db's activity level is significant and you do run your own, then I'd suggest hosting it on pure SSD rather than HDD.  I don't think BuyVM has an SSD product at the moment, though perhaps they'll offer one someday.  Although I'm not currently running a db on it, I have a Ramnode 128MB ram, 5GB SSD vps and it's snappier than any HDD-based VPS or even local HDD server that I've ever used.  All my current machines (home and work) are SSD based.  HDD is the new magtape, used for bulk static storage but not for anything "live".

Fran if you're reading this: I suggest rebuilding your offload server on SSD if you aren't already and if the economics are at all feasible.  It makes a huge difference.
 
Last edited by a moderator:

Francisco

Company Lube
Verified Provider
Fran if you're reading this: I suggest rebuilding your offload server on SSD if you aren't already and if the economics are at all feasible.  It makes a huge difference.
It's already in the works, as well as beefing the box out. We grew much faster than we originally had planned with the service so we're planning out how we can beef it out big time. Likely going to give it a pair of L5638's , 72GB RAM and a TB or so of SSD cache + a raid10 for raw storage.

The service works well but once in a while it requires a kick. For $1/m you're going to be hard pressed to beat the price, especially considering we don't limit diskspace :)

Francisco
 

MannDude

Just a dude
vpsBoard Founder
Moderator
Yeah, I'm using it right now as my KVM running vpsBoard with BuyVM is only boasting 256MB of RAM, so for the price it's great. Have had a few hickups here and there but Fran was quick to sort them out to speed things up. As he said, for an added $1/mo you, can't go wrong really. Easier than managing MySQL yourself.

However I will be putting the DB on a different BuyVM KVM I have soon. Just been busy. Not really because of performance issues, but for more control and to compare the two.
 

film_girl

New Member
I've used it in the past and recently started using it again for the self-hosted RSS reader (Fever, www.feedafever.com) I use. Good performance, especially if you're using a lower-memory box and for $1 a month, can't beat it.

If you need more control, need to run lots of custom queries, well, obviously run the MySQL/MariaDB/Whatever stack yourself. For me, if I'm just hosting a small website or web app, I'd rather offload the database and not deal with it. TBH, most of my most recent play sessions have been with Node.js and of the NoSQL ilk, so my use cases for MySQL in general are becoming fewer and further between.

But that's me. I'm far from an expert, just a hobbyest who sometimes gets herself into trouble.
 

bdtech

New Member
It's already in the works, as well as beefing the box out. We grew much faster than we originally had planned with the service so we're planning out how we can beef it out big time. Likely going to give it a pair of L5638's , 72GB RAM and a TB or so of SSD cache + a raid10 for raw storage.


The service works well but once in a while it requires a kick. For $1/m you're going to be hard pressed to beat the price, especially considering we don't limit diskspace :)


Francisco
is a HA solution still TBD?
 

bdtech

New Member
Yus.


We'll be waiting for the rebuild of the platform which will happen when it merges together with stallion 2. :)


Francisco
I'd pay $3-4 a month for HA MySQL. Separate physical hardware of course.
 
Last edited by a moderator:

Francisco

Company Lube
Verified Provider
I'd pay $3-4 a month for HA MySQL. Separate physical hardware of course.
We won't bump the price.

We'll just setup a master/master replication in each location :)

It's on the list of features on the way, we simply don't have enough man hours to knock it out in a weekend.

Francisco
 

NodeBytes

Dedi Addict
Edit: Just ordered offloaded sql services... got marked as fraud(first time ever). I'll have to wait til they manually approve. :p
 
Last edited by a moderator:

mikho

Not to be taken seriously, ever!
I'm not sure anything would be done unless you contact them via ticket or their irc channel.
 
Top
amuck-landowner