← Back to team overview

maria-discuss team mailing list archive

Re: MariaDB master-slave chained replication and parallelism

 

InnoDB is faster even on a read-only workload now and has been for over a
decade.
One of very, very few cases for use of MyISAM is if you use compressed
read-only MyISAM tables.

On Thu, Aug 5, 2021 at 11:39 AM Jan Křístek <jkresa@xxxxxxxxx> wrote:

> It's used as an archive of events and data. The data are written just once
> and then read multiple times.
>
> I think that the response times are limited by the disk speed and that
> indexing for lookups works in a similar way on both MyISAM and InnoDB. We
> were considering upgrading it to Aria storage engine, as it offers better
> consistency (after a crash - I have read that somewhere), but it's not much
> time to do it now.
>
> Could be the upgrade might be easier when we will have a DB-proxy in place.
>
> On Thu, 5 Aug 2021 at 10:14, Gordan Bobic <gordan.bobic@xxxxxxxxx> wrote:
>
>> I think you are going to have to bite the bullet on conversion to InnoDB
>> sooner rather than later. The performance improvement you are going to see
>> will likely be orders of magnitude. The longer you leave it, the more
>> painful it is going to become.
>> You could do it on a slave and then promote it, or you could do it with
>> pt-online-schema-change.
>> While MyISAM still has some very narrow niche uses, it really is way past
>> time to retire it in any regular use.
>>
>>

Follow ups

References