Question
I have a Osticket app with over 50G database what's droplet architecture to choose
- Posted on June 1, 2022
- LAMP StackMySQL
Asked by b6a2e043af7e4c01b7c6c3990d
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!
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.
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