can not install from source : libft.so' failed

Lastest Forum Posts - 5 hours 22 min ago
Can't install from source: by instruction https://www.percona.com/doc/percona-...source-tarball

[ 38%]Building CXX object storage/tokudb/PerconaFT/ft/CMakeFiles/ft.dir/log_print.cc.o
Linking CXX shared library libft.so
/usr/bin/ld: cannot find -lz
collect2: error: ld returned 1 exit status
storage/tokudb/PerconaFT/ft/CMakeFiles/ft.dir/build.make:1323: recipe for target 'storage/tokudb/PerconaFT/ft/libft.so' failed
make[2]: *** [storage/tokudb/PerconaFT/ft/libft.so] Error 1
CMakeFiles/Makefile2:1318: recipe for target 'storage/tokudb/PerconaFT/ft/CMakeFiles/ft.dir/all' failed
make[1]: *** [storage/tokudb/PerconaFT/ft/CMakeFiles/ft.dir/all] Error 2
Makefile:137: recipe for target 'all' failed
make: *** [all] Error 2

What is the dependence is absent?
What is problem? Please help.

Encryption feature, is it available in Percona XtraDB cluster 5.6?

Lastest Forum Posts - 8 hours 8 min ago

Would wanted know, Encryption feature, is it available in Percona XtraDB cluster 5.6?

Need your expert advice.


Transactions in PSMDB

Lastest Forum Posts - November 29, 2015 - 2:12pm
When can I expect the implementation of the transactions' mechanism in the PSMDB? Whether it is on a road map in the near future?

Best regards,
Mateusz Zygmunt

How to selectively restore database/table

Lastest Forum Posts - November 27, 2015 - 9:58pm
Environment: MariaDB 10.1 + XtraBackup 2.3.2
Backup: Full + Incremental for all databases

Question 1: is there one way to restore selective database from backup rather than all the databases? for example, database A,B,C,D inside the backup, is there anyway to only revert database A to previous full backup, and keep database B,C,D?

Question 2: is there any way to at above at table level granule?

Currently I am thinking to restore all databases into staging database server and export data from database A using mysqldump, and import it. But it will be time consuming due to slowness of mysqldump.

Thanks for help!

Trigger replication issue (trigger loop)

Lastest Forum Posts - November 27, 2015 - 2:09pm
I encountered a strange behaviour today when setting up a cluster, starting with 2 nodes, that triggers started replicating in a loop and would continue to do so. So the trigger sets of once and then triggers the trigger again for whatever reason. This is not happening on a single server and starts as soon as I add a node to the cluster and will skyrocket once I add another node. Are there any known issues with triggers? AFAIK they should not be replicated at all, or at least be flagged to not execute on the other nodes again. What am I missing here?

Is there anyone who knows what could be happening? It was planed to use the cluster for 9 to 10 nodes and the trigger problem killed the whole project for now.

pt-online-schema-change not as online as I hoped...

Lastest Forum Posts - November 27, 2015 - 9:31am
I used this tool for the first time today, to do an ALTER on a large table. This is on a cluster with 3 nodes.

During some of this time (unfortunately while I was away) the DB cluster became slow to the point of being unresponsive; I can see this from logs from haproxy, which is sitting in front of it, which shows the occasional 2s timeout. I also had pingdom errors and user reports.

In the log of the node issuing the change, I see a few instances of this:

2015-11-27 17:11:28 27983 [Warning] WSREP: Failed to report last committed 333909394, -4 (Interrupted system call)

It's still running, and will hopefully complete, but below is the output so far.

Any ideas? I wondered whether I would be better off bringing the other two nodes down for the duration of a schema change, even if that requires an SST when they come back up.

