]]>
]]>

You are here

Feed aggregator

Xtradb cluster - WSREP_SST error

Lastest Forum Posts - May 20, 2015 - 8:27am
Hi all,

I'm trying to add a new node to my db cluster, and encountering an error I can't solve.

Context:
The cluster currently has 3 active servers (nodes: db1, db3, db4) , 1 down with a filesystem issue (db2)
I've updated db1 and db3 config (new ip in the wsrep_cluster_address), but not db4 since it's under heavy load at the moment (it's taking db2 load).
So I'm trying to add a new node db5 to replace db2 with the following config:


[mysqld]
log-error = /var/log/mysql.log
wsrep_provider = /usr/lib64/libgalera_smm.so
wsrep_cluster_address = gcomm://xxx.xxx.xxx.3,xxx.xxx.xxx.6,xxx.xxx.xxx.7,xxx.xxx. xxx.23,xxx.xxx.xxx.54
binlog_format = ROW
default_storage_engine = InnoDB
innodb_autoinc_lock_mode = 2
log_slave_updates = 1
innodb_locks_unsafe_for_binlog = 1
innodb_buffer_pool_size = 12G
datadir = /db-data/mysql
server_id = 5
sql_mode = NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
wsrep_sst_method = xtrabackup
wsrep_cluster_name = live_cluster
wsrep_node_name = db5
log_bin = mysql-bin
wsrep_sst_auth = "userassword"
sort_buffer_size = 4M
join_buffer_size = 128M
expire_logs_days = 7
max_connections = 200

//Test: tried to specify a donor
wsrep_sst_donor = db1


An now the error I get when I start the server:

[...]
2015-05-20 14:59:35 4466 [Note] WSREP: 1.0 (db1): State transfer to 3.0 (db5) complete.
2015-05-20 14:59:35 4466 [Note] WSREP: Member 1.0 (db1) synced with group.
WSREP_SST: [INFO] Preparing the backup at /db-data/mysql/ (20150520 14:59:57.972)
WSREP_SST: [INFO] Evaluating innobackupex --no-version-check --apply-log $rebuildcmd ${DATA} &>${DATA}/innobackup.prepare.log (20150520 14:59:57.975)
WSREP_SST: [ERROR] Cleanup after exit with status:2 (20150520 14:59:58.231)
WSREP_SST: [INFO] Removing the sst_in_progress file (20150520 14:59:58.233)
2015-05-20 14:59:58 4466 [ERROR] WSREP: Process completed with error: wsrep_sst_xtrabackup --role 'joiner' --address 'xxx.xxx.xxx.54' --auth 'user: password --datadir '/db-data/mysql/' --defaults-file '/etc/my.cnf' --parent '4466' '' : 2 (No such file or directory)
2015-05-20 14:59:58 4466 [ERROR] WSREP: Failed to read uuid:seqno from joiner script.
2015-05-20 14:59:58 4466 [ERROR] WSREP: SST failed: 2 (No such file or directory)
2015-05-20 14:59:58 4466 [ERROR] Aborting

2015-05-20 15:00:00 4466 [Note] WSREP: Closing send monitor...
2015-05-20 15:00:00 4466 [Note] WSREP: Closed send monitor.
2015-05-20 15:00:00 4466 [Note] WSREP: gcomm: terminating thread
2015-05-20 15:00:00 4466 [Note] WSREP: gcomm: joining thread
2015-05-20 15:00:00 4466 [Note] WSREP: gcomm: closing backend
2015-05-20 15:00:00 4466 [Note] WSREP: gcomm: closed
2015-05-20 15:00:00 4466 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1
2015-05-20 15:00:00 4466 [Note] WSREP: Flow-control interval: [16, 16]
2015-05-20 15:00:00 4466 [Note] WSREP: Received NON-PRIMARY.
2015-05-20 15:00:00 4466 [Note] WSREP: Shifting JOINER -> OPEN (TO: 39533446)
2015-05-20 15:00:00 4466 [Note] WSREP: Received self-leave message.
2015-05-20 15:00:00 4466 [Note] WSREP: Flow-control interval: [0, 0]
2015-05-20 15:00:00 4466 [Note] WSREP: Received SELF-LEAVE. Closing connection.
2015-05-20 15:00:00 4466 [Note] WSREP: Shifting OPEN -> CLOSED (TO: 39533446)
2015-05-20 15:00:00 4466 [Note] WSREP: RECV thread exiting 0: Success
2015-05-20 15:00:00 4466 [Note] WSREP: recv_thread() joined.
2015-05-20 15:00:00 4466 [Note] WSREP: Closing replication queue.
2015-05-20 15:00:00 4466 [Note] WSREP: Closing slave action queue.
2015-05-20 15:00:00 4466 [Note] WSREP: Service disconnected.
2015-05-20 15:00:00 4466 [Note] WSREP: rollbacker thread exiting
2015-05-20 15:00:01 4466 [Note] WSREP: Some threads may fail to exit.
2015-05-20 15:00:01 4466 [Note] Binlog end
2015-05-20 15:00:01 4466 [Note] /usr/sbin/mysqld: Shutdown complete

Error in my_thread_global_end(): 1 threads didn't exit
150520 15:00:06 mysqld_safe mysqld from pid file /db-data/mysql/db5.pid ended


Could anyone please give me a hand.
Thank you.

Backup -> Prepare -> Compress

Lastest Forum Posts - May 20, 2015 - 5:23am
Hi,

I want to make a backup, then prepare it (I guess with --apply-log) and then compress it. But as I understand it, compression is an option while making the backup, and then the backup cannot be prepared without decompressing it first.

I want my backup to be prepared and ready before I archive it. So that I don't have to prepare it before restoring.
Am I thinking about this the wrong way?

If not, any recommendations for compressing my backup after doing --apply-log?

Thanks!

Percona XtraDB Cluster 5.7 ?

Lastest Forum Posts - May 20, 2015 - 3:30am
Hi all,

am I correct in assuming that Percona XtraDB cluster 5.6 is built upon MySQL 5.6 ? If so, any idea when we can expect 5.7 ?
We're running Percona XtraDB cluster and we need some features only available in MySQL 5.7 ...

thanks & regards
Jo

Percona XtraDB Cluster 5.7 ?

Lastest Forum Posts - May 20, 2015 - 3:21am
Hi all,

am I correct in assuming that Percona XtraDB cluster 5.6 is built upon MySQL 5.6 ? If so, any idea when we can expect 5.7 ?
We're running Percona XtraDB cluster and we need some features only available in MySQL 5.7 ...

thanks & regards
Jo

after change config - Can't open and lock privilege tables

Lastest Forum Posts - May 19, 2015 - 11:40pm
ubuntu 14.04 amd64
percona 5.6

After changing my config, I decided to restart second node and found permission errors. It seems that all files under data dir has become owned by root:root. What gives?

: WSREP_SST: [INFO] Waiting for SST streaming to complete! (20150520 13:23:58.751) 2015-05-20 13:23:59 15145 [Note] WSREP: (6928fbc1, 'tcp://0.0.0.0:4567') turning message relay requesting off 2015-05-20 13:25:52 15145 [Note] WSREP: 0.0 (db1): State transfer to 1.0 (db2) complete. 2015-05-20 13:25:52 15145 [Note] WSREP: Member 0.0 (db1) synced with group. WSREP_SST: [INFO] Preparing the backup at /var/lib/mysql//.sst (20150520 13:25:52.171) WSREP_SST: [INFO] Evaluating innobackupex --no-version-check --apply-log $rebuildcmd ${DATA} &>${DATA}/innobackup.prepare.log (20150520 13:25:52.175) rm: cannot remove ‘/var/lib/mysql//innobackup.prepare.log’: No such file or directory rm: cannot remove ‘/var/lib/mysql//innobackup.move.log’: No such file or directory WSREP_SST: [INFO] Moving the backup to /var/lib/mysql/ (20150520 13:26:01.720) WSREP_SST: [INFO] Evaluating innobackupex --defaults-file=/etc/mysql/my.cnf --no-version-check --move-back --force-non-empty-directories ${DATA} &>${DATA}/innobackup.move.log (20150520 13:26:01.724) WSREP_SST: [INFO] Move successful, removing /var/lib/mysql//.sst (20150520 13:26:02.770) WSREP_SST: [INFO] Galera co-ords from recovery: 19bf9b09-ed47-11e4-8005-f75eee435bfc:930465 (20150520 13:26:02.788) WSREP_SST: [INFO] Total time on joiner: 0 seconds (20150520 13:26:02.793) WSREP_SST: [INFO] Removing the sst_in_progress file (20150520 13:26:02.798) 2015-05-20 13:26:02 15145 [Note] WSREP: SST complete, seqno: 930465 2015-05-20 13:26:02 15145 [Note] InnoDB: Using atomics to ref count buffer pool pages 2015-05-20 13:26:02 15145 [Note] InnoDB: The InnoDB memory heap is disabled 2015-05-20 13:26:02 15145 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2015-05-20 13:26:02 15145 [Note] InnoDB: Memory barrier is not used 2015-05-20 13:26:02 15145 [Note] InnoDB: Compressed tables use zlib 1.2.8 2015-05-20 13:26:02 15145 [Note] InnoDB: Using Linux native AIO 2015-05-20 13:26:02 15145 [Note] InnoDB: Using CPU crc32 instructions 2015-05-20 13:26:02 15145 [Note] InnoDB: Initializing buffer pool, size = 91.9G 2015-05-20 13:26:07 15145 [Note] InnoDB: Completed initialization of buffer pool 2015-05-20 13:26:08 15145 [Note] InnoDB: Highest supported file format is Barracuda. 2015-05-20 13:26:10 15145 [Note] InnoDB: 128 rollback segment(s) are active. 2015-05-20 13:26:10 15145 [Note] InnoDB: Waiting for purge to start 2015-05-20 13:26:10 15145 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.22-72.0 started; log sequence number 8113619938 2015-05-20 13:26:42 15145 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: cc1d0d52-feb0-11e4-8fda-40f2e99e3ca2. 2015-05-20 13:26:42 15145 [Note] RSA private key file not found: /var/lib/mysql//private_key.pem. Some authentication plugins will not work. 2015-05-20 13:26:42 15145 [Note] RSA public key file not found: /var/lib/mysql//public_key.pem. Some authentication plugins will not work. 2015-05-20 13:26:42 15145 [Note] Server hostname (bind-address): '10.1.1.100'; port: 3306 2015-05-20 13:26:42 15145 [Note] - '10.1.1.100' resolves to '10.1.1.100'; 2015-05-20 13:26:42 15145 [Note] Server socket created on IP: '10.1.1.100'. 2015-05-20 13:26:42 15145 [ERROR] /usr/sbin/mysqld: Can't find file: './mysql/user.frm' (errno: 13 - Permission denied) 2015-05-20 13:26:42 15145 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/user.frm' (errno: 13 - Permission denied) 150520 13:26:42 mysqld_safe mysqld from pid file /var/lib/mysql/mysqld.pid ended my.cnf

: [client] port = 3306 socket = /var/run/mysqld/mysqld.sock [mysqld_safe] pid_file=mysqld.pid log_error=/var/log/mysql.log basedir=/usr/ datadir=/var/lib/mysql [mysqld] user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp lc-messages-dir = /usr/share/mysql federated skip-external-locking bind-address = 10.1.1.100 key_buffer = 24M tmp_table_size = 64M max_heap_table_size = 64M max_allowed_packet = 512M skip_name_resolve memlock sysdate_is_now=1 #thread_stack = 192K thread_cache_size = 512 query_cache_size = 0 table_open_cache=1024 lower_case_table_names=0 # 5.6 backwards compatibility explicit_defaults_for_timestamp=1 #myisam-recover = BACKUP #query_cache_limit = 1M #query_cache_size = 16M log_error = /var/log/mysql.log binlog_format=ROW ### INNODB OPTIONS innodb_buffer_pool_size=94065M innodb_flush_log_at_trx_commit=2 innodb_file_per_table=1 innodb_data_file_path = ibdata1:100M:autoextend ## You may want to tune the below depending on number of cores and disk sub innodb_read_io_threads=4 innodb_write_io_threads=4 innodb_io_capacity=200 innodb_doublewrite=1 innodb_log_file_size=1024M innodb_log_buffer_size=96M innodb_buffer_pool_instances=8 innodb_log_files_in_group=2 innodb_thread_concurrency=64 #innodb_file_format=barracuda innodb_flush_method = O_DIRECT innodb_autoinc_lock_mode=2 ## avoid statistics update when doing e.g show tables innodb_stats_on_metadata=0 default_storage_engine=innodb wsrep_provider=/usr/lib/libgalera_smm.so wsrep_cluster_name = dbcluster wsrep_sst_method=xtrabackup-v2 wsrep_sst_auth=root:password wsrep_node_name = db2 #wsrep_cluster_address=gcomm:// wsrep_cluster_address=gcomm://10.1.1.100:4567,10.1.1.100:4567 expire_logs_days = 10 max_binlog_size = 100M # replicate myisam #wsrep_replicate_myisam=1 [mysqldump] quick quote-names max_allowed_packet = 16M [mysql] [isamchk] key_buffer = 16M !includedir /etc/mysql/conf.d/

rsync: failed to set permissions on "."

Lastest Forum Posts - May 19, 2015 - 8:52pm
ubuntu 14.04 amd64
percona 5.6

why would rsync failed?

: rsync: failed to set permissions on "." (in rsync_sst): Operation not permitted (1) rsync: recv_generator: mkdir "FedTest" (in rsync_sst) failed: Permission denied (13) *** Skipping any contents from this failed directory *** rsync: open "ibdata1" (in rsync_sst) failed: Permission denied (13) 2015-05-20 11:45:12 13218 [Note] WSREP: (6b694432, 'tcp://0.0.0.0:4567') turning message relay requesting off rsync error: some files/attrs were not transferred (see previous errors) (code 23) at main.c(1183) [sender=3.1.0] WSREP_SST: [ERROR] rsync returned code 23: (20150520 11:45:12.039) 2015-05-20 11:45:12 13218 [ERROR] WSREP: Failed to read from: wsrep_sst_rsync --role 'donor' --address '10.1.1.101:4444/rsync_sst' --auth '(null)' --socket '/var/run/mysqld/mysqld.sock' --datadir '/var/lib/mysql/' --defaults-file '/etc/mysql/my.cnf' '' --gtid '19bf9b09-ed47-11e4-8005-f75eee435bfc:930436' 2015-05-20 11:45:12 13218 [ERROR] WSREP: Process completed with error: wsrep_sst_rsync --role 'donor' --address '10.1.1.101:4444/rsync_sst' --auth '(null)' --socket '/var/run/mysqld/mysqld.sock' --datadir '/var/lib/mysql/' --defaults-file '/etc/mysql/my.cnf' '' --gtid '19bf9b09-ed47-11e4-8005-f75eee435bfc:930436': 255 (Unknown error 255) db2:~$ grep sst_method /etc/mysql/my.cnf wsrep_sst_method=rsync db2:~$ sudo ls -l /var/lib/mysql lrwxrwxrwx 1 root root 12 Mei 19 12:36 /var/lib/mysql -> /mnt/db/db2/ db2:~$ sudo ls -l /var/lib/mysql/ total 2330648 -rw-rw---- 1 mysql mysql 56 Mei 20 11:09 auto.cnf -rw------- 1 mysql mysql 134219048 Mei 20 11:44 galera.cache -rw-rw---- 1 mysql mysql 104 Mei 20 11:44 grastate.dat -rw-rw---- 1 mysql mysql 104857600 Mei 20 11:44 ibdata1 -rw-rw---- 1 mysql mysql 1073741824 Mei 20 11:44 ib_logfile0 -rw-rw---- 1 mysql mysql 1073741824 Mei 20 11:09 ib_logfile1 /etc/mysql/my.cnf

: [client] port = 3306 socket = /var/run/mysqld/mysqld.sock [mysqld_safe] socket = /var/run/mysqld/mysqld.sock nice = 0 [mysqld] user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp lc-messages-dir = /usr/share/mysql federated skip-external-locking bind-address = 10.1.1.101 key_buffer = 24M tmp_table_size = 64M max_heap_table_size = 64M max_allowed_packet = 512M skip_name_resolve memlock sysdate_is_now=1 thread_cache_size = 512 query_cache_size = 0 table_open_cache=1024 lower_case_table_names=0 explicit_defaults_for_timestamp=1 log_error = /var/log/mysql.log binlog_format=ROW innodb_buffer_pool_size=94065M innodb_flush_log_at_trx_commit=2 innodb_file_per_table=1 innodb_data_file_path = ibdata1:100M:autoextend innodb_read_io_threads=4 innodb_write_io_threads=4 innodb_io_capacity=200 innodb_doublewrite=1 innodb_log_file_size=1024M innodb_log_buffer_size=96M innodb_buffer_pool_instances=8 innodb_log_files_in_group=2 innodb_thread_concurrency=64 innodb_flush_method = O_DIRECT innodb_autoinc_lock_mode=2 innodb_stats_on_metadata=0 default_storage_engine=innodb wsrep_provider=/usr/lib/libgalera_smm.so wsrep_cluster_name = dbcluster wsrep_sst_method=rsync wsrep_node_name = db2 wsrep_cluster_address=gcomm://10.1.1.101:4567,10.1.1.101:4567 expire_logs_days = 10 max_binlog_size = 100M [mysqldump] quick quote-names max_allowed_packet = 16M [mysql] [isamchk] key_buffer = 16M !includedir /etc/mysql/conf.d/

[Note] WSREP: cleanup transaction for LOCAL_STATE: COMMIT

Lastest Forum Posts - May 19, 2015 - 8:26am
Percona-Server-shared-51.x86_64 5.1.73-rel14.12.624.rhel6 @percona-release-x86_64
Percona-XtraDB-Cluster-56.x86_64 1:5.6.22-25.8.978.el6 @percona-release-x86_64
Percona-XtraDB-Cluster-client-56.x86_64 1:5.6.22-25.8.978.el6 @percona-release-x86_64
Percona-XtraDB-Cluster-galera-3.x86_64 3.9-1.3494.rhel6 @percona-release-x86_64
Percona-XtraDB-Cluster-server-56.x86_64 1:5.6.22-25.8.978.el6 @percona-release-x86_64
Percona-XtraDB-Cluster-shared-56.x86_64 1:5.6.22-25.8.978.el6 @percona-release-x86_64
percona-release.noarch 0.1-3 @percona
percona-toolkit.noarch 2.2.14-1 @percona-release-noarch
percona-xtrabackup.x86_64 2.2.10-1.el6 @percona-release-x86_64
percona-zabbix-templates.noarch 1.1.4-1 @percona-release-noarch


Following a crash of my cluster ( 2 nodes corrupted on the cluster of 3 nodes ) after a double hard disk failure
(No luck this time ... the I am not able to restore a copy of the database at the right point in time)

So I turn to community to seek for advice with this issue

My mysql error log get filled with such message ... and I wonder if there is a way to clean this.

2015-05-19 17:13:40 253025 [Note] WSREP: cleanup transaction for LOCAL_STATE: COMMIT
2015-05-19 17:13:40 253025 [Note] WSREP: cleanup transaction for LOCAL_STATE: SELECT dv.mandatory,dv.optional FROM dbversion dv
2015-05-19 17:13:40 253025 [Note] WSREP: cleanup transaction for LOCAL_STATE: SELECT n.* FROM nodes n WHERE n.nodetype=1 ORDER BY n.nodeid
2015-05-19 17:13:40 253025 [Note] WSREP: cleanup transaction for LOCAL_STATE: SELECT p.* FROM profiles p WHERE p.userid=4 ORDER BY p.userid,p.profileid
2015-05-19 17:13:40 253025 [Note] WSREP: cleanup transaction for LOCAL_STATE: SELECT p.* FROM profiles p WHERE p.userid=4 ORDER BY p.userid,p.profileid
2015-05-19 17:13:40 253025 [Note] WSREP: cleanup transaction for LOCAL_STATE: COMMIT
2015-05-19 17:13:40 253025 [Note] WSREP: cleanup transaction for LOCAL_STATE: COMMIT
2015-05-19 17:13:40 253025 [Note] WSREP: cleanup transaction for LOCAL_STATE: COMMIT
2015-05-19 17:13:40 253025 [Note] WSREP: cleanup transaction for LOCAL_STATE: SELECT c.* FROM config c
2015-05-19 17:13:40 253025 [Note] WSREP: cleanup transaction for LOCAL_STATE: SELECT p.* FROM profiles p WHERE p.userid=4 ORDER BY p.userid,p.profileid
2015-05-19 17:13:40 253025 [Note] WSREP: cleanup transaction for LOCAL_STATE: COMMIT
2015-05-19 17:13:40 253025 [Note] WSREP: cleanup transaction for LOCAL_STATE: COMMIT
2015-05-19 17:13:40 253025 [Note] WSREP: cleanup transaction for LOCAL_STATE: COMMIT
2015-05-19 17:13:40 253025 [Note] WSREP: cleanup transaction for LOCAL_STATE: SELECT p.* FROM profiles p WHERE p.userid=4 ORDER BY p.userid,p.profileid
2015-05-19 17:13:40 253025 [Note] WSREP: cleanup transaction for LOCAL_STATE: SELECT p.* FROM profiles p WHERE p.userid=4 ORDER BY p.userid,p.profileid
2015-05-19 17:13:40 253025 [Note] WSREP: cleanup transaction for LOCAL_STATE: COMMIT
2015-05-19 17:13:40 253025 [Note] WSREP: cleanup transaction for LOCAL_STATE: COMMIT
2015-05-19 17:13:40 253025 [Note] WSREP: cleanup transaction for LOCAL_STATE: COMMIT
2015-05-19 17:13:40 253025 [Note] WSREP: cleanup transaction for LOCAL_STATE: COMMIT
2015-05-19 17:13:40 253025 [Note] WSREP: cleanup transaction for LOCAL_STATE: COMMIT
2015-05-19 17:13:40 253025 [Note] WSREP: cleanup transaction for LOCAL_STATE: COMMIT
2015-05-19 17:13:40 253025 [Note] WSREP: cleanup transaction for LOCAL_STATE: SELECT COUNT(DISTINCT t.triggerid) AS cnt,t.status,t.value FROM triggers t WHERE NOT EXISTS (SELECT f.functionid FROM functions f JOIN items i ON f.itemid=i.itemid JOIN hosts h ON i.hostid=h.hostid WHERE f.triggerid=t.triggerid AND (i.status<>0 OR h.status<>0)) AND t.flags IN (0,4) GROUP BY t.status,t.value
2015-05-19 17:13:40 253025 [Note] WSREP: cleanup transaction for LOCAL_STATE: COMMIT
2015-05-19 17:13:40 253025 [Note] WSREP: cleanup transaction for LOCAL_STATE: COMMIT
2015-05-19 17:13:40 253025 [Note] WSREP: cleanup transaction for LOCAL_STATE: COMMIT

Like my MySQL QA series? Here’s how to record your own!

Latest MySQL Performance Blog posts - May 19, 2015 - 6:55am

Professional Screen Recording / Screencast Template 1280×720

Whilst not directly related to MySQL, it may be helpful to post (and open source at the same time) the HD screen recording/screencast template I’ve been using to create the MySQL QA series.

If you’ve never recorded a screencast before, or if you’d like to improve your screen recordings, this short blog post will get you started/help you along the way!

 

Here’s what you need;
1. Software Budget: $0 (Really! All required software is free, provided you have Microsoft Windows to use it on)
2. A reasonable quality headset. I can recommend (and use) a Microsoft LifeChat LX-3000 or similar (~$40)
3. The attached template (right-click the image above and select ‘Save Link/Image As…’ or similar)

Here’s how to get started;
1. Install Microsoft Visual C++ 2010 Redistributable Package (x86) from here.
2. Install CamStudio 2.7 or higher. CamStudio can be downloaded from http://camstudio.org/
3. Install CamStudioCodec 1.5 or higher (a good quality codec, available from the same website as in step 2).
4. Use a 1600×900 or higher screen resolution to match the template size (or you can also edit the template).
5. Set the Professional Screen Recording / Screencast Template (right click & save) as your background.
6. Make the settings/follow the instructions as per the template (tip: read everything first before you start).
7. You can scale your to-be-recorded window to match the black frame (and one of the settings as shown in the template makes CamStudio match the recording size exactly to that frame). The black frame ensures that any slight pixel-mismatch still shows nicely in the resulting video.
8. You may like to install a screen marking tool like DemoHelper or ScreenMarker.

If you followed the steps above you will have already covered the blue (top right) “Installation/use” steps nr’s 1-5, and you can now continue with the red steps 1-8 (and read the additional blue tips 1-4).

There’s quite a bit to it, but if you get it setup right the quality will be great!

I hope to see more technical how-to video’s on this and other blogs in the future!

Enjoy!

The post Like my MySQL QA series? Here’s how to record your own! appeared first on MySQL Performance Blog.

Multi master cluster question

Lastest Forum Posts - May 19, 2015 - 4:45am
Hello,

I apologize for the following question but I am starting out with XtraDB cluster.

I have a scenario where I run 4 servers with different sites (so 4 masters), now I need to add one server where all 4 databases would consolidate. I need the setup to be flexible where I could add more servers to replicate the database for Server2.

Also is it possible select which database gets replicated instead of the cluster trying to replicate everything?


Again, I apologize for the noob questions.

Schema change with manual RSU possible issues?

Lastest Forum Posts - May 19, 2015 - 3:18am

I have a setup with three percona cluster servers. I a doing some tests with online schema changes and i have a question regarding what happens when you drop a column on a schema change as this method requires the old/new schema change to be backwards compatible.

Assuming we have:

ServerA: Receives all traffic
ServerB: Synced
ServerC: Synced

You take out ServerC see from cluster, change OSU method to RSU, and you drop the column "comments" from "table1".
ServerC has any activities performed by the rest of the cluster cached in galera.cache. So when ServerC is brought back to cluster it will start executing the activity cached.

At this point, ServerA receives an insert to table "table1" which also inserts information in column "comments"

Now, when we add ServerC back to cluster, it will try to perform the above insert (since it is cached) in order to get synced with the rest of the cluster. Wouldn’t the above insert fail? I mean it will try to insert on a column that does not exists, right?

How can your schema be backwards compatible when you actually drop a column on the new schema?

garb open file(./gvwstate.dat.tmp) failed(Permission denied)

Lastest Forum Posts - May 18, 2015 - 10:55pm
when a node restarted its service, belwo warning message will appear

2015-05-19 12:35:28.097 WARN: open file(./gvwstate.dat.tmp) failed(Permission denied)

: $ ls -l /gvwstate.dat -rw-r--r-- 1 root root 265 Mei 13 06:31 /gvwstate.dat It is safe to ignore?

percona-xtradb-cluster-galera-3.x
Version: 3.9.3494.trusty

garb open file(./gvwstate.dat.tmp) failed(Permission denied)

Lastest Forum Posts - May 18, 2015 - 10:43pm
when a node restarted its service, belwo warning message will appear

2015-05-19 12:35:28.097 WARN: open file(./gvwstate.dat.tmp) failed(Permission denied)

: $ ls -l /gvwstate.dat -rw-r--r-- 1 root root 265 Mei 13 06:31 /gvwstate.dat It is safe to ignore?

percona-xtradb-cluster-galera-3.x
Version: 3.9.3494.trusty

Percona security update: oCERT and SSL improvements

Latest MySQL Performance Blog posts - May 18, 2015 - 10:56am

We have recently become a member of oCERT to aid in allowing responsible disclosure for Percona products and services as can be seen on their members page.

We are presently working on the verbiage for the responsible disclosure program, and we are also investigating establishing a bug bounty program. In the mean time you can refer to our security contact page which will be updated as more information becomes available.

Secondly as you have quiet possibly noticed www.percona.com now enforces SSL and requests are redirected to https://www.percona.com should a http request be made.

This is but one small part of the continuing security initiative here at Percona and one I am happy to finally announce completion of as it had been on the “list” for some time.

The current SSL configuration follows best practices such as those laid out in the Mozilla Security Server Side TLS wiki entry, and as such gains an A+ rating from Qualys’ SSLLabs.com

There are of course still improvements to be made, and we are incrementally deploying those as they are completed and pass QA which sometimes leads to unavoidable delays. I would like to thank isvsecwatch for their report (which came in near the end of the overhaul process) and their patience in the extended time it took to get it into production.

The post Percona security update: oCERT and SSL improvements appeared first on MySQL Performance Blog.

Broken pipe - MySQL 5.5 and tomcat6

Lastest Forum Posts - May 18, 2015 - 3:59am
Hi,
in a java application with tomcat6/jdbc and mysql5.5 i am having this error:

** BEGIN NESTED EXCEPTION **
java.net.SocketException
MESSAGE: Broken pipe
STACKTRACE:
java.net.SocketException: Broken pipe
at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite(SocketOutp utStream.java:92)
at java.net.SocketOutputStream.write(SocketOutputStre am.java:136)
at java.io.BufferedOutputStream.flushBuffer(BufferedO utputStream.java:65)
at java.io.BufferedOutputStream.flush(BufferedOutputS tream.java:123)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2744)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:16 12)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :1723)
at com.mysql.jdbc.Connection.execSQL(Connection.java: 3283)
ecc....ecc....

