Live data from Hacker News

Wordpress site running on Raspberry Pi

pipress.vo3.net

21–30 of 37 posts

Re: Wordpress site running on Raspberry Pi

#21

Earlier quoted context omitted.

Running ab -n 1000 -c 20 http://pipress.vo3.net/wp-login.php\?action\=lostpassword Seems to have killed it. The site came back when I killed the process. Sorry jstalin but I had to do it! For science!

For science lots of people will probably try to replicate your results, as good scientists should.

Haha, I liked this conversation! @jstalin I'll get my raspberry pi delivered in a few days, I'll let you know if I can figure out the varnish issue. Meanwhile, you can also submit a ticket on Trac https://www.varnish-cache.org/trac

Re: Wordpress site running on Raspberry Pi

#22
post #20

Earlier quoted context omitted.

Not by default and especially not once you start adding any sort of add-ons. A typical wordpress site will hit your MySQL database a TON.

I'm not familiar with wordpress but does it require that you use mysql?

Yep.

Re: Wordpress site running on Raspberry Pi

#23
post #21

Earlier quoted context omitted.

For science lots of people will probably try to replicate your results, as good scientists should.

Haha, I liked this conversation! @jstalin I'll get my raspberry pi delivered in a few days, I'll let you know if I can figure out the varnish issue. Meanwhile, you can also submit a ticket on Trac https://www.varnish-cache.org/trac

The quickest way to get an answer regarding varnish issues is to ask on the irc channel.

irc://irc.linpro.no/#varnish

Re: Wordpress site running on Raspberry Pi

#24
post #13
post #6

Earlier quoted context omitted.

Most people who have their site go down aren't using proper caching so their Wordpress sites are evaluating the PHP and querying the MySQL database with each page load. This is extremely wasteful of processor cycles and memory, hence the site goes down when the server gets overloaded. The proper way to do it is to have caching in place such that it evaluates once and saves the result as a static HTML page. Then the s…

If it survives does that mean that the Pi can essentially saturate its network connection if it doesn't need to do any "real" work? I bet you could stick it in a rack in front of the grownup servers to act as a haproxy dongle, how hard can it be ? I officially dub it the cutest webserver.. in the world .

> Pi can essentially saturate its network connection

There are a few caveats here. If you're serving the same content ( < 512MB ) and it's static, then yeah, why not? Serving static content isn't CPU intensive and you're serving directly from RAM.

Re: Wordpress site running on Raspberry Pi

#25
post #20

Earlier quoted context omitted.

I'm not familiar with wordpress but does it require that you use mysql?

Yep.

This isn't really accurate. WordPress supports overriding the database class. Here's an example of a plugin that supposts Postgres http://wordpress.org/extend/plugins/postgresql-for-wordpress...

Re: Wordpress site running on Raspberry Pi

#26

Headers: W3 Total Cache/0.9.2.4 So he's serving a static page 90% of the time? I'd love to see how this thing operates without a cache.

Pretty much every good Wordpress install involves setting up something like WP Super Cache which generates static pages for your webserver to hit instead of the PHP pages.

Most blogs lack any dynamic content (except the admin section) and can just regenerate the pages when a new post is made or new comment added.

Re: Wordpress site running on Raspberry Pi

#27

Nice. With Redis and a simple script I wrote I load WP in a few milliseconds: http://www.jimwestergren.com/wordpress-with-redis-as-a-front... He should try it, as he is getting errors with Varnish.

I test your script and compare it on my LEB with my common setup.

- OpenVZ 128MB RAM

- Ubuntu

- Nginx

- MySQL

- PHP-FPM

- APC

- Varnish -->> Redis

At 250user/second here's the result : http://imgur.com/a/hPkyZ

This is vanilla WordPress installation. There is almost no difference in load time or overall resource usage as far as I'm concerned. I've never use Redis before so thank you for this.

Re: Wordpress site running on Raspberry Pi

#28

I'm working on a project where I have a rails site running on a beaglebone, it is populating its database with data coming from a usb device (~200 byte/s continuous). I am finding that the SD card with all of the data and the OS fails quite quickly (scale of weeks). Are SD cards just not up to the task?

Yes, SD cards are not designed as disks. 'SSD' drives work by selling you 4 - 10x the amount of flash as 'advertised' and replacing failed pages from the excess over time. They are more like light bulbs than switches in that way (finite lifetime).

Chuck - can you point to more articles or first hand evidence of lifetime testing of SD cards? I am very curious.

Re: Wordpress site running on Raspberry Pi

#29
post #24
post #13

Earlier quoted context omitted.

If it survives does that mean that the Pi can essentially saturate its network connection if it doesn't need to do any "real" work? I bet you could stick it in a rack in front of the grownup servers to act as a haproxy dongle, how hard can it be ? I officially dub it the cutest webserver.. in the world .

> Pi can essentially saturate its network connection There are a few caveats here. If you're serving the same content ( < 512MB ) and it's static, then yeah, why not? Serving static content isn't CPU intensive and you're serving directly from RAM.

Let's not forget the caveat of network speed (4MB/s tops), and the other caveat of alleged stability concerns when saturating the network link AKA USB system.

Re: Wordpress site running on Raspberry Pi

#30
post #28

Earlier quoted context omitted.

Yes, SD cards are not designed as disks. 'SSD' drives work by selling you 4 - 10x the amount of flash as 'advertised' and replacing failed pages from the excess over time. They are more like light bulbs than switches in that way (finite lifetime).

Chuck - can you point to more articles or first hand evidence of lifetime testing of SD cards? I am very curious.

Well, Intel used to have a service life comparison for flash up on their site but I can't find it now :-(. There was also a great article on it in EE Times which has also faded apparently. SanDisk in its 2004 document [1] re-iterates the 100,000 writes limit.

Typically flash is broken up into 'pages' and a page can be as small as 8K bytes and as large as 128K bytes, there are reasons for doing it different ways (mostly related to write latency) but if you consider an 8GB flash with 128K byte pages, that is 64K 'pages' (8G/128K) And if you wan to write one byte on that 'page' you have to rewrite the entire page.

San Disk and others will typically spec that a single 'page' can be written 100,000 times, and wear levelling software insures that no single page gets written more than any other page. So you can expect a total of 100,000 * 64K or 6.55B writes before you see a failure.

If you look at typical 'disk' sorts of statistics you will see that a typical SATA drive will do something like 80 - 100 IO operations per second (IOPS) so writing at 80 IOPS you would take nearly 23 thousand hours to wear out an 8G flash. But at Flash speeds (10,000 IOPS) that could easily drop to a mere 182 hours (which is why you don't see a lot of 8G SSDs)

But this is where the math gets fun. The card is spreading writes over total available pages, so assuming 128K pages and 100K writes per page and 500 IOPS (somewhere between a SATA SSD and a spinning rust drive, and well within the rate possible using USB channels or SPI) that kills off 128K bytes every 200 seconds.

Writes get flushed out to disk right away to keep the file system consistent and so you get more writes than you might expect. And writing one byte to a file, not only changes the inode holding that byte, but it also changes the inode holding the directory entry which has the length and modification time (assuming you've disabled atime). So every write from user land can be 2 writes to the device, and sometimes more if it results in overflowing a directory block.

Other variables include how effective the write leveling works, the card has to 'remember' its leveling. An early version I saw wrote a generation number into a page header (written with the same page) and then managing the map. On cheap cards the map (from the linear space presented to the user to the random space of the actual flash) I've seen code which basically mapped each page to 16 candidate pages and then linearly searched amongst those 16 for the next page to write. This had the effect that the single page write endurance lifetime was shorter than the aggregate device write endurance lifetime. (back when I was doing my embedded OS work I was using JTAG to read back flash state directly from flash drives (not the SD cards but the early drives offered for sale as replacement disks)

Anyway, like most things, its not immediately obvious what factors come into play and its easy to do things that screw you (like doing atime writes).

[1] www.flashgenie.net/img/productmanualsdcardv2.2final.pdf

Post reply on HN