No slaves found. See --recursion-method if host db1.ilovefreegle.org has slaves.
Not checking slave lag because no slaves were found and --check-slave-lag was not specified.
Operation, tries, wait:
analyze_table, 10, 1
copy_rows, 10, 0.25
create_triggers, 10, 1
drop_triggers, 10, 1
swap_tables, 10, 1
update_foreign_keys, 10, 1
Child tables:
`iznik`.`messages_groups` (approx. 40686 rows)
Will use the rebuild_constraints method to update foreign keys.
Altering `iznik`.`messages`...
Creating new table...
Created new table iznik._messages_new OK.
Altering new table...
Altered `iznik`.`_messages_new` OK.
2015-11-27T16:03:28 Creating triggers...
2015-11-27T16:03:28 Created triggers OK.
2015-11-27T16:03:28 Copying approximately 46400 rows...
Copying `iznik`.`messages`: 7% 07:35 remain
Copying `iznik`.`messages`: 12% 08:30 remain
Copying `iznik`.`messages`: 14% 10:16 remain
Copying `iznik`.`messages`: 15% 12:30 remain
Copying `iznik`.`messages`: 17% 13:57 remain
2015-11-27T16:06:31 Rows are copying very slowly. --chunk-size has been automatically reduced to 1. Check that the server is not being overloaded, or increase --chunk-time. The last chunk selected 1 rows and took 5.298 seconds to execute.
Copying `iznik`.`messages`: 20% 13:50 remain
Copying `iznik`.`messages`: 21% 16:43 remain
Copying `iznik`.`messages`: 21% 18:28 remain
Copying `iznik`.`messages`: 27% 15:22 remain
Copying `iznik`.`messages`: 27% 16:47 remain
Copying `iznik`.`messages`: 29% 16:10 remain
Copying `iznik`.`messages`: 32% 15:06 remain
Copying `iznik`.`messages`: 34% 17:59 remain
Copying `iznik`.`messages`: 34% 18:39 remain
Copying `iznik`.`messages`: 39% 16:25 remain
Copying `iznik`.`messages`: 43% 14:17 remain
Copying `iznik`.`messages`: 43% 16:54 remain
Copying `iznik`.`messages`: 43% 17:50 remain
Copying `iznik`.`messages`: 43% 19:06 remain
Copying `iznik`.`messages`: 43% 20:42 remain
Copying `iznik`.`messages`: 47% 18:37 remain
Copying `iznik`.`messages`: 47% 20:49 remain
Copying `iznik`.`messages`: 47% 21:19 remain
Copying `iznik`.`messages`: 48% 21:25 remain
Copying `iznik`.`messages`: 49% 21:58 remain
Copying `iznik`.`messages`: 49% 22:10 remain
Copying `iznik`.`messages`: 51% 20:38 remain
Copying `iznik`.`messages`: 52% 21:27 remain
Copying `iznik`.`messages`: 52% 22:23 remain
Copying `iznik`.`messages`: 53% 21:58 remain
Copying `iznik`.`messages`: 54% 22:35 remain
Copying `iznik`.`messages`: 54% 22:50 remain
Copying `iznik`.`messages`: 56% 21:39 remain
Copying `iznik`.`messages`: 57% 21:40 remain
Copying `iznik`.`messages`: 57% 21:47 remain
Copying `iznik`.`messages`: 57% 21:53 remain
Copying `iznik`.`messages`: 57% 22:33 remain
Copying `iznik`.`messages`: 58% 22:21 remain
Copying `iznik`.`messages`: 60% 21:23 remain
Copying `iznik`.`messages`: 60% 22:16 remain
Copying `iznik`.`messages`: 60% 22:36 remain
Copying `iznik`.`messages`: 60% 23:16 remain
Copying `iznik`.`messages`: 62% 21:42 remain
Copying `iznik`.`messages`: 65% 19:00 remain
Copying `iznik`.`messages`: 67% 18:07 remain
Copying `iznik`.`messages`: 67% 17:56 remain
Copying `iznik`.`messages`: 67% 19:19 remain
Copying `iznik`.`messages`: 68% 19:15 remain
Copying `iznik`.`messages`: 68% 19:11 remain
Copying `iznik`.`messages`: 69% 18:46 remain
Copying `iznik`.`messages`: 69% 18:44 remain
Copying `iznik`.`messages`: 69% 18:57 remain
Copying `iznik`.`messages`: 69% 19:06 remain
Copying `iznik`.`messages`: 70% 19:09 remain
Copying `iznik`.`messages`: 71% 18:16 remain
Copying `iznik`.`messages`: 72% 17:52 remain
Copying `iznik`.`messages`: 72% 18:17 remain
Copying `iznik`.`messages`: 72% 18:25 remain
Copying `iznik`.`messages`: 72% 18:21 remain
Copying `iznik`.`messages`: 73% 17:59 remain
Copying `iznik`.`messages`: 73% 17:59 remain
Copying `iznik`.`messages`: 73% 18:10 remain
Copying `iznik`.`messages`: 74% 17:49 remain
Copying `iznik`.`messages`: 74% 17:49 remain
Copying `iznik`.`messages`: 75% 17:31 remain
Copying `iznik`.`messages`: 75% 17:20 remain
Copying `iznik`.`messages`: 76% 17:02 remain
Copying `iznik`.`messages`: 76% 16:40 remain
Copying `iznik`.`messages`: 76% 16:47 remain
Copying `iznik`.`messages`: 76% 17:07 remain
Copying `iznik`.`messages`: 76% 17:21 remain
Copying `iznik`.`messages`: 77% 16:59 remain
Copying `iznik`.`messages`: 77% 16:58 remain
Copying `iznik`.`messages`: 77% 17:04 remain
Copying `iznik`.`messages`: 77% 17:06 remain
Copying `iznik`.`messages`: 78% 16:52 remain
Copying `iznik`.`messages`: 78% 16:47 remain
Copying `iznik`.`messages`: 78% 17:23 remain
Copying `iznik`.`messages`: 78% 17:10 remain
Copying `iznik`.`messages`: 79% 16:54 remain
Copying `iznik`.`messages`: 79% 16:39 remain
Copying `iznik`.`messages`: 79% 16:40 remain
Copying `iznik`.`messages`: 79% 16:39 remain
Copying `iznik`.`messages`: 80% 16:40 remain
Copying `iznik`.`messages`: 80% 16:39 remain
Copying `iznik`.`messages`: 80% 16:42 remain
Copying `iznik`.`messages`: 80% 16:42 remain
Copying `iznik`.`messages`: 80% 16:54 remain
Copying `iznik`.`messages`: 80% 17:04 remain
Copying `iznik`.`messages`: 80% 17:09 remain
Copying `iznik`.`messages`: 80% 16:59 remain
Copying `iznik`.`messages`: 81% 16:43 remain
Copying `iznik`.`messages`: 81% 16:30 remain
Copying `iznik`.`messages`: 81% 16:21 remain
Copying `iznik`.`messages`: 81% 16:16 remain
Copying `iznik`.`messages`: 82% 16:07 remain
Copying `iznik`.`messages`: 82% 16:03 remain
Copying `iznik`.`messages`: 82% 15:42 remain
Copying `iznik`.`messages`: 83% 15:11 remain
Copying `iznik`.`messages`: 83% 15:00 remain
Copying `iznik`.`messages`: 83% 14:58 remain
Copying `iznik`.`messages`: 83% 14:47 remain
Copying `iznik`.`messages`: 84% 14:37 remain
Copying `iznik`.`messages`: 84% 14:38 remain
Copying `iznik`.`messages`: 84% 14:35 remain
Copying `iznik`.`messages`: 84% 14:43 remain
Copying `iznik`.`messages`: 84% 14:45 remain
Copying `iznik`.`messages`: 84% 14:45 remain
Copying `iznik`.`messages`: 84% 14:41 remain
Copying `iznik`.`messages`: 84% 14:39 remain
Copying `iznik`.`messages`: 85% 14:33 remain
Copying `iznik`.`messages`: 85% 14:23 remain
Copying `iznik`.`messages`: 85% 14:08 remain
Copying `iznik`.`messages`: 85% 13:54 remain

