linux可以同时有两个mysql吗_linux 下安装两个mysql

展开全部

同一个mysql启动32313133353236313431303231363533e78988e69d8331333238663036两个进程。

编辑 my.cnf(linux) my.ini(window)

vi /etc/my.cnf

[client]

#password = your_password

port = 3306

socket = /tmp/mysql.sock

# Here follows entries for some specific programs

[mysqld_multi]

mysqld = /usr/local/mysql/bin/mysqld_safe

mysqladmin = /usr/local/mysql/bin/mysqladmin

user= root

password = gthsskd0345

# The MySQL server

[mysqld1]

port = 3306

socket = /tmp/mysql.sock

datadir = /usr/local/mysql/data/

skip-locking

key_buffer = 600M

max_allowed_packet = 16M

table_cache = 1024

sort_buffer_size = 1M

read_buffer_size = 512k

read_rnd_buffer_size = 512k

join_buffer_size = 8M

myisam_sort_buffer_size = 64M

thread_cache_size = 8

query_cache_size = 128M

max_connections = 300

back_log=400

delayed_insert_limit = 100

delayed_insert_timeout = 300

delayed_queue_size= 1000

#basedir = /usr/local/mysql

#datadir = /opt/crawler_files/data/

# Try number of CPU's*2 for thread_concurrency

thread_concurrency = 4

# Replication Master Server (default)

# binary logging is required for replication

tmp_table_size = 128M

max_heap_table_size =128M

server-id = 61

master-host=192.168.15.10

master-user=jipingmi_logger

master-password=jipingmi007

master-port=3306

master-connect-retry=60

replicate-do-db = jipingmi_logs

#replicate-do-table=meijob.jobs_languages

#replicate-do-table=meijob.employers_languages

log-bin =/opt/crawler_files/data/

#binlog-do-db=meijob

replicate-ignore-table=jipingmi_logs.aggregate_runtimes

replicate-ignore-table=jipingmi_logs.aggregate_searches_stats

replicate-ignore-table=jipingmi_logs.aggregate_track_emails

replicate-ignore-table=jipingmi_logs.seekers_searches_cache

replicate-ignore-table=jipingmi_logs.statastic_p_v_l

replicate-ignore-table=jipingmi_logs.statastic_p_v_l_cache

# Point the following paths to different dedicated disks

#tmpdir = /tmp/

#log-update = /path-to-dedicated-directory/hostname

# Uncomment the following if you are using BDB tables

#bdb_cache_size = 384M

#bdb_max_lock = 100000

# Uncomment the following if you are using InnoDB tables

innodb_data_home_dir = /usr/local/mysql/data/

innodb_data_file_path = ibdata1:2000M;ibdata2:100M:autoextend

innodb_log_group_home_dir = /usr/local/mysql/data/

innodb_autoextend_increment = 16M

#innodb_log_arch_dir = /usr/local/mysql/data/

# You can set .._buffer_pool_size up to 50 - 80 %

# of RAM but beware of setting memory usage too high

innodb_buffer_pool_size = 1024M

innodb_additional_mem_pool_size = 20M

# Set .._log_file_size to 25 % of buffer pool size

innodb_log_file_size = 256M

innodb_log_buffer_size = 16M

innodb_log_files_in_group = 4

innodb_flush_log_at_trx_commit = 1

innodb_lock_wait_timeout = 1800

transaction_prealloc_size = 64K

transaction_alloc_block_size = 1M

[mysqld2]

port = 3307

socket = /tmp/mysql.sock2

datadir = /opt/crawler_files/data1/

pid-file = /opt/crawler_files/data1/db-app2.pid

log = /opt/crawler_files/data1/app2.log

user = mysql

max_connections = 300

server-id = 161

master-host=192.168.15.31

master-user=jipingmi

master-password=jipingmi007

master-port=3306

master-connect-retry=60

replicate-do-db = jipingmi

log-bin =/opt/crawler_files/data1/

datadir = /opt/crawler_files/data1/

[mysqldump]

quick

max_allowed_packet = 16M

[mysql]

no-auto-rehash

# Remove the next comment character if you are not familiar with SQL

#safe-updates

[isamchk]

key_buffer = 256M

sort_buffer_size = 256M

read_buffer = 2M

write_buffer = 2M

[myisamchk]

key_buffer = 256M

sort_buffer_size = 256M

read_buffer = 2M

write_buffer = 2M

[mysqlhotcopy]

interactive-timeout

然后启动

/usr/local/mysql/bin/mysqld_multi start 1-2

已赞过

已踩过<

你对这个回答的评价是？

评论

收起