Success with OpenSolaris + ZFS + MySQL in production!


 
Thread Tools Search this Thread
Operating Systems Solaris Solaris BigAdmin RSS Success with OpenSolaris + ZFS + MySQL in production!
# 1  
Old 10-21-2008
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...
Login or Register to Ask a Question

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... (2 Replies)
Discussion started by: summer_cherry
2 Replies
Login or Register to Ask a Question
ZFSLOADER(8)						    BSD System Manager's Manual 					      ZFSLOADER(8)

NAME
zfsloader -- kernel bootstrapping final stage DESCRIPTION
zfsloader is an extended variant of loader(8) with added support for booting from ZFS. This document describes only differences from loader(8). ZFS FEATURES
zfsloader supports the following format for specifying ZFS filesystems which can be used wherever loader(8) refers to a device specification: zfs:pool/filesystem: where pool/filesystem is a ZFS filesystem name as described in zfs(8). If /etc/fstab does not have an entry for the root filesystem and vfs.root.mountfrom is not set, but currdev refers to a ZFS filesystem, then zfsloader will instruct kernel to use that filesystem as the root filesystem. ZFS COMMAND EXTENSIONS
lsdev [-v] Lists ZFS pools in addition to disks and partitions. Adding -v shows more ZFS pool details in a format that resembles zpool status output. lszfs filesystem A ZFS extended command that can be used to explore the ZFS filesystem hierarchy in a pool. Lists the immediate children of the filesystem. The filesystem hierarchy is rooted at a filesystem with the same name as the pool. FILES
/boot/zfsloader zfsloader itself. EXAMPLES
Set the default device used for loading a kernel from a ZFS filesystem: set currdev=zfs:tank/ROOT/knowngood: SEE ALSO
gptzfsboot(8), loader(8), zfs(8), zfsboot(8), zfsloader(8), zpool(8) HISTORY
The zfsloader first appeared in FreeBSD 7.3. AUTHORS
This manual page was written by Andriy Gapon <avg@FreeBSD.org>. BSD
September 15, 2014 BSD