Restarting tomcat6 and mysql5.5 the error gone away?
I've googled and it seemes that tuning the wait_timeout/interactive_timeout in mysql could be a solution.
Do you have any experience with this type of error?
Any suggestion?

Thank you everyone
Alberto


Restoring an incremental backup

Lastest Forum Posts - May 18, 2015 - 3:46am
Hello all,

As I am new to Xtrabackup I am facing some difficulties on how to restore an incremental backup. In more details:

Step 1. Take a fll backup
#innobackupex --user=<user> --password=<pwd> /home/mysql_test/MYSQL_BACKUPS/

Step 2. Create an incremental backup
#innobackupex --incremental --user=<user> --password=<pwd> /home/mysql_test/MYSQL_BACKUPS/ --incremental- basedir=/home/mysql_test/MYSQL_BACKUPS/2015-05-14_15-55-09_FULL_BACKUP

where2015-05-14_15-55-09_FULL_BACKUP -> latest full backup

The above will create another dir under /home/mysql_test/MYSQL_BACKUPS/ with execution date e.g 2015-05-15_15-55-09_1st_INCREMENTAL_BACKUP

Step 3. Create another incremental backup:
#innobackupex --incremental --user=<user> --password=<pwd> /home/mysql_test/MYSQL_BACKUPS/ --incremental- basedir=/home/mysql_test/MYSQL_BACKUPS/2015-05-15_15-55-09_1st_INCREMENTAL_BACKUP

