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
Tag: mysql
Nov 11 2017
How To Install And Configure Mailman On Ubuntu
In this tutorial I will configure a virtual host with the hostname lists.example.com where I will install Mailman. lists.example.com is also the right part of the mailing list email addresses that will be configured in Mailman, i.e., mails to a mailing list will have to be sent to the address <listname>@lists.example.com. As your hostname will …
Oct 27 2017
Asterisk dynamic routing with MySQL database
For the next task we will need Asterisk dynamic routing using MySQL: some company has technical department that should provide emergency services on non-working hours. Based on time and date conditions, a call should be routed to a shared department’s extension (technicians) or be sent to a man on duty on non-working time and weekends. …
Jan 14 2017
Upgrading MySQL 5.1 to 5.7 service failed to start
After MySQL upgrade from 5.1 to 5.7 on Centos 6.8 the mysqld service failed to start. In /var/log/mysqld.log I got the following: 2017-01-14 17:19:33 2175 [ERROR] InnoDB: auto-extending data file ./ibdata1 is of a different size 640 pages (rounded down to MB) than specified in the .cnf file: initial 768 pages, max 0 (relevant if …
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 |
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 …
- 1
- 2
Stay tuned! :)
