Tag archive for: MariaDB

How to setup a Raspberry Pi LEMP server with Raspbian Buster Lite for running PHP applications

Many useful applications are written in PHP backed by MariaDB/MySQL for data persistency.

When you wondering what you can use a Raspberry Pi for, one way is to turn it into a LEMP server for hosting PHP applications.

With this in mind, let us look at how we can setup a Raspberry Pi LEMP server with Raspbian Buster Lite for running PHP applications.

How to host a WordPress website on a Raspberry Pi with Raspbian Buster Lite and Nginx

If you are thinking of starting a blog about computer technology, then you can consider hosting a WordPress website on your Raspberry Pi.

Since Raspberry Pi is a capable machine that does not take up too much space and power, it is a good as a web server.

In addition, if you have an Internet subscription that does not block port 80 and 443, hosting a WordPress at home can be cost effective.

Given these points, let’s look at how we can host a WordPress website on a Raspberry Pi with Raspbian Buster and Nginx.

How to start a blog about computer technology

Previously, I wrote about why programmers should blog. When you are convinced that you should blog as a programmer, you may wonder how to start a blog.

In order to have a place to refer people who wants to learn more about this topic, I write my experience in this article.

Given that in mind, this is how you can start a blog about computer technology.

How to setup a Raspberry Pi web server with Raspbian Stretch Lite, Nginx, MariaDB and PHP as the LEMP stack

Raspberry Pi LEMP Linux Nginx MariaDB PHP

When you want to deploy a PHP application that you wrote, you can first deploy it on a Raspberry Pi. Once your PHP application gets enough traction, you can then port it over to a computer with more horsepower.

When your PHP application employs MySQL or MariaDB as the backing database, we can put it up on a LEMP stack. In this situation, HTTP requests will first be directed to the Nginx reverse proxy server. Whenever the request is made to a php application, Nginx will then pass it on to the PHP7 Fast CGI Process Manager (PHP FPM) for generating the HTTP response.

Given these points, this post provides the steps to setup a Raspberry Pi web server with Raspbian Stretch Lite, Nginx, MariaDB and PHP as the LEMP stack.

How I use my Raspberry Pis to help me work on with my side projects

Undeniably, Raspberry Pi has revolutionised the way we use computing technology in our lives. In addition to being energy efficient, a Raspberry Pi is a single board computer that does not take up too much space.

Given these points, a Raspberry Pi is an ideal programmer gift and one of the things that you should buy if you are a computer programmer.

On the other hand, pursuing side projects help me explore technologies that I may not be able to explore at work. For example, through Techcoil, I got to know more about:

In case you are wondering how to use Raspberry Pis to help you work on your side projects, read on to find out more.

How to host your own file sharing website on Raspberry Pi 3 with Raspbian Stretch Lite, Nginx, ProjectSend, MariaDB and PHP

While experiencing Northern Lights in Finland, you may capture some Northern Lights pictures with your DSLR. In case you want to share them with friends through your own file sharing website, have a look at ProjectSend.

Since a Raspberry Pi 3 is energy efficient and affordable, you may want to setup ProjectSend on a Raspberry Pi 3. With this in mind, this post discusses how to do so with Raspbian Stretch Lite, Nginx, MariaDB and PHP as the LEMP stack.

How to setup phpMyAdmin on a Raspbian Stretch Lite, Nginx, MariaDB / MySQL and PHP 7 LEMP stack

The phpMyAdmin project is a solid software tool written in PHP, that can help us handle the administration of MySQL / MariaDB over the web.

phpMyAdmin Demo Server 4.7.8 demo screenshot

If you want to build your next project with a Raspbian Stretch Lite, Nginx, MariaDB / MySQL and PHP 7 LEMP stack, you may want to consider setting up phpMyAdmin as well. This post details how you can do so.

How to migrate your MySQL / MariaDB database with mysqldump, tar and scp

If you had been building the content for your new WordPress site on a Raspberry Pi 3, there will come a time when you need to migrate the underlying MySQL database to another machine, for eg. a DigitalOcean droplet, for production usage.

MySQL provides us with the mongodump client utility to produce a set of SQL statements that can be executed to reproduce the original database object definitions and table data.

A simple MySQL database migration can be performed with the following steps:

  1. Use mysqldump to get the set of SQL statements that can be executed to reproduce the original database object definitions and table data.
  2. If the mysqldump output is too big, use the tar command to compress it.
  3. Use the scp command to send the mysqldump output from the source server to the destination server.
  4. If you had used the tar command to compress the mysqldump output, use the tar command at the destination server to decompress it.
  5. Execute the set of SQL commands in the mysqldump output at the destination server.

This post documents how you can migrate your MySQL / MariaDB database with utilities provided by MySQL and most Linux servers.

Setting up WordPress on Raspberry Pi Zero W with Raspbian Stretch Lite, Nginx, MariaDB and PHP as the LEMP stack

A Raspberry Pi Zero W is a small and capable computer that included a Wi-Fi chip for projects that requires an Internet connection.

Apart from running client programs on the Raspberry Pi Zero W, it is equally capable of being a web server. Since I had a spare Raspberry Pi Zero W lying around the house and there are good reasons to blog as a programmer, I decided to use it as a WordPress server to collect content for a new blog project.

This post documents how I setup WordPress on a Raspberry Pi Zero W with Raspbian Stretch Lite, nginx, MariaDB and PHP as the LEMP stack.