一个mysql跑两个实列
程序员文章站
2022-05-07 20:34:57
...
在有些时间,我们的应用环境需要在一台机器上跑两个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跑两个实列,首发于运维者。
上一篇: 小议Python中自定义函数的可变参数的使用及注意点
下一篇: Mysql 优化详细介绍_MySQL
推荐阅读
-
MySQL一个索引最多有多少个列?真实的测试例子
-
MySQL一个索引最多有多少个列?真实的测试例子
-
Mysql将一个表中的某一列数据复制到另一个表中某一列里的方法
-
【实战】如何通过html+css+mysql+php来快速的制作动态网页(以制作一个博客网站为列)
-
如果在互为主从的架构下,开始log-slave-updates不就会导致一个事务在两个mysql之间不断循环?
-
一个连接两个不同MYSQL数据库的PHP程序
-
mysql从一个表中查询插入另一个表,两个表关联再更新其中一个表的操作教程
-
mysql-关于Hibernate 关联同一个表的两个字段的配置
-
mysql-请问数据库表中可以在一个表里面有两个关联同一个表的外键吗?
-
MYSQL如何建立两个表共用一个ID字段