MySQL – MyISAM, BSD, InnoDB Considerations

MySQL Table Types that are well known - MyISAM - InnoDB - BSD When making a choice amongst the different types of tables in MySQL, we need to consider the following points - Size of database based on the activity - Nature of database access / activity (whether it involves heavy reads / writes) - Database backup (schema, data) - Session handling - If it involves a sync to another database - What needs to be done if the application is to be scaled (more…)