InnoDB is very different from MyISAM in how it stores data and how the indexes works. InnoDB uses an index-organized data storage technique, wherein the primary key acts as the clustered index and this clustered index holds the data. There
MySQL
A collection of 31 posts
Understanding InnoDB transaction isolation levels
Isolation is an important part of ACID properties that guarantee that transactions are processed in a reliable manner. Isolation ensures that concurrently running transactions do not interfere with each other. Isolation ensures data consistency. If the transactions are not isolated
On Hot Backups and Restore using XtraBackup
Backups are an integral and very important part of any system. Backups allow you to recover your data and be up and running again, in the advent of problems such as system crashes, hardware failures or users deleting data by
Setting up Master-Slave Replication with MySQL
Replication enables data from one MySQL server, called the master, to be replicated to one or more MySQL servers, called slaves. Replication is mostly used as a scale-out solution. With scale-out solution we are basically spreading the load among multiple
Statement-based vs Row-based Replication
Replication as most people know it, has mostly been SQL statement propagation from master to slave. This is known as “statement-based” replication. But there is also another kind of replication that is available, “the row-based replication” and that has quite
Understanding InnoDB clustered indexes
Some people don’t probably know, but there is a difference between how indexes work in MyISAM and how they work in InnoDB, particularly when talking from the point of view of performance enhancement. Now since, InnoDB is starting to
Tuning InnoDB Configuration
I had earlier written a post on tuning the MySQL server configuration [https://www.ovaistariq.net/358/tuning-mysql-server-settings/] which was more geared towards the MyISAM storage engine. While that is not because I didn’t intend on ignoring InnoDB but
A step by step guide to upgrading to MySQL 5.5
MySQL 5.5 has created a lot of hype and its not just hype, there are major performance enhancements not only in the MySQL server itself but in the newer InnoDB plugin shipped with MySQL 5.5. That’s exactly
Subscribe to ovais.tariq - tech and leadership
Subscribe today and get access to a private newsletter and new content every week!