Howdy, Stranger!

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

Sign In Register

Quick Links


Categories

In this Discussion

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

1…457910…13

Comments

  • danblazedanblaze Member
    edited April 2

    @Francisco said:

    @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

    I'm pretty sure I'll do it. Especially if you have it configured in the US, Europe, and Asia, I think it would be good for synchronizing the database across multiple nodes and doing queries close to each other.

  • FranciscoFrancisco Top Host, Host Rep, Veteran

    @danblaze said: I'm pretty sure I'll do it. Especially if you have it configured in the US, Europe, and Asia, I think it would be good for synchronizing the database across multiple nodes and doing queries close to each other.

    We aren't doing any sort of geo replication for this or things like that. This is going to be localized data.

    We're still mostly in scope where it's localized SQL servers. If we start trying to do global replication/sharding/whatever then we're asking for a headache that $0.50/GB isnt' going to cure.

    Francisco

  • danblazedanblaze Member
    edited April 2

    @Francisco said:

    @danblaze said: I'm pretty sure I'll do it. Especially if you have it configured in the US, Europe, and Asia, I think it would be good for synchronizing the database across multiple nodes and doing queries close to each other.

    We aren't doing any sort of geo replication for this or things like that. This is going to be localized data.

    We're still mostly in scope where it's localized SQL servers. If we start trying to do global replication/sharding/whatever then we're asking for a headache that $0.50/GB isnt' going to cure.

    Francisco

    I think PostgreSQL could simply be configured with a master-slave cluster, streaming to synchronize the data. Nonetheless, it makes sense even if you can't geo-replicate.

    Personally, I get a nicely configured VPS in PV's NYC to run certain services, and I'm very happy to see that this is only an average of 0.3ms latency from your NYC database.

    Have now acquired a log database to use as a secondary query.

    I'm finding it faster than if I ran a Mysql query locally, well done! Can't wait for the official release and then happily migrate more stuff up.

    I'd also love to see some sort of external traffic billing (in a follow up) so I can connect in both the NY and LA servers. buyvm's specs don't always work for me.

    But anyway, really loving NameCrane's new service, which is exciting. The “enterprise” database hosting services (RDS) on the market are usually too expensive. It's not friendly to individual developers and small business owners.

    And we all know those are steeply difficult to get started with.

    Thanked by 2hakurin BasToTheMax
  • shakensoulshakensoul Member

    Waiting for SG and Postgres

  • sanvitsanvit Member

    Although I understand that lower the better, but what would be an acceptable latency between the server and the DB for say, a simple Wordpress (which I understand is a bit more DB intensive) app? Was wondering if I could run some Django apps from a server ~8ms away.

  • JabJabJabJab Member
    edited April 2

    @Francisco I recall you bumped phpMyAdmin import size (or PHP settings?) to allow 4GB files and this is shown in PMA, but I guess you also need to bump Apache settings. I just got denied ~3GB upload. :-D

    Request Entity Too Large