and this will create the next incremental backup: e.g 2015-05-16_15-55-09_2nd_INCREMENTAL_BACKUP

So up to now we have one full and 2 incremental backups under our backup directory:

/home/mysql_test/MYSQL_BACKUPS/
- 2015-05-14_15-55-09_FULL_BACKUP
- 2015-05-15_15-55-09_1st_INCREMENTAL_BACKUP

-2015-05-16_15-55-09_2nd_INCREMENTAL_BACKUP

Here is where I face my dificulties and need your help, how to restore one of my 2 incremental backups...

Based on https://www.percona.com/doc/percona-...obackupex.html before restoring an incremental backup we need to prepare it where I do:

Step 4. Prepare the incremental backup:
#innobackupex --apply-log --redo-only /home/mysql_test/MYSQL_BACKUPS/<???????>

Question 1. Which incremental I should use for this command, should I use this command for all the incrementals created above (1st... and 2nd...)

Question 2. After preparing my incremental backups (if this is what I have to do on Step 4) how do I restore one incremental backup e.g the latest one 2015-05-16_15-55-09_2nd_INCREMENTAL_BACKUP

Thank you all and looking forward for your suggestions
George

Galera synchronization broken

Lastest Forum Posts - May 16, 2015 - 3:23pm
Hi, I'm new to percona cluster and I need advice about shutting down of cluster nodes.
I have 2 nodes and this scenario:

