Results 1 to 8 of 8
  1. #1
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    12,399
    Plugin Contributions
    87

    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,846
    Plugin Contributions
    25

    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
    12,399
    Plugin Contributions
    87

    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
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    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.

  5. #5
    Join Date
    Sep 2018
    Location
    Texas
    Posts
    32
    Plugin Contributions
    0

    Default Re: Switching db-tables from MyISAM to InnoDB

    What would we use to backup databases in that or any event?
    Thanks in advance

  6. #6
    Join Date
    Jan 2004
    Location
    N of San Antonio TX
    Posts
    9,106
    Plugin Contributions
    11

    Default Re: Switching db-tables from MyISAM to InnoDB

    Quote Originally Posted by DrByte View Post
    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.
    Mike, as DrByte pointed out, you'd need to dump the data.

    In phpMyAdmin, you'd select the database and select export.

  7. #7
    Join Date
    Aug 2007
    Location
    Gijón, Asturias, Spain
    Posts
    2,571
    Plugin Contributions
    30

    Default Re: Switching db-tables from MyISAM to InnoDB

    @lat9: did you make the change to InnoDB?
    Steve
    github.com/torvista: Spanish Language Pack, Google reCaptcha, Structured Data, Multiple Copy-Move-Delete, Image Checker, BackupMySQL Admin/Auto...

  8. #8
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    12,399
    Plugin Contributions
    87

    Default Re: Switching db-tables from MyISAM to InnoDB

    Quote Originally Posted by torvista View Post
    @lat9: did you make the change to InnoDB?
    Not "personally", but a site that I help with that has a massive organism that doubles as a database did.

 

 

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