Tag: MariaDB

Error Duplicate entry for key on query

On checking MySQL/MariaDB slave status we can see the following error:

There are a few ways how to treat such kind of errors. Be sociable 🙂 Share!

Continue reading

Could not find target log during relay log initialization

While a setting up MariaDB slave I ran in the following issue: 180118 14:14:11 [ERROR] Failed to open the relay log ‘./-relay-bin’ (relay_log_pos 7654336) 071118 16:44:10 [ERROR] Could not find target log during relay log initialization 071118 16:44:10 [ERROR] Failed to initialize the master info structure Be sociable 🙂 Share!

Continue reading

MySQL show connections with MyTOP

mytop-help

MyTOP is an utility for tracking performance and connections to MySQL/MariDB servers. The interface is very similar to top utility. Further examples is performed in CentOS 6 x64 operating system. First of all we need to plug Epel repository:

Be sociable 🙂 Share!

Continue reading

MariaDB(MySQL) Master-Master Replication

I’m going to develop my cluster further and create MariaDB(MySQL) geo-cluster by enabling MariaDB(MySQL) Master-Master Replication. I’ve already deployed MariaDB cluster in the second datacenter (nodes 4, 5 and 6) and now I need to configure Master-Master replication between two MariaDB clusters. The replication will take place between node 1 (first datacenter, we will name …

Continue reading

MariaDB Galera three nodes cluster on CentOS 6

Let’s build MariaDB Galera cluster with three nodes on CentOS x64 6.7 Minimal. On all nodes static IP adresses have been configured. Node1- 10.20.20.11 Node2 – 10.20.20.12 Node3 – 10.20.20.13 On all nodes we need to install necessary packages: Be sociable 🙂 Share!

Continue reading

Cloned Hyper-V CentOS6 Server error “device eth0 does not seem to be present, delaying initialization”

In order to have 3 identical nodes for my MariaDB Galera cluster, I cloned a hyper-v install of CentOS6 and after firing up the clone and trying to start networking received the error: “device eth0 does not seem to be present, delaying initialization” We need to get the list of current eth devices:

Be …

Continue reading