Question: Pi 4 as a web server

[itkenb]

Thinking to buy a pi 4 and use it as a web server

I want to run
PHP7 and Mysql
simple system for hotel room management that would update both local and online database


any tips or suggestions?
TIA

[fruitoftheloom]

Thinking to buy a pi 4 and use it as a web server

I want to run
PHP7 and Mysql
simple system for hotel room management that would update both local and online database


any tips or suggestions?
TIA

Maybe ?

https://projects.raspberrypi.org/en/pro ... -wordpress

[ankith26]

I had followed this ( https://howtoraspberrypi.com/how-to-ins ... y-pi-lamp/ ) tutorial a few months ago on my raspbian stretch OS. It had a few hiccups but in the end, it worked.
And I guess the same would also work on buster.

[ankith26]

Thinking to buy a pi 4 and use it as a web server

I want to run
PHP7 and Mysql
simple system for hotel room management that would update both local and online database


any tips or suggestions?
TIA

Maybe ?

https://projects.raspberrypi.org/en/pro ... -wordpress

That solution looks better as it comes from the official website of the raspberry pi.

[markatlnk]

I have been running a web site with email system on a pi for many years. I updated it from a pi2 to a pi4 last year. I have a static IP with 1G up and down. You are welcome to go look at it.

zjunk.net

We use it share our vacation trips in a Wordpress blog, I take a few photos and my wife writes. I turned off the comments.

The email system is more of an issue, when I updated to the pi 4, I made a bunch of changes and broke spam assassin so I do get a bunch of spam. I really need to get back to that one of these days.

I am running a 1T SSD with it and the SD-card only has the boot directory.

It has been 99 days from last reboot which is very common. I do have a fan case on it as it can get a bit toasty. It isn't even on a UPS, our power here has been very reliable. I had an up time of over 500 days at one point.

Mark

[itkenb]

Thinking to buy a pi 4 and use it as a web server

I want to run
PHP7 and Mysql
simple system for hotel room management that would update both local and online database


any tips or suggestions?
TIA

Maybe ?

https://projects.raspberrypi.org/en/pro ... -wordpress

Thank you!

Is it safe to run 24/7/365 on SD card? I have read topics regarding worn out sd cards

[itkenb]

I have been running a web site with email system on a pi for many years. I updated it from a pi2 to a pi4 last year. I have a static IP with 1G up and down. You are welcome to go look at it.

zjunk.net

We use it share our vacation trips in a Wordpress blog, I take a few photos and my wife writes. I turned off the comments.

The email system is more of an issue, when I updated to the pi 4, I made a bunch of changes and broke spam assassin so I do get a bunch of spam. I really need to get back to that one of these days.

I am running a 1T SSD with it and the SD-card only has the boot directory.

It has been 99 days from last reboot which is very common. I do have a fan case on it as it can get a bit toasty. It isn't even on a UPS, our power here has been very reliable. I had an up time of over 500 days at one point.

Mark

Thank you!

Is it safe to run 24/7/365 on SD card? I have read topics regarding worn out sd cards

[Heater]

I want to run PHP7 and Mysql simple system for hotel room management that would update both local and online database
...
Is it safe to run 24/7/365 on SD card? I have read topics regarding worn out sd cards

I suggest that if you want to run your business on a computer, any kind of computer, you have to be aware that the computer or it's hard drive or SSD or any other component can fail at any time. At which point your business stops.

What to do?

Either you have to have someone to call on 24 hours per day, ready for the day things fail.

Or you have to arrange multiple redundant systems.

Perhaps SD cards are less reliable than hard drives or SSD's in this respect. Makes no difference. You have to be ready for failure no matter what.

It's up to you to decide what risks you want to take in running your business.

[markatlnk]

My server only boots from the SD card, its main / directory is on the SSD. It is the same way I did it on the Pi2. The /boot directory is all that is needed there. There are ways to get it to boot from the SSD, but I never bothered. The SD card isn't written to except for updates, so it shouldn't ever have any issues.

Mark

[itkenb]

My server only boots from the SD card, its main / directory is on the SSD. It is the same way I did it on the Pi2. The /boot directory is all that is needed there. There are ways to get it to boot from the SSD, but I never bothered. The SD card isn't written to except for updates, so it shouldn't ever have any issues.

Mark

Well I guess I'll go with sd cards.. I'm will have once a month maintenance and the hoter/resort is not that popular.. so... I think it will not stress out the SD in terms of writing to database.... THANKS!

[itkenb]

I want to run PHP7 and Mysql simple system for hotel room management that would update both local and online database
...
Is it safe to run 24/7/365 on SD card? I have read topics regarding worn out sd cards

I suggest that if you want to run your business on a computer, any kind of computer, you have to be aware that the computer or it's hard drive or SSD or any other component can fail at any time. At which point your business stops.

What to do?

Either you have to have someone to call on 24 hours per day, ready for the day things fail.

Or you have to arrange multiple redundant systems.

Perhaps SD cards are less reliable than hard drives or SSD's in this respect. Makes no difference. You have to be ready for failure no matter what.

It's up to you to decide what risks you want to take in running your business.

Thanks man!... Well... All it does is write on database... so SD should be fine for at least a year...

[peppe8o]

Even if you have anyway to install a LAMP server (I suggest MariaDB instead of MySQL), you could also try Qloapps (open source). Once LAMP server is installed, you need to setup dependencies and upload installation package to Apache home directory.

It worked for me on a Raspberry PI 3 B+, so a PI 4 should work fine: https://peppe8o.com/2020/01/open-source ... d-qloapps/

Regarding data backup, you usually have 2 options:

• Periodically bakup application files: you must now what files to backup (usually database data and apache data) and how to restore them. Phpmyadmin could help for database data

• Periodically backup entire SD card: this is the simpler way, but requires planned stops to your server in order to extract SD card and create its image