thinkingcap

Looking to create a Software RAID 1 setup for your 2-disk server on Ubuntu Server 20.04?

Let's start with the basics: the official guide by Ubuntu (https://ubuntu.com/server/docs/install/storage) is outdated/wrong. And as of March 2021 it's possible that there's a bug as well with how the bios_grub partitions are created when using multiple disks.

Now on to the solution:

Select "Custom storage layout" when you reach the storage configuration step of the installer.
If the disks have existing partitions, click on each disk under AVAILABLE DEVICES and then select REFORMAT. This will (temporarily) wipe out the partitions.

	DELETE from wp_users where wp_users.ID not in (
	SELECT meta_value FROM wp_postmeta WHERE meta_key = '_customer_user'
	) AND wp_users.ID not in (
	select distinct(post_author) from wp_posts
	);

	delete from wp_usermeta where wp_usermeta.user_id not in (select ID from wp_users);

	<?php
	/**
	* Plugin Name: WooCommerce Upsells Shortcode
	* Plugin URI: http://skyver.ge/51
	* Description: Adds a shortcode to output WooCommerce product upsells; removes them from the original location when used
	* Author: SkyVerge
	* Author URI: https://www.skyverge.com/
	* Version: 1.0.0
	*
	* Copyright: (c) 2016 SkyVerge, Inc. ([email protected])

	#/!/bin/bash
	# Most of the tweaks here are wrapped up in gmailmig
	# https://code.google.com/p/gmailmig/
	#
	# Props to brave folks who figured this out before me
	# http://imapsync.lamiral.info/FAQ
	# http://www.thamtech.com/blog/2008/03/29/gmail-to-google-apps-email-migration
	# http://seagrief.co.uk/2010/12/moving-to-google-apps-with-imapsync/
	# http://blog.mcfang.com/tag/imapsync/
	#

	# Optimized MySQL configuration by Fotis Evangelou - Updated Jan 2016
	#
	# The settings provided below are a starting point for a 4GB-8GB RAM server with 4 CPU cores.
	# If you have less or more resources available you MUST adjust accordingly to save CPU, RAM and disk I/O usage.
	# To fine tune these settings for your system, use MySQL DB diagnostics tools like:
	# https://launchpad.net/mysql-tuning-primer
	# or
	# http://blog.mysqltuner.com/download/
	# Note that if there is no comment beside a setting, then you don't need to adjust it.