It's easy. Look - you can get an IDE -to- CF adapter for about a fiver. Get a 4 or 8 GB CF card and install it on IDE 01.
That's your main drive.
Set up your other drives in what ever config is necessary. Solo, Software RAID, whatever.
Do your install. Either use the partition editor, or boot into Knoppix and run gparted to format your other drives. After install - edit that FSTAB to make sure everything is in order. For example, on one of the other drives you could set a mount point as '/data'.
Configure MySQL. *database can be anywhere, NFS share or other FS. It doesn't matter as long as you configure my.cnf to tell MySQL where to look. Here is one of my production machine's my.cnf using databases from a /data partition (which is on a RAID FS). Although MySQL is installed at /usr/local - the databases are all on /data. Read you man pages and have a noodle through the MySQL website for declaring options for my.cnf
=========================================
[client] port=3306 socket=/tmp/mysql.sock
[mysqld] log-bin=example-bin server-id=4 port=3306 socket=/tmp/mysql.sock query_cache_size = 200M set-variable = key_buffer_size=512M set-variable = max_allowed_packet=2M set-variable = max_binlog_size=20M set-variable = record_buffer=200K set-variable = net_buffer=100K set-variable = max_connections=1000 set-variable = thread_cache_size=20 set-variable = thread_stack=128K innodb_data_file_path = data/mysql/innodb/datafile01:10000M innodb_data_home_dir = / set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = /data/mysql/innodb/ set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=10M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 innodb_log_arch_dir = /data/mysql/innodb/ innodb_log_archive=0 set-variable = innodb_buffer_pool_size=128M set-variable = innodb_additional_mem_pool_size=20M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 default-table-type = innodb log-slow-queries = /data/mysql/slow-queries.log ft_min_word_len=3 set-variable = wait_timeout=604800
[mysqldump] quick
=========================================
-Peter
2008/6/9 Ryan Nichols rnichols430@gmail.com:
Michel van Deventer wrote:
Hi,
On Sun, 2008-06-08 at 16:38 -0500, Ryan Nichols wrote:
Ok.. Im curious.. Can I install CentOS on a compact flash card, then have the MySQL on another drive? to have the compact flash like read only for the OS to boot from, then do the swap, mysql,etc from the other drive? How hard would this be to do?
Yes, you can (of course). My backupserver boots from CF (only kernel +initrd) and then continues from harddrive.
I do not have a howto here but if you search google, you'll probably find a lot of them.
Regards,
Michel
CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
I have searched google, and all i get is more and more confused... Maybe I need to not go this route. I was trying to get the CF as the system drive and keep the database on a seperate drive incase either failed.. seemed like it made sense at the time..
Ryan Nichols
CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos