Howdy, Stranger!

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


NameCrane Offloaded SQL is now in public BETA!
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.

NameCrane Offloaded SQL is now in public BETA!

FranciscoFrancisco Top Host, Host Rep, Veteran
edited March 30 in General

Hello everyone!

We're happy to announce that we're in the process of rolling out a "Managed Databases", or "Offloaded SQL" product for NameCrane. We've had quite the increase in MySQL heavy websites causing quite the mess during peak hours.

Features

  • Based on MariaDB 11.4. Given the nature of the product we hope to also offer PostgreSQL.
  • High performance hardware (top performing CPU's for MySQL, 1 million IOPS enteprise NVMEs, tons of RAM).
  • Colocated on the same LAN/switch as our shared/reseller hosting, giving you ~0.1ms latency/
  • phpMyAdmin available with a whitelabeled domain. Users can point their own domains to the server and an SSL will automagically be assigned.
  • Hourly backups with probably 24 - 48 hours of retention, as well as DR backups. Not implemented yet, but should be ready by the time this is out of BETA.

Pricing

We're aiming around $0.35 - $0.50 per GB of storage, per year. So, 10GB of database storage would be $5.00/year.

The price will be $0.00 for the entirety of the beta

Ordering

You can order the service at https://namecrane.com/store/networking/managed-databases . This service currently only available in Las Vegas, but we expect it to be live in the Netherlands in the next couple weeks.

Other locations will follow as demand dictates.

What's Franned?

The current hardware is not the final specs we'll be rolling with. The node we bought for this came in damaged to the point we physically can't use one of the front drive bays, half the ram won't show up, and 2 of the PCI slots won't respond. We expect replacement hardware next week, at which point we'll migrate everything over.

It should still perform quite well, but it'll absolutely haul ass once moved.

Feedback either on here or our Discord would be highly appreciated!

Francisco

«13456710

Comments

  • tentortentor Member, Host Rep

    @Francisco said: Hourly backups with probably 24 - hours of retention, as well as DR backups.

    Any plans/thoughts on replication?

  • FranciscoFrancisco Top Host, Host Rep, Veteran

    @tentor said: Any plans/thoughts on replication?

    Possible as a cold standby we can swap over to, but we're not wanting to do HA with KVM or something like that, it eats into our IOPs too much (or makes it so we can't live migrate at all).

    Francisco

    Thanked by 3cainyxues tentor kkrajk
  • Good luck with the public BETA 🤍

  • StevieStevie Member

    @Francisco you beautiful person, I been waiting for a cheap MySQL database. Thanks so much.

    Thanked by 1Francisco
  • fzorbfzorb Member

    I wish you the best of luck, Francisco!

    Thanked by 2Francisco eb1995
  • JabJabJabJab Member

    @Francisco said: So, 10GB of database storage would be $5.00/year.

    That cheap, very fucking cheap, isn't it? Sign me for NL, I will store shit ton of small entries to crap up your db!
    What are the rules of the BETA?

  • Good luck with it.

    Thanked by 1Francisco
  • FranciscoFrancisco Top Host, Host Rep, Veteran
    edited March 29

    @JabJab said:

    @Francisco said: So, 10GB of database storage would be $5.00/year.

    That cheap, very fucking cheap, isn't it? Sign me for NL, I will store shit ton of small entries to crap up your db!
    What are the rules of the BETA?

    Use it like you would normally use such a product. If you want to shift some production loads to it, give 'er.

    We aren't going to yolo your data, it's just that there will probably be an SQL reboot next week (or maybe a longer outage while we sync things over).

    Past that, stress it, test it, look for bugs.

    Helpful users are likely to get to keep their services for lifetime.

    Francisco

  • GLWS <3

    Thanked by 1Francisco
  • FranciscoFrancisco Top Host, Host Rep, Veteran
    edited March 29

    @Stevie said:
    @Francisco you beautiful person, I been waiting for a cheap MySQL database. Thanks so much.

    Thank you :) Let me know what you think and what we're missing.

    The CraneBase portal is pretty simple/straight forward. Maybe we can work on some metrics I guess. Some visual 'success' feedback instead of just refreshing the page like we do.

    Francisco

  • Fran, cmon, get me some british offloaded SQL 😁. I'll buy.

  • iSkyiSky Member

    @Francisco you are always so sexy about hosting

    i dream about this, now only need to wait until it ready on SG

    wish you luck with this
    this year really need some place to manage my DB from many hosting
    plus need more backup places

    Thanked by 2Francisco dedimark
  • Interesting.

    Thanked by 1Francisco
  • Interesting!

    Thanked by 1Francisco
  • douladoula Member

    Hello,
    Can i get infos about the number of simultaneous users/connections? The limits? Ram, cpu per active database, ....
    Thanks.

  • FranciscoFrancisco Top Host, Host Rep, Veteran

    @doula said:
    Hello,
    Can i get infos about the number of simultaneous users/connections? The limits? Ram, cpu per active database, ....
    Thanks.

    There's nothing in concrete but we doubt it'll be an issue.

    Large caches, fast hardware, etc, should keep things in check.

    If you intend to use the database remotely you're more likely to have slow downs due latency than anything else.

    I make it a habit to check the slow SQL log for missing indexes and go through and add them for users. I've done this many times for shared users that were pulling their hair out trying to figure out why they were maxing 6 full cores.

    Francisco

    Thanked by 1wedge1001
  • KebabKebab Member

    I can't wait for NL release

  • FranciscoFrancisco Top Host, Host Rep, Veteran

    @Kebab said:
    I can't wait for NL release

    We for sure have some SQL whales over there we're going to beg/force to move over.

    Francisco

    Thanked by 2nghialele jnd
  • @Francisco said:

    @JabJab said:

    @Francisco said: So, 10GB of database storage would be $5.00/year.

    That cheap, very fucking cheap, isn't it? Sign me for NL, I will store shit ton of small entries to crap up your db!
    What are the rules of the BETA?

    Use it like you would normally use such a product. If you want to shift some production loads to it, give 'er.

    We aren't going to yolo your data, it's just that there will probably be an SQL reboot next week (or maybe a longer outage while we sync things over).

    Past that, stress it, test it, look for bugs.

    Helpful users are likely to get to keep their services for lifetime.

    Francisco

    Can I store 500GB of porn on it? Do you check if I store the raw bytes in Database if I create a table for each video? /s

    Thanked by 3Decicus satorik bdspice
  • FranciscoFrancisco Top Host, Host Rep, Veteran

    Can I store 500GB of porn on it? Do you check if I store the raw bytes in Database if I create a table for each video? /s

    Francisco

    Thanked by 2Kevinf100 Decicus
  • suutsuut Member

    I was looking for a database for vercel and this is awesome! I hope you can make some optimizations to vercel.

  • FranciscoFrancisco Top Host, Host Rep, Veteran

    @suut said: I was looking for a database for vercel and this is awesome! I hope you can make some optimizations to vercel.

    In what way?

    Francisco

  • KebabKebab Member

    How does the pricing work during beta? It shows 0 dollars per month when ordering @Francisco

  • FranciscoFrancisco Top Host, Host Rep, Veteran

    @Kebab said: How does the pricing work during beta? It shows 0 dollars per month when ordering @Francisco

    It's free for the entire run of the BETA. Once done we'll inform all BETA users of the new pricing, as well as reward free service to people providing us feedback.

    Francisco

    Thanked by 2Kebab nick_
  • FranciscoFrancisco Top Host, Host Rep, Veteran

    Fixed the phpmyadmin upload limits, it should be something usable now (~4GB?).

    Francisco

  • I would be super curious if you could share info about your implementation to automate provisioning of databases, backups, failover and replication.

    I have been implementing something similar not for customers, but for internal user at my company, and am using CloudNativePG operator for Postgres in Kubernetes. It's absolutely awesome and it makes operating lots of database instances a breeze with a ton of automation.

  • FranciscoFrancisco Top Host, Host Rep, Veteran

    @vitobotta said: I have been implementing something similar not for customers, but for internal user at my company, and am using CloudNativePG operator for Postgres in Kubernetes. It's absolutely awesome and it makes operating lots of database instances a breeze with a ton of automation.

    >

    There's isn't per user SQL's running or any sort of replication at the moment minus local R1. While we weren't planning to have that at the moment, never say never.

    For now the cranebase portal just interacts with a users designated SQL server to create databases, grants, and assign them.

    The same thing could've been done on top of cPanel/DA like we used to do on BuyVM, but with this we have complete control without a bulky control panel.

    Francisco

  • @Francisco said:

    @vitobotta said: I have been implementing something similar not for customers, but for internal user at my company, and am using CloudNativePG operator for Postgres in Kubernetes. It's absolutely awesome and it makes operating lots of database instances a breeze with a ton of automation.

    >

    There's isn't per user SQL's running or any sort of replication at the moment minus local R1. While we weren't planning to have that at the moment, never say never.

    For now the cranebase portal just interacts with a users designated SQL server to create databases, grants, and assign them.

    The same thing could've been done on top of cPanel/DA like we used to do on BuyVM, but with this we have complete control without a bulky control panel.

    Francisco

    You really should try operators in Kubernetes for this kind of stuff :)

  • suutsuut Member
    edited March 30

    @Francisco said:

    @suut said: I was looking for a database for vercel and this is awesome! I hope you can make some optimizations to vercel.

    In what way?

    Francisco

    I don't know the backend IP of vercel, so 0.0.0.0./0 is useful. Or you can maintain a dedicated IP whitelist.

  • Got one to try it out, so far so nice! Love the domain as well :)

Sign In or Register to comment.