Just to be fair to the pi - most of these problems aren't the pi's fault.titanicsaled wrote:The biggest limitation of the Pi for wordpress is CPU cycles. Even with just one user loading a page it consumes 100% of the Pi's cycles for a few seconds. I wouldn't even think about using the Pi to replace a production wordpress webserver. You also have to think about the possible downtime as a result of using the Pi. Your router could stop responding, the Pi could stop responding, you could have a powercut, your internet connection could go down. There are ways of tackling all these problems but it requires a lot of effort.
Code: Select all
High availability solutions generally work of processes that will detect when "primary" is down, and have the second take over its IP. This won't work unless they are sitting next to each other.
I found it hard to find a good document on this - because products have been depreciated or had their roles changed several times and most guides are out of date.Un4Seen wrote: That's fine, I can have them next to each other. How would you detect that the primary is down and have the second take over its IP?
If you want to improve database performance, you could try SQLite instead of MySQL, or simply running one Pi as a database server, and the other as an HTTP server, but this is probably a bit redundant unless the traffic supports it.Un4Seen wrote:Wow, thank you! You're the first person who's given me any kind of feedback It's a new thing, it's... sharing my knowledge and my projects with the world so hopefully others can learn from it
It is indeed running on my Pi. Future plans include:
1. Running it on a dedicated Pi, so that I can use the current one for hardware projects without messing with the site's performance, or
2. Running it on two Pis, using some kind of replication technique. I'm stuck for the moment because I don't know how to achieve real-time DB replication with MySQL (it's not something really supported).
3. Moving the Pi (or Pis) that host the website from the wall plug onto a 12V battery powered by solar panels. This will take time because I don't have the necessary equipment yet, but it'definitely is in the long term plan
Users browsing this forum: No registered users and 18 guests