Showing entries 1 to 10 of 69
10 Older Entries »
Displaying posts with tag: Tutorials (reset)
Master MySQL Point in Time Recovery

Data loss or corruption can be daunting. With MySQL point-in-time recovery, you can restore your database to the moment before the problem occurs.

This article delivers a practical roadmap for using backups and binary logs to achieve accurate MySQL recovery, detailed steps for setting up your server, and tips for managing recovery and backups effectively without overwhelming you with complexity.

Key Takeaways

  • MySQL Point in Time Recovery (PITR) enables restoration to a specific point after a full backup. It relies heavily on binary log files to record the incremental changes needed for recovery.
  • Preparation for PITR is crucial and involves enabling binary logging and creating a full database backup. Monitoring and managing binary log activities, such as file retention, are essential for effective recovery.
  • Executing PITR requires …
[Read more]
Sync user data between Clerk and a PlanetScale MySQL database

Learn how to sync user data from a Clerk project into your PlanetScale MySQL database with webhooks using Netlify and Netlify Functions.

Build a contacts app with Node, Express, and MySQL

Learn how to build a contacts web app with Node, Express, and PlanetScale.

Build a library app with Laravel 10 and MySQL

Learn how to build a Laravel application backed by a MySQL PlanetScale database.

Build an expense tracker app with Symfony and MySQL

Learn how to build a use MySQL with Symfony by building an expense tracking application using a PlanetScale MySQL database.

Build a Rust API with Rocket, Diesel, and MySQL

Learn how to build a Rust API using Rocket, Diesel, and a MySQL database hosted on PlanetScale.

How to read MySQL EXPLAINs

Learn how to read the output in MySQL EXPLAIN plans so you can utilize them to improve query performance.

How to upgrade from MySQL 5.7 to 8.0

Learn what you should look out for when upgrading an existing database from MySQL 5.7 to 8 and how to change your database to be compatible with the new version.

Build a products listing application with Golang and MySQL

Learn how to build a products listing application with Golang and a MySQL database.

Read the full story

Build a products listing application with Golang and MySQL

Learn how to build a products listing application with Golang and a MySQL database.

Showing entries 1 to 10 of 69
10 Older Entries »