In this tutorial, you’ll learn how to build a mood tracker application with Laravel 9, connect it to a PlanetScale MySQL database, make database schema changes, and deploy your database branch to production. You’ll use PlanetScale for the database, which gives you a fully managed MySQL-compatible database, unlimited scalability, a Git-like development workflow, zero downtime schema changes, and more. This blog post is over a year old and may be out of date.

Here are some of the highlights of what you’ll create: A production-ready MySQL database in PlanetScale 2 database branches: main for production and dev for development 2 tables, moods and entries, to store your daily entries and mood options Database migrations and a seeder to run on your development database Deploy non-blocking schema changes from development to production with PlanetScale branching and deploy requests. If you just want to get up and running with Laravel and …

Learn how to build a Harry Potter API using Node.js Express and PlanetScale

In this tutorial, we are going to show you how to install MySQL on your Ubuntu 20.04 and how to ...

Read More

The post How to Install and Use MySQL on Ubuntu 20.04 appeared first on RoseHosting.

MySQL is an open-source relational database management system (RDBMS), it’s widely used and part of the popular LAMP/LEMP stacks. The ...

Read More

The post How to Install MySQL Database on Ubuntu 20.04 appeared first on RoseHosting.

Today we are going to guide you on how to show all users in the MySQL users Database. A common ...

Read More

The post MySQL SHOW USERS: List All Users in a MySQL Database appeared first on RoseHosting.

While it's easier to measure the impact of Dynimize if you are running a MySQL benchmark with clear metrics, it can sometimes be a challenge on a production workload where you don't have precise performance analytics or metrics available. There are many great MySQL performance analysis tools out there, however they can often take time and effort to setup.

The simple measureDyniMysql script was created for this exact reason, and does not incur any MySQL downtime. You can find it at /opt/dynimize/measureDyniMysql after installing Dynimize. It will report the change in MySQL queries per second and mysqld CPU usage after applying Dynimize. Here is how to use it.

1. Install and start dynimize, and get your mysqld process into the dynimized state. For example, the …

In this tutorial, we will show you how to create a backup of MySQL databases on an Ubuntu 20.04 VPS, ...

Read More

The post How to Create a Backup of MySQL Databases Using mysqldump on Ubuntu 20.04 appeared first on RoseHosting.

In this tutorial, we will show you how to install LAMP Stack on a Debian 9 VPS. A LAMP (Linux, ...

Read More

The post How to Install LAMP (Linux, Apache, MySQL, PHP) on Debian 9 appeared first on RoseHosting.

The LEMP stack is a web development platform for hosting static and dynamic websites. It is a combination of free ...

Read More

The post How to Install LEMP on Ubuntu 18.04 appeared first on RoseHosting.

In this tutorial, we will show you how to install and improve the security of MySQL on Ubuntu 18.04. MySQL ...

Read More

The post How to Install MySQL on Ubuntu 18.04 appeared first on RoseHosting.