Re: How to make Mysql Replication faster

[Sunil Divyeshvar]

-- If I recall correctly, MariaDB, even without Galera, has more parallelism in the Slaves.

Will have to check about MariaDB.


-- Have you looked at Engine=Blackhole in a relay? That _may_ give you another place to apply the trigger(s).

Engine=Blackhole , means slave side table's engine=blackhole ? no we required data on slave.


-- Would you care to step back and explain what your Triggers are doing? Perhaps we can concoct a different way to solve the ultimate problem.

We dont want to block/slow-down any insert on master so we are not doing any manipulation activity on master so we are having triggers on slave with all logic, Triggers working on before & after insert method , from that we are inserting/updating records in other different tables and from those tables other GUI related activity happens.

Tell me about Mysql-5.7.5 and parallel replication thread withing single schema.

Thanks