mysql默认实列_一个mysql跑两个实列

在有些时间，我们的应用环境需要在一台机器上跑两个mysql的实例，来满足开发需求和测试需求，下面是我在一个mysql下面跑的两个实例，配置文件如下： [client]port = 3306socket = /tmp/mysql.sock[mysqld_multi]mysqld = /data/mysql/bin/mysqld_safemysqlad

在有些时间，我们的应用环境需要在一台机器上跑两个mysql的实例，来满足开发需求和测试需求，下面是我在一个mysql下面跑的两个实例，配置文件如下：[client]

port = 3306

socket = /tmp/mysql.sock

[mysqld_multi]

mysqld = /data/mysql/bin/mysqld_safe

mysqladmin = /data/mysql/bin/mysqladmin

user = root

password = **************

#DB1

[mysqld1]

port = 3306

socket = /tmp/mysql.sock

default-storage-engine = InnoDB

pid-file = /data/mysql/mysql.pid

key-buffer-size = 32M

myisam-recover-options = FORCE,BACKUP

max-allowed-packet = 16M

max-connect-errors = 1000000

skip-name-resolve

sql-mode = STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_AUTO_VALUE_ON_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ONLY_FULL_GROUP_BY

innodb = FORCE

innodb-strict-mode = 1

datadir = /data/mysql/var/

log-bin = /data/mysqllog/binlog/mysql-bin

expire-logs-days = 15

sync-binlog = 1

tmp-table-size = 32M

max-heap-table-size = 32M

query-cache-type = 0

query-cache-size = 0

max-connections = 500

thread-cache-size = 50

open-files-limit = 65535

table-definition-cache = 4096

table-open-cache = 4096

innodb-flush-method = O_DIRECT

innodb-log-files-in-group = 2

innodb-log-file-size = 512M

innodb-flush-log-at-trx-commit = 1

innodb-file-per-table = 1

innodb-buffer-pool-size = 2G

binlog_format = row

log-error = /data/mysql/mysql-error.log

log-queries-not-using-indexes = 0

slow-query-log = 1

slow-query-log-file = /data/mysql/mysql-slow.log

long_query_time = 1

#DB2

[mysqld2]

port = 3307

socket = /tmp/mysql.sock2

default-storage-engine = InnoDB

pid-file = /data/mysql/mysql.pid2

key-buffer-size = 32M

myisam-recover-options = FORCE,BACKUP

max-allowed-packet = 16M

max-connect-errors = 1000000

skip-name-resolve

sql-mode = STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_AUTO_VALUE_ON_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ONLY_FULL_GROUP_BY

innodb = FORCE

innodb-strict-mode = 1

datadir = /data/mysql/var2/

log-bin = /data/mysqllog/binlog2/mysql-bin

expire-logs-days = 15

sync-binlog = 1

tmp-table-size = 32M

max-heap-table-size = 32M

query-cache-type = 0

query-cache-size = 0

max-connections = 500

thread-cache-size = 50

open-files-limit = 65535

table-definition-cache = 4096

table-open-cache = 4096

innodb-flush-method = O_DIRECT

innodb-log-files-in-group = 2

innodb-log-file-size = 512M

innodb-flush-log-at-trx-commit = 1

innodb-file-per-table = 1

innodb-buffer-pool-size = 2G

binlog_format = row

log-error = /data/mysql/mysql2-error.log

log-queries-not-using-indexes = 0

slow-query-log = 1

slow-query-log-file = /data/mysql/mysql2-slow.log

long_query_time = 1

查看实例运行情况：# netstat -lnpt | grep mysqld

tcp 0 0 0.0.0.0:3307 0.0.0.0:* LISTEN 12356/mysqld

tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 13204/mysqld

# mysql -uroot -p -h192.168.1.33 -P3306

Enter password:

Welcome to the MySQL monitor. Commands end with ; or g.

Your MySQL connection id is 8

Server version: 5.5.34-log MySQL Community Server (GPL)

Copyright (c) 2009-2013 Percona LLC and/or its affiliates

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.

mysql> show databases;

+--------------------+

| Database |

+--------------------+

| information_schema |

| cat_db |

| mhac_db |

| mysql |

| passport_db |

| pay_db |

| performance_schema |

+--------------------+

7 rows in set (0.00 sec)

mysql> q

Bye

]# mysql -uroot -p -h192.168.1.33 -P3307

Enter password:

Welcome to the MySQL monitor. Commands end with ; or g.

Your MySQL connection id is 18

Server version: 5.5.34-log MySQL Community Server (GPL)

Copyright (c) 2009-2013 Percona LLC and/or its affiliates

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.

mysql> show databases;

+--------------------+

| Database |

+--------------------+

| information_schema |

| mysql |

| performance_schema |

+--------------------+

3 rows in set (0.00 sec)

mysql> q

Bye

一个mysql跑两个实列，首发于运维者。

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉

本文系统来源：php中文网