1. Both servers A and B are running in cluster.
2. Server A performs normal shutdown. The seqno in grastate.dat is 1.
3. There are some writes on server B.
4. Server B performs normal shutdown. The seqno in grastate.dat is 2.
5. Server A is starting as a first node of the cluster.
6. There are some writes on server A.
7. Server B starts and joins the cluster. At this moment, the changes on each node aren't replicated to the other node and so data aren't consistent, although cluster doesn't log any error and is normally running.

I consider this scenario, because my customer wants to run cluster nodes as virtual guests in Microsoft Hyper-V on Windows, so I must suppose that he will perform updates and restarts on the host machine, and so the cluster nodes will be restarted without my control. I can add the third node to the cluster (propably Galera Arbitrator) to the cluster, but in will run on the same host as the node A, and so it isn't a solution.
Can you please advice me, how to avoid inconsistent data in this scenario?
Thanks and sorry for my English.
Thomas

WA TCH Pitch Perfect 2 SUB English ONLINE 2015 DOWNLOAD

Lastest Forum Posts - May 16, 2015 - 12:46pm

The official plot is: Pitch Perfect 2 will tell a new story: An Earth where peace has arrived. However, remnants of

VIDEO -> http://regionmovie.com/movies/5563-pitch-perfect-2
VIDEO -> http://regionmovie.com/movies/5563-pitch-perfect-2
VIDEO -> http://regionmovie.com/movies/5563-pitch-perfect-2


