Home | History | Annotate | Download | only in mys
      1 #
      2 # CDDL HEADER START
      3 #
      4 # The contents of this file are subject to the terms of the
      5 # Common Development and Distribution License (the License).
      6 # You may not use this file except in compliance with the License.
      7 #
      8 # You can obtain a copy of the license at usr/src/CDDL.txt
      9 # or http://www.opensolaris.org/os/licensing.
     10 # See the License for the specific language governing permissions
     11 # and limitations under the License.
     12 #
     13 # When distributing Covered Code, include this CDDL HEADER in each
     14 # file and include the License file at usr/src/CDDL.txt.
     15 # If applicable, add the following below this CDDL HEADER, with the
     16 # fields enclosed by brackets [] replaced with your own identifying
     17 # information: Portions Copyright [yyyy] [name of copyright owner]
     18 #
     19 # CDDL HEADER END
     20 #
     21 
     22 #
     23 # Copyright 2007 Sun Microsystems, Inc.  All rights reserved.
     24 # Use is subject to license terms.
     25 #
     26 
     27 #ident	"@(#)my.cnf_sample_slave	1.7	07/06/06 SMI"
     28 
     29 # Note: Please be aware that this sample my.conf file is 
     30 # 	provided to get you started. You should read
     31 #	the MySQL documentation for a complete description 
     32 #	of the options listed here.
     33 #	
     34 #	Furthermore, /global/mysql-data-1 is used here to match up
     35 #	with the Sun Cluster HA for MySQL documentation. You
     36 #	will need to change this if your path is different.
     37 
     38 [mysqld]
     39 #Server Id
     40 server-id=2
     41 
     42 #Port Number 
     43 port=3306
     44 
     45 # Bind Address
     46 bind-address=<Logical Host>
     47 
     48 # Socket
     49 socket=/tmp/<Logical Host>.sock
     50 
     51 # General Logfile
     52 log=/global/mysql-data/logs/log1
     53 
     54 # Binary Logfile
     55 log-bin=/global/mysql-data/logs/bin-log
     56 
     57 # Ignore logg updates for sc3_test_database
     58 binlog-ignore-db=sc3_test_database
     59 
     60 # Log Slow Queries
     61 log-slow-queries=/global/mysql-data/logs/log-slow-queries
     62 
     63 #
     64 # Innodb Table Type Section
     65 #
     66 
     67 # Should InnoDB Table be used.
     68 #skip-innodb
     69 
     70 # Home Directory for InnoDB
     71 innodb_data_home_dir = /global/mysql-data/innodb
     72 
     73 # File-name and size for InnoDB
     74 innodb_data_file_path = ibdata1:10M:autoextend
     75 
     76 # Log directory for InnoDB
     77 innodb_log_group_home_dir = /global/mysql-data/innodb
     78 
     79 # Archive directory for InnoDB
     80 innodb_log_arch_dir = /global/mysql-data/innodb
     81 
     82 set-variable = innodb_buffer_pool_size=50M
     83 # You can set .._buffer_pool_size up to 50 - 80 %
     84 # of RAM but beware of setting memory usage too high
     85 
     86 set-variable = innodb_additional_mem_pool_size=20M
     87 # Set .._log_file_size to 25 % of buffer pool size
     88 
     89 # Log file size
     90 set-variable = innodb_log_file_size=12M
     91 
     92 # Log buffer size
     93 set-variable = innodb_log_buffer_size=4M
     94 
     95 # Should InnoDB flush logs to disk on commit.
     96 innodb_flush_log_at_trx_commit=1
     97 
     98 #
     99 # BDB Table Types section
    100 #
    101 
    102 # Should BDB Table be used.
    103 #skip-bdb
    104 
    105 #Base directory for `BDB' tables
    106 bdb-home=/global/mysql-data
    107 
    108 #Don't start Berkeley DB in recover mode.
    109 bdb-no-recover
    110 
    111 # Berkeley lock detect.
    112 bdb-lock-detect=DEFAULT
    113 
    114 # BDB Log Directory
    115 bdb-logdir=/global/mysql-data/BDB
    116 
    117 # BDB Temp Directory
    118 bdb-tmpdir=/global/mysql-data/BDB
    119 
    120 #
    121 # Slave Configuration Section
    122 #
    123 
    124 # Master hostname or IP address for replication.
    125 master-host=<hostname>
    126 
    127 # The username the slave thread will use for
    128 # authentication when connecting to the
    129 # master.
    130 master-user=repl
    131 
    132 
    133 # The password the slave thread will use for
    134 # authentication when connecting to the
    135 # master.
    136 master-password=repl
    137 
    138 # The location of the file that remembers
    139 # where we left off on the master during the
    140 # replication process.
    141 master-info-file=/global/mysql-data/logs/master.info
    142 
    143 # Specific for MySQL 4.x
    144 
    145 # Where to put the slave's relay bin log.
    146 #relay-log=/global/mysql-data/logs/slave-bin.log
    147 
    148 # Where to put the slave's info file
    149 #relay-log-info-file=/global/mysql-data/logs/slave-info
    150 
    151