> 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, 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
> <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
(text/plain)