Comparing Magento 2 DB Schema Changes

Recently I came across an issue on a site where the setup:db:status would constantly report Declarative Schema is not up to date even after consecutive runs. This was breaking the zero downtime deployment configuration for the store, as the CD process always saw DB updates to process. There seemed to be (at least at the time of writing) very little information / tooling on how to debug db schema issues. So after a bunch of reverse engineering Magento’s implementation of DB Schema, I ended up creating a simple script that compares the current DB schema with the current configuration in the compiled db_schema....

November 12, 2023 · 2 min · 391 words · Me

Finding Magento 2 Uncacheable Blocks

A handful of times I have came across pages where full page caching is broken. Instead of diving through and grepping various XML files to identify what module is breaking the cache. I have wrote a section of code, that will identify any uncacheable blocks on the current page and display them in the bottom left of the page. Currently I just paste this into the theme (usually the header or logo phtml files)....

February 17, 2023 · 1 min · 171 words · Me

Magento 2 CLI Scratch File

I often find the need to test components / functionality independently of the system or execute single time use scripts. Which i find developing and deploying a whole module is a waste of time and resources. Some recent uses of scratch files are: Inspecting product or category data to help debug data issues Inspecting Cached Data Bulk assigning attributes Bulk renaming SKUs etc This is where scratch files come in handy, we can create a simple PHP file in the Magento root (I tend to prefix with z_ to easily find them)....

February 17, 2023 · 1 min · 165 words · Me

OpenVPN Split Routing

When setting up a VPN you have the option to either route all traffic through, or only route specific traffic through it. Some of the benefits with split routing within a development team context are: Increased privacy Reduced VPN load, allowing more connections / less allocated resources Access to both local & VPN network resources while connected Server Configuration Within your main server configuration file server.conf remove the line that looks like the following if it exists...

November 16, 2020 · 1 min · 175 words · Me

OpenVPN Quick Installation

You can simplify OpenVPN installation by using the OpenVPN installation script by NYR https://github.com/Nyr/openvpn-install On your target installation server, run the following to download and execute the script into your home directory. wget https://github.com/Nyr/openvpn-install/raw/master/openvpn-install.sh -O ~/openvpn-install.sh bash ~/openvpn-install.sh Default options you can choose are: UDP Protocol Port 1194 DNS Server 1.1.1.1 After the installer runs, you can now connect to the VPN, and you can rerun the script to add/remove clients or uninstall OpenVPN....

November 13, 2020 · 1 min · 74 words · Me