Jan 23 2018
On checking MySQL/MariaDB slave status we can see the following error:
|
1 2 3 4 |
mysql> SHOW SLAVE STATUS\G ... Last_SQL_Errno: 1062 Last_SQL_Error: Error 'Duplicate entry '146474' for key 'PRIMARY'' on query. Default database: 'db'. Query: 'INSERT INTO `options` (`name`, `value, autoload`) VALUES ('enable', 'true', 'true')' |
There are a few ways how to treat such kind of errors. Be sociable 🙂 Share!
Jan 23 2018
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!
Jun 21 2016
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:
|
1 2 |
wget http://mirror.omnilance.com/epel/6/x86_64/epel-release-6-8.noarch.rpm rpm -Uvh epel-release-6-8.noarch.rpm |
Be sociable 🙂 Share!
May 05 2016
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 …
Apr 22 2016
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!
Apr 15 2016
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:
|
1 2 |
# ls /sys/class/net eth1 lo |
Be …
