Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    8,836
    Plugin Contributions
    69

    Default Switching db-tables from MyISAM to InnoDB

    A client whose Zen Cart is highly integrated with other processing is experiencing problems during the store's daily operation due to table-level locks.

    Since MyISAM doesn't provide a workaround for the issue, he's asked if the base Zen Cart processing will experience issues if the database engine for all tables is changed to InnoDB.

    I'm posting here to to see if anyone knows of any "lurking gremlins" that might not play well with that change.

  2. #2
    Join Date
    Dec 2009
    Location
    Amersfoort, The Netherlands
    Posts
    2,786
    Plugin Contributions
    24

    Default Re: Switching db-tables from MyISAM to InnoDB

    Quote Originally Posted by lat9 View Post
    A client whose Zen Cart is highly integrated with other processing is experiencing problems during the store's daily operation due to table-level locks.

    Since MyISAM doesn't provide a workaround for the issue, he's asked if the base Zen Cart processing will experience issues if the database engine for all tables is changed to InnoDB.

    I'm posting here to to see if anyone knows of any "lurking gremlins" that might not play well with that change.
    I don't think there are any dangers. I am looking to converting to innodb too. It has the benefit of linking fields of different tables, making updates and deleting simpler.

  3. #3
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    8,836
    Plugin Contributions
    69

    Default Re: Switching db-tables from MyISAM to InnoDB

    Thanks, @Design75; I'll relay that back to the client.

  4. #4
    Join Date
    Jan 2004
    Posts
    65,261
    Blog Entries
    7
    Plugin Contributions
    226

    Default Re: Switching db-tables from MyISAM to InnoDB

    Shouldn't be much of a problem. Granted, some (rarely changed, non-transactional data) tables would yield no benefit by the conversion, and would increase overhead.
    Note that switching to InnoDB will require backups to be generated via a dump and therefore filesystem backups would not be usable for db restores. Granted, if the site is that high in traffic then they probably couldn't have used filesystem restores in the first place. Relying on filesystem backups/restores for db data is never a good idea anyway. I'm just pointing out that they'll be impossible when using innodb.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

 

 

Similar Threads

  1. Change Storage Engine ( MyISAM to/from InnoDB converter)
    By data_digger in forum All Other Contributions/Addons
    Replies: 11
    Last Post: 17 Dec 2009, 09:56 AM
  2. Switching from oscommerce
    By mommyof2 in forum Setting Up Categories, Products, Attributes
    Replies: 1
    Last Post: 1 Nov 2009, 09:08 PM
  3. Switching from hosting
    By stefaaaan in forum Installing on a Windows Server
    Replies: 2
    Last Post: 27 Apr 2009, 09:33 PM
  4. Innodb mysql
    By disciple in forum General Questions
    Replies: 2
    Last Post: 25 Feb 2008, 04:30 PM
  5. Zen Cart and InnoDB
    By starslab in forum General Questions
    Replies: 1
    Last Post: 10 Nov 2006, 12:39 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR