Two instances better - or mix MyISAM and InnoDB?
Posted by:
Date: August 07, 2012 05:31PM
I may have submitted this question to the wrong forum. I'll try here.
We use MySQL to support a large OLAP type application with one very large table that is only updated once a month. By large, I mean 1.5 billion rows. We use MyISAM for this table for performance reasons, and also because we use merge tables to facilitate the monthly updates (dropping the oldest merge table, and adding a new one).
We are developing a new application that is highly relational and makes heavy use of real-time user-driven transactions with joins and commits. We will be using Innodb tables for this functionality.
We have a dedicated db server that currently runs one instance of MySQL with the MyISAM table format. To support the new transaction-driven functionality under development is it better to continue with one instance of MySQL and mix the two table types, or would it be better to run two instances of MySQL, with different ports and data directories?
Thank you for any insight you might have...
-Jim Gallagher
Subject
Views
Written By
Posted
Two instances better - or mix MyISAM and InnoDB?
3831
August 07, 2012 05:31PM
1904
August 08, 2012 11:14PM
1920
August 11, 2012 04:37AM
2036
August 15, 2012 10:09AM
1846
August 18, 2012 10:15PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.