Best way to set up ubuntu

[tkaiser]

Staying with NTFS on Linux will at least ensure that disk access is slow as hell. Combining an USB HDD with database workloads sounds also wrong (fast eMMC or a SATA SSD would be better -- yeah, both not possible with Pine64). The best you could do on Pine64 is to rely on mainline kernel and an UASP capable disk enclosure combined with a fast SSD. Further readings: http://linux-sunxi.org/USB/UAS and
http://forum.armbian.com/index.php/topic...s-on-sbcs/ and maybe also http://forum.armbian.com/index.php/topic...rformance/