Pitch Perfect 2 Full Movie English SUb , Watch Pitch Perfect 2 HD, Watch Pitch Perfect 2 online

Putlocker, Watch Pitch Perfect 2 online Megashare, Watch Pitch Perfect 2 Movie online,Pitch Perfect 2

Pitch Perfect 2 2015 English Sub , Watch Pitch Perfect 2 2015 Movie Online Free. Watch Pitch Perfect 2 2015 .

Pitch Perfect 2 2015 Online on putlocker, viooz, megashare..

The official plot is: Pitch Perfect 2 will tell a new story: An Earth where peace has arrived. However, remnants of

balls.

Watch Pitch Perfect 2 Free,Pitch Perfect 2 2015 Full Movie Online, Watch Pitch Perfect 2

of F 2015 Full Movie ,Pitch Perfect 2 Movie Online ,Pitch Perfect 2 Download ,Dragon Ball Z:

Resurrection of F Full Movie ,Pitch Perfect 2 Online ,Pitch Perfect 2 Film ,Dragon Ball Z:

Resurrection of F Full Movie Online ,Pitch Perfect 2 Full Movie Stream ,Pitch Perfect 2 Watch Online

================================================== ============



Watch Pitch Perfect 2 †“ In a future where the population is divided by personality types, one woman branded "

