Hi Wagner. That is what I did as the last resort, and that is "only" what solved the issue.
Thanks. On Fri, Sep 5, 2014 at 1:52 AM, wagnerbianchi.com <m...@wagnerbianchi.com> wrote: > You can try these steps: > > 1-) Stop slave and write down the replication coordinates getting that in > MySQL's error log (*very important step*); > 2-) Issue the `reset slave` command on MySQL Slave; > 3-) Issue the CHANGE MASTER TO considering the replication coordinates > you've just written down on step 1; > 4-) Give replication a start; > 5-) Check if the issue has gone away. > > If you're not comfortable to do that, just share the SHOW SLAVE STATUS > output with us. > > Let us know how's it going, cheers!! > > > > > -- > Wagner Bianchi, MySQL Database Specialist > Mobile: +55.31.8654.9510 > E-mail: m...@wagnerbianchi.com > Twitter: @wagnerbianchijr > > > 2014-09-04 7:24 GMT-03:00 Ajay Garg <ajaygargn...@gmail.com>: > >> Hi all. >> >> Unfortunately, I have run into the logs, as described at >> http://bugs.mysql.com/bug.php?id=71495 >> >> Unfortunately, the issue does not go away, even after reverting back >> to "slave-parallel-workers=0" in "my.cnf", and restarting the mysql >> instance. >> >> >> Any quick idea, as to how we may get the mysql+replication up and >> running (even with the plain old non-multi-threaded mode)? >> >> >> >> >> On Tue, Sep 2, 2014 at 12:57 PM, Ajay Garg <ajaygargn...@gmail.com> wrote: >> > Thanks Akshay for the reply. >> > >> > On Tue, Sep 2, 2014 at 12:25 PM, Akshay Suryavanshi >> > <akshay.suryavansh...@gmail.com> wrote: >> >> Hello Ajay, >> >> >> >> I tried testing the slave-parallel-workers few months ago, what I can >> >> surely >> >> tell you its still under development, and at that time needed some >> >> critical >> >> bug fixing. >> >> >> >> It is helpful in situations where each schema has even workload. The >> >> case >> >> you mentioned above doesnt have so. DB2 is getting different type of >> >> load >> >> than the others, in that case the other slave workers should be able to >> >> proceed with their workload as opposed to db2 which is still executing >> >> the >> >> long running statement. Now just imagine what happens if we try to take >> >> a >> >> backup, what binlog position should be captured ? the show slave status >> >> will >> >> print what ? this is where it needs development, I tried testing >> >> backups on >> >> it, but there is no concrete documentation on what position it would >> >> fetch. >> >> >> >> db2-statement-1 (very, very long-running) >> >> db2-statement-2 (short-running) >> >> >> >> about the above scenario, the next db2-statement-2 it will wait for the >> >> long >> >> running statement-1 to complete. >> > >> > Surely.. !! :) >> > >> > >> > However, my concern is how this "tracking" is done. >> > That is, how is the db-wise segregation of statements done (from a >> > single-binlog-file originally coming onto the slave) ? >> > >> > If this segregation is not done, then I cannot think of a way on how >> > things would scale up, like for example, when the slave-relay-log-file >> > contains a random mix of statements from tens of different databases. >> > >> > >> > >> > Any pointers on the "actual current" implementation of this db-wise >> > statements-segregation will be a great confidence-booster !! :) >> > >> > >> > >> > Thanks and Regards, >> > Ajay >> > >> > >> > However db2-statement-2 can be picked up by >> >> any other sql worker thread. >> >> >> >> This is a good feature added in mysql, however still needs to go >> >> through lot >> >> of testing. Please share your observation and findings in case it >> >> differs >> >> from the above. >> >> >> >> Cheers!!! >> >> Akshay >> >> >> >> >> >> On Mon, Sep 1, 2014 at 8:27 AM, Ajay Garg <ajaygargn...@gmail.com> >> >> wrote: >> >>> >> >>> Hi all. >> >>> >> >>> >> >>> We have replication set-up, where we cater to HUUGEE amounts of data. >> >>> Since quite some time, we have been facing issues wherein the slave >> >>> lags behind master quite a lot. >> >>> >> >>> >> >>> So, yesterday we were able to setup parallel replication, by >> >>> incorporating the following changes :: >> >>> >> >>> a) >> >>> To begin with, partitioned some tables into dedicated databases. >> >>> >> >>> b) >> >>> Set up the "slave-parallel-workers" parameter. >> >>> >> >>> >> >>> The above seems to work functionally fine, but we have one doubt/query >> >>> about the scalability of this solution. >> >>> >> >>> >> >>> >> >>> >> >>> First, I will jot down the flow as far as I understand (please correct >> >>> if wrong) :: >> >>> >> >>> """ >> >>> Even in parallel-replication scenario, the master writes all the >> >>> binlog (combined for all databases) in just one file, which then gets >> >>> passed onto the slave as single-file itself. Thereafter, all the >> >>> replication commands (combined for all databases) are written >> >>> sequentially onto one slave-relay file. >> >>> >> >>> Thereafter, as per the documentation, the slave-SQL-Thread acts as the >> >>> manager, handing over commands to worker-threads depending upon the >> >>> databases on which the commands run. >> >>> """ >> >>> >> >>> >> >>> >> >>> So far, so good. >> >>> However, what would happen if the slave-relay file contains the >> >>> following >> >>> :: >> >>> >> >>> >> >>> db1-statement-1 (short-running) >> >>> db2-statement-1 (very, very long-running) >> >>> db2-statement-2 (short-running) >> >>> db1-statement-2 (short-running) >> >>> db1-statement-3 (short-running) >> >>> >> >>> >> >>> We will be grateful if someone could please clarifiy, as to how the >> >>> above statements will be managed amongst the Manager and the >> >>> Worker-Threads (let's say there is just one worker-thread-per-db) ? >> >>> >> >>> In particular, does the Manager thread creates internal >> >>> slave-relay-log-files, one for per database-statements? >> >>> >> >>> >> >>> >> >>> Thanks and Regards, >> >>> Ajay >> >>> >> >>> -- >> >>> MySQL General Mailing List >> >>> For list archives: http://lists.mysql.com/mysql >> >>> To unsubscribe: http://lists.mysql.com/mysql >> >>> >> >> >> > >> > >> > >> > -- >> > Regards, >> > Ajay >> >> >> >> -- >> Regards, >> Ajay >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: http://lists.mysql.com/mysql >> > -- Regards, Ajay -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql