Sponsored Content
Operating Systems Linux Red Hat Master logs for all the operations performed on mysql DB Post 302735239 by vivek d r on Saturday 24th of November 2012 12:08:57 AM
Old 11-24-2012
Master logs for all the operations performed on mysql DB

is there any such thing as master logs for all the operations performed on mysql database. thing is i need to find the operations performed on mysql on a linux server running on RHEL 5.7 for the past 2 days. One more thing i found out that the bin logs will be refreshed whenever server goes to reboot. so is there any way i could find the operation done on DB for past 2 days even when server has been rebooted a couple of times. my servers(2 servers) are running as Master - Slave configuration.
Any help will be deeply appreciated.
regards
Vivek
 

8 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Grep yesterday logs from weblogic logs

Hi, I am trying to write a script which would go search and get the info from the logs based on yesterday timestamp and write yesterday logs in new file. The log file format is as follows: """"""""""""""""""""""""""... (3 Replies)
Discussion started by: harish.parker
3 Replies

2. Web Development

MySQL Master-Slave Configuration: Don't Replicate a Row of a Table?

Anyone have a clue about this? I have checked the MySQL documentation and it does not seem possible to exclude a row of a table from replication between Master and Slave. It seems that replication in MySQL can only be managed at the table level, not at the row level. Does anyone know a work... (5 Replies)
Discussion started by: Neo
5 Replies

3. AIX

smit see comand performed ??

i in smit , press F6 , smit fs , Change / Show Characteristics of an Enhanced Journaled File System then F6 to see the comand , how can i see the command performed ?? x() { │ │ LIST= ... (5 Replies)
Discussion started by: prpkrk
5 Replies

4. UNIX for Dummies Questions & Answers

logs of commands performed by users

Hi, when 2 users are logged as root , how can i find witch one had perform witch command? Thanks, (1 Reply)
Discussion started by: prpkrk
1 Replies

5. Shell Programming and Scripting

How to grep the content performed by an User

I want to grep the content performed by an User from a file. Suppose that i have a following file HYD-HMS-2$ ls -lrt -rw-r--r-- 1 sdfrun sdf 31726356 Aug 1 13:04 journal.03.01082012.19.csv I could able to grep the content performed by a user by "sed" command as follows HYD-HMS-2$... (0 Replies)
Discussion started by: duppalav
0 Replies

6. UNIX for Dummies Questions & Answers

System administration tasks performed from a menu driven interface

I need to write a shell script that allows some system-administration tasks to be preformed automatically from a menu-driven interface. Automate the following tasks: • Copy directory tree • Delete files or directories • Output Information But I don't understand the question. What is a "menu... (2 Replies)
Discussion started by: femchi
2 Replies

7. UNIX Desktop Questions & Answers

How can I replicate master master and master master MySQL databse replication and HA?

I have an application desigend in PHP and MySQl running on apache web server that I is running on a Amazon EC2 server Centos. I want to implement the master-master and master slave replication and high availability disaster recovery on this application database. For this I have created two... (0 Replies)
Discussion started by: Palak Sharma
0 Replies

8. Shell Programming and Scripting

If I ran perl script again,old logs should move with today date and new logs should generate.

Appreciate help for the below issue. Im using below code.....I dont want to attach the logs when I ran the perl twice...I just want to take backup with today date and generate new logs...What I need to do for the below scirpt.............. 1)if logs exist it should move the logs with extention... (1 Reply)
Discussion started by: Sanjeev G
1 Replies
OCF_HEARTBEAT_MYSQL()													     OCF_HEARTBEAT_MYSQL()

NAME
ocf_heartbeat_mysql-proxy - Manages a MySQL Proxy daemon SYNOPSIS
mysql-proxy [start | stop | reload | monitor | validate-all | meta-data] DESCRIPTION
This script manages MySQL Proxy as an OCF resource in a high-availability setup. Tested with MySQL Proxy 0.7.0 on Debian 5.0. SUPPORTED PARAMETERS
binary Full path to the MySQL Proxy binary. For example, "/usr/sbin/mysql-proxy". (optional, string, default /usr/sbin/mysql-proxy) defaults_file Full path to a MySQL Proxy configuration file. For example, "/etc/mysql-proxy.conf". (optional, string, no default) proxy_backend_addresses Address:port of the remote backend-servers (default: 127.0.0.1:3306). (optional, string, default 127.0.0.1:3306) proxy_read_only_backend_addresses Address:port of the remote (read only) slave-server (default: ). (optional, string, default 127.0.0.1:3306) proxy_address Listening address:port of the proxy-server (default: :4040). You can also specify a socket like "/tmp/mysql-proxy.sock". (optional, string, default :4040) log_level Log all messages of level (error|warning|info|message|debug|) or higher. An empty value disables logging. (optional, string, no default) keepalive Try to restart the proxy if it crashed (default: ). Valid values: true or false. An empty value equals "false". (optional, string, no default) admin_address Listening address:port of the admin-server (default: 127.0.0.1:4041). (optional, string, default 127.0.0.1:4041) admin_username Username to allow to log in (default: ). (optional, string, no default) admin_password Password to allow to log in (default: ). (optional, string, no default) admin_lua_script Script to execute by the admin plugin. (optional, string, no default) parameters The MySQL Proxy daemon may be called with additional parameters. Specify any of them here. (optional, string, no default) pidfile PID file (optional, string, default /var/run/resource-agents/mysql-proxy-default.pid) SUPPORTED ACTIONS
This resource agent supports the following actions (operations): start Starts the resource. Suggested minimum timeout: 30s. stop Stops the resource. Suggested minimum timeout: 30s. reload Suggested minimum timeout: 30s. monitor Performs a detailed status check. Suggested minimum timeout: 20s. Suggested interval: 60s. validate-all Performs a validation of the resource configuration. Suggested minimum timeout: 30s. meta-data Retrieves resource agent metadata (internal use only). Suggested minimum timeout: 5s. EXAMPLE
The following is an example configuration for a mysql-proxy resource using the crm(8) shell: primitive example_mysql-proxy ocf:heartbeat:mysql-proxy op monitor depth="0" timeout="20s" interval="60s" SEE ALSO
http://www.linux-ha.org/wiki/mysql-proxy_(resource_agent) AUTHOR
Linux-HA contributors (see the resource agent source for information about individual authors) OCF_HEARTBEAT_MYSQL()
All times are GMT -4. The time now is 03:31 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy