美高梅网址注册-澳门mgm4858集团登录网址
做最好的网站
来自 澳门mgm4858集团登录网址 2020-02-13 11:27 的文章
当前位置: 美高梅网址注册 > 澳门mgm4858集团登录网址 > 正文

多实例则可以随意new,一个端口

如下所示:

1.单实例和多实例

MySQL单实例、多实例安装

【单实例安装】

 

说明:即只提供一个服务,一个端口

sed -i 2s/localhost.localdomain/mysql/ /etc/sysconfig/network

hostname mysql

yum -y install ncurses-devel gcc gcc-c++

useradd mysql -s /sbin/nologin -M 

tar xf cmake-2.8.8.tar.gz 

cd cmake-2.8.8

./configure

gmake

gmake install

cd ..

tar xf mysql-5.5.32.tar.gz

cd mysql-5.5.32

cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql

-DMYSQL_DATADIR=/usr/local/mysql/data

-DMYSQL_UNIX_ADDR=/usr/local/mysql/tmp/mysql.sock

-DDEFAULT_CHARSET=utf8

-DDEFAULT_COLLATION=utf8_general_ci

-DEXTRA_CHARSETS=gbk,gb2312,utf8,ascii

-DENABLED_LOCAL_INFILE=ON

-DWITH_INNOBASE_STORAGE_ENGINE=1

-DWITH_FEDERATED_STORAGE_ENGINE=1

-DWITH_BLACKHOLE_STORAGE_ENGINE=1

-DWITHOUT_EXAMPLE_STORAGE_ENGINE=1

-DWITHOUT_PARTITION_STORAGE_ENGINE=1

-DWITH_ZLIB=bundled

-DENABLED_LOCAL_INFILE=1

-DWITH_READLINE=1

-DWITH_EMBEDDED_SERVER=1

-DWITH-DEBUG=0

make && make install         

cp support-files/my-small.cnf /etc/my.cnf

ln -s /usr/local/mysql/bin/* /usr/local/sbin  

chmod -R 1777 /tmp                        

chown -R mysql:mysql /usr/local/mysql    

cd /usr/local/mysql/scripts/

./mysql_install_db --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/ --user=mysql

cp /opt/mysql-5.5.32/support-files/mysql.server /etc/init.d/mysqld

chmod +x /etc/init.d/mysqld 

service mysqld start

chkconfig mysqld on

mysql -e "delete from mysql.user where user='';"

mysql -e "delete from mysql.user where host='localhost.localdomain';"

mysql -e "delete from mysql.user where host='::1';"

mysql -e "drop database test;"

mysqladmin -u root password "wsyht123"

 

【多实例安装】

 

说明:多实例,指多个端口,多个MySQL提供服务

sed -i 2s/localhost.localdomain/mysql/ /etc/sysconfig/network

hostname mysql

yum -y install ncurses-devel gcc gcc-c++ libaio-devel

useradd mysql -s /sbin/nologin -M 

tar xf cmake-2.8.8.tar.gz 

cd cmake-2.8.8

./configure

gmake

gmake install

cd ..

tar xf mysql-5.5.32.tar.gz

cd mysql-5.5.32

cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql

-DMYSQL_DATADIR=/usr/local/mysql/data

-DMYSQL_UNIX_ADDR=/usr/local/mysql/tmp/mysql.sock

-DDEFAULT_CHARSET=utf8

-DDEFAULT_COLLATION=utf8_general_ci

-DEXTRA_CHARSETS=gbk,gb2312,utf8,ascii

-DENABLED_LOCAL_INFILE=ON

-DWITH_INNOBASE_STORAGE_ENGINE=1

-DWITH_FEDERATED_STORAGE_ENGINE=1

-DWITH_BLACKHOLE_STORAGE_ENGINE=1

-DWITHOUT_EXAMPLE_STORAGE_ENGINE=1

-DWITHOUT_PARTITION_STORAGE_ENGINE=1

-DWITH_ZLIB=bundled

-DENABLED_LOCAL_INFILE=1

-DWITH_READLINE=1

-DWITH_EMBEDDED_SERVER=1

-DWITH-DEBUG=0

make && make install  

ln -s /usr/local/mysql/bin/* /usr/local/sbin

chmod 700 /opt/mysql

mkdir -p /data/{3306,3307,3308}

cp /opt/my.cnf /data/3306/

cp /opt/my.cnf /data/3307/

cp /opt/my.cnf /data/3308/

cp /opt/mysql /data/3306

cp /opt/mysql /data/3307

cp /opt/mysql /data/3308

chmod -R 1777 /tmp    

chown -R mysql:mysql /data

chown -R mysql:mysql /usr/local/mysql 

cd /usr/local/mysql/scripts

./mysql_install_db --basedir=/usr/local/mysql/ --datadir=/data/3306/data/ --user=mysql

./mysql_install_db --basedir=/usr/local/mysql/ --datadir=/data/3307/data/ --user=mysql

./mysql_install_db --basedir=/usr/local/mysql/ --datadir=/data/3308/data/ --user=mysql

/data/3306/mysql start

【单实例安装】 说明:即只提供一个服务,一个端口 sed -i 2s/localhost.localdomain/mysql/ /etc/sysconfig/network hostname mysql...

//下载,添加响应头信息header('Content-type:application/octet-stream');header('Content-Disposition:attachment;filename="'.basename;header('Content-Length:'.filesize;readfile;

单实例一般会在类中自己实例化,通过getInstance获取该实例。ps:

以上就是小编为大家带来的php下载文件,添加响应头的简单实例的全部内容了,希望对大家有所帮助,多多支持脚本之家~

/**

 * 单例模式

 */

public class Singleton { 

    private static Singleton singleton = new Singleton();

    private Singleton() {}

    public static Singleton getInstance() {

       return singleton;

    }

多实例则可以随意new。ps:

public class Multiton {

 

    private static Multiton multi1 = new Multiton();

    private static Multiton multi2 = new Multiton();

   

    private Multiton() {}

本文由美高梅网址注册发布于澳门mgm4858集团登录网址,转载请注明出处:多实例则可以随意new,一个端口

关键词: