天长网站制作,网站一般宽度是多少像素,广告发布属于什么服务,嘉兴优化网站费用mysql单服务器启动多个实例实际有两种方式第一种方式就是使用mysql mysqld_multi第二种方式就是分别使用不同的目录端口启动不同的实例第一种方式#xff1a;1、数据库实例目录data3306data3307data33082、创建实例/usr/local/mysql//scripts/mysql_install_db –basedir/usr…mysql单服务器启动多个实例实际有两种方式第一种方式就是使用mysql mysqld_multi第二种方式就是分别使用不同的目录端口启动不同的实例第一种方式1、数据库实例目录data3306data3307data33082、创建实例/usr/local/mysql//scripts/mysql_install_db –basedir/usr/local/mysql/ –datadir/usr/local/mysql/data3306 –usermysql/usr/local/mysql//scripts/mysql_install_db –basedir/usr/local/mysql/ –datadir/usr/local/mysql/data3307 –usermysql/usr/local/mysql//scripts/mysql_install_db –basedir/usr/local/mysql/ –datadir/usr/local/mysql/data3308 –usermysql3、修改my.cnf文件修改部分[mysqld_multi]mysqld /usr/local/mysql//bin/mysqldmysqladmin /usr/local/mysql//bin/mysqladminuser rootpassword 123456[mysqld3306]port 3306socket /usr/local/mysql/mysqld3306.sockpid-file /usr/local/mysql/mysqld3306.pidbasedir /usr/local/mysql/datadir /usr/local/mysql/data3306[mysqld3307]port 3307socket /usr/local/mysql/mysqld3307.sockpid-file /usr/local/mysql/mysqld3307.pidbasedir /usr/local/mysql/datadir /usr/local/mysql/data3307[mysqld3307]port 3307socket /usr/local/mysql/mysqld3308.sockpid-file /usr/local/mysql/mysqld3308.pidbasedir /usr/local/mysql/datadir /usr/local/mysql/data33084、启动数据库mysqld_multi –defaults-file/etc/mysql/my.cnf start 3306mysqld_multi –defaults-file/etc/mysql/my.cnf start 3307mysqld_multi –defaults-file/etc/mysql/my.cnf start 33085、登录数据库修改root密码mysql -S /usr/local/mysql/mysqld3306.sockmysql -S /usr/local/mysql/mysqld3307.sockmysql -S /usr/local/mysql/mysqld3308.sockuse mysqlUPDATE user SET passwordPASSWORD(123456) WHERE user’root’;FLUSH PRIVILEGES;6、关闭数据库mysqld_multi –defaults-file/etc/mysql/my.cnf stop 3306mysqld_multi –defaults-file/etc/mysql/my.cnf stop 3307mysqld_multi –defaults-file/etc/mysql/my.cnf stop 33087、全部启动/关闭mysqld_multi –defaults-file/etc/mysql/my.cnf start 3306-3308mysqld_multi –defaults-file/etc/mysql/my.cnf stop 3306-3308第二种方式1创建目录data3307data33082,分别添加配置未见my.cnf并修改里面相关的参数3.进行系统表初始化也可以从现有的复制过来一会/usr/local/mysql//scripts/mysql_install_db –basedir/usr/local/mysql/ –datadir/usr/local/mysql/data3307 –usermysql/usr/local/mysql//scripts/mysql_install_db –basedir/usr/local/mysql/ –datadir/usr/local/mysql/data3308 –usermysql4启动脚本修改cp /etc/init.d/mysql.server /etc/ini.d/mysql3307.server cp /etc/init.d/mysql.server /etc/init.d/mysql3308.server然后修改里面的配置路径5分别启动数据库启动之前相关目录权限修改为mysql:mysql/etc/init.d/mysql.server start /etc/init.d/mysql3307.server start /etc/init.d/mysql3308.server start
