Working with MongoDB 6.0 and mongosh 1.10.0. Continue reading
Category Archives: Database
MySQL Replication and MEMORY Tables
Memory tables do not play well with replication. Continue reading
Configure MySQL Replication with Puppet
We’re going to use Puppet to install MySQL and configure Master/Master replication. Continue reading
Setting up a MariaDB Server with SELinux on RHEL 7
We are going to install and configure a MariaDB server and create a simple database schema. MariaDB backup and restore procedures, as well as some common MariaDB errors, will be covered. Continue reading
Reset Forgotten MySQL Root Password
We’re using MySQL 5.5 and Debian Wheezy in this example. Continue reading
Optimise MySQL Configuration for WordPress
Re-configure default MySQL server to run more efficiently. Continue reading
SQL Server 2014 Reporting Services Fail to Bind to SSL
Configuring SSRS 2014 over SSL. Continue reading
Move tempdb on MSSQL Server 2008
Moving tempdb to another disk. Continue reading
Shrink MSSQL Logs and Rebuild Database Table Indexes
Some quite useful MSSQL notes here. Continue reading