> 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 <https://cloud.digitalocean.com/account-referrals?i=e885b2> 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, techli...@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 > <https://u2206659.ct.sendgrid.net/ls/click?upn=SJEG7TF39YLaAIMD0HhsfELR9jZwxT3HiTkUXO1tE9ioZClLgKvLnBulO3piISvIZ65wMWwOAiOOzLhl4HI5ZCH57ca9a-2F7x2bGLXrOQv66lNQ2m6K5KOjhE21l7gwjFc1Sa_o-2BjQxMsWfboH-2B-2BcY2qb3IYCoqvthnvff9ftZz0pNEJ2tF1jbVlVBtrlaPYq4av3GYaZ24Wb1JZF8W3xUqpQjCBR-2F-2FsMcpC0Kr-2Ff0g66Gp-2FYF04f-2FJnuRV0SMlmF-2BfRLwfhwGyHk2YGfWcbL-2FokSn7uIeXBQOK2r9YnG7scs6K-2BBaerdNkNYJ4mg2l-2FqFDfBfddvbE4wMw8vkuHdJQblW5XHFeIbdSF4mxFT5EGg4f1g-3D> > > 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 > <https://u2206659.ct.sendgrid.net/ls/click?upn=SJEG7TF39YLaAIMD0HhsfC6E-2FcJXOs2D1VhGcvn2YkObFLMBOC3gmante55BOqf2F-2ByuZjZxeWAcK3DSlXP4Xtp4dQImX1G2Oq-2BQoN6woQ4-3DzUTm_o-2BjQxMsWfboH-2B-2BcY2qb3IYCoqvthnvff9ftZz0pNEJ2tF1jbVlVBtrlaPYq4av3GYaZ24Wb1JZF8W3xUqpQjCIbYwGL1HsmqYFll1GmgWW2pww2lHbr9MV8Lh5H9E7N69yzZ4ZgoD4E7l7s1hd2pkBItVP7yJekLmwU2aSlp4qFEIrvkWjleSqcTBZ3l2T15m9wl9jSPA0oBHzTAlSySu57U4ZjFv7VOmACxiDJriqc-3D> > > > --------------------------------------------------- > 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