Success with OpenSolaris + ZFS + MySQL in production!

Tags

mysql, production, rss, solaris

Operating Systems Solaris Solaris BigAdmin RSS Success with OpenSolaris + ZFS + MySQL in production!

10-21-2008

Registered User

26,240, 27

Join Date: Sep 2000

Last Activity: 1 August 2008, 3:09 PM EDT

Posts: 26,240

Thanks Given: 0

Thanked 27 Times in 26 Posts

Success with OpenSolaris + ZFS + MySQL in production!

This tip provides information about using ZFS on a MySQL database box and OpenSolaris. The author explores two questions: Can a MySQL slave on OpenSolaris with ZFS keep up with the write load with no readers, and if yes, can the slave shoulder its fair share of the reads, too?

More...

Linux Bot

View Public Profile for Linux Bot

Find all posts by Linux Bot

Previous Thread | Next Thread

1 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

production issue - shell sqlplus processing sometime success sometime fail

Hi Expert, Below is a real production environment issue: we are using shell script to FTP to a remote server and fetch around 150 files every day, for each file we need to keep a entry inside ORACLE DB table, before insert into table, each file has a associated logid, which need to be...

LEARN ABOUT OPENSOLARIS

mysql_zap

zap(1)								  MySQL database							    zap(1)

NAME

       zap - a perl script used to kill processes

USAGE

       /usr/bin/mysql_zap [-signal] [-?Ift] pattern

SYNOPSIS

       zap [-I|-?]  [-f] [-t]

DESCRIPTION

       zap    supports by executing

       -I|-?  info

       -f     force

       -t     test

NOTE

       If  -f isn't given, ask user for confirmation for each process to kill. If signal isn't given, try first with signal 15 and after that with
       signal 9. If -t is given the processes is only shown on stdout.

SEE ALSO

       isamchk(1), isamlog(1), mysql(1), mysqlaccess(1), mysqladmin(1), mysqld(1), mysqld_multi(1), mysqld_safe(1), mysqldump(1), mysql_fix_privi-
       lege_tables(1), mysqlshow(1), perror(1), replace(1)

       For  more information please refer to the MySQL reference manual, which may already be installed locally and which is also available online
       at http://www.mysql.com/doc/en/

BUGS

       Please refer to http://bugs.mysql.com/ to report bugs.

AUTHOR

       Ver 1.0, distribution 4.0.24 Michael (Monty) Widenius (monty@mysql.com), MySQL AB (http://www.mysql.com/). This software comes with no war-
       ranty.  Manual  page  by L. (Kill-9) Pedersen (kill-9@kill-9.dk), Mercurmedia Data Model Architect / system developer (http://www.mercurme-
       dia.com)

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +--------------------+------------------------------------+
       |  ATTRIBUTE TYPE    |	       ATTRIBUTE VALUE		 |
       +--------------------+------------------------------------+
       |Availability	    | SUNWmysqlr, SUNWmysqlu, SUNWmysqlt |
       +--------------------+------------------------------------+
       |Interface Stability | External				 |
       +--------------------+------------------------------------+
NOTES

       Source for mysql is available on http://opensolaris.org.

MySQL 4.0							 19 December 2000							    zap(1)

Solaris BigAdmin RSS