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.

Converting RoundCube database from MySQL to SQLite question

Discussion in 'E-mail Discussions' started by copernic2006, Feb 28, 2017.

Tags:
  1. copernic2006

    copernic2006 Member

    Joined:
    Dec 7, 2010
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    51
    Hello,
    Can you please tell me the benefits of converting the RoundCube database from Mysql to Sqlite?
    Does this conversion bring a benefit to the loadserver?. My stats shows me hugely Imap and webmail session which tends to increase the server load.
     
  2. mtindor

    mtindor Well-Known Member

    Joined:
    Sep 14, 2004
    Messages:
    1,301
    Likes Received:
    42
    Trophy Points:
    178
    Location:
    inside a catfish
    cPanel Access Level:
    Root Administrator
    For one, the single Roundcube DB (that holds all data for all domains) is replaced with individual SQLite DBs per email account. So [in my mind] the important thing to take away from this is that a single DB corruption will not lead to widspread issues for all email users since each user will now have their own DB.

    I don't know whether you can expect any decreased server load. Even if all of your accounts were IMAP, I would doubt that access to the single Roundcube MySQL DB would be causing an increased load.

    Mike
     
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    37,163
    Likes Received:
    1,294
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page