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! - Page 6
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!

13468913

Comments

  • FranciscoFrancisco Top Host, Host Rep, Veteran

    @syihabx said:
    i have a suggestion, can you add ipv6 support? i have a small vps with ipv6 only and have been looking for a db that supports vps ipv6 for a long time, but never found one.
    maybe someone else has the same problem too.
    Thank you

    We'd do that if we decide to make it a standalone product. If we intend for it to be focused for our local shared users there's no reason.

    We're not against making it a product, we'd just need 2 tiers of pricing to cover bandwidth usage.

    Francisco

    Thanked by 1syihabx
  • Oh this has finally become ready to launch. My LV node has been going up and down every day due to some people loading their shared hosting with awful amount of SQL data...

    If it does become a standalone product, will there be some egress fees to non-crane IPs? Any ways to "bypass" that with another product, like maybe a buyvm node from the same location and have the traffic ?

  • FranciscoFrancisco Top Host, Host Rep, Veteran

    @TheOnlyDK said: If it does become a standalone product, will there be some egress fees to non-crane IPs? Any ways to "bypass" that with another product, like maybe a buyvm node from the same location and have the traffic ?

    We'd just charge a flat smaller increase and hopefully we can throw enough on IX's or things like that so it doesn't matter.

    Our target is $0.50/GB/year or so, so maybe we do $0.65/GB/year for stand alone products. Does that break the bank or spoil it for those interested?

    Francisco

    Thanked by 1BasToTheMax
  • @Francisco said:

    @TheOnlyDK said: If it does become a standalone product, will there be some egress fees to non-crane IPs? Any ways to "bypass" that with another product, like maybe a buyvm node from the same location and have the traffic ?

    We'd just charge a flat smaller increase and hopefully we can throw enough on IX's or things like that so it doesn't matter.

    Our target is $0.50/GB/year or so, so maybe we do $0.65/GB/year for stand alone products. Does that break the bank or spoil it for those interested?

    Francisco

    0.65/GB is fair pricing for storage, but if someone were to abuse it, bandwidth is probably the first one targetted. They can just store like 5GB of data and then use up TBs of data each month.

    Thanked by 1BasToTheMax
  • FranciscoFrancisco Top Host, Host Rep, Veteran

    @TheOnlyDK said: 0.65/GB is fair pricing for storage, but if someone were to abuse it, bandwidth is probably the first one targetted. They can just store like 5GB of data and then use up TBs of data each month.

    >

    Well, it's MySQL, I don't see people pulling millions of rows over the wire. Someone earlier transferred 50 million rows for ~10G on disk.

    Francisco

    Thanked by 1BasToTheMax
  • @Francisco said:

    @TheOnlyDK said: 0.65/GB is fair pricing for storage, but if someone were to abuse it, bandwidth is probably the first one targetted. They can just store like 5GB of data and then use up TBs of data each month.

    >

    Well, it's MySQL, I don't see people pulling millions of rows over the wire. Someone earlier transferred 50 million rows for ~10G on disk.

    Francisco

    Are you talking about normal people? Or...

  • FranciscoFrancisco Top Host, Host Rep, Veteran

    @TheOnlyDK said: Are you talking about normal people? Or...

    His username is @jarjar123 , i'm not sure if that makes him more or less normal :D

    Francisco

    Thanked by 2TheOnlyDK Frameworks
  • @Francisco said:

    @TheOnlyDK said: 0.65/GB is fair pricing for storage, but if someone were to abuse it, bandwidth is probably the first one targetted. They can just store like 5GB of data and then use up TBs of data each month.

    >

    Well, it's MySQL, I don't see people pulling millions of rows over the wire. Someone earlier transferred 50 million rows for ~10G on disk.

    Francisco

    Stores 50 million rows, than does a select that returns half the rows every minute.

  • FranciscoFrancisco Top Host, Host Rep, Veteran
    edited April 1

    @Kevinf100 said: Stores 50 million rows, than does a select that returns half the rows every minute.

    >

    "I just DOS'd myself via MySQL."

    Francisco

  • @Francisco said:

    @Kevinf100 said: Stores 50 million rows, than does a select that returns half the rows every minute.

    >

    "I just DOS'd myself via MySQL."

    Francisco

    Adds firewall rule to deny all incoming request to anything crane related, but allow outgoing
    Or
    Runs it on some random free website that lets me send that request through them as a "test"

  • raindog308raindog308 Administrator, Veteran

    @Francisco said: Ideally you're connecting within a Namecrane location so there is no 'egress' cost to us. We aren't blocking it, but we're not going to let someone rip 100's of mbit in outgoing SQL traffic.

    IIRC BuyVM offload SQL was limited to BuyVM VMs only.

    I didn't see it explicitly stated above, so just to confirm - I could buy a VM or shared hosting on any random non-NameCrane provider and use NameCrane offloaded SQL from that?

  • FranciscoFrancisco Top Host, Host Rep, Veteran

    @raindog308 said: I didn't see it explicitly stated above, so just to confirm - I could buy a VM or shared hosting on any random non-NameCrane provider and use NameCrane offloaded SQL from that?

    Sure, that'd be what the 'external priced' stuff would allow. We aren't forbidding it on the discounted, but if we start seeing huge BW spikes from discounted users we're gonna have a chat.

    As a DBA you also know that latency matters in this.

    We're going to rush out a New York offload probably today.

    Francisco

    Thanked by 1BasToTheMax
  • I really like the product so far. I will probably use it from my existing vps (hosted somewhere else). Any idea what the network cost (per GB) will be?

  • FranciscoFrancisco Top Host, Host Rep, Veteran

    @BasToTheMax said: I really like the product so far. I will probably use it from my existing vps (hosted somewhere else). Any idea what the network cost (per GB) will be?

    I don't think we need to charge per GB since I honestly don't see someone slapping that much BW on it.

    I think just doing an extra $0.10 per GB of data is likely enough.

    In most markets we have tons of capacity, and in others we'll have a lot of peering we'll likely offload onto (especially if we add V6).

    Francisco

    Thanked by 1BasToTheMax
  • JabJabJabJab Member

    @Francisco said: I don't think we need to charge per GB since I honestly don't see someone slapping that much BW on it.

    Believe me there will be guy that will use that as CDN / blob storage :-D

  • FranciscoFrancisco Top Host, Host Rep, Veteran

    @JabJab said:

    @Francisco said: I don't think we need to charge per GB since I honestly don't see someone slapping that much BW on it.

    Believe me there will be guy that will use that as CDN / blob storage :-D

    Always possible, seems a bit odd to use SQL for it though, given they have to pull the record then serve it off their own BW :)

    Francisco

  • JabJabJabJab Member
    edited April 1

    @Francisco said: Always possible, seems a bit odd to use SQL for it though, given they have to pull the record then serve it off their own BW

    Peer2Mail Peer2SQL incoming.
    Cheap storage, BLOB file, no BW limits, crypto payment? :-D

    No idea if Peer2Mail still works or providers successfully killed that, but it was a real hit long time ago :-D

  • FranciscoFrancisco Top Host, Host Rep, Veteran

    @JabJab said: Peer2Mail Peer2SQL incoming.

    Cheap storage, BLOB file, no BW limits, crypto payment? :-D

    No idea if Peer2Mail still works or providers successfully killed that, but it was a real hit long time ago :-D

    Hah!

    Talking with Mike, he expects to see people plugging this into Cloudflare Workers or similar. Maybe CF has a cheaper RDS product? No idea.

    The product is definitely going a different route than we originally expected.

    Francisco

  • Any hints on the next restock? I’ll get f5 ready

  • FranciscoFrancisco Top Host, Host Rep, Veteran

    @TheOnlyDK said:
    Any hints on the next restock? I’ll get f5 ready

    A couple hours. I’ll have New York wired for then too.

    Francisco

  • FranciscoFrancisco Top Host, Host Rep, Veteran

    NY is up :)

    I've added 100 stock units to be shared between both locations.

    Francisco

    Thanked by 1TheOnlyDK
  • HarambeHarambe Member, Host Rep
    Thanked by 1Francisco
  • Got one now. Noticing in the email it's saying that we can bookmark the service URL for faster access, however, if the account is not logged in, it doesn't automatically get redirected to the correct page after logging in, instead it redirects to the dashboard page.

    Not sure if this is a limitation on WHMCS but hope this can be addressed.

  • Another one, if the database name/username can be automatically pre-generated (in grey text), for the people who don't want to bother with a custom name, it would be amazing. Or maybe have a button, like the password, that would generate a random name and call it a day.

  • FranciscoFrancisco Top Host, Host Rep, Veteran

    @TheOnlyDK said: Another one, if the database name/username can be automatically pre-generated (in grey text), for the people who don't want to bother with a custom name, it would be amazing. Or maybe have a button, like the password, that would generate a random name and call it a day.

    >

    Sure, i'll add a generator for the username. now to pick a word set for it (do we go virmach style or something else?)

    Francisco

  • @Francisco said:

    @TheOnlyDK said: Another one, if the database name/username can be automatically pre-generated (in grey text), for the people who don't want to bother with a custom name, it would be amazing. Or maybe have a button, like the password, that would generate a random name and call it a day.

    >

    Sure, i'll add a generator for the username. now to pick a word set for it (do we go virmach style or something else?)

    Francisco

    HELLYA

  • FranciscoFrancisco Top Host, Host Rep, Veteran

    @TheOnlyDK said: HELLYA

    Done.

    Enjoy :)

    Francisco

  • FranciscoFrancisco Top Host, Host Rep, Veteran

    @TheOnlyDK said: HELLYA

    Francisco

  • @Francisco said:

    @TheOnlyDK said: HELLYA

    Francisco

    Clean

  • Waiting for the Cranebase deployment in Singapore location
    @Francisco

Sign In or Register to comment.