Watch Pitch Perfect 2 " uncovers a conspiracy to eliminate all who bear her misfit †¦

Watch Pitch Perfect 2 Online Free The legit and trusted place to surely

Watch Pitch Perfect 2 Online Free on your computer in high definition quality without even having to spend a dime.

Watch Pitch Perfect 2 or Download Full Movie Online Diverget †¦

Watch Pitch Perfect 2 or Download Full Movie Online Diverget 2014. 7 likes · 2 talking about this.

Watch Pitch Perfect 2 or Download Full Movie Online Diverget 2014, High †¦

Watch Pitch Perfect 2 (2014) Free Online †“ OVGuide

Watch full length Watch Pitch Perfect 2 Movie for Free Online. Streaming Free Films to

Watch Online including Movie Trailers and Movie Clips.Official

Watch Pitch Perfect 2 Movie Watch Online Download HD Full

Watch Pitch Perfect 2 Movie Online, Download

Watch Pitch Perfect 2 Online,Pitch Perfect 2 Movie

Watch Pitch Perfect 2 Online Streaming

Watch Pitch Perfect 2 Full Movie Online

Watch Pitch Perfect 2 Full Movie Online

Watch Pitch Perfect 2 English Film Free Watch Online

Watch Pitch Perfect 2 English Film,

