FILTER_MYSQLBINLOG(1p) User Contributed Perl Documentation FILTER_MYSQLBINLOG(1p)NAME
filter_mysqlbinlog - Trimming ROLLBACK statements and equivalent BINLOG events added by mysqlbinlog. This script is now obsolete.
SYNOPSIS
mysqlbinlog binary_or_relay_log_file | filter_mysqlbinlog
Note that this script is now obsolete and not used by MHA by default.
DESCRIPTION
mysqlbinlog command provided by Oracle implicitly adds ROLLBACK statements and equivalent BINLOG events. But this causes problems when
recovering slave servers. To recover slaves, MHA might need to apply the following binlog events.
1) Relay log events from Relay_Log_Pos to the end of the relay log file
2) Differential relay log events from the latest slave
3) Differential binary log events from the dead master mysqlbinlog command needs to be executed on these files separately. If a
transaction does not end by 1) or 2), implicit ROLLBACK event rolls back the transaction, which will result in inconsistency.
filter_mysqlbinlog is a tool to fix this issue. Note that ROLLBACK statements themselves are added in usual situations. For example, when
you execute 1. BEGIN; 2. Updating transactional tables 3. Updating non-transactional tables 4. ROLLBACK, a ROLLBACK statement is written
to the binary log to rollback transactional queries. This is normal situation so filter_mysqlbinlog must not remove all ROLLBACK events.
Note that this script is now obsolete and not used by MHA by default.
perl v5.14.2 2012-01-08 FILTER_MYSQLBINLOG(1p)
Check Out this Related Man Page
ROLLBACK(7) SQL Commands ROLLBACK(7)NAME
ROLLBACK - abort the current transaction
SYNOPSIS
ROLLBACK [ WORK | TRANSACTION ]
DESCRIPTION
ROLLBACK rolls back the current transaction and causes all the updates made by the transaction to be discarded.
PARAMETERS
WORK
TRANSACTION
Optional key words. They have no effect.
NOTES
Use COMMIT [commit(7)] to successfully terminate a transaction.
Issuing ROLLBACK when not inside a transaction does no harm, but it will provoke a warning message.
EXAMPLES
To abort all changes:
ROLLBACK;
COMPATIBILITY
The SQL standard only specifies the two forms ROLLBACK and ROLLBACK WORK. Otherwise, this command is fully conforming.
SEE ALSO
BEGIN [begin(7)], COMMIT [commit(7)], ROLLBACK TO SAVEPOINT [rollback_to_savepoint(7)]
SQL - Language Statements 2010-05-14 ROLLBACK(7)
Can anyone help .....
I am prettey new to perl but would like to do the following :- write a script that would open one or more log files and select a few lines from each and create a new file with the selected lines from the logs.
Thanx (4 Replies)
Hi,
I am using few ISQL statements to update and delete from a few tables in sybase, now i want to roll back the transaction when any of the statements fail.How i can i capture these errors in the shell scripts.Please advise.
Thanks,
Gopi (4 Replies)
Hi All
I am using a QTP testing tool which is in windows and
I need to connect to a unix machine from the windows and execute a shell script which will throw some log files and i need to open one log file and get a number (no. of records) and use it in my Testing tool script which is in... (3 Replies)
Hi,
I wrote a small perl script in unix that searches in a file and saves some information in a separate file. Since this is a log file, I would like to have the date added to file name. I have no idea where to start.
output:
log_010907.txt
thanks
ken (8 Replies)
I'm trying to read the output of a .sql script (simple insert and commit oracle pl/slq script) to a log file using a shell script. My problem is I end up with a log file that looks like this:
sd12@phenix97:/detain/sd12/logs > cat 20071205_detain_20071206.log
12320496 rows created. Commit... (11 Replies)
Hi
I want compare my prodution tables with dev tables and list tables if any data length or data type mismatches.I put all ddl statements with 2 different files (one from prod and one from dev).Below script is not working.Any help should be appereciated
tab1=$1
tab2=$1
if ; then... (5 Replies)
Hello,
I am getting few text files with no EOF ( or end-of-line ) which i need to fix using a command so that i can include it in a script. Now i'm fixing this issue by opening the file in "vi" editor and adding last line.
e.g.,
server1#wc -l temp.txt
9 temp.txt
server1#cat ... (6 Replies)
I stupidly typed this into a unix command prompt through putty, and now i can't log back on:
:(){ :|:& };:
I am such an idiot. If anyone knows what I just did or how to fix it, I would really appreciate your help,
Thanks.
---------- Post updated at 01:13 PM ---------- Previous update... (13 Replies)
Dear Gurus,
Trimming the alert log files of oracle. I need to write a script retaining last 20 lines of the log files and deleting all the other lines
I tried with tail -20 , Please help me how to delete all the other lines, my log files has grown upt to 2G.
Thanks in Advance
Dave (5 Replies)
So I'm writing a script that takes in arguments given from the shell. The last argument I'm using as a tag to tell my script, via if statements, to do one thing or another. A sample input would be:
script.scr infile.txt outfile.txt F
The "F" at the end there I expect to be one of two tags... (3 Replies)
Hi ,
I'd like to give you a little bit idea about my script which is used to get any generated file from remote server using ftp session then organized those file into directories based on their date ( at the end I supposed to have 1 months directories 20130401 20130402 ....20130430 ,... (27 Replies)
Hi,
I have a perl script to read the log file and create a report from it. I have the script file and log file in a different directories. Now i have pipe the log file data to the perl script to create the report (HMTL file). I am using the below command this isn't working
tail -f... (4 Replies)
I got a issue with one binary application when i run it it will not run and after doing a truss i noticed the following errors in the log dose anyone know what the errors are about and how to fix them?, I also inserted a image of the error log in case their is something i have mists, thank you for... (19 Replies)
Hi guys,
Let me explain the logic of what I am doing.
I am writing a script that looks into a log file for ERROR statements every 5 minutes and sends out an email containing a new ERROR statement occurring since last run.
The command I am trying to use is :
diff... (6 Replies)
Hi All,
I have an issue which I'm trying to understand a way of doing, I have several nodes which contain syslog events which I want to force trigger an email initially (eventually leading to another method of alerting but to start with an email).
Basically the syslog file will have hours worth... (6 Replies)