Question

I have a Osticket app with over 50G database what's droplet architecture to choose

I have an osTicket installation with a big MYSQL database (50G), I tried to create a LAMP droplet with 8G RAM and 160G Disk I tried to import the MYSQL database, it took all the night and the disk got full and the import still not completed. Should i order a separate MYSQL database or use the installed MYSQL in my droplet


Submit an answer


This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

Sign In or Sign Up to Answer

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Bobby Iliev
Site Moderator
Site Moderator badge
October 22, 2022

Hi there,

Indeed it sounds like a good idea to use a separate Droplet for your database, the structure would look as follows:

That way you will decouple the database server from your web server.

Also what you could do for the import, rather than first uploading the 50GB file on the server and then importing it to MySQL, which means that you would need at least double the disk space, you could run the import remotely directly from your laptop:

https://www.digitalocean.com/community/tutorials/how-to-allow-remote-access-to-mysql

Hope that this helps!

Best,

Bobby

Try DigitalOcean for free

Click below to sign up and get $200 of credit to try our products over 60 days!

Sign up