3 year old pt-slave-delay bug still not assigned

Lastest Forum Posts - November 27, 2015 - 1:21am
Can someone at Percona have a look at this 3 year old bug on launchpad:


It even has a suggested patch attached .. I've been experiencing this issue for a while.

It relates to pt-slave-delay going way older than it is supposed to if it starts when the slave is already lagged (which to me sounds like a very common situation)


Xtradb cluster 5.6 crash in production

Lastest Forum Posts - November 26, 2015 - 12:56am

I had a production system running for half year without problem up until recently when it crashed. I try to figure out what have caused the issue.

It is a 2 node master-master xtradb 5.6 cluster on 2 Debian Wheezy 7 linuxes.

Here is the relevant log:

mysql error log:

17:05:33 UTC - mysqld got signal 11 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed,
something is definitely wrong and this may fail.
Please help us make Percona XtraDB Cluster better by reporting any
bugs at https://bugs.launchpad.net/percona-xtradb-cluster

It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 233144 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x7f40fc177630
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
Segmentation fault


Nov 18 18:05:34 sql kernel: [9921358.749531] mysqld[25732]: segfault at 30 ip 00000000005e09f8 sp 00007f41717d7f50 error 4 in mysqld[400000+bd6000]

Thank you.

Percona Monitoring tool for Linux works from command line, do not show any graphs

Lastest Forum Posts - November 25, 2015 - 3:09pm
I installed Percona Monitoring plugin 1.1 with Cacti 0.8.8f (latest).
I tested that it works from command line:

Reading Memory values
php /var/www/cacti/scripts/ss_get_by_ssh.php --host --type memory --items hq,hr,hs,ht,hu,hv
hq:441073664 hr:64520192 hs:274432 ht:189108224 hu:349212672 hv:1044189184

php /var/www/cacti/scripts/ss_get_by_ssh.php --host --type diskstats --device dm-1 --items iw,ix,iy,iz,jg,jh,ji,jj,jk,jl,jm,jl,jm
iw:31734 ix:0 iy:1426098 iz:83060 jg:13993 jh:0 ji:111944 jj:420965 jk:45727 jl:139208 jm:504025

Within Cacti I created graphs based on Percona GNU/Linux HT template for Centos 6.7 server, but nothing is showed in all these graphs.
I configured Cacti to access remote server via SSH, following steps described on Percona site, it works well.

Cacti works well for other graphs not based on Percona template, such as SNMP network interface, for locahost or for remote servers.

what's wrong ?
How can fix it ?

thanks in advance
kind regards

index disabled when using variable

Lastest Forum Posts - November 25, 2015 - 8:16am
Hi all
When using the stored procedure, I passed the cursor to the SQL and found that the SQL was unable to use the index.

You can reproduce this when using session variables,For example

Correct use index:
1.SELECT count(1) FROM T_E4S_BU_ECA_FAIL_UNCONT where FAIL_NO='H2923LFR001690' ;

Index disabled,full table scan:
2.set @FAIL_NO='H2923LFR001690' ;

How can i do? thx

Smallest MySQL Server in the World (under $60) which can even make you toast while fixing MySQL bug #2

Latest MySQL Performance Blog posts - November 25, 2015 - 7:36am

In my last blog post, Internet of Things, Messaging and MySQL, I have showed how to start your own Internet of Things with Particle Photon board. That implementation is great, but requires constant internet (wi-fi) access as the Particle Photon board does not have any local storage. If you do not have a reliable network access (i.e. in some remote places) or need something really small to store your data you can now use Intel Edison. I’ve even install MySQL on Edison, which makes it the smallest (in size) MySQL server in the world! Other options include:

MySQL Configuration

Intel Edison is a tiny computer based on 22 nm Silvermont dual-core Intel Atom CPU, 500MHz, running Linux (Ubuntu based distribution called Yocto). To program the Edison we will need a breakout board. Options include Arduino compatible breakout board (which includes SD card) and a small Intel breakout board.

The installation and configuration is straightforward. I’ve used the Get Started with Yocto Project on the Intel Edison Board guide to setup and configure the board. First we need to connect to Edison via serial connection and configure sshd and Wi-Fi; when it is done we can connect to Edison using SSH.

The MySQL installation is relatively easy as Linux generic binaries are compatible with Yocto Linux (so you do not have to compile anything). There are 2 challenges though:

  • By default the Yocto linux (as well as the official repository) does not include libraries needed for MySQL: libaio1, libcrypto, libssl
  • The internal storage is tiny and MySQL 5.7 binaries did not even fit into any partition. I had to remove some “tests” and other stuff I do not need. For the real installation one can use SD card (SD slot is available on some boards).

To install the libraries I’ve used the un-official Edison repositories following the excellent guide: Edison package repo configuration. Setup is simple:

To configure your Edison to fetch packages from this repo, replace anything you have in /etc/opkg/base-feeds.conf with the following (other opkg config files don’t need any changes):

src/gz all http://repo.opkg.net/edison/repo/all src/gz edison http://repo.opkg.net/edison/repo/edison src/gz core2-32 http://repo.opkg.net/edison/repo/core2-32

