09-07-2007
Mysql logging in Solaris
Folks;
i have mysql installed on Solaris box (sparc).
The problem is under /opt/mysql/data directory, there's a log file that grows very fast & becomes a huge size.
Is there a way to stop the logging under the data directory so i don't have the issue of running out of space?
Your help will be a greatly appreciated.
10 More Discussions You Might Find Interesting
1. Solaris
I want to log tcp-wrapper events Solaris 10. I researched and saw that I could make a syslog entry in the hosts.deny, which I did below. After restarting syslog and having ssh blocking, I see nothing logging. I also do not get the email that should be generated. The file was taken from a... (2 Replies)
Discussion started by: csgonan
2 Replies
2. Solaris
Hi all,
I have installed Solaris along with Xp ....The installation was successful... I get the Grub menu displaying Solaris along with Win Xp....After i select Solaris the following happens,
"Failed to initialize inband hotplug controller"
The above message repeats three times & i get the... (2 Replies)
Discussion started by: codewarrior
2 Replies
3. Solaris
Hi All,
Is there a built in function/tool in Solaris that enables creation of a history file on any connection (via telnet, ssh, rsh or nfs) to Solaris machine?
I would like to create a script that records IP Address, date and timestamp, and command excuted for any connection to a Solaris... (2 Replies)
Discussion started by: racbern
2 Replies
4. Solaris
HI all,
i Have a requirement for my customer fro tracking the ftp user sessions details.
After some google search i got to know i need to confgure xferlog for the same.Want to know how to start the xferlog in solaris 10.
Please help me :( (2 Replies)
Discussion started by: rgrandhi
2 Replies
5. Solaris
i've been able to log incoming telnet and ssh connections on solaris 9 using the following lines in /etc/syslog.conf
# Telnet connections are logged to auth.notice
auth.notice /var/adm/authlog
# An entry in /etc/profile logs all telnet connections... (2 Replies)
Discussion started by: soliberus
2 Replies
6. UNIX for Advanced & Expert Users
Hello,
We need to log the operations that specific user on Solaris 10 (SPARC) is performing on one directory and it's contents. I was able to configure solaris auditing service (auditd) and it works fine. The only problem is that auditd logs huge amount of unneeded information. We need to log... (0 Replies)
Discussion started by: +Yan
0 Replies
7. Solaris
hi all,
i want to log every thing happen in my server
is any body can provide me with articals, pdf's
is that correct to log every thing in the system
what is the most important thing i should i log it (4 Replies)
Discussion started by: corvinusbsd
4 Replies
8. Solaris
Holla!
Sorry to spam the board with all my Solaris 2.6 questions (I just found this forum). My most recent problem is that not ALL failed log-ins are getting logged in /var/log/authlog. It seems to work fine for the "su" command from a non-root user, but the actual "login" command or a desktop... (4 Replies)
Discussion started by: rrossorr
4 Replies
9. Solaris
Hello,
It would appear that my server is no longer logging anything. Last time anything was written to /var/adm/messages and /var/log/syslog was Aug 26 2010. I was told there was a storm and the power went out or something around that time, but there were never any problems. I've tried... (11 Replies)
Discussion started by: gadonj18
11 Replies
10. Solaris
Excuse my ignorance as I am very new to working with Solaris.
I'm looking for documentation on how to create a network log in Solaris 10 & 11. I don't wish to edit any of the logs currently the system. I simply want a log that will capture all incoming IP addresses and log them with a time-in... (8 Replies)
Discussion started by: FamousAv8er
8 Replies
LEARN ABOUT SUSE
ocf_heartbeat_mysql-proxy
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()