Comments for SpinupWP

Comment on How to Install Ansible and Automate Your Ubuntu 22.04 Server Setup by R Scott LaMorte

R Scott LaMorte — Tue, 25 Apr 2023 16:56:55 +0000

Can Ansible be used to manage server configs on a per-site base? For example, for each client and environment on my servers, I need to custimize the .user.ini and other settings for New Relic, the php.ini settings, and add some nginx redirects to dev and staging sites to request images from production.
It would be great to automate these things, there’s a bunch of them, they are tedious and fiddly, and I don’t currently have them under version control.

Comment on WordPress Caching: All You Need To Know by Shravan Kumar

Shravan Kumar — Fri, 07 Apr 2023 07:18:40 +0000

Thanks for the article!

Comment on Using Laravel Valet to Set Up Local WordPress Dev in Minutes by James Clark

James Clark — Tue, 21 Mar 2023 13:10:02 +0000

In reply to Jules Colle. That's a good question! We've not experimented with Xdebug directly while using Valet, but I've done a little research and it does look like it should work with out too much effort. A couple of notable links: https://freek.dev/660-setting-up-xdebug-with-laravel-valet and https://www.daronspence.com/2021/06/02/installing-and-using-xdebug-with-homebrew-valet-and-vs-code-in-2021/

Comment on Using Laravel Valet to Set Up Local WordPress Dev in Minutes by Jules Colle

Jules Colle — Wed, 08 Mar 2023 10:34:38 +0000

Have you tried setting this up with Xdebug? For me, having live step by step PHP debugging during development is something I can’t live without anymore. I have switched dev environments so many times, and never found a solution where Xdebug would work out of the box. (Local by Flywheel did, but it kind of locked me in a bit too much.) Currently I’m using docker with a custom dockerfile and image that works perfectly for me, but it’s still hard to get this to work for team members that don’t have experience with docker.

Comment on WordPress Database Optimization: Adding Indexes to Custom Tables by Serafin Design

Serafin Design — Mon, 17 Oct 2022 00:39:46 +0000

I wish you actually showed how to see what the issue is with the wp_postmeta table when it relates to WooCommerce. We have a client that has 30 million rows and it slows the site down immensely.
However, it also has apps like TM Extra Product whatever that adds some hodgepodge voodoo to it and from there it’s anybody’s guess. Really concerned about if it’s a good idea to index that portion of the postmeta table.
You added a category did you not? Was that a blog post or a WooCommerce product category? I’m a bad reader. :o)

Comment on Drill Down into Disk Space Usage to Free Up Space on Ubuntu 22.04 LTS with the du Command by Jay Holtslander

Jay Holtslander — Thu, 27 May 2021 17:00:48 +0000

I discovered ncdu before I knew about du and I love it.

Comment on Drill Down into Disk Space Usage to Free Up Space on Ubuntu 22.04 LTS with the du Command by Jonathan Bossenger

Jonathan Bossenger — Wed, 05 May 2021 06:52:05 +0000

In reply to Richard van Denderen. Ooo, nice one. I must give that a "bash", thanks.

Comment on Drill Down into Disk Space Usage to Free Up Space on Ubuntu 22.04 LTS with the du Command by Raymond Day

Raymond Day — Tue, 04 May 2021 13:37:28 +0000

Installing Ubuntu server default is to format in LVM "Logical Volume Management" That way can just add a drive and it will see it as one bigger drive. Not 2 drives. So when you start to run out of space just add another drive. It will see it as one big hard drive.

Comment on Drill Down into Disk Space Usage to Free Up Space on Ubuntu 22.04 LTS with the du Command by Richard van Denderen

Richard van Denderen — Tue, 04 May 2021 13:18:01 +0000

I’ve installed the ncdu package just to have a bit simpler view and option to navigate trough folders 🙂

Comment on Varnish vs Nginx FastCGI Cache: Which is Best for WordPress? by Юлій В. Чирков

Юлій В. Чирков — Tue, 04 May 2021 05:32:16 +0000

Thanks a lot for sharing your test case!
at the moment, setting up a new server, I’ve stucked with the same «to be or not to be» question on Nginx vs Varnish
I’ve got my custom advanced build of nginx/1.19.10 with http3 / quic (it’s experimental branch of official Nginx) and couple of additional useful third-party modules, manually selected from the list on https://nginx.org/ (you can review the full kit on screenshot https://i.imgur.com/B3PDrWL.png) on one hand and varnish-6.2.1 on another
must note, Varnish has been installed most likely as a tribute to the past – both Varhish & Nginx for a long years has been running along on obsoleted server under Ubuntu 16.04, so at first I’ve just mirrored the scheme to the new one, ignoring the important nuance
modern Varnish grew up to 6th generation, but old server has been (and still is) supplied with 2nd one; same thing for Nginx – year and a half ago it has been frozen on release 1.10.3, and no more official updates are expected (most probably, old 16.04 line just can’t handle neoteric technologies)
but despite in fact 5-6 years is the short time, these past years changed everything, and old hardware and software vs the modern one are definitely chalk and cheese
modern server hardware and actual Ubuntu 20.04 perfectly fit each other, it’s really the escape velocity, and http3 is quite promising and pretty fast, so I’ve ended up with 186 lines of completely non-interactive bash script to keep my custom Nginx build up to date for no cost – ’cause it’s for sure will be too expensive to combine and build each new release by hands
as soon as new release available in repo on https://nginx.org/, one should launch the script, and it apt-gets last nginx release as source tarball, clones the source of latest stable http3 branch from nginx@github, merges sources, autodetects on Github and downloads sources of latest releases of dependencies and third-party modules, configures the rules for dpkg, compiles the whole bunch and provides two ready for install .deb packages (common and debug) with nginx http3 / quic, configured to be drop-in replacement of official mainline packages till the next release
and after I’ve took advantage of all this stuff to tune Nginx config and successfully paired it with Nginx Unit on backend, I’ve proceeded to Varnish and surprisingly realized that I don’t see the reason to utilize it at all – Nginx itself covers the same tasks very well, and moreover, as opposed to Varnish it’s notably more comfortable in tuning nowadays due to ability to extend the config and workflow with custom JavaScript modules
these doubts forced me to start the research on this topic. I’ve googled and reviewed quite a few opinions but unfortunately lion’s share of them propagated the thesis «Nginx is cool, but Varnish is also cool, they are both very cool, jedem das seine, the choice is yours»
thus I’ve been upset and ready to stop googling, when, fortunately, I came across your excellent post. no babbling, no water, clean and simple stages – I) specifications II) experiment III) statistics – true old school, quoting Fin the Human, «mathematical!»
so thank you one more time for your contribution!
now I’ve got the confirmation that my initial doubts haven’t been unreasonable and I’m calm again