Then we will need to setup the libraries:

# opkg install libaio1_0.3 libcrypto1.0.0 libssl1.0.0

Finally we can download Percona Server 5.6 and place it somewhere (use basedir in my.cnf to point to the installation path):

# wget https://www.percona.com/downloads/Percona-Server-5.6/Percona-Server-5.6.25-73.1/binary/tarball/Percona-Server-5.6.25-rel73.1-Linux.i686.ssl100.tar.gz

Please note that the latest Percona Server 5.6 depends on the Numa library and there is no such library for Yocto (does not make sense for Edison). So 5.6.25 is the latest Percona Server you can install here.

The simple (and rather useless) benchmark on Intel Edison:

root@edison:/usr/local/mysql# cat /proc/cpuinfo processor : 0 vendor_id : GenuineIntel cpu family : 6 model : 74 model name : Genuine Intel(R) CPU 4000 @ 500MHz ... mysql> SELECT BENCHMARK(10000000,ENCODE('hello','goodbye')); +-----------------------------------------------+ | BENCHMARK(10000000,ENCODE('hello','goodbye')) | +-----------------------------------------------+ | 0 | +-----------------------------------------------+ 1 row in set (18.77 sec)

Can MySQL make you toast?

The famous MySQL Bug#2, submitted 12 Sep 2002, states that “MySQL Connector/J doesn’t make toast”. With Intel Edison and Arduino compatible breakout board it is now trivial to fix this bug: not only MySQL Connector/J but also MySQL server itself can make you a toast! This can be done via UDF or, in MySQL 5.7, with Query Rewrite Plugins, so you can execute MySQL query:

mysql> make toast;

For the actual implementation you can either “hack” an existing toaster to interface with breakout board pins or use a Arduino compatible Robotic Arm. Ok, MySQL, make me toast!

The post Smallest MySQL Server in the World (under $60) which can even make you toast while fixing MySQL bug #2 appeared first on MySQL Performance Blog.

Error on launching innobackupex

Lastest Forum Posts - November 25, 2015 - 3:25am
Hello everyone,

I have an issue when trying to run innobackupex 2.0.8 on a mysql server 5.1.30 - Source distribution - The error is as below.

[root@svr var]# innobackupex --compress --user=bkpuser --password=xxxxxxx --defaults-extra-file=/etc/my.data.cnf /backup/percona/

InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona LLC and/or its affiliates 2009-2013. All Rights Reserved.

This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.

151125 14:00:52 innobackupex: Starting mysql with options: --defaults-extra-file="/etc/my.data.cnf" --password=xxxxxxxx --user='bkpuser' --unbuffered --
151125 14:00:52 innobackupex: Connected to database with mysql child process (pid=16599)
151125 14:01:01 innobackupex: Connection to database server closed
IMPORTANT: Please check that the backup run completes successfully.
At the end of a successful backup run innobackupex
prints "completed OK!".

innobackupex: Using mysql Ver 14.12 Distrib 5.0.77, for redhat-linux-gnu (i386) using readline 5.1
innobackupex: Using mysql server version Copyright (C) 2000-2008 MySQL AB

innobackupex: Created backup directory /backup/percona/2015-11-25_14-01-01
151125 14:01:01 innobackupex: Starting mysql with options: --defaults-extra-file="/etc/my.data.cnf" --password=xxxxxxxx --user='bkpuser' --unbuffered --
151125 14:01:01 innobackupex: Connected to database with mysql child process (pid=16832)
151125 14:01:04 innobackupex: Connection to database server closed

151125 14:01:04 innobackupex: Starting ibbackup with command: xtrabackup --defaults-extra-file="/etc/my.data.cnf" --defaults-group="mysqld" --backup --suspend-at-end --target-dir=/backup/percona/2015-11-25_14-01-01 --tmpdir=/tmp --compress --compress-threads=1
innobackupex: Waiting for ibbackup (pid=16852) to suspend
innobackupex: Suspend file '/backup/percona/2015-11-25_14-01-01/xtrabackup_suspended'

