Database

Overview The MariaDB version in the default Ubuntu repository is not the latest one. To see the default version, you can use the following commands: apt show mariadb-server Output: Package: mariadb-server Version: 1:10.6.18-0ubuntu0.22.04.1 Priority: optional Section: universe/database Source: mariadb-10.6 Origin: Ubuntu As you can see, the default MariaDB version on Ubuntu 20.04 is the version 10, however the latest one is version 11. In order to install the latest one, you need to add MariaDB APT repository first before installing...

Overview Veeam version 12 introduces to use PostgreSQL as the Database Engine. To ensure the database engine is keep updated, and any potential vulnerabilities, you need to manually update the PostgreSQL to the latest version periodically. Check current PostgreSQL version To check the current PostgreSQL version: Using Powershell Open Powershell on Administrative task, and run: postgres.exe --version Result: postgres (PostgreSQL) 15.1 This method requires the PostgreSQL to be registered on Windows Environment Variables...

Overview Backup Procedure. Here is the backup procedure to backup the database on PostgreSQL. Using PgAdmin. Launch PgAdmin UI. Enter the Credential. Select the Veeam Database. Right click, and choose Backup. Enter the FileName, browse the path where you want to save the backup. Format keep default Custom. By default postgreSQL backups the DB as .SQL format. Click Backup, and see the progress. Using Powershell Open Powershell Go to Postgres bin folder....

Overview As we know, Veeam has released version 12, which includes PostgreSQL as the default database. For new installations, PostgreSQL will be used by default. However, if you upgraded Veeam from a previous version, you can still using the SQL Express 2016. It is important to note that Veeam uses the SQL Express edition, which have some limitation below: Use of one socket or four cores Use of only 1.4GB per instance 10GB limit for databases As the database grows due to large backup, there is a risk that it might become full, potentially disrupting backups....

Overview Due to the SQL 2016 has reached End-Off-Life (EOL), switching the SQL database on Veeam to PostgreSQL, or upgrading the SQL express version to 2022 is crucial to make sure the database engine version is updated. If you prefer to switch the database to PostgreSQL, you can follow This Link. However, if you are more comfortable, stick with SQL server, you can use the following procedures for upgrading the underlying SQL software to the latest 2022 version....

Overview A Veeam Immutable Repository is a feature within Veeam Backup & Replication v11 and newer, that allows for the creation of immutable backups. Immutable backups are protected from being modified or deleted for a specified period, providing a robust defense against ransomware and accidental data loss. Best practice Server Requirement Ensure the server have multiple CPUs, cores and threads. More core is better to handle the backup process. Ensure you have at least two Physical NIC for redundancy, and to increase the available bandwidth....

Overview You got Mariadb replication ERROR 1201 (HY000): Could not initialize master info structure for ''; when running start-slave after the migration. Steps: Check the Current Master Binary Log Position Login to master server, and run the following: docker exec mariadb-master show-status Replication Mode: master [mysql] *************************** 1. row *************************** [mysql] File: mysqld-bin.xx [mysql] Position: xx [mysql] Binlog_Do_DB: [mysql] Binlog_Ignore_DB: ############### Connections ############### Reset and Reconfigure Replication On the slave server, stop the slave: STOP SLAVE; Reset the replication....

Overview The error message Got fatal error 1236 from master when reading data from binary log: typically indicates that the replication slave is trying to read from a position in the master’s binary log that doesn’t exist. The detailed error is as follow: [mysql] Last_IO_Errno: 1236 [mysql] Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'Client requested master to start replication from impossible position; the first event 'mysqld-bin....

Network Design And IP Node Name Management IP Role DC01 10.10.101.5 AD/Dns Server SQL0A 10.10.101.12 SQL Server SQL0B 10.10.101.13 SQL Server SQLCL0A 10.10.101.10 Cluster Name Object (CNO) SQLAGL0A 10.10.101.11 SQL Availability Group Listener Requirement SQL Server requires a minimum of 20 GB of available hard drive space. Windows Server 2019 or greater Ensure that the system isn’t a domain controller. Ensure that each computer is running Windows Server 2019 or later versions with latest patches....

Introduction MariaDB is an open-source relational database management system (RDBMS) that is a fork of MySQL. It was created by the original developers of MySQL after concerns over the acquisition of MySQL by Oracle Corporation. MariaDB replication MariaDB replication is a process that allows you to create and maintain a copy of a database on another server, which is known as a replica. Replication in MariaDB can be useful for various purposes, including load balancing, high availability, and backup....