java 管理MYSQL 二进制日志 binlog

 

import java.io.BufferedReader;import java.io.File;import java.io.FileInputStream;import java.io.FileNotFoundException;import java.io.IOException;import java.io.InputStreamReader;import java.io.RandomAccessFile;import java.io.UnsupportedEncodingException;import java.util.Calendar;import java.util.regex.Matcher;import java.util.regex.Pattern;public class MysqlLog {public static final String folder_name = "D:\\mysql_log\\";public static final String file_index_name = "D:\\mysql_log\\binary_log.index";public static final String file_txt_name = "D:\\mysql_log\\binary_log.txt";public static final String mysql_binlog_exe = "D:\\mysql_log\\mysqlbinlog.exe";public static final String insert = "insert";public static final String update = "update";public static final String delete = "delete from";public static void main(String[] args) throws Exception {String lastFileName = readLastLine(file_index_name, "utf-8");System.out.println(lastFileName);convertToTxt(lastFileName);readContent(new File(file_txt_name), "utf-8");String actionSql = lastActionSql(file_txt_name, "utf-8");System.out.println(actionSql);}public static boolean isExistActionSql(final String content,final String... actionSqls){for(String actionSql : actionSqls){Pattern pattern = Pattern.compile(actionSql);Matcher matcher = pattern.matcher(content);if(matcher.find()){return true;}}return false;}public static String lastActionSql(String fileName,String charset){String actionSql = "";RandomAccessFile rf = null;try {rf = new RandomAccessFile(fileName, "r");long len = rf.length();long start = rf.getFilePointer();long nextend = start + len - 1;String line;rf.seek(nextend);int c = -1;while (nextend > start) {c = rf.read();if (c == '\n' || c == '\r') {line = rf.readLine();if (line != null) {if(isExistActionSql(line,insert,update,delete)){actionSql = new String(line.getBytes("ISO-8859-1"),charset);return actionSql;}}nextend--;}nextend--;rf.seek(nextend);}} catch (FileNotFoundException e) {e.printStackTrace();} catch (IOException e) {e.printStackTrace();} finally {try {if (rf != null)rf.close();} catch (IOException e) {e.printStackTrace();}}return actionSql;}public static String readContent(File file, String charset) {StringBuffer sb = new StringBuffer();InputStreamReader inputStreamReader = null;BufferedReader bufferedReader = null;try {inputStreamReader = new InputStreamReader(new FileInputStream(file), charset);bufferedReader = new BufferedReader(inputStreamReader);String content = "";while ((content = bufferedReader.readLine()) != null) {System.out.println(content);}System.out.println(sb.toString());} catch (UnsupportedEncodingException e) {e.printStackTrace();} catch (FileNotFoundException e) {e.printStackTrace();} catch (IOException e) {e.printStackTrace();} finally {try {inputStreamReader.close();bufferedReader.close();} catch (IOException e) {e.printStackTrace();}}return sb.toString();}public static void convertToTxt(String fileName) {Runtime runtime = Runtime.getRuntime();String cmd = "cmd.exe /c " + mysql_binlog_exe + " " + fileName + " > "+ file_txt_name;try {runtime.exec(cmd);} catch (IOException e) {e.printStackTrace();}}public static String readLastLine(String filename, String charset) {String lastFileName = "";RandomAccessFile rf = null;try {rf = new RandomAccessFile(filename, "r");long len = rf.length();long start = rf.getFilePointer();long nextend = start + len - 1;String line;rf.seek(nextend);int c = -1;while (nextend > start) {c = rf.read();if (c == '\n' || c == '\r') {line = rf.readLine();if (line != null) {lastFileName = new String(line.getBytes("ISO-8859-1"),charset);return lastFileName;}nextend--;}nextend--;rf.seek(nextend);// if (nextend == 0) {// 当文件指针退至文件开始处，输出第一行// lastFileName += new// String(rf.readLine().getBytes("ISO-8859-1"), charset);// }}} catch (FileNotFoundException e) {e.printStackTrace();} catch (IOException e) {e.printStackTrace();} finally {try {if (rf != null)rf.close();} catch (IOException e) {e.printStackTrace();}}return lastFileName;}public String getTime() {Calendar now = Calendar.getInstance(); // get the current time!String time, mon, dd, hh, mm, sec, mes;// format the time!int month = now.get(Calendar.MONTH) + 1; // 月份必须加1，比如是12月，get返回的是11int day = now.get(Calendar.DAY_OF_MONTH);int hour = now.get(Calendar.HOUR_OF_DAY);int minute = now.get(Calendar.MINUTE);int second = now.get(Calendar.SECOND);int mesl = now.get(Calendar.MILLISECOND);/* * 位数不足前面补0 */if (month < 10)mon = "0" + month;elsemon = "" + month;if (day < 10)dd = "0" + day;elsedd = "" + day;if (hour < 10)hh = "0" + hour;elsehh = "" + hour;if (minute < 10)mm = "0" + minute;elsemm = "" + minute;if (second < 10)sec = "0" + second;elsesec = "" + second;if (mesl < 10)mes = "00" + mesl;else if (mesl < 100)mes = "0" + mesl;elsemes = "" + mesl;time = now.get(Calendar.YEAR) + mon + dd + hh + mm + sec + mes;return time;}}