Which virtualization technology do you use with MySQL?

Have you looked at virtualization for your MySQL environments yet?  If so, I'd like to hear about it-- what technology are you using, what benefits have you seen due to virtualization, and have you encountered any downsides or limitations?  For those who haven't explored virtualization, why not?  Once again, I'd like to here about?
Comments:

The key resources you carve up with virtualisation are CPU cores and RAM. And that's exactly what you want MySQL to have "lots" of.
Virtualisation for management reasons can make sense, but I tend to recommend against virtualisation for purpose of assigning some of those key resources to other db servers, application, servers, or whatever else.

Posted by Arjen Lentz on October 27, 2008 at 10:46 AM PDT #

In the case of the multi- multicore systems (CMT technology from Sun) the db server often does not scale adequately past 20 cores which means that the remainder of the cores are simply spinning on OS resources waiting for access to begin data access. In that case if the system has many more cores you can create another execution stack and use the remaining cores for other work. the degree of data partitioning will often dictate the number of cores required. So in this case virtualization helps.

Posted by fred bresani on October 28, 2008 at 06:27 AM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Jennifer Glore

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today