This is a general question to optimize performance, reliability, and consistency. I know that both of these methods work, I'm just wondering if there are (dis)advantages to one over the other.
- OS: Ubuntu 10.04 running on VMWare ESX
- Spare drive presented as an additional drive device. Appears as "/dev/sdb" to the OS
- Using MySQL 5.1 with the data directory, /var/lib/mysql, mounted on /dev/sdbX where X is defined below
- Using XFS as /dev/sdbX filesystem
The thing I'm interested in is partitioning the drive vs leaving it unpartitioned
An accident of decision making resulted in us having a number of systems with this setup using unpartioned "/dev/sdb"
I'd strongly prefer that all drives be partitioned, and thus configured and used as "/dev/sdb1"
The only advantage I can think of, though, is that partitioning the drive is a more standard way of setting this up.