While loading res_odbc.so Asterisk crashes with “invalid pointer” error like in the backtrace below: Loading res_odbc.so. Be sociable 🙂 Share!
Tag: MariaDB
Apr 03 2019
How to reset MySQL/MariaDB root password
Start session ssh (using root if possible). Edit my.cnf file using. sudo vi /etc/my.cnf Add line to [mysqld] block: Be sociable 🙂 Share!
Jan 23 2018
Error Duplicate entry for key on query
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
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!
Jun 21 2016
MySQL show connections with MyTOP
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
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 …
Apr 22 2016
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!
Apr 15 2016
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:
1 2 |
# ls /sys/class/net eth1 lo |
Be …