<< previous page   --   table of contents   --   next page >>
| | | | | | | |
  • Return to Table of Contents
    • Table of Contents
    1. General Information
    2. MySQL Installation
    3. Tutorial Introduction
    4. Database Administration
    5. MySQL Optimisation
    6. MySQL Language Reference
    7. MySQL Table Types
    8. MySQL APIs
    9. Extending MySQL
    Chapter 4:  Database Administration 189 --port=3306 --socket=/tmp/mysql.sock --no-auto-rehash The above output contains all options for the groups 'client' and 'mysql'. 4.1.3  Installing Many Servers on the Same Machine In some cases you may want to have many di erent mysqld daemons (servers) running on the same machine.  You may for example want to run a new version of MySQL for testing together with an old version that is in production.  Another case is when you want to give di erent users access to di erent mysqld servers that they manage themselves. One way to get a new server running is by starting it with a di erent socket and port as follows: shell> MYSQL_UNIX_PORT=/tmp/mysqld-new.sock shell> MYSQL_TCP_PORT=3307 shell> export MYSQL_UNIX_PORT MYSQL_TCP_PORT shell> scripts/mysql_install_db shell> bin/safe_mysqld & The environment variables appendix includes a list of other environment variables you can use to a ect mysqld.  See Appendix F [Environment variables], page 770. The above is the quick and dirty way that one commonly uses for testing.  The nice thing with this is that all connections you do in the above shell will automatically be directed to the new running server! If you need to do this more permanently, you should create an option le for each server. See  Section 4.1.2 [Option les], page 186.  In your startup script that is executed at boot time you should specify for both servers: safe_mysqld --default-file=path-to-option-file At least the following options should be di erent per server: port=# socket=path pid- le=path The following options should be di erent, if they are used: log=path log-bin=path log-update=path log-isam=path bdb-logdir=path If you want more performance, you can also specify the following di erently: tmpdir=path bdb-tmpdir=path
     

    Customer Support CentreMySQL Reference Manual

    Web Hosting Services
    UNIX WEB HOSTING
    SUPPORT & FAQ's
    TERMS OF USE
    Domain Services
    DOMAIN REGISTRATION
    MANAGE YOUR ACCOUNT
    SUPPORT & FAQ's
    TERMS OF USE
    SITE MAP
    Home
    Hosting Plans | Domain Registration | About Us | Contact Us | Site Map
    Terms of Use | Privacy Policy | Guarantees
    Merchant Accounts

    SpiritHost - web hosting for spiritual and education sites
    SpiritHit.com - Religious and Spiritual Portal

    Copyright © 2002 Dyntex Group, Inc. All Rights Reserved

  • Return to Table of Contents
    		•
  • Back to top
    • Web Hosting: Manuals & FAQ's
    1. Unix-Based Web Hosting
    2. Unix Dedicated Servers
    3. Windows Dedicated Servers
    4. CuteFTP User’s Guide
    5. CuteHTML User’s Guide
    6. WS_FTP Pro User's Guide
    7. Miva Order User's Guide
    8. Miva Merchant User's Guide