1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

MySQL cluster

Discussion in 'Plesk for Linux - 8.x and Older' started by wsani, Nov 11, 2008.

  1. wsani

    wsani Silver Pleskian

    28
    40%
    Joined:
    Mar 4, 2005
    Messages:
    509
    Likes Received:
    0
    Is it possible to setup a MySQL cluster and still use Plesk with it? I want to create some redundancy but I need to know if I'm going to run into limitations with Plesk understanding it...
     
  2. wsani

    wsani Silver Pleskian

    28
    40%
    Joined:
    Mar 4, 2005
    Messages:
    509
    Likes Received:
    0
    no one here has done this?
     
  3. dtjmullins

    dtjmullins Guest

    0
     
    Please click one of the Quick Reply icons in the posts above to activate Quick Reply.
     
  4. dtjmullins

    dtjmullins Guest

    0
     
    Plesk allows you to point to external mysql servers. You could setup multiple backend servers with a front end and point it to the front end database. Or if the cluster does not care which machine you talk to, you could always use a IP that you could float between them ?

    my 2c
     
  5. Amin Taheri

    Amin Taheri Golden Pleskian Plesk Certified Professional

    33
     
    Joined:
    Jul 5, 2007
    Messages:
    1,398
    Likes Received:
    1
    Location:
    Seattle Area
    You can do it if you like yes. External databases for customers is probably the best way to go, but you can also set up another database server (or your own DB on the customer cluster) and have it setup a slave process that will do replication from your active box to the slave cluster.
     
  6. ap__@

    ap__@ New Pleskian

    22
    23%
    Joined:
    Sep 16, 2008
    Messages:
    7
    Likes Received:
    0
    how to configure plesk to use the database 'psa' on the external mysql-server?
     
  7. Amin Taheri

    Amin Taheri Golden Pleskian Plesk Certified Professional

    33
     
    Joined:
    Jul 5, 2007
    Messages:
    1,398
    Likes Received:
    1
    Location:
    Seattle Area
    You cant, plesk has to use local database unless you use something like a mysql relay agent to relay localhost connections - that setup is definately not recomended and definately not supported by parallels ubt you can do it if you feel brave.
     
  8. wsani

    wsani Silver Pleskian

    28
    40%
    Joined:
    Mar 4, 2005
    Messages:
    509
    Likes Received:
    0
    Right, you're taking about sockets but that's not what I'm trying to do. I couldn't care less about the local PSA database, which resides on the same server.

    Plesk does allow remote databases, so I'm sure it can be done. I'm trying to set this up for my customers. I'm using Plesk Expand, so I think extending the idea of "centralized" databases into a cluster would be the step in the right direction. That said, it seems that what I would be doing has been done with hsphere...
     
  9. Amin Taheri

    Amin Taheri Golden Pleskian Plesk Certified Professional

    33
     
    Joined:
    Jul 5, 2007
    Messages:
    1,398
    Likes Received:
    1
    Location:
    Seattle Area
    If you are talking about for your customers then yes that can easily be done with little to no configuration. If you mean the Plesk psa database then thats a completely seperate and different discussion.
     
Loading...