tag:blogger.com,1999:blog-3577485635097286077.post9103008819906663508..comments2018-12-23T02:30:34.158+05:30Comments on Rohit's Blog: MySQL 5.7 Enhanced MTS: configuring slave for Intra-database parallelization rkalhanshttp://www.blogger.com/profile/01515820270253398672noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-3577485635097286077.post-81296769340670052602018-12-23T02:30:34.158+05:302018-12-23T02:30:34.158+05:30MySQL is one of the easy to use ways for you. It i...MySQL is one of the easy to use ways for you. It is extremely powerful, scalable and secure as compared to anything else. It is known to be the ideal database solution for your websites due to its small size and speed. <a href="https://www.dbdesigner.net/" rel="nofollow">Database Diagram Tool</a><br />Johnson 90https://www.blogger.com/profile/05376537054212999039noreply@blogger.comtag:blogger.com,1999:blog-3577485635097286077.post-49704655802013673672015-09-26T13:56:39.029+05:302015-09-26T13:56:39.029+05:30I’m glad reading your blog style .
watchescave.co...I’m glad reading your blog style .<br /><br /><a href="http://watchescave.com/" rel="nofollow">watchescave.com</a><br />Nina Fleminghttps://www.blogger.com/profile/08492050450850802608noreply@blogger.comtag:blogger.com,1999:blog-3577485635097286077.post-22805650587745502792015-02-12T21:11:12.406+05:302015-02-12T21:11:12.406+05:30Enhanced MTS is not available when using an old ma...Enhanced MTS is not available when using an old master. i.e 5.6 or before. This is because the enhanced MTS requires master to store information of the binlog groups, which are not being captured by the events generated on a 5.6 master. The enhanced MTS is only available for 5.7.1+ (master) ====> 5.7.1+(slave) replication.rkalhanshttps://www.blogger.com/profile/01515820270253398672noreply@blogger.comtag:blogger.com,1999:blog-3577485635097286077.post-61116307503348076242015-02-12T21:03:17.732+05:302015-02-12T21:03:17.732+05:30Rohit,
Have you tried parallel replication using...Rohit, <br /><br />Have you tried parallel replication using a 5.6 master? I've configured master's variables as you mentioned and slave keeps throwing these errors:<br />Last_SQL_Errno: 1755<br /> Last_SQL_Error: Cannot execute the current event group in the parallel mode. Encountered event Query, relay-log name ./francisco-mariadb-25cbf970-f4fd-4e23-b79a-62e7dbb02af3-relay-bin.000058, position 662 which prevents execution of this event group in parallel mode. Reason: The master does not support the selected parallelization mode. It may be too old, or replication was started from an event internal to a transaction..<br /><br />Any ideas? <br /><br />Best. Anonymoushttps://www.blogger.com/profile/04734771121951935027noreply@blogger.com