BuyVM offloaded SQL
- Thread starter NodeBytes
- Start date
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.
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.
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.
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:
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
vanarp
Active Member
How do you identify abusers on your Offloaded MySQL? Are there some scripts to handle such?
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.
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.
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.
is a HA solution still TBD?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
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.Yus.
We'll be waiting for the rebuild of the platform which will happen when it merges together with stallion 2.
Francisco
Last edited by a moderator:
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
Did you order via a VPN?Edit: Just ordered offloaded sql services... got marked as fraud(first time ever). I'll have to wait til they manually approve.
Hit them up and they'll get you sorted out, I am sure.
