MySQL
How To Migrate a MySQL Database Between Two Servers
Tutorials
MySQL
Transferring a database between virtual private servers can be accomplished using a SCP (Secure Copy), a method of copying files derived from the SSH Shell. Keep in mind, you will need to know the passwords for both virtual servers.
How To Create a Table in MySQL and MariaDB on an Ubuntu Cloud Server
Tutorials
MariaDB
MySQL
Ubuntu
Status: Deprecated> Status: Deprecated # This article covers a version of Ubuntu that is no longer supported. If you are currently operate a server running Ubuntu 12.04, we highly recommend upgrading or migrating to a supported version of Ubuntu:
How To Install Linux, Apache, MySQL, PHP (LAMP) Stack on Debian 8
Tutorials
Apache
Debian
LAMP Stack
MySQL
PHP
Introduction> Introduction # The “LAMP” stack of software, consisting of the Linux operating system, Apache web server, MySQL database, and PHP scripting language, is a great foundation for web or application development.
How To Install and Configure Zabbix to Securely Monitor Remote Servers on CentOS 7
Tutorials
Apache
CentOS
High Availability
MariaDB
Monitoring
MySQL
Networking
Open Source
PHP
System Tools
The author selected the Open Source Initiative to receive a donation as part of the Write for DOnations program.
Introduction> Introduction # Zabbix is open-source monitoring software for networks and applications.
How To Move a MySQL Data Directory to a New Location on Ubuntu 16.04
Tutorials
Block Storage
MySQL
Storage
Ubuntu
Ubuntu 16.04
Introduction> Introduction # Databases grow over time, sometimes outgrowing the space on the file system. You can also run into I/O contention when they’re located on the same partition as the rest of the operating system.
How To Set Up Laravel, Nginx, and MySQL with Docker Compose
Tutorials
Docker
Laravel
MySQL
Nginx
PHP
PHP Frameworks
Ubuntu 18.04
The author selected The FreeBSD Foundation to receive a donation as part of the Write for DOnations program.
Introduction> Introduction # Over the past few years, Docker has become a frequently used solution for deploying applications thanks to how it simplifies running and deploying applications in ephemeral containers.
How To Backup MySQL Databases on an Ubuntu VPS
Tutorials
Backups
MySQL
Ubuntu
Status: Deprecated> Status: Deprecated # This article covers a version of Ubuntu that is no longer supported. If you are currently operate a server running Ubuntu 12.04, we highly recommend upgrading or migrating to a supported version of Ubuntu:
How To Launch Your Site on a New Ubuntu 14.04 Server with LAMP, SFTP, and DNS
Tutorials
Apache
MySQL
PHP
Ubuntu
Introduction> Introduction # Getting your Linux server running can be a troubling experience for beginners, but it doesn’t have to be difficult. We have a number of articles written in our community that go over the basics of getting set up on a server.
How To Install and Secure phpMyAdmin with Nginx on an Ubuntu 14.04 Server
Tutorials
LEMP
MySQL
Nginx
Ubuntu
Introduction> Introduction # Relational database management systems like MySQL are needed for a significant portion of web sites and applications. However, not all users feel comfortable administering their data from the command line.
How To Create a New User and Grant Permissions in MySQL
Tutorials
MySQL
Introduction> Introduction # MySQL is an open-source relational database management system. It is commonly deployed as part of the LAMP stack (which stands for Linux, Apache, MySQL, and PHP) and, as of this writing, is the most popular open-source database in the world.
How To Install and Use Memcache on Ubuntu 12.04
Tutorials
Caching
MySQL
PHP
Server Optimization
Ubuntu
Status: Deprecated> Status: Deprecated # This article covers a version of Ubuntu that is no longer supported. If you are currently operate a server running Ubuntu 12.04, we highly recommend upgrading or migrating to a supported version of Ubuntu:
How To Install and Secure phpMyAdmin on Ubuntu 16.04
Tutorials
Apache
Applications
MySQL
PHP
Ubuntu 16.04
Introduction> Introduction # While many users need the functionality of a database management system like MySQL, they may not feel comfortable interacting with the system solely from the MySQL prompt.
How To Install Linux, Apache, MySQL, PHP (LAMP) stack on Ubuntu
Tutorials
Apache
LAMP Stack
MySQL
PHP
Ubuntu
Status: Deprecated> Status: Deprecated # This article covers a version of Ubuntu that is no longer supported. If you are currently operate a server running Ubuntu 12.04, we highly recommend upgrading or migrating to a supported version of Ubuntu:
How To Install WordPress and PhpMyAdmin with Docker Compose on Ubuntu 14.04
Tutorials
Databases
Docker
MariaDB
MySQL
PHP
Ubuntu
WordPress
Introduction> Introduction # Docker Compose makes dealing with the orchestration processes of Docker containers (such as starting up, shutting down, and setting up intra-container linking and volumes) really easy.
This article provides a real-world example of using Docker Compose to install an application, in this case WordPress with PHPMyAdmin as an extra.
How To Use HAProxy to Set Up MySQL Load Balancing
Tutorials
Debian
MySQL
Scaling
Server Optimization
Ubuntu
Prelude> Prelude # HAProxy is an open source software which can load balance HTTP and TCP servers. In the previous article on HAProxy we configured load balancing for HTTP and in this one we’ll do the same for MySQL.
How To Install Linux, Nginx, MySQL, PHP (LEMP stack) on Ubuntu 18.04
Tutorials
Databases
LEMP
MySQL
Nginx
PHP
Ubuntu 18.04
Introduction> Introduction # The LEMP software stack is a group of software that can be used to serve dynamic web pages and web applications. This is an acronym that describes a Linux operating system, with an Nginx (pronounced like “Engine-X”) web server.
How To Measure MySQL Query Performance with mysqlslap
Tutorials
CentOS
MySQL
Server Optimization
Introduction> Introduction # MySQL comes with a handy little diagnostic tool called mysqlslap that’s been around since version 5.1.4. It’s a benchmarking tool that can help DBAs and developers load test their database servers.
How To Create and Manage Databases in MySQL and MariaDB on a Cloud Server
Tutorials
MariaDB
MySQL
What are MySQL and MariaDB?> What are MySQL and MariaDB? # MySQL and MariaDB are relational database management systems. These tools can be used on your VPS server to manage the data from many different programs.
How To Use MySQL with Your Ruby on Rails Application on Ubuntu 14.04
Tutorials
MySQL
Ruby
Ruby on Rails
Ubuntu
Introduction> Introduction # Ruby on Rails uses sqlite3 as its default database, which works great in many cases, but may not be sufficient for your application. If your application requires the scalability, centralization, and control (or any other feature) that a client/server SQL database, such as PostgreSQL or MySQL, you will need to perform a few additional steps to get it up and running.
How To Install and Secure phpMyAdmin on Ubuntu 14.04
Tutorials
Apache
MySQL
Security
Ubuntu
Introduction> Introduction # While many users need the functionality of a database management system like MySQL, they may not feel comfortable interacting with the system solely from the MySQL prompt.