On DBs
Category: MySQL
How MariaDB achieves global scale with Xpand
distributed SQL. In a distributed SQL implementation, the database is distributed across multiple physical systems, delivering transactions at a globally scalable level. MariaDB Platform X5, a major release that includes upgrades to every aspect of MariaDB Platform, provides distributed SQL and massive scalability through the addition of a new smart storage engine called Xpand.…
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 configuration, and securing it is one of the essential tasks in general database management.…
Install MariaDB 10.2 on Fedora 28/27, CentOS/RHEL 7.5/6.9
MariaDB is a binary drop in replacement for MySQL database server. This means that for most cases, you can just uninstall MySQL and install MariaDB and you are good to go.…
Install phpMyAdmin 4.3.10 on Fedora 21/20, CentOS/RHEL 6.6/5.11
This is guide, howto install phpMyAdmin 4.3.10 with Nginx or Apache on Fedora 21/20/19, CentOS 7/6.6/5.11 and Red Hat (RHEL) 7/6.6/5.11 servers. phpMyAdmin needs web server with PHP and MySQL database.…
LEMP on Fedora 28/27, CentOS/Red Hat (RHEL) 7.5/6.9
LEMP (Linux, Nginx, MySQL, PHP) server is extremely powerful setup behind any website or web based service. This guide is collection of Fedora/CentOS/Red Hat (RHEL), Nginx, MariaDB/MySQL and PHP (PHP-FPM) install guides.…
Install WordPress 4.1.1 on Fedora 21/20, CentOS/RHEL 7/6.6/5.11
This is guide, howto install WordPress 4.1.1 with Nginx or Apache on Fedora 21/20/19, CentOS 7/6.6/5.11 and Red Hat (RHEL) 7/6.6/5.11 servers. WordPress needs web server with PHP and MariaDB or MySQL database.…
LAMP on Fedora 28/27, CentOS/Red Hat (RHEL) 7.5/6.9
LAMP (Linux, Apache, MariaDB/MySQL, PHP) server is very powerful server setup behind any website or web based service. This guide is collection of Fedora/CentOS/Red Hat (RHEL), Apache, MariaDB/MySQL and PHP install guides.…
Install Apache/PHP 7.2.5 on Fedora 28/27, CentOS/RHEL 7.5/6.9
This guide shows howto install Apache HTTP Server (httpd) with PHP 7.2.5 and following modules on Fedora 28/27/26, CentOS 7.5/6.9 and Red Hat (RHEL) 7.5/6.9 systems.…
Install MySQL 8.0/5.7 on Fedora 28/27, CentOS/RHEL 7.5/6.9
Are you looking MariaDB 10.2/10.1/10.3 Install guide? MySQL is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases.…
cPanel Server : Restoring MySQL SimLink.
If you’re unable to restart mysqld and troubleshooting the cause: if u log into SSH and go to /tmp you may see that there is no simlink To create a simlink you can do the following: cd /var/lib/mysql/ touch mysql.sock…
nginx, PHP 5.3 and FastCGI on CentOS 5.5, Fedora 13, Red Hat RHEL 5.5/6
This is guide howto install nginx, PHP 5.3 and FastCGI webserver with MySQL and/or PostgreSQL and Memcache support on Fedora 12 and Fedora 13, CentOS 5.5, Red Hat (RHEL) 5.5/6.…
Turbo charging MySQL by setting up the query cache
To make sure MySQL uses the query cache, there are a few variables you need to set in the configuration file . Usually its my.cnf or my.ini…
