The latest from the MySQL community

SQL databases tend to be rigid.

If you have worked with them, you would agree that database design though it seems easier, is a lot trickier in practice. SQL databases believe in structure, that is why it's called structured query language.

On the other side of the horizon, we have the NoSQL databases, also called schema-less databases that encourage flexibility. In schema-less databases, there is no imposed structural restriction, only data to be saved.

Though every tool has it's use case, sometimes things call for a hybrid approach.

What if you could structure some parts of your database and leave others to be flexible?

MySQL version 5.7.8 introduces a JSON data type that allows you to accomplish that.

In this tutorial, you are going to learn.

1. How to design your database tables using …

We’ll show you, how to set up MySQL Cluster on Ubuntu. The MySQL NDB Cluster integrates the standard MySQL server with an in-memory clustered storage engine called NDB (Network DataBase). We will use a total of 4 virtual servers, one for the management, one SQL node and two data nodes: 172.16.1.1 – management VPS 172.16.1.2 […]

We’ll show you how to repair a MySQL database ane, how to optimize MySQL database and tables. We will talk about mysqlcheck which is a maintenance command line tool that allows you to check, analyze, repair, and optimize MySQL/MariaDB tables and databases. Repairing MySQL database is not complicated process, just follow the steps bellow carefully. […]

We’ll show you how to install MySQL on Ubuntu 16.04. MySQL is the world’s most popular open-source relational database management system (RDBMS). It is widely used for building web applications and is an important part of the LAMP open-source web application software stack. Installing MySQL on Ubuntu 16.04 is really not so complicated to install, […]

We’ll show you, how to create a MySQL Database and User in cPanel. There are different ways to create a MySQL database and user. In one of our previous blog articles about MySQL database administration, we described how to create a new MySQL database and user through the command line which is pretty easy. If you have a Linux VPS with cPanel you can create a new MySQL database through the control panel with just few clicks of your mouse.cPanel is one of the most popular and widely used control panels. In this tutorial we will guide you through the […]

In this tutorial we are going to show you how to install Prosper202. Made by Tracking202, Prosper202 is a self-hosted application that lets you track and optimize all your marketing campaigns. It’s open source and easy to install on a Linux VPS. Follow the steps below to install Prosper202 on Ubuntu 14.04. The following are the minimum system requirements for Prosper202: – PHP version 5.4 or greater. – MySQL version 5.6 or greater. – MySQLi extension enabled in PHP Go ahead and connect to your server via SSH. The first thing you need to do is to upgrade all your […]

In today’s simple article we will cover the steps needed for installing and configuring a basic LEMP stack on a openSUSE VPS. A LEMP stack is a synonym of LEMP server or LEMP web server. It refers to a set-up which includes Linux, Nginx, MySQL (MariaDB) and PHP. REQUIREMENTS We will be using our SSD 1 Linux VPS hosting plan for this tutorial. Log in to your server via SSH: # ssh root@server_ip Before starting, enter the command below to check whether you have the proper OS version installed on your machine: # cat /etc/issue which should give you the […]

In this tutorial we will explain how to install LiteCart on an Ubuntu 14.04 VPS with Nginx, PHP-FPM and MySQL. LiteCart is a free e-commerce, feature rich e-commerce solution. The framework is constructed to be lightweight and easy for developers to modify and build upon. LiteCart relies on the latest HyperText standard HTML 5, the latest CSS 3 for styling, the jQuery framework for client-side dynamics, and the popular web scripting language PHP for server-side dynamics. REQUIREMENTS We will be using our SSD 1 Linux VPS Hosting plan for this tutorial. UPDATE THE SYSTEM Make sure your server is fully […]

In this article we will show you how to install GLPI with Apache, PHP and MySQL on a Debian 7 VPS. GLPI is an IT software management package developed in PHP. It offers many functionalities one of which is to build up a database with an inventory for your company (computer, monitors, software, printers…). GLPI has enhanced functions to make the daily life for the administrators easier, like a job-tracking-system with mail-notification and methods to build a database with basic information about your network-topology. Below are the functions of this application: Inventory of computers, peripherals, network printers and associated components […]

In this blog article we will show you how to install AutoMySQLBackup on a Linux VPS. AutoMySQLBackup is very useful utility for creating daily, weekly or monthly backups of one or more MySQL databases from one of more MySQL servers. It dumps the databases and compress them in to archives.it comes with many features such as:   Email notification of backups   Backup Compression and Encryption   Configurable backup rotation   Incremental database backups As usual, log in to your server as user root ssh root@IP and execute the following command to make sure that all services ar up to […]