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
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.
Click below to sign up and get $200 of credit to try our products over 60 days!
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:
Hope that this helps!