List:InnoDB Storage Engine« Previous MessageNext Message »
From:Reindl Harald Date:February 9 2012 10:03pm
Subject:Re: SAN guidelines for MySQL
View as plain text  

Am 09.02.2012 20:44, schrieb Luis Motta Campos:
> On 9 Feb 2012, at 20:07, Reindl Harald wrote:
>> Am 09.02.2012 20:01, schrieb Luis Motta Campos:
>>> easily measurable return of investment than a (usually painful) migration to
> SAN
>>
>> what is painful in migration to a SAN?
>>
>> SAN storage will be mostly faster since modern
>> devices having 1 GB buffers in front, your
>> physical disk not and yes it is a hughe different
>> between OS-chacing/buffering and dedicated hardware
>>
>> these days you can use VMware vSphere with dedicated SAN storages
>> and failover with better performance as most physical installations
>> with local storage
> 
> 
> NEVER EVER THINK about running Databases on Virtualization Engines. 

the real life shows no problems over years
you only need to buy the right hardware

> Abou the pains of SAN migration: (A) downtime, of a sort you cannot control 

which downtime?
replication anywhere?

> and cannot avoid by failing over from a master database to some replication slave

why do you believe this?

> (B) expensive scalability - if you're facing issues with the size of your data you 
> will be looking for ways to scale up your database cluster soon, and SANs are
> expensive 
> to scale up

this is not a technical problem

> (C) completely different infra-structure for your data-centre 
> a SAN unit will force you to rethink the way you organize your 
> database boxes in the data centre

but where is te problem?

> and this is painful, specially if you have been growing organically for a long time.

not if it is done right


Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc
Thread
SAN guidelines for MySQLANIL YADAV9 Feb
  • Re: SAN guidelines for MySQLLuis Motta Campos9 Feb
    • Re: SAN guidelines for MySQLReindl Harald9 Feb
      • Re: SAN guidelines for MySQLLuis Motta Campos9 Feb
        • Re: SAN guidelines for MySQLReindl Harald9 Feb
          • Re: SAN guidelines for MySQLLuis Motta Campos9 Feb
            • Re: SAN guidelines for MySQLReindl Harald9 Feb