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.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
Comments
It would be useful to offer either SSH tunneling or a VPN or something for this use case, as a rudimentary implementation of "two factor" auth (the first factor being the SSH or VPN private key, and the second factor being the password).
I was thinking just SSL certificate authentication. VPN is interesting but it becomes a whole lot more to manage.
Francisco
This should all be sorted
Francisco
Looks like phpMyAdmin disable is fully working. IP lock on phpMyAdmin is not tho.
Phpmyadmin always runs as localhost, the allowed ip stuff won’t matter. Thats why we have the phpmyadmin as a separate control.
Francisco
Yep, that’s working as expected
Just because my eye picks up these things, some buttons on the left hand have hard right angle corners and some are rounded
Add user form - password field:
database information form:
Another suggestion would be for the allowed IP’s, maybe have a drop down with the IPs associated with any current plans, with the “name - IP” displayed. If the user then select a plan hosted in a different location, maybe a soft warning indicating it’s recommended to have these at the same location. Small thing, but saves having to look it up.
I've cured your OCD. I had to do manual
style=""fixes since Lagom doesn't normally support input groups.Anyway, looks much better
Francisco
That's a great idea! Definitely easier to set up.
How's this for you:
Francisco
Looks great
@off
Can we dream of a Stallion someday, but with a webhost? I mean, Plesk/cPanel/DirectAdmin panels are a shit to use, Stallion's way of being simple, functional and straight to the point is charming
I don't think so. People don't like change on the shared side of things. Look at how stubborn people are going from cPanel -> DA, and DA has 10+? years in the market.
Francisco
any chance it will come free with crates when its stable?
By default very unlikely. With that being said, we will be open to giving it for free on larger crates and longer payment terms on them. We aren’t against haggling.
Francisco
Ok, i signed up for beta at LV.
Does anyone able to export/attach their WP SQL database to offloaded SQL?
if im not wrong:
I've create new DB in the panel,
go to phpmyadmin,
and import the WP db from shared-node.
is that how you do?
And update your wp-config.php.
Francisco
So fwiw I have both a DA and CPanel LasVegas plan so decided to spin up a new Wordpress install on one (and already had a pretty much bare bones already on the other. If it’s interest, here’s how the Wordpress Benchmark Plugin compared the two.
CPanel Plan with Offloaded SQL - https://report.wpbenchmark.io/pKH2tazVti/
DA Plan with Standard SQL - https://report.wpbenchmark.io/Y3wHeUMnHH/
DA Plan with Standard SQL here does pull away on the SQL. Haven’t really done any analysis why and whether what’s being tested for here should be heeded too much or not. For example, I’m not sure if the ‘large import’ is typically super relevant to a WP optimisation or not (I’d have thought in most case probably not?). They do publishe settings they recommend which maybe hints at what the benchmarks are lfavouring. https://wpbenchmark.io/improve-wordpress-speed/. Wacked those settings on another VPS I have running LAMP and saw the ‘large upload go form 0.9 to 8.23, so this particular test certainly likes some of the settings in that article.
(being that these aren’t my live sites, I haven’t bothered to look at why the one regex test if failing, but if I had to guess its a php module I don’t have enabled.)
Maybe it’s of interest, maybe it’s not. Again, important to look at context. Ancidotally both WP instances are performing fine, but they also are fresh installs with almost no plugins or content, so the blog itself isn’t an amazing benchmark.
In terms of experience, already provided a few minor things (and you legends have already addressed them all!). Will say I found the email instructions concise but clear and it was pretty quick and painless to get everything set up. Been a good experience.
I actually think I got a fix for the import thing, it’s basically a tunable. I’ll look through my my.cnf
you can see complex is better on offload there.
Thanks for the testing, I should go install that plugin so I can confirm my work.
Francisco
can't wait for postgresql, redis, and mongodb xD
I'm definitely interested in trying out the service when postgresql support lands
Redis is already there inside cpanel and DA. Mongo is u likely due to how authentication works.
Francisco
I’m still researching how to safely create a user, grant access, and lock it down:m. It seems there’s a lot more to it than mysqls simpler grant system.
Francisco
I have a question, my Mysql is expected to store a fair amount of logs and query them at times, is this usage scenario within your acceptance? The logs might be 100G-200G max.
>
If you're paying for 100 - 200G of storage, sure?
The storage isn't unmetered or anything like that, you'd be paying $50 - $100/year most likely.
Francisco
Absolutely, I'm very aware that it's something that's paid for. I love the concept of hosted databases, it gives me a break from the hassle of O&M to focus on my life. Although running a database with Docker is not complicated these days
But I realize, wouldn't this project have to make sure that the programs used can be hosted on a crane? Don't get me wrong, I want the crane's semi-dedicated hosting, I'm just not sure it can run the programs I want so that everything is hosted and I'm able to get a good night's sleep late at night.
Given user demand/interest, we'll most likely make this available as a standalone product, just it might cost a bit more to cover bandwidth costs.
We'd also put DB servers in Kansas to cover the mid-west if we did that.
Francisco
Oh, this is gonna be good. I'll give it a try anyway. Absolutely love the concept, thanks for clearing that up. I'll even try semi-dedicated hosting as well to see what all I can do, I used to run my own programs on my VPS and that part is practically new to me.
I must digress, if only you could host Docker containers, that would be the perfect combination.
Wish it was in NY for testing! I get why LV tho.
Not something we are really interested in doing. You can get a VPS with BuyVM for that, or check with Terabit, they have a docker product in BETA right now.
Francisco
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