1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Multiple Databases?

Discussion in 'XenForo Questions and Support' started by Chris Nutter, Mar 27, 2013.

  1. Chris Nutter

    Chris Nutter Member

    I currently have a large xenforo site. The database size is 1.5 gb. I currently have a dedicated server but would like to save some money each month by going to to web hosting setup. The only issue I am running into is the web hosting companies all say unlimited databases BUT they limit each database size to 1gb. Is it possible to split the xenforo install across multiple databases?
  2. Mike

    Mike XenForo Developer Staff Member

    The simple answer is no. Limiting the DB size like that seems bizarre IMO.
    tyteen4a03 likes this.
  3. Chris Nutter

    Chris Nutter Member

    Almost every web hosting company I have checked from godaddy to 1and1.com (I have check at least 15 different companies) have Database size limits. But allow unlimited databases. So I could have 1000 1 gb databases but not a single database that was a 1000 gb.
  4. Brandon Sheley

    Brandon Sheley Well-Known Member

    There is no such things as unlimited anything when it comes to hosting, it's impossible ;)

    Also remove godaddy from any list of host you may be looking at ;)
    Walter and tyteen4a03 like this.
  5. Chris Nutter

    Chris Nutter Member

    LOL... yeah still has not addressed my issue. Of Database size limits.
  6. BamaStangGuy

    BamaStangGuy Well-Known Member

    Your issue is you have out grown shared hosting.
  7. Chris Nutter

    Chris Nutter Member

    I currently have a dedicated server that I pay $99.99 a month that I don't use fully. Sadly, dedicated hosting solutions are not solutions. I am most likely going to have to go to a VPS to get a cost savings but still have enough system resources to handle my site.
  8. BamaStangGuy

    BamaStangGuy Well-Known Member

    VPS is ideal for what you need. Servint is nice.
    Alexander Firth likes this.
  9. Sim

    Sim Well-Known Member

    I vote VPS too - far more flexible than shared hosting, but also more configurable than dedicated (in that you can generally choose smaller/cheaper configuration on VPS than you could on dedicated and save quite a bit of money).
  10. Reeve of Shinra

    Reeve of Shinra Well-Known Member

    I would personally like to archive older posts in a separate database in a read only type of thing.
  11. Sim

    Sim Well-Known Member

    Why a separate database? Makes it far more difficult to manage data across multiple databases.

    Why bother archiving them if you can't access them any more? Either delete them or leave them be.

    If saving disk space is your primary concern, I fear you may be doing it wrong.
  12. Reeve of Shinra

    Reeve of Shinra Well-Known Member

    It would be accessible in a read-only format on the web for anyone searching ... the smaller db would be easier for those of us who like to download a local copy of the DB.

    archived data = database 1 (1 gig)
    current data = database 2 (200 Meg)
  13. Sim

    Sim Well-Known Member

    Compress them first - you'll probably find you get close to 3:1 compression on database dumps. I have a 1GB database which compresses to a 340MB file.

    Why do you want to download a local copy anyway? For backup purposes? Try setting up an automated routine to dump your database to disk, compress it, then archive it to Amazon S3.

    It's fully automated so doesn't take you any time, independent of any local internet download speeds or quotas you might have, and since it is going to be server-to-server, it is likely much faster than downloading anyway. You can then download any copy you want from S3 when you need it.

    I have several hundred gigabytes worth of database backups on S3 costing less than $10 per month to store ... this could be cheaper still if I started using Glacier for archiving.
  14. The Forum Heroes

    The Forum Heroes Well-Known Member

    Hey Chris, long time.. Still running WSN? Shoot me a PM, yours are turned off.

Share This Page