> 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 >