Watch Pitch Perfect 2 English Full Movie Watch Online

Watch Pitch Perfect 2 English Full Movie Watch Online

Watch Pitch Perfect 2 Watch Online

Watch Pitch Perfect 2 English Full Movie Watch Online

Watch Pitch Perfect 2 Watch Online, Watch Online Watch Pitch Perfect 2

Watch Pitch Perfect 2 English Full Movie Download

Watch Pitch Perfect 2 English Full Movie Free Download

Watch Pitch Perfect 2 English Full Movie Online Free Download

Watch Pitch Perfect 2 Free Download

Watch Pitch Perfect 2 HD Full Movie Online

Watch Pitch Perfect 2 HD English Full Movie Download

Watch Pitch Perfect 2 English Full Movie

Watch Pitch Perfect 2 Full Movie Online

Watch Pitch Perfect 2 Movie Online

Watch Pitch Perfect 2 English Full Movie Watch Online

Watch Pitch Perfect 2 Full Movie

Watch Pitch Perfect 2 Online

Watch Pitch Perfect 2 English Full Movie Watch Online

Watch Pitch Perfect 2 Movie Watch Online

Watch Pitch Perfect 2 English Full Movie

Watch Pitch Perfect 2 Full Movie,

Watch Pitch Perfect 2 Full Movie