xtrabackup version 2.0.8 for Percona Server 5.1.59 pc-linux-gnu (i686) (revision id: 587)
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /home/mysql/var/
xtrabackup: Target instance is assumed as followings.
xtrabackup: innodb_data_home_dir = ./
xtrabackup: innodb_data_file_path = ibdata1:10M:autoextend
xtrabackup: innodb_log_group_home_dir = ./
xtrabackup: innodb_log_files_in_group = 2
xtrabackup: innodb_log_file_size = -4639575577537282048
InnoDB: No valid checkpoint found.
InnoDB: If this error appears when you are creating an InnoDB database,
InnoDB: the problem may be that during an earlier attempt you managed
InnoDB: to create the InnoDB data files, but log file creation failed.
InnoDB: If that is the case, please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.1/...ng-innodb.html
innobackupex: Error: ibbackup child process has died at /usr/bin/innobackupex line 386.
You have new mail in /var/spool/mail/root

Any ideas how to solve this?

ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect

Lastest Forum Posts - November 24, 2015 - 4:04pm
I am not sure whether this questions belongs to Cluster side or just mysql server side.

I have set wait_timeout and interactive_timeout to 3600 ( 1 hr) but it looks like I see error message even much before 1 hr
So what is causing this behavior ?

mysql> select * from test ;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 114677

Code: mysql> show global variables like '%timeout'; +-----------------------------+----------+ | Variable_name | Value | +-----------------------------+----------+ | connect_timeout | 10 | | delayed_insert_timeout | 300 | | have_statement_timeout | YES | | innodb_flush_log_at_timeout | 1 | | innodb_lock_wait_timeout | 50 | | innodb_rollback_on_timeout | OFF | | interactive_timeout | 3600 | | lock_wait_timeout | 31536000 | | net_read_timeout | 30 | | net_write_timeout | 60 | | rpl_stop_slave_timeout | 31536000 | | slave_net_timeout | 3600 | | thread_pool_idle_timeout | 3600 | | wait_timeout | 3600 | +-----------------------------+----------+ 14 rows in set (0.03 sec)

installing - circular reference ExtUtils::Makemaker and Test::Harness on RH7

Lastest Forum Posts - November 24, 2015 - 9:41am
Having issues with install. Getting a circular reference problem with perl modules. any ideas?

[ERROR] WSREP: Unrecognized parameter 'gmcast.segment'

Lastest Forum Posts - November 24, 2015 - 5:37am
Hello all

I have added the below to my.cnf

wsrep_cluster_address = gcomm://
wsrep_node_address =
wsrep_node_incoming_address =
wsrep_provider = /usr/lib64/libgalera_smm.so
wsrep_provider_options = "gmcast.segment=1"

It does not start up the cluster anymore stating the below error:

[ERROR] WSREP: Unrecognized parameter 'gmcast.segment'


Lastest Forum Posts - November 24, 2015 - 5:36am
My looks are natural and smart Chandigarh escorts. A fit way of life is imperative for me, so I'm working out every now and again to keep myself in figure, for the most part encountering yoga activities and jumping. for more info visit my site - http://www.karanpreet.in

Monitoring tools for TokuMX

Lastest Forum Posts - November 24, 2015 - 3:00am

We are trying to use TokuMX in our prod environment in the near future. So doing some R&D about it.
I would like to know, if there is any specific monitoring tools for TokuMX?
If yes, What are the recommended tools?
Can we expect tools for Tokumx like ops-manager that is used for mongodb?


Re-instating the bootstrap node after a crash

Lastest Forum Posts - November 23, 2015 - 1:36pm
We have a 3 node cluster. One of the node which happened to be the bootstrapped node crash and we needed to reinstall. Is there a way to add it back to the cluster without bringing down the cluster? Thank you!

Show real host IP/Hostname instead of HAProxy IP

Lastest Forum Posts - November 23, 2015 - 10:44am

When I do show processlist, I see host is showing haproxy server not the real host where connection is made. How do I fix it ? Is it haproxy configuration or MySQL configuration change.

In the above mentioned article,
it says "If you are using HAProxy for MySQL you can break the privilege system’s host part, because MySQL will think that the connections are always coming from the load balancer. You can work this around using T-Proxy patches and someiptables magic for the backwards connections."

BUT, it did not provide enough details. Can you please provide documentation on how to achieve this ?

Etiquette and Protocol

Lastest Forum Posts - November 22, 2015 - 1:42am
The College of Mass Communication organized an activity for development of the professional skills of the academic and administrative members of Al Falah University.