If you’ve built a web application, large or small, chances are you are pushing a good amount of data in and out of a database. For many apps, the database either lives on the same server as your code, or on its own machine for performance reasons. If you don’t want to babysit a database server and be constantly worried about availability, rollovers, and standby nodes, then a “Managed Database as a Service” setup may be of interest to you. DigitalOcean is the latest company to jump on this trend and in 2020 began offering managed database services for MySQL and PostgreSQL. It can be great for setups of any size and it’s easy to scale up the resources the database has access to instantly. Plus, you leave the mundane tasks of running a high performance database server to the experts while you focus on your code and app. Continue Read
How to perform some basic user commands in MySQL Continue Read
Today we released support for using Wasabi S3's storage. Wasabi boast offering 1/5 the price of AWS s3 storage and is a fanatic option for those who want to store large amounts of data at a reduced rate compared to other generation 1 cloud platforms. Getting started could not be easier, follow the steps in the dashboard to add the bucket name and newly generated config. Continue Read
If you are a Database administrator and responsible for managing the MySQL server, you must have a knowledge of the replication concept as this will helps you in terms of Data Security, Fail-over Solution and Database Backup from Slave. MySQL replication is the process that enables data from one MySQL server to be copied to one or more MySQL servers. By default, replication is asynchronous by default and slaves do not need to be connected permanently to receive updates from the master. It is primarily used to read access on multiple servers for scalability and also used for failover. Continue Read
If your Droplet has an extremely active database its worth exporting the data into a static file just before taking a snapshot, this was you guarantee your data is safely backed up and restorable without corruption. For this guide, we are going to base it on using MySQL but this is possible for any database where you can export into a static file. Continue Read