MySQL Virtualisation

Databases

MySQL

In a 2008 Sun Microsystems paper, the performance impact of virtualisation vs dedicated hardware was measured at 4.9% (1)
Reduce the number of vCPUs in your virtual machines to the minimum, as larger numbers of vCPUs will incur more scheduling overhead. For example, if running on a four vCPU virtual machine with only 30% CPU utilization, reduce the number of vCPUs to two and expect to run at around 55 to 60% CPU utilization. (2)

MySQL Licensing & Support

Oracle customers with an active support contract and running supported versions of Oracle products will receive assistance from Oracle when running those products on VMware virtualized environments. If Oracle identifies the underlying issue is not caused by Oracle’s products or is being run in a computing environment not supported by Oracle, Oracle will refer customers to VMware for further assistance and Oracle will provide assistance to VMware as applicable in resolving the issue. (3)

Bibliography & References

(1,2) https://www.vmware.com/content/dam/digitalmarketing/vmware/en/pdf/techpaper/Virtualization-for-MySQL-on-VMware.pdf

https://warlord0blog.wordpress.com/2017/02/22/mysql-enterprise/ https://houseofbrick.com/wp-content/uploads/2020/09/2016_HoB_RDBMS_Licensing-White-Paper.pdf

https://www.mysql.com/support/supportedplatforms/database.htmlhttps://support.oracle.com(3) Support Position for Oracle Products Running on VMware Virtualized Environments (Doc ID 249212.1)