The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Using PostgreSQL instead of MySQL

Discussion in 'E-mail Discussions' started by Samuraid, Sep 20, 2010.

  1. Samuraid

    Samuraid Member

    Joined:
    Apr 20, 2006
    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    1
    Is CPanel/WHM married to MySQL, or is is feasible to remove MySQL and use PostgreSQL instead (for cphulkd, mail, etc.)?

    If so, has anyone had any success doing this?

    If not, when will Cpanel be adding support for this (and why hasn't it been added yet)?

    Thanks. :)
     
  2. cPanelDon

    cPanelDon cPanel Quality Assurance Analyst
    Staff Member

    Joined:
    Nov 5, 2008
    Messages:
    2,557
    Likes Received:
    7
    Trophy Points:
    38
    Location:
    Houston, Texas, U.S.A.
    cPanel Access Level:
    DataCenter Provider
    Twitter:
    MySQL database support is needed if using applications that are designed to work with MySQL or that may require MySQL in a stock-default installation; this may include Horde, Roundcube (if not converted to SQLite), cPHulk, and Eximstats.

    I am not aware of any other requests for removing MySQL to use only PostgreSQL, and I am not aware of any plans for doing so at this time.

    Is there a specific reason you would like to use remove MySQL and use only PostgreSQL?
     
  3. Samuraid

    Samuraid Member

    Joined:
    Apr 20, 2006
    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    1
    Thanks for the response. :)

    The main reasons are:
    - PostgreSQL is becoming the main part of our infrastructure, and it would be helpful to move the databases into it without having to run MySQL separately.

    - With Oracle's acquisition of Sun, MySQL's roadmap is a little less clear. Sure it will still be around, but avoiding "lock-in" to a specific database vendor would be nice.

    - MyISAM hasn't proven to be very durable nor very fast under heavier load in production. Granted, the MySQL databases that CPanel uses don't get as much traffic on our production machines, but it would still be nice to not have to have to worry so much about table corruption.

    I realize and completely understand that there hasn't historically been much demand for anything other than MySQL. That said, Postgres is becoming more prevalent these days, and it would be fantastic to have the option of using it in CPanel. :)
     
    #3 Samuraid, Sep 20, 2010
    Last edited: Sep 20, 2010
Loading...

Share This Page