On DBs
Category: MySQL
How to Transfer All MySQL Databases From Old to New Server
Transferring or Migrating a MySQL/MariaDB database between servers usually takes only few easy steps, but data transfer can take some time depending on the volume of data you would like to transfer. In this...
Sharding writes with MySQL and increment offsets
TL;DR we shard writes and avoid conflicts using an increment offset on PKs each data center contains local write servers we use multi-source replication on read servers so they contain all the data from all …
How to Install Latest MySQL 8.0 on RHEL/CentOS and Fedora
MySQL is an open source free relational database management system (RDBMS) released under GNU (General Public License). It is used to run multiple databases on any single server by providing multi-user access to each...
How to Monitor MySQL/MariaDB Databases using Netdata on CentOS 7
Netdata is a free open source, simple and scalable, real-time system performance and health monitoring application for Unix-like systems such as Linux, FreeBSD and MacOS. It gathers various metrics and visualizes them, allowing you...
How to Install MySQL 8.0 in Ubuntu 18.04
MySQL community server is a free open source, popular and cross-platform database management system. It supports both SQL and NoSQL, and has a pluggable storage engine architecture. Additionally, it also comes with multiple database...
Mytop – A Useful Tool for Monitoring MySQL/MariaDB Performance in Linux
Mytop is an open source and free monitoring program for MySQL and MariaDB databases was written by Jeremy Zawodny using Perl language. It is much similar in look and feel of the most famous...
How to Change Default MySQL/MariaDB Port in Linux
In this guide we’ll learn how to change the default port that MySQL/MariaDB database binds in CentOS 7 and Debian-based Linux distributions. The default port that MySQL database server is running under Linux and...
How to Check MySQL Database Size in Linux
In this article, I will show you how to check the size of MySQL/MariaDB databases and tables via the MySQL shell. You will learn how to determine the real size of a database file...
Being a Good Open Source Community Member: Why we hesitated on MySQL 5.7
The open source community is great, largely because it is powered by the passion of its members. Much of that passion is rooted in Doing What’s Right™*, but often there are lengthy discussions about what specifically that means. I want to talk a bit about one particular part of the open source community, and how it has made cPanel as a company react. Why we hesitated on MySQL 5.7 In January of 2015 we released cPanel …
How to Reset WordPress Admin Password via MySQL Command Prompt
Sometimes, a WordPress user, with one of the following capabilities, such as administrator, editor, author, contributor or subscriber, forgets its login credentials, especially the password. WordPress password can be easily changed via “Lost password”...
12 MySQL/MariaDB Security Best Practices for Linux
MySQL is the world’s most popular open source database system and MariaDB (a fork of MySQL) is the world’s fastest growing open source database system. After installing MySQL server, it is insecure in it’s...
12 MySQL/MariaDB Security Best Practices for Linux
MySQL is the world’s most popular open source database system and MariaDB (a fork of MySQL) is the world’s fastest growing open source database system. After installing MySQL server, it is insecure in it’s default …
How to Test PHP MySQL Database Connection Using Script
MySQL is a popular database management system while PHP is a server-side scripting language suitable for web development; together with Apache or Nginx HTTP servers, are the different components of the LAMP (Linux Apache...
MyCLI – A MySQL/MariaDB Client with Auto-completion and Syntax-highlighting
MyCLI is an easy-to-use command line (CLI) interface for the popular database management systems: MySQL, MariaDB, and Percona with auto-completion and syntax highlighting. It is built using prompt_toolkit and requires Python 2.7, 3.3, 3.4,...
How to Change a Default MySQL/MariaDB Data Directory in Linux
After installing the components of a LAMP stack on a CentOS/RHEL 7 server, there are a couple of things you may want to do. Some of them have to do with increasing the security...
How to Change Root Password of MySQL or MariaDB in Linux
If you’re installing MySQL or MariaDB in Linux for the first time, chances are you will be executing mysql_secure_installation script to secure your MySQL installation with basic settings. One of these settings is, database...
How to Reset MySQL or MariaDB Root Password in Linux
If you are setting up a MySQL or MariaDB database server for the first time, chances are you will be running mysql_secure_installation soon afterwards to implement basic security settings. One of these settings is...
Learn How to Use Several Functions of MySQL and MariaDB – Part 2
This is the second part of a 2-article series about the essentials of MariaDB / MySQL commands. Please refer to our previous article on this topic before proceeding. Learn MySQL/MariaDB Basics for Beginners –...
Learn MySQL / MariaDB for Beginners – Part 1
In this article we will show how to create a database (also known as a schema), tables (with data types), and explain how to perform Data Manipulation Language (DML) operations with data on a...
How to Backup/Restore MySQL/MariaDB and PostgreSQL Using ‘Automysqlbackup’ and ‘Autopostgresqlbackup’ Tools
If you are a database administrator (DBA) or are responsible for maintaining, backing up, and restoring databases, you know you can’t afford to lose data. The reason is simple: losing data not only means...