Found 10 results
How to install MySQL 8 on CentOS 7 is our next quick tutorial where we will learn in just a few easy steps how to install and test latest MySQL 8 available – as of today – from Oracle on a CentOS 7 server by using only our terminal window. These days most of modern companies are using Cloud managed services for their databases, some of these with fancy names, different functions, speeds and sizes but sometimes we may have no other choice than to use the classic MySQL. Depending on the project requirements we may have to perform these […]
Category: General | Published: 14/05/2019 | Updated: 19/07/2019Access MySQL without password locally may be sometimes needed and quite handy for various reasons like for example if you are a very passionate database developer or just occasionally doing DBA stuff and you desperately need to quickly access a specific database or table, can be quite annoying to type in your username and password each time you are using the console. In this very short tutorial we’ll talk about how to access MySQL without using a password locally via terminal window. We have tested this method using MySQL version 5.6 and 5.7 based on CentOS 7 operating system but […]
Category: MySQL | Published: 10/08/2018 | Updated: 05/11/2018In this tutorial called dump MySQL table and import we will learn how to export a single database table using mysqlpump utility instead of exporting an entire database and also we will guide you how to import a single database table using different methods. Exporting a single table can be very handy when you have to update or replace another database table that is not part of a cluster or maybe you simply need it for your development environment to perform some quick changes or various tests. In this example we will use MySQL 5.7 and MySQL Client (CLI) based […]
Category: MySQL | Published: 08/08/2018 | Updated: 23/04/2019In this tutorial called create MySQL slave by cloning we’ll try to guide you through a very detailed but in the same time simple process to create a MySQL slave, also known as MySQL replica, by using a fresh backup taken from an existing MySQL server referred here as MySQL master server. Assuming that our master database is 11TB large we’ll have to copy its data content from US, where the master server is located to another server located in a UK data centre, not quite an easy task with this amount of data or without using a costly commercial […]
Category: MySQL | Published: 06/07/2018 | Updated: 05/11/2018MySQL GTID replication error can happen unexpectedly for various reasons and as often as the classic master slave, circular or multi-master replication but in this short tutorial we will learn, step by step, how to skip MySQL GTID transaction error in order to keep in sync our MySQL slave server. Before we begin we need to say that all below steps were tested in a master-slave setup using MySQL 5.6 and MySQL 5.7, we think that this MySQL skipping transaction method detailed below can be easily applied even for newer MySQL versions like 8+. Please note that all below operations […]
Category: MySQL | Published: 28/06/2018 | Updated: 05/11/2018Resize RAID 0 array by adding new disks
In this tutorial called Resize RAID 0 Array by Adding New Disks we will learn how to extend an existing RAID 0 Array in just a few easy steps via CLI. Before starting to resize your RAID 0 array please do take a backup of your data, this is very important as the resize action can lead to data loss. It’s well known that RAID 0 architecture by definition is very fast but in the same time it is not the safest, at any time one of the disks can fail and the entire array could be lost. It is […]
Category: General | Published: 10/01/2019 | Updated: 23/04/2019