Tag: MariaDB

ASP.NET Core SQL Server and MySQL database logging with Serilog
ASP.NET / C# / Coding / SQL / Web

ASP.NET Core SQL Server and MySQL database logging with Serilog How to use the ASP.NET Core's built-in ILogger logging API to write application logs to SQL Server, MySQL and/or MariaDB using Serilog logging provider

- by Ryan - Leave a Comment

In this article we'll see how to take advantage of Serilog, a neat open-source diagnostic logging library for .NET applications, to log our ASP.NET Core web application’s data to a …

ASP.NET Core SQL Server and MySQL database logging with Serilog How to use the ASP.NET Core's built-in ILogger logging API to write application logs to SQL Server, MySQL and/or MariaDB using Serilog logging provider Read More
MySQL Master-Master Replication setup in 5 easy steps
Linux / Operating Systems / Servers & Services

Linux - MySQL and MariaDB sock file folder issues - how to fix How to force MySQL and MariaDB services to create the /var/run/mysqld/mysqld.sock and /var/run/mariadb/mariadb.sock files and folders

- by Ryan - Leave a Comment

Yesterday I wrote a small tutorial explaining how to fix a common MySQL or MariaDB problem related to the pid file not being created upon the service startup. That same …

Linux - MySQL and MariaDB sock file folder issues - how to fix How to force MySQL and MariaDB services to create the /var/run/mysqld/mysqld.sock and /var/run/mariadb/mariadb.sock files and folders Read More
Come installare MariaDB 10.x su CentOS 7.x e metterlo in sicurezza per l'utilizzo in produzione
Linux / Operating Systems / Servers & Services

Linux - MySQL and MariaDB pid-file folder issues - how to fix How to force MySQL and MariaDB services to create the /var/run/mysqld/mysqld.pid and /var/run/mariadb/mariadb.pid files and folders

- by Ryan - 6 Comments.

If you've stumbled upon this post it most likely means that you've just discovered that your MySQL or MariaDB service, despite running without issues, are not creating their mysqld.pid or …

Linux - MySQL and MariaDB pid-file folder issues - how to fix How to force MySQL and MariaDB services to create the /var/run/mysqld/mysqld.pid and /var/run/mariadb/mariadb.pid files and folders Read More
Come installare MariaDB 10.x su CentOS 7.x e metterlo in sicurezza per l'utilizzo in produzione
Coding / Linux / Servers & Services / SQL

How to safely upgrade from MariaDB 10.x to 10.3 without losing data A quick tutorial explaining how to perform a seamless upgrade from a previous version of MariaDB 10 to MariaDB 10.3 keeping all the existing databases intact

- by Ryan - 6 Comments.

It has been a while since MariaDB 10.3 has been out, bringing its stunning pack of changes, improvements and new features - most notably, System-versioned tables and Sequences. If you found this …

How to safely upgrade from MariaDB 10.x to 10.3 without losing data A quick tutorial explaining how to perform a seamless upgrade from a previous version of MariaDB 10 to MariaDB 10.3 keeping all the existing databases intact Read More
Backup MySQL or MariaDB Server with a single Command-Line using mysqldump
Coding / Servers & Services / SQL

Backup MySQL or MariaDB Server with a single Command-Line using mysqldump How to perform a full backup of a MySQL or MariaDB Server instance on a Windows or Linux machine with single command-line

- by Ryan - 1 Comment

If you like playing with MySQL or MariaDB servers, you most likely know that both of these great open-source DBMS come with mysqldump, a neat command-line utility that can be used to …

Backup MySQL or MariaDB Server with a single Command-Line using mysqldump How to perform a full backup of a MySQL or MariaDB Server instance on a Windows or Linux machine with single command-line Read More
Wordpress - Error establishing a database connection repeatedly and intermittently (MySQL / MariaDB) - Fix
Coding / PHP / Servers & Services / Web

WordPress - Error establishing a database connection repeatedly and intermittently (MySQL / MariaDB) - Fix What to do if you're randomly and repeatedly getting the "Error establishing a database connection" with your WordPress installation using MySQL or MariaDB

- by Ryan - Leave a Comment

The "Error establishing a database connection" WordPress error is a rather common one. You can either get it upon each request, meaning that you WordPress site is entirely down, or intermittently (randomly …

WordPress - Error establishing a database connection repeatedly and intermittently (MySQL / MariaDB) - Fix What to do if you're randomly and repeatedly getting the "Error establishing a database connection" with your WordPress installation using MySQL or MariaDB Read More
The Importance of learning SQL Programming Language
Coding / SQL

The Importance of learning SQL Programming Language Why SQL Programming Language Is Essential While Building and Developing a Database with DBMS such as MS SQL Server, PostgreSQL, MySQL, MariaDB & more

- by Ariya Stark - Leave a Comment

Programming is simply setting instructions that will help a computer perform a certain task. A programmed computer can be used to generate accurate algorithms. Over the years, computers have evolved …

The Importance of learning SQL Programming Language Why SQL Programming Language Is Essential While Building and Developing a Database with DBMS such as MS SQL Server, PostgreSQL, MySQL, MariaDB & more Read More