Results 1 to 8 of 8
  1. #1
    Join Date
    Jan 2003
    Posts
    3

    Question Unanswered: Dedicated server : how to know if it is really ?

    Hi,
    I would like to know if there is a way to know if a mysql database is on a dedicated server (i mean if it is the only database setup on one machine).

    Actually a company told us that they hold our mysql database on a dedicated server to OUR database but last day I tried to connect to it with SQLLyog an I saw many other databases (even if they weren't accessible to me).

    So I wonder, before asking explanation to this company, if it is possible for example to have differents database visible on a single IP while each database is really on its dedicated machine ?

    Thank you people and sorry if my question may looks like stupid.
    Arthur.h

  2. #2
    Join Date
    Jan 2003
    Location
    Paris, France
    Posts
    320

    Re: Dedicated server : how to know if it is really ?

    Originally posted by coucouman
    Hi,
    I would like to know if there is a way to know if a mysql database is on a dedicated server (i mean if it is the only database setup on one machine).

    Actually a company told us that they hold our mysql database on a dedicated server to OUR database but last day I tried to connect to it with SQLLyog an I saw many other databases (even if they weren't accessible to me).

    So I wonder, before asking explanation to this company, if it is possible for example to have differents database visible on a single IP while each database is really on its dedicated machine ?

    Thank you people and sorry if my question may looks like stupid.
    Arthur.h

    You could use

    Code:
    show database
    To see if there are other database
    But remember that by default there are 2 database in mysql
    mysql and test
    Olivier Miossec
    --
    http://www.lasso-developpeur.net/
    --

  3. #3
    Join Date
    Jan 2003
    Posts
    3

    I know there are several other database already

    I've seen (throught SHOW DATABASE or even a simple connection to the server) that there were many databases (other than the 2 "system databases" that are mysql and test). There is more than 25 other databases..

    I want to be sure that these 25 other database I see ARE NOT on my said "dedicated" server...

  4. #4
    Join Date
    Jan 2003
    Location
    Paris, France
    Posts
    320

    Re: I know there are several other database already

    Originally posted by coucouman
    I've seen (throught SHOW DATABASE or even a simple connection to the server) that there were many databases (other than the 2 "system databases" that are mysql and test). There is more than 25 other databases..

    I want to be sure that these 25 other database I see ARE NOT on my said "dedicated" server...
    You could use show processlist to see if other user are using the mysql server.
    Olivier Miossec
    --
    http://www.lasso-developpeur.net/
    --

  5. #5
    Join Date
    Jan 2003
    Posts
    3

    Re: This needs rights we don't have on the server

    Originally posted by omiossec
    You could use show processlist to see if other user are using the mysql server.
    Is there any other way (as we have only simple user access privileges) ?

    Thank you in advance.

  6. #6
    Join Date
    Sep 2002
    Location
    Kyiv, Ukraine
    Posts
    77
    I suppose MySQL server can not keep it's databases on different computers, so the ones that you have seen are all on one machine ...

    Or am I wrong and MySQL can do this?
    Yours faithfully,
    Yaroslav Zaremba

  7. #7
    Join Date
    Aug 2001
    Location
    London, UK
    Posts
    31

    Re: This needs rights we don't have on the server

    Originally posted by coucouman
    Is there any other way (as we have only simple user access privileges) ?

    Thank you in advance.
    With what you have said, it certainly does not add up... if you are paying for a dedicated box then I would hope that this is a box that you and only you have... in most cases the hosting company would give you root access for this and not 'simple user' access.

    It is more likely that this is a confusion between you and your host, they may have a dedicated MySql box, but does this mean it is YOUR dedicated box? Nope... it means that this one box only does MySql and numerous customers for the host have their databases on the one box. This is good as it allows the CPU and Disk to focus on dealing with the database rather than be running PHP or handling the web server and requests.

    You should check what you are paying for... Unless you have configured this box and have root access... I will place a hefty bet that you are merely on a shared hosting facility whereby the MySql is on a dedicated server (still shared) from the web server and PHP.
    My homepage:
    http://www.buro9.com/
    My work:
    http://www.btopenworld.com/
    http://www.officialfootballsites.co.uk/
    http://www.jeepster.co.uk/

  8. #8
    Join Date
    Aug 2001
    Location
    London, UK
    Posts
    31
    The important point I didn't summarise is:

    Is the box dedicated to performing the task? MySql

    or

    Is the box dedicated to a customer? You

    A dedicated box can be either, check what you paid for
    My homepage:
    http://www.buro9.com/
    My work:
    http://www.btopenworld.com/
    http://www.officialfootballsites.co.uk/
    http://www.jeepster.co.uk/

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •