> Some may ask, “Why not some cloud service, like AWS or …?” My only answer is: because this is what I know right now. Convince me otherwise.

I'm biased, but I'd use - spin up a VPC, attach a database vm, and a front-end vm, and only expose the front-end vm. Then you have a private network to the MySQL instance. Or use DBaaS, but that's $15 a mo. 

Heck, here's a $200 credit to get started on DO 

Best Regards, 
-Thomas Scott


On Fri, Feb 24, 2023 at 2:52 PM David Schwartz via PLUG-discuss <plug-discuss@lists.phxlinux.org> wrote:
That’s certainly the simplest way, and it’s probably fine for an intranet that’s behind a firewall, but it’s not safe for a a public-facing application, which is what this is.

But thanks for the reminder.

-David Schwartz




On Feb 24, 2023, at 7:34 AM, techlists@phpcoderusa.com wrote:

David,

Seems like what you are attempting would be routine.  (remote MySql)

I found this :: https://stackoverflow.com/questions/27916503/lamp-setup-with-remote-mysql

Hope it helps.

Keith


On 2023-02-24 03:00, David Schwartz via PLUG-discuss wrote:
I’m building a web app that requires a membership with various levels. There will be a front-end (the web app) and a back-end on a Windows server. I’m thinking about putting the user DB on separate server.
I have this tool that lets me build apps using php and MySQL really easily to handle my basic admin needs (AppGini) and I’m thinking of using that to create the member’s DB and maintain it.
But if it’s on another server, then I’ll need some kind of interface to it so the back-end service can talk to it and do basic user-access things, like login/logout, change their pwd, get their basic account details, maybe deal with payments.
I’ve done a bit of poking around and it seems that in a Linux server with Apache, you need a little “router” that takes the incoming requests and routes them to endpoints by calling some php methods that access the DB. Or maybe it implements them itself.
It looks like there may even be something like that included in MySQL.
I have a shared hosting account that runs cPanel and WHM, so I don’t have access to the shell (well, it’s an option per account in WHM, and I’ve asked, but generally not).
This sort of thing is something I’ve had the dubious luxury of having managed everywhere I’ve worked by an IT Dept, but this is for me and I haven’t done this stuff in a long time. This is mainly for Dev + Test; I’ll set up a dedicated server when I go into production.
So I’m curious what y’all think of this approach.
Some may ask, “Why not some cloud service, like AWS or …?” My only answer is: because this is what I know right now. Convince me otherwise.
I’d actually be open to a 3rd-party service if you know of any that’s free or really cheap for Devs to set up.
-David Schwartz
---------------------------------------------------
PLUG-discuss mailing list: PLUG-discuss@lists.phxlinux.org
To subscribe, unsubscribe, or to change your mail settings:
https://lists.phxlinux.org/mailman/listinfo/plug-discuss

---------------------------------------------------
PLUG-discuss mailing list: PLUG-discuss@lists.phxlinux.org
To subscribe, unsubscribe, or to change your mail settings:
https://lists.phxlinux.org/mailman/listinfo/plug-discuss