Watch Pitch Perfect 2 English Full Movie Online

Watch Pitch Perfect 2 Film Online

Watch Pitch Perfect 2 English Film

Pitch Perfect 2 Full Movie English SUb , Watch Pitch Perfect 2 HD, Watch Pitch Perfect 2

of F online Putlocker, Watch Pitch Perfect 2 online Megashare, Watch Pitch Perfect 2 Movie

online,Pitch Perfect 2 2015 English Sub , Watch Pitch Perfect 2 2015 Movie Online Free. Watch Dragon

Perfect 2 2015 . Watch Pitch Perfect 2 2015 Online on putlocker, viooz, megashare..
TIME‎ -
-@DOWNLOAD-TORRENT Pitch Perfect 2 Online

W ATCH Piku Road FULL MOVIE

Lastest Forum Posts - May 16, 2015 - 12:46pm
Watch Piku Road 2015 Online Putlocker” Through Some ways over the internet that means legitimate ways to “watch Piku Road 2015 online Full movie” ultimate source to watch full movie and also sometimes free online. Have your say!! watch Piku Road 2015 movie is another amazing film released just right these two weeks ago and has made its impact on the box office by being on the top of most pirated movie list.
=®=®=®=®=®=.=.=.=.=.=.=.=.=.=.=.=.= .=.=.=.=.=.=®=®=®=®=®=
Click Here To Watch >>> http://1ststreammovie.com/movies/989644-piku
Click Here To Watch >>> http://1ststreammovie.com/movies/989644-piku
=®=®=®=®=®=.=.=.=.=.=.=.=.=.=.=.=.= .=.=.=.=.=.=®=®=®=®=®=
Piku Road Full Mov Online
Piku Road Full Mov Online
Piku Road English Film Free Watch Online
Piku Road English Film Free Watch Online
Piku Road English Film, Watch Piku Road English Full Mov Watch Online
Piku Road English Full Mov Watch Online
Piku Road Watch Online
Piku Road English Full Mov Watch Online
Piku Road Watch Online, Watch Online Watch Piku Road
Piku Road English Full Mov Download
Piku Road English Full Mov Free Download
Piku Road English Full Mov Online Free Download
Piku Road Free Download
Piku Road HD Full Mov Online
Piku Road HD English Full Mov Download

Issues trying to run Percona Server on Centos 7 with attached disk

Lastest Forum Posts - May 15, 2015 - 11:16pm

I am attempting to run Percona Server on CentOS 7 in a VM on Windows Azure. This is using an attached disk for the data storage.

Unfortunately when I try and get the server to start with the datadir being on the attached disk, it fails for the following reason:
May 16 06:05:20 pppudb6 mysqld_safe[50758]: /usr/bin/mysqld_safe: line 184: /datadrive/mysqldata/binlogs/udb6.log: Permission denied
May 16 06:05:20 pppudb6 mysqld_safe[50758]: touch: cannot touch ‘/datadrive/mysqldata/binlogs/udb6.log’: Permission denied
May 16 06:05:20 pppudb6 mysqld_safe[50758]: chown: cannot access ‘/datadrive/mysqldata/binlogs/udb6.log’: Permission denied
May 16 06:05:20 pppudb6 mysqld_safe[50758]: chmod: cannot access ‘/datadrive/mysqldata/binlogs/udb6.log’: Permission denied
May 16 06:05:20 pppudb6 mysqld_safe[50758]: 150516 06:05:20 mysqld_safe mysqld from pid file /var/lib/mysql/mysql.pid ended
May 16 06:05:20 pppudb6 mysqld_safe[50758]: /usr/bin/mysqld_safe: line 147: /datadrive/mysqldata/binlogs/udb6.log: Permission denied
May 16 06:05:20 pppudb6 systemd[1]: mysqld.service: main process exited, code=exited, status=1/FAILURE
May 16 06:08:54 pppudb6 systemd[1]: Stopping MySQL Percona Server...
May 16 06:08:54 pppudb6 systemd[1]: Stopped MySQL Percona Server.
May 16 06:08:54 pppudb6 systemd[1]: Unit mysqld.service entered failed state.


Permissions look fine as per:

drwxr-xr-x. 76 mysql mysql 4.0K May 15 03:48 2015-05-12_03-06-22 * This is the mysql data dir
drwxr-xr-x. 2 mysql mysql 4.0K May 15 04:36 binlogs * binlogs dir

Yet, when it attempts to run it says there is the permission issue. If I run it using default settings in /var/lib/mysql it works, just not on the attached disk which would be useful if I could get it to work!

Any ideas? I can get this to run fine on Ubuntu, but not on CentOS.

Duplicate post

Lastest Forum Posts - May 15, 2015 - 11:15pm
Duplicate post

Pages

Subscribe to Percona aggregator
]]>