The requested resource does not allow request data with POST requests, or the amount of data provided in the request exceeds the capacity limit.
Apache/2.4.62 (Debian) Server at lv-mysql01.offloadsql.com Port 8080

    also enable this please (-:
    https://lv-mysql01.offloadsql.com/phpmyadmin/doc/html/faq.html#faq2-9

    EDIT: Importing relatively small CSV (42MB!) ends with #2006 - MySQL server has gone away.

    Thanked by 1BasToTheMax
  • JabJabJabJab Member

    @sanvit said:
    Although I understand that lower the better, but what would be an acceptable latency between the server and the DB for say, a simple Wordpress (which I understand is a bit more DB intensive) app? Was wondering if I could run some Django apps from a server ~8ms away.

    This depends from the app you running and how it's created. If for example you have two queries per page it will be only +16 ms latency so not that bad.

    If you have a waterfall of queries like:
    1. Check if site enabled then
    2. Check if user enabled then
    3. Check if subsection enabled then
    4. Check if user has permissions to that subsection then
    5. Load subsection settings then
    6. Load subsection content then
    7. Do anything else then
    8. Do something else then
    etc.
    It's 8+ queries, each one 8 ms - turns out it will be like 100ms solo on network part. If your website takes 50 ms on localhost this would be 150ms, no go.

    Thanked by 4nick_ sanvit hakurin mwt
  • COLBYLICIOUSCOLBYLICIOUS Member

    I like the fact that @Francisco buys domains for every shit is doing.

  • HarambeHarambe Member, Host Rep

    @COLBYLICIOUS said:
    I like the fact that @Francisco buys domains for every shit is doing.

    I hate the fact that they're not all under our own ICANN account yet :disappointed:

    soon™

    Thanked by 2COLBYLICIOUS Francisco
  • HydeWingHydeWing Member

    When adding hourly backups, could you also include an option to save these backups directly to cloud storage services like Dropbox or Google Drive?

    Also, is there a way to access MySQL via command line without using phpMyAdmin? Importing and exporting large SQL files through phpMyAdmin can be cumbersome.

  • JabJabJabJab Member

    @HydeWing said:
    Also, is there a way to access MySQL via command line without using phpMyAdmin? Importing and exporting large SQL files through phpMyAdmin can be cumbersome.

    Yes, you access it normally. Add IP to allowed IPs to connect and there you go.

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

    @HydeWing said:
    When adding hourly backups, could you also include an option to save these backups directly to cloud storage services like Dropbox or Google Drive?

    Also, is there a way to access MySQL via command line without using phpMyAdmin? Importing and exporting large SQL files through phpMyAdmin can be cumbersome.

    No on the upload. Sounds like a fun way to burn crap loads of bandwidth.

    Backups will be local filesystem snapshots and then we can pull data out of them, drop tablespaces, and import.

    Francisco

  • FranciscoFrancisco Top Host, Host Rep, Veteran

    @JabJab said:
    @Francisco I recall you bumped phpMyAdmin import size (or PHP settings?) to allow 4GB files and this is shown in PMA, but I guess you also need to bump Apache settings. I just got denied ~3GB upload. :-D

    Request Entity Too Large
The requested resource does not allow request data with POST requests, or the amount of data provided in the request exceeds the capacity limit.
Apache/2.4.62 (Debian) Server at lv-mysql01.offloadsql.com Port 8080

    also enable this please (-:
    https://lv-mysql01.offloadsql.com/phpmyadmin/doc/html/faq.html#faq2-9

    EDIT: Importing relatively small CSV (42MB!) ends with #2006 - MySQL server has gone away.

    Let me check that, I'm guessing I need to bump packetsize.

    For LV all I tuned was innodb, but I'll merge my other changes shortly.

    Francisco

  • antariksa95antariksa95 Member

    Waiting sg

  • FranciscoFrancisco Top Host, Host Rep, Veteran

    @JabJab said:
    @Francisco I recall you bumped phpMyAdmin import size (or PHP settings?) to allow 4GB files and this is shown in PMA, but I guess you also need to bump Apache settings. I just got denied ~3GB upload. :-D

    Request Entity Too Large
The requested resource does not allow request data with POST requests, or the amount of data provided in the request exceeds the capacity limit.
Apache/2.4.62 (Debian) Server at lv-mysql01.offloadsql.com Port 8080

    also enable this please (-:
    https://lv-mysql01.offloadsql.com/phpmyadmin/doc/html/faq.html#faq2-9

    EDIT: Importing relatively small CSV (42MB!) ends with #2006 - MySQL server has gone away.

    I applied a fix for for the 'gone away', let me know.

    Francisco

  • SolarplexSolarplex Member

    Hey Francisco, what's the newest Discord link?

  • FranciscoFrancisco Top Host, Host Rep, Veteran

    @Solarplex said:
    Hey Francisco, what's the newest Discord link?

    https://discord.gg/tRbJjyVvmj Should do it.

    Francisco

  • KebabKebab Member

    @Francisco said:

    @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

    Any way to switch from LV to NY, I have plan activated in LV and NY now is closer but there is allowance of 1 plan per account

  • FranciscoFrancisco Top Host, Host Rep, Veteran

    @Kebab said: Any way to switch from LV to NY, I have plan activated in LV and NY now is closer but there is allowance of 1 plan per account

    >

    You can ticket and I can make the service in NY.

    Francisco

  • FranciscoFrancisco Top Host, Host Rep, Veteran

    @Kebab said:

    @Francisco said:

    @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

    Any way to switch from LV to NY, I have plan activated in LV and NY now is closer but there is allowance of 1 plan per account

    I tweaked the lock script so you can now order a 2nd service in NY w/o needing a ticket.

    Francisco

    Thanked by 2Kebab nick_
  • dgaroorkeedgaroorkee Member

    That sounds like a fantastic development for NameCrane, Francisco! 🚀 Rolling out a managed database solution with high-performance hardware, near-zero latency, and incredibly competitive pricing is a game-changer for MySQL-heavy sites. The addition of PostgreSQL in the future is also a great move! Offering this for free during the beta is a generous way to let users test and provide feedback, and I’m sure many will appreciate the effort you and your team have put into this.

    Wishing you and the NameCrane team a smooth rollout and a successful launch! Looking forward to seeing how this evolves. Keep up the great work! 💪🔥

  • FranciscoFrancisco Top Host, Host Rep, Veteran

    The crate has been picked up and is enroute to NL :)

    Francisco

  • suutsuut Member

    When there are multiple locations to choose from, can you launch something to test the network? It's like entering the server ip and being able to see which location has the lowest SQL ping. Or you provide test ip for each location.

  • FranciscoFrancisco Top Host, Host Rep, Veteran

    @suut said:
    When there are multiple locations to choose from, can you launch something to test the network? It's like entering the server ip and being able to see which location has the lowest SQL ping. Or you provide test ip for each location.

    Sure, you can also just ping any host from https://status.namecrane.com/

    Some sort of simpler looking glass would be ideal.

    Francisco

    Thanked by 1suut
  • suutsuut Member
    edited April 4

    @Francisco said:

    @suut said:
    When there are multiple locations to choose from, can you launch something to test the network? It's like entering the server ip and being able to see which location has the lowest SQL ping. Or you provide test ip for each location.

    Sure, you can also just ping any host from https://status.namecrane.com/

    Some sort of simpler looking glass would be ideal.

    Francisco

    Thanks bro!
    I mean the test IP of Offloaded SQL later.
    When the official version is released, custom Hostname can be provided for high-priced products. White Label Hostname.
    And SQL can support SSL.

  • FranciscoFrancisco Top Host, Host Rep, Veteran

    @suut said: When the official version is released, custom Hostname can be provided for high-priced products. White Label Hostname.

    And SQL can support SSL.

    We already have offloadsql-dot-com in use for offload :) We'll add SSL as well. I need to test it fully.

    We'll see about getting an SG node online by next week. My project over the past couple days has been rolling out the new backups cluster.

    Francisco

    Thanked by 2suut nick_
  • itachikonohaitachikonoha Member

    @Francisco

    I couldn't sign up for beta as I saw the thread late....

    Is it similar to aiven.io? They give a generous amount of database query and size in mysql, pgsql and redis.

    Is it similar to those?

  • TOMAS111TOMAS111 Member

    Some suggestions Currently when you add a user to a db while no user exists, it just shows an empty selection. Maybe add a hint like "create a user first" or just a "-", not only to make it look better, but also to let the user know to create a user first (tho mostly just to make it not look too empty) Also, since we already have a random generator for the username, why not add one for the database XD

  • FranciscoFrancisco Top Host, Host Rep, Veteran

    @TOMAS111 said: Some suggestions Currently when you add a user to a db while no user exists, it just shows an empty selection. Maybe add a hint like "create a user first" or just a "-", not only to make it look better, but also to let the user know to create a user first (tho mostly just to make it not look too empty)

    Good idea, or maybe I just popup the 'create user' modal instead.

    @TOMAS111 said: Also, since we already have a random generator for the username, why not add one for the database XD

    Another good idea, i'll add it over there as well :)

    Francisco

  • FranciscoFrancisco Top Host, Host Rep, Veteran

    @TOMAS111 said: Also, since we already have a random generator for the username, why not add one for the database XD

    Absolute unit.

    Should have the user modal in a few.

    Francisco

Sign In or Register to comment.