Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


[Request] Looking for SSD VPS on LA, budget : $18/Q
New on LowEndTalk? Please Register and read our Community Rules.

All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.

[Request] Looking for SSD VPS on LA, budget : $18/Q

DevoniusDevonius Member
edited December 2014 in Requests

I need VPS with specs below:

CPU: 2-4 vcore 3Ghz+
RAM: 2GB-4GB
SSD: 30GB-40GB
IPv4: 4-5
Location: LA
Uplink : 1Gbps +
Weekly backup if available

budget : $18/Quarter

my new web will have some sql so I prefer ssd+good cpu.

anyone?

or you can PM me/reply this thread about your price, if $18/Q doesn't match your price

Comments

  • BoltVM comes to my mind, but they would be $5/mo. for only 1GB with only 1 IPv4.

  • DevoniusDevonius Member
    edited December 2014

    I see.. for 1 IP maybe I will prefer vapornode with his coupon

    but thanks for your reply

  • I guess the cheapest way would always be to wait for a sick promotional offer.

  • Have to be pure ssd or just ssd cached good enough? I ask because @VMbox had a 3gb plan for 50/yr with 5 ipv4 a few months back, but it was only cached. Doubt they could do exactly that for that many addresses again, but maybe they could get you close. Free wildcard SSL with it, which is always a plus.

    Really though, you should consider a higher price point for what you're looking for... Vultr could get you a 2gb for just a few bucks more, but you'd be short on addresses. Most providers will want $1 a month for an extra address, so you'll be taking 12 a quarter away from them at that point. You're asking for greenvaluehost style deals with your price range... I'm fairness, they're probably the only one that could or would do it... Think I saw an email from them come through (really need to unsubscribe from that) about 12gb ram with a ton of addresses for 25/qtr or some such. Wouldn't recommend it if you value quality of service though

  • What kind of site you running? You don't really need ssd unless your going to be querying the hell out of mysql. Setting up a ram disk is a easy way to speed up mysql.

  • @aggressivenetworks said:
    What kind of site you running? You don't really need ssd unless your going to be querying the hell out of mysql. Setting up a ram disk is a easy way to speed up mysql.

    Any advice relating to using a RAM disk with MYSQL?

  • DevoniusDevonius Member
    edited December 2014

    @aggressivenetworks said:
    What kind of site you running? You don't really need ssd unless your going to be querying the hell out of mysql. Setting up a ram disk is a easy way to speed up mysql.

    are you talking about memcache?
    if it is, then I have already used some memcache there, but there's something logic that somehow hard to use memcache like "search" feature.

  • DevoniusDevonius Member
    edited December 2014

    @Pyr02k1 said:
    Have to be pure ssd or just ssd cached good enough? I ask because VMbox had a 3gb plan for 50/yr with 5 ipv4 a few months back, but it was only cached. Doubt they could do exactly that for that many addresses again, but maybe they could get you close. Free wildcard SSL with it, which is always a plus.

    Really though, you should consider a higher price point for what you're looking for... Vultr could get you a 2gb for just a few bucks more, but you'd be short on addresses. Most providers will want $1 a month for an extra address, so you'll be taking 12 a quarter away from them at that point. You're asking for greenvaluehost style deals with your price range... I'm fairness, they're probably the only one that could or would do it... Think I saw an email from them come through (really need to unsubscribe from that) about 12gb ram with a ton of addresses for 25/qtr or some such. Wouldn't recommend it if you value quality of service though

    please read : or you can PM me/reply this thread about your price, if $18/Q doesn't match your price

    pure ssd is preferable. I wouldn't consider GVH. Thanks.

    anyone can match this price?

  • Actually running the database in ram.

    Mount ramdisk folder in RAM
    mkdir /tmp/ramdisk
    mount -t tmpfs -o size=128M tmpfs /tmp/ramdisk/
    
    # Move MySQL data
    mv /var/lib/mysql /tmp/ramdisk/mysql
    ln -s /tmp/ramdisk/mysql/ /var/lib/mysql
    
    # Update permissions
    chmod -R 700 /var/lib/mysql
    chown -R mysql:mysql /var/lib/mysql
    

    restart mysql

    Thanked by 10xdragon
  • @aggressivenetworks said:
    Actually running the database in ram.

    Mount ramdisk folder in RAM
    mkdir /tmp/ramdisk
    mount -t tmpfs -o size=128M tmpfs /tmp/ramdisk/
     
    # Move MySQL data
    mv /var/lib/mysql /tmp/ramdisk/mysql
    ln -s /tmp/ramdisk/mysql/ /var/lib/mysql
     
    # Update permissions
    chmod -R 700 /var/lib/mysql
    chown -R mysql:mysql /var/lib/mysql
     
    

    restart mysql

    Won't there be data loss if your server shuts down?

  • edited December 2014

    Yes but there are many different ways to apply a ram disk to mysql. The one I gave above was just of an example of how to apply it. You can dump your temp queries to the ramdisk to speed up mysql.

    Edit: The above method you have to backup your mysql databases on a normal basis.

  • Unless your database is sufficiently large to saturate your RAM, it already is in-memory. And even after that, the indexes still are. The RAM disk is just a bad idea.

    Thanked by 1doughmanes
  • edited December 2014

    Your reducing the query times. It all depends on your situation and what your doing.

  • @aggressivenetworks said:
    Your reducing the query times. It all depends on your situation and what your doing.

    What? How so? If your DB is small enough to fit in memory, you're not hitting spindles anyway, ramdisk or not.

  • edited December 2014

    iwaswrongonce said: What? How so? If your DB is small enough to fit in memory, you're not hitting spindles anyway, ramdisk or not.

    Your database is not going to be cached all the time depending on the size. Your going to have eventually hit the disk to get some data. So having a the database on a ram disk reduces the time it takes to pull up the data. I am neither a MYSQL expert but from what I seen from using a ramdisk it has greatly improved the situation.

  • VPSDime? Just a few dollars over your budget but their service is solid.

  • bump

  • @4n0nx said:
    BoltVM comes to my mind, but they would be $5/mo. for only 1GB with only 1 IPv4.

    It's actually $3 a month or $30 a year for a 1 GB VPS! We're currently out of stock in Los Angeles for our SSD VPS, though, and I'm not sure when we'll begin re-stocking them.

  • Steven_F said: It's actually $3 a month or $30 a year for a 1 GB VPS! We're currently out of stock in Los Angeles for our SSD VPS, though, and I'm not sure when we'll begin re-stocking them.

    Oh, I am so sorry.. the price on your website seems to be wrong? It says $5 but when you click $3..

  • @4n0nx said:
    Oh, I am so sorry.. the price on your website seems to be wrong? It says $5 but when you click $3..

    Yep, we're pushing out an update this week.

  • got my vps, can close this thread, thanks all

Sign In or Register to comment.