]]>
]]>

You are here

Feed aggregator

OpenStack Live tutorials & sessions to bring OpenStack users up to speed

Latest MySQL Performance Blog posts - December 16, 2014 - 9:28am

I attended the OpenStack Paris summit last month (Percona had a booth there). It was my first opportunity to meet face-to-face with this thriving community of developers and users. I’m proud that Percona is part of this open source family and look forward to reconnecting with many of the developers and users I met in Paris – as well as meeting new faces – at OpenStack Live in Silicon Valley April 13-14.

OpenStack summits, generally held twice a year, are the place where (for the most part) developers meet and design “in the open,” as the OpenStack organization says. OpenStack Live 2015, held in parallel with the annual Percona Live MySQL Conference and Expo, will be a unique opportunity for users and enthusiasts to learn from leading OpenStack experts in the field about top cloud strategies, improving overall cloud performance, and operational best practices for managing and optimizing OpenStack and its MySQL database core.

OpenStack Live will also provide some serious classroom-style learning. Percona announced the OpenStack Live tutorials sessions a couple days ago. Most sessions are three hours long and because they really are “hands-on” require that you bring your laptop – and a power cord (not to be confused with a “power chord,” though those also welcome”).

Let’s take a closer look at the OpenStack Live tutorial sessions.

Barbican: Securing Your Secrets.” Join Rackspace gurus Douglas Mendizábal, Chelsea Winfree and Steve Heyman on a tour through the magical world of Barbican (yes, they are dedicated members of the Barbican project).

Don’t be intimidated if don’t have any previous experience with Barbican (and if you’ve never heard of it, more the reason to attend!). A basic understanding of security components (such as keys and certificates) and a basic understanding of ReST is helpful, but not required.

By the end of the class you will know:
1)   Importance of secret storage
2)   How to store & retrieve secrets with Barbican
3)   How to submit an order with Barbican
4)   How to create a container
5)   Use cases for Barbican / Examples
6)   The future of Barbican –Ordering SSL Certs

Deploying, Configuring and Operating OpenStack Trove.” As the title suggests, these three hours focus squarely on Trove. The tutorial – led by Tesora founder & CTO Amrith Kumar, along with Doug Shelley, the company’s vice president of product development – will begin with a quick overview of OpenStack and the various services.

If you attend this tutorial you’ll actually deploy your own OpenStack environment – and create and manage a Nova (compute) instance using a command line and a graphical user interface (Horizon). And the fun continues! You’ll then install and configure Trove, and create and manage a single MySQL instance. Finally, pupils will create and operate a simple replicated MySQL instance pair and ensure that data is being properly replicated from master to slave.

Essential DevStack.” DevStack is an opinionated script to quickly create an OpenStack development environment. It can also be used to demonstrate starting/running OpenStack services and provide examples of using them from a command line. The power of DevStack lies within small trick that if people understand can hugely improve the contribution effectiveness, quality and required time. This three-hour tutorial will be led by Red Hat senior software engineer Swapnil Kulkarni.

OpenStack Networking Introduction,” with PLUMgrid’s Valentina Alaria and Brendan Howes. Buckle your seat belts! Designed for IT professionals looking to expand their OpenStack “networking” (no, not the LinkedIn sort of networking) knowledge, OpenStack Networking Fundamentals will be a comprehensive and fast-paced course.

This half-day training provides an overview of OpenStack, its components and then dives deep into OpenStack Networking – the features and plugin model and its role in building an OpenStack Cloud. The training is concluded with a hands-on lab to bring all the concepts together.

OpenStack Networking (Neutron) Introduction [1 hour]
– Goal of Neutron
– Architecture of Neutron
– Plugin Architecture
– Use cases for Neutron
– What’s new in Juno & what’s planned for Kilo

OpenStack Networking (Neutron) Advanced [1 hour]
– Interaction with other OpenStack components (Compute & Storage)
– Designing Neutron for HA
– Installing Neutron
– Troubleshooting Neutron

Hands-on Lab [1 hour]
– Creation of tenant networks
– Configuration of external connectivity
– Advanced Features Configurati

Percona’s director of conferences, Kortney Runyan, offered a sneak peek at the OpenStack sessions last week. Attendees of the Percona Live MySQL Conference and Expo 2015 (April 13-16, 2015) with full-pass access are also welcome to attend OpenStack Live sessions. The two conferences are running in parallel, which is very exciting since there will be crossover opportunities between them.

I hope to see you next April! And be sure to take advantage of Early Bird pricing for OpenStack Live (register here).
And if you are an organizer of an OpenStack (or MySQL) Meetup and need some financial help, Percona is happy to chip in as a sponsor. Just let me know and I’ll work with you to set that up! You can drop me a note in the comments and I’ll contact you offline.

The post OpenStack Live tutorials & sessions to bring OpenStack users up to speed appeared first on MySQL Performance Blog.

Which vision is to merge art and poetr

Lastest Forum Posts - December 16, 2014 - 9:15am
http://www.invisionpower.ro/topic/49...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/

Which vision is to merge art and poetr

Lastest Forum Posts - December 16, 2014 - 9:00am
http://www.invisionpower.ro/topic/49...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/
http://www.invisionpower.ro/topic/50...li-ne-hd1080p/

Backup fails with InnoDB: Operating system error number 0

Lastest Forum Posts - December 16, 2014 - 3:19am
Hi,

I was just trying to take hot backup with innobackupex but I get a read error whilst innobackupex is trying to scan the logfiles - strangely though the failure is an Error 0 which is reported as a success:

: xtrabackup_55 version 1.6.3 for Percona Server 5.5.9 Linux (x86_64) (revision id: undefined) xtrabackup: uses posix_fadvise(). xtrabackup: cd to /var/lib/mysql 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 = 5242880 141216 10:59:08 InnoDB: Using Linux native AIO 141216 10:59:08 InnoDB: Warning: allocated tablespace 53, old maximum was 9 >> log scanned up to (1221137553871) [01] Copying ./ibdata1 to /home/nick/2014-12-16_10-59-04/ibdata1 >> log scanned up to (1221137615178) >> log scanned up to (1221137624351) >> log scanned up to (1221137650292) InnoDB: Error: tried to read 1048576 bytes at offset 0 534773760. InnoDB: Was only able to read 40960. 141216 11:00:15 InnoDB: Operating system error number 0 in a file operation. InnoDB: Error number 0 means 'Success'. InnoDB: Some operating system error numbers are described at InnoDB: http://dev.mysql.com/doc/refman/5.5/en/operating-system-error-codes.html InnoDB: File operation call: 'read'. InnoDB: Cannot continue operation. innobackupex: Error: ibbackup child process has died at /usr/bin/innobackupex line 336. Can anyone shed any light on what causes this? MySQL is using this Inno DB normally without any apparent errors, and starts up and shuts down normally when required, so I was assuming that the integrity of the data files + logs was ok, but perhaps not? Is this a known issue with xtrabackup? Is there a workaround or some way to get more information on this issue?

Thanks,

Nick

Recovering / Restoring a single database with Xtrabackup

Lastest Forum Posts - December 15, 2014 - 11:23pm
Hi ,

Is it possible to recovery / restore a single database using xtrabackup ?

Thanks & Regards
Raghupradeep

Recovering / Restoring a single database with Xtrabackup

Lastest Forum Posts - December 15, 2014 - 11:18pm
Hi ,

Is it possible to recovery / restore a single database using xtrabackup ?

Thanks & Regards
Raghupradeep

Can not build cluster

Lastest Forum Posts - December 15, 2014 - 10:49am
Hi
I have two nodes on Ubuntu 12.04 Server 64 bit

When i bootstrap first node, in error log i can see

[Warning] WSREP: access file(gvwstate.dat) failed(No such file or directory)

but it is start

When i start second node

I can see that errors in log
[Warning] WSREP: access file(gvwstate.dat) failed(No such file or directory)
[Warning] WSREP: (5b571936, 'tcp://0.0.0.0:4567') address 'tcp://10.1.1.13:4567' points to own listening address, blacklisting
[Warning] WSREP: Gap in state sequence. Need state transfer.
[Warning] WSREP: Failed to prepare for incremental state transfer: Local state UUID (00000000-0000-0000-0000-000000000000) does not match group state UUID (2f13e6f3-845d-11e4-a92a-1353578a748d): 1 (Operation not permitted)
[Warning] WSREP: 1.0 (xtradb1): State transfer to 0.0 (xtradb2) failed: -22 (Invalid argument)
[ERROR] WSREP: gcs/src/gcs_group.cpp:int gcs_group_handle_join_msg(gcs_group_t*, const gcs_recv_msg_t*)():722: Will never receive state. Need to abort.
[ERROR] WSREP: Process completed with error: wsrep_sst_xtrabackup-v2 --role 'joiner' --address '10.1.1.13' --auth 'sstuser:s3cretPass' --datadir '/var/lib/mysql/' --defaults-file '/etc/mysql/my.cnf' --parent '20901' '' : 1 (Operation not permitted)
[ERROR] WSREP: Failed to read uuid:seqno from joiner script.
[ERROR] WSREP: SST failed: 1 (Operation not permitted)
[ERROR] Aborting




Percona Xtradb Cluster version is 5.6.21-25.8-938.precise on two nodes

Config on first node
skip-name-resolve

explicit_defaults_for_timestamp=TRUE
wsrep_provider=/usr/lib/libgalera_smm.so
wsrep_provider_options = 'socket.checksum = 1;'
#wsrep_cluster_address=gcomm://10.1.1.12,10.1.1.13
wsrep_cluster_address=gcomm://
wsrep_slave_threads = 96
binlog_format=ROW
default_storage_engine=InnoDB
innodb_autoinc_lock_mode=2
wsrep_node_address=10.1.1.12
wsrep_node_name=xtradb1
wsrep_sst_method=xtrabackup-v2
wsrep_cluster_name=stalker_db_cluster
wsrep_sst_auth="sstuser:s3cretPass"




Config on second node

skip-name-resolve

explicit_defaults_for_timestamp=TRUE
wsrep_provider=/usr/lib/libgalera_smm.so
wsrep_provider_options = 'socket.checksum = 1;'
wsrep_cluster_address=gcomm://10.1.1.12,10.1.1.13
#wsrep_cluster_address=gcomm://
wsrep_slave_threads = 96
binlog_format=ROW
default_storage_engine=InnoDB
innodb_autoinc_lock_mode=2
wsrep_node_address=10.1.1.13
wsrep_node_name=xtradb2
wsrep_sst_method=xtrabackup-v2
wsrep_cluster_name=stalker_db_cluster
wsrep_sst_auth="sstuser:s3cretPass"




What is WRONG ?

I alredy have 3 working well clusters on previos version of percona cluster ?
What is wrong with new one ?

Can someone help ?

Strange behaviour on partitioned table (Percona Server 5.5.36)

Lastest Forum Posts - December 15, 2014 - 5:34am
This one's really got me. Maybe it's a bug. Ideas anyone? See below...

We have a table with the following partition scheme (example names and values):

: PARTITION BY LIST COLUMNS(`owner`) SUBPARTITION BY HASH(CASE WHEN (`foo`+`bar`) < 1 THEN 0 ELSE 1 END) SUBPARTITIONS 2 ( PARTITION p0 VALUES IN('A','B','C','D','E','F','G'), PARTITION p1 VALUES IN('H'), PARTITION p2 VALUES IN('I','J'), PARTITION p3 VALUES IN('K') ); N.B. the A,B,C, etc. values above are only examples. The real table has strings that represent the owner of the row. There are over 3m rows.

We should end up with a partition that has all the foo+bar = 0 values owned by A through G as the first subpartition of partition p0.

We get the following output from SELECT owner,COUNT(*) FROM maintable GROUP BY owner;:

: +----------+----------+ | owner | COUNT(*) | +----------+----------+ | H | 2077675 | | B | 138243 | | I | 13333 | | C | 26507 | | A | 806889 | | K | 134 | | E | 38165 | | D | 14118 | +----------+----------+ There are no values for F, G or J.

Now when I run SELECT COUNT(*) FROM maintable WHERE owner = 'A';, I get zero.

If I change the list to IN('A','B','C','D','E','F','G') then I get the expected result. If I omit G, I get the correct result. If I omit F and G from the list, it goes back to zero. Whaaaaat?

I've tested this on 5.6 on another server with a subset of the data, and it is fine, with the additional feature of selecting directly from p0, etc.

Anyone ever seen anything like this? Am I missing something? Let me know if you want to know any variables.

--
Sam

MySQL Tutorials: A time to learn at Percona Live 2015

Latest MySQL Performance Blog posts - December 15, 2014 - 12:00am

The many hours of intensive tutorials, led by some of the top minds in MySQL, have always been a major draw each year to the Percona Live MySQL Conference and Expo. And 2015’s event will be no exception.

Percona Live 2015 runs April 13-16 in Santa Clara, Calif. and the first day is dedicated to the classroom – so bring your laptops for the combined 45 hours of learning. MySQL tutorials are included with the full-conference pass but a “tutorial-only pass” is also available. Super-saver registration discounts have been extended until Dec. 19. Here’s a look at this year’s tutorials lineup. (There will be a couple more announced in January).

And that’s just on Monday! There will be much more over the four days of the Percona Live MySQL Conference and Expo 2015. Percona conference director Kortney Runyan shared a sneak peek at the full schedule a few days ago. And remember, super-saver registration discounts have been extended until Dec. 19 so register now – and don’t forgot your laptop (and power cord)!

The post MySQL Tutorials: A time to learn at Percona Live 2015 appeared first on MySQL Performance Blog.

Can't join second node (rsync)

Lastest Forum Posts - December 14, 2014 - 6:33pm
After bootstrapping nodeA, nodeB fails to start because it can't SST
Using rsync
Tried 5.6.21 and reverted to 5.6.20 with dsame result

2014-12-14 21:41:40 9277 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 1)
2014-12-14 21:41:40 9277 [Note] WSREP: State transfer required:
Group state: cc13f472-83fa-11e4-8ea3-138a7ef719a7:1
Local state: 00000000-0000-0000-0000-000000000000:-1
2014-12-14 21:41:40 9277 [Note] WSREP: New cluster view: global state: cc13f472-83fa-11e4-8ea3-138a7ef719a7:1, view# 4: Primary, number of nodes: 2, my index: 1, protocol version 3
2014-12-14 21:41:40 9277 [Warning] WSREP: Gap in state sequence. Need state transfer.
2014-12-14 21:41:40 9277 [Note] WSREP: Running: 'wsrep_sst_rsync --role 'joiner' --address '10.10.1.62' --auth '' --datadir '/var/lib/mysql/' --defaults-file '/etc/my.cnf' --parent '9277' '' '
2014-12-14 21:41:40 9277 [Note] WSREP: Prepared SST request: rsync|10.10.1.62:4444/rsync_sst
2014-12-14 21:41:40 9277 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2014-12-14 21:41:40 9277 [Note] WSREP: REPL Protocols: 6 (3, 2)
2014-12-14 21:41:40 9277 [Note] WSREP: Service thread queue flushed.
2014-12-14 21:41:40 9277 [Note] WSREP: Assign initial position for certification: 1, protocol version: 3
2014-12-14 21:41:40 9277 [Note] WSREP: Service thread queue flushed.
2014-12-14 21:41:40 9277 [Warning] WSREP: Failed to prepare for incremental state transfer: Local state UUID (00000000-0000-0000-0000-000000000000) does not match group state UUID (cc13f472-83fa-11e4-8ea3-138a7ef719a7): 1 (Operation not permitted)
at galera/src/replicator_str.cpprepare_for_IST():456. IST will be unavailable.
2014-12-14 21:41:40 9277 [Note] WSREP: Member 1.0 (nodeB) requested state transfer from '*any*'. Selected 0.0 (nodeA)(SYNCED) as donor.
2014-12-14 21:41:40 9277 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 1)
2014-12-14 21:41:40 9277 [Note] WSREP: Requesting state transfer: success, donor: 0
2014-12-14 21:41:40 9277 [Warning] WSREP: 0.0 (nodeA): State transfer to 1.0 (nodeB) failed: -255 (Unknown error 255)
2014-12-14 21:41:40 9277 [ERROR] WSREP: gcs/src/gcs_group.cpp:int gcs_group_handle_join_msg(gcs_group_t*, const gcs_recv_msg_t*)():722: Will never receive state. Need to abort.
2014-12-14 21:41:40 9277 [Note] WSREP: gcomm: terminating thread
2014-12-14 21:41:40 9277 [Note] WSREP: gcomm: joining thread
2014-12-14 21:41:40 9277 [Note] WSREP: gcomm: closing backend
2014-12-14 21:41:41 9277 [Note] WSREP: view(view_id(NON_PRIM,dcb11fa5,4) memb {
e50b4be3,0
} joined {
} left {
} partitioned {
dcb11fa5,0
})
2014-12-14 21:41:41 9277 [Note] WSREP: view((empty))
2014-12-14 21:41:41 9277 [Note] WSREP: gcomm: closed
2014-12-14 21:41:41 9277 [Note] WSREP: /usr/sbin/mysqld: Terminated.
141214 21:41:41 mysqld_safe mysqld from pid file /var/lib/mysql/mysqlb.pid ended
WSREP_SST: [ERROR] Parent mysqld process (PID:9277) terminated unexpectedly. (20141214 21:41:42.237)
WSREP_SST: [INFO] Joiner cleanup. (20141214 21:41:42.239)
WSREP_SST: [INFO] Joiner cleanup done. (20141214 21:41:42.746)

2006 MySQL server has gone away

Lastest Forum Posts - December 14, 2014 - 1:53pm
Hi,
In the last couple of weeks we have been experiencing a 2006 MySQL server has gone away error intermittently on our servers, to allow connections again we run "FLUSH TABLES". (we have this running on a cron to maintain stability at the moment)

We have upgraded to from MySQL 5.6.5 to MySQL 5.6.22 and switched now to Percona 5.6.21-70.

Server Mac Mini Core i7 16GB RAM 512GB Enterprise SSD.


ulimit -a
core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
max locked memory (kbytes, -l) unlimited
max memory size (kbytes, -m) unlimited
open files (-n) 16384
pipe size (512 bytes, -p) 1
stack size (kbytes, -s) 8192
cpu time (seconds, -t) unlimited
max user processes (-u) 512
virtual memory (kbytes, -v) unlimited

uptime
8:45 up 1 day, 15:55, 2 users, load averages: 0.49 0.32 0.31

NB - This config has been tinkered with by many people over the years - My hunch is the problem lays within here...
This is used in MM Replication environment.











Cluster dos not synchronized

Lastest Forum Posts - December 14, 2014 - 9:44am
Hi
I have two nodes with version 5.6.21-25.8-938.precise

| wsrep_local_state | 4 |
| wsrep_local_state_comment | Synced |
| wsrep_cert_index_size | 91 |
| wsrep_causal_reads | 0 |
| wsrep_cert_interval | 0.000022 |
| wsrep_incoming_addresses | 10.1.1.12:3306,10.1.1.13:3306 |
| wsrep_evs_delayed | |
| wsrep_evs_evict_list | |
| wsrep_evs_repl_latency | 0/0/0/0/0 |
| wsrep_evs_state | OPERATIONAL |
| wsrep_gcomm_uuid | 87ae0011-83ab-11e4-9fc0-d65c844c8cea |
| wsrep_cluster_conf_id | 30 |
| wsrep_cluster_size | 2 |
| wsrep_cluster_state_uuid | 1abb2b3e-82ff-11e4-824a-a24ee1e11d16 |
| wsrep_cluster_status | Primary |
| wsrep_connected | ON |
| wsrep_local_bf_aborts | 0 |
| wsrep_local_index | 0 |
| wsrep_provider_name | Galera |
| wsrep_provider_vendor | Codership Oy <info@codership.com> |
| wsrep_provider_version | 3.8(rf6147dd) |
| wsrep_ready | ON |



clustercheck says

clustercheck root pass
HTTP/1.1 200 OK
Content-Type: text/plain
Connection: close
Content-Length: 40

Percona XtraDB Cluster Node is synced.



But second node dos not have one table in database

and in error log i see

2014-12-14 18:35:44 53445 [Warning] InnoDB: Cannot open table test_db/all_cities from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/...eshooting.html for how you can resolve the problem.


also that
[Warning] WSREP: access file(gvwstate.dat) failed(No such file or directory)


from config:

explicit_defaults_for_timestamp=TRUE
wsrep_provider=/usr/lib/libgalera_smm.so
#wsrep_provider_options = 'pc.ignore_sb = true'
#wsrep_provider_options = 'socket.checksum = 1;'
wsrep_cluster_address=gcomm://10.1.1.12,10.1.1.13
#wsrep_cluster_address=gcomm://
wsrep_slave_threads = 128
binlog_format=ROW
default_storage_engine=InnoDB
innodb_autoinc_lock_mode=2
wsrep_node_address=10.1.1.12
wsrep_node_name=xtradb1
wsrep_sst_method=xtrabackup-v2
wsrep_cluster_name=test_db_cluster
wsrep_sst_auth="sstuser:s3cretPass"




I have now working well other cluster with 10 nodes
There is version 5.6.20-25.7-886.precise

What is different betwen new version and previos ?
Something changed in config ?

How can i install previos worked version ?

Thank you

Which vision is to merge art and poetr

Lastest Forum Posts - December 14, 2014 - 7:39am
http://www.rup.co.il/wnthdprntthe-le...tch-li-ne-720p
http://www.rup.co.il/wnthdprnthawaii...tch-li-ne-720p
http://www.rup.co.il/wnthdprntblue-b...tch-li-ne-720p
http://www.rup.co.il/wnthdprntthe-x-...tch-li-ne-720p
http://www.rup.co.il/wnthdprntcasual...tch-li-ne-720p
http://www.rup.co.il/wnthdprntthe-ul...tch-li-ne-720p
http://www.rup.co.il/wnthdprntsaturd...tch-li-ne-720p
http://www.rup.co.il/wnthdprntone-pi...tch-li-ne-720p
http://www.rup.co.il/wnthdprntthe-x-...tch-li-ne-720p
http://www.rup.co.il/wnthdprntbobs-b...tch-li-ne-720p
http://www.rup.co.il/wnthdprntthe-li...tch-li-ne-720p
http://www.rup.co.il/wnthdprntonce-u...tch-li-ne-720p
http://www.rup.co.il/wnthdprntbrookl...tch-li-ne-720p
http://www.rup.co.il/wnthdprntthe-ne...tch-li-ne-720p
http://www.rup.co.il/wnthdprnthomela...tch-li-ne-720p
http://www.rup.co.il/wnthdprntthe-me...tch-li-ne-720p
http://www.rup.co.il/wnthdprntthe-af...tch-li-ne-720p
http://www.rup.co.il/wnthdprntthe-co...tch-li-ne-720p
http://www.rup.co.il/wnthdprntlost-g...tch-li-ne-720p
http://www.rup.co.il/wnthdprntcsi-se...tch-li-ne-720p
http://www.rup.co.il/wnthdprntgettin...tch-li-ne-720p
http://www.rup.co.il/wnthdprnt4-oclo...tch-li-ne-720p
http://www.rup.co.il/wnthdprnthollyo...tch-li-ne-720p
http://www.rup.co.il/wnthdprntthe-bo...tch-li-ne-720p
http://www.rup.co.il/wnthdprntgenera...tch-li-ne-720p
http://www.rup.co.il/wnthdprnteasten...tch-li-ne-720p
http://www.rup.co.il/wnthdprntcorona...tch-li-ne-720p
http://www.rup.co.il/wnthdprntcorona...tch-li-ne-720p
http://www.rup.co.il/wnthdprntsome-g...tch-li-ne-720p
http://www.rup.co.il/wnthdprntnever-...tch-li-ne-720p

http://www.rup.co.il/wnthdprntno-goo...tch-li-ne-720p
http://www.rup.co.il/wnthdprntpengui...tch-li-ne-720p
http://www.rup.co.il/wnthdprntthe-th...tch-li-ne-720p
http://www.rup.co.il/wnthdprntbirdman-w-atch-li-ne-720p
http://www.rup.co.il/wnthdprntget-sa...tch-li-ne-720p
http://www.rup.co.il/wnthdprntblack-...tch-li-ne-720p
http://www.rup.co.il/wnthdprntthe-py...tch-li-ne-720p
http://www.rup.co.il/wnthdprntst-vin...tch-li-ne-720p
http://www.rup.co.il/wnthdprntthe-gr...tch-li-ne-720p
http://www.rup.co.il/wnthdprntaction...tch-li-ne-720p
http://www.rup.co.il/wnthdprntmea-cu...tch-li-ne-720p
http://www.rup.co.il/wnthdprntopen-b...tch-li-ne-720p
http://www.rup.co.il/wnthdprntwild-2...tch-li-ne-720p
http://www.rup.co.il/wnthdprntzero-m...tch-li-ne-720p
http://www.rup.co.il/wnthdprntpioneer-w-atch-li-ne-720p
http://www.rup.co.il/wnthdprntcomet-w-atch-li-ne-720p
http://www.rup.co.il/wnthdprntlife-p...tch-li-ne-720p
http://www.rup.co.il/wnthdprntshes-b...tch-li-ne-720p
http://www.rup.co.il/wnthdprntthe-hu...tch-li-ne-720p
http://www.rup.co.il/wnthdprntimitat...tch-li-ne-720p
http://www.rup.co.il/wnthdprntnativi...tch-li-ne-720p
http://www.rup.co.il/wnthdprnt2001-s...tch-li-ne-720p
http://www.rup.co.il/wnthdprnthorrib...tch-li-ne-720p
http://www.rup.co.il/wnthdprnti-am-a...tch-li-ne-720p
http://www.rup.co.il/wnthdprntpaddin...tch-li-ne-720p
http://www.rup.co.il/wnthdprntfrozen-w-atch-li-ne-720p
http://www.rup.co.il/wnthdprntfoxcat...tch-li-ne-720p
http://www.rup.co.il/wnthdprntdumb-a...tch-li-ne-720p
http://www.rup.co.il/wnthdprntinters...tch-li-ne-720p
http://www.rup.co.il/wnthdprntbig-he...tch-li-ne-720p
http://www.rup.co.il/wnthdprntjessab...tch-li-ne-720p
http://www.rup.co.il/wnthdprntthe-be...tch-li-ne-720p
http://www.rup.co.il/wnthdprntnation...tch-li-ne-720p
http://www.rup.co.il/wnthdprntnightc...tch-li-ne-720p
http://www.rup.co.il/wnthdprntouija-w-atch-li-ne-720p
http://www.rup.co.il/wnthdprntjohn-w...tch-li-ne-720p
http://www.rup.co.il/wnthdprntfury-w-atch-li-ne-720p
http://www.rup.co.il/wnthdprntthe-be...tch-li-ne-720p
http://www.rup.co.il/wnthdprntthe-bo...tch-li-ne-720p
http://www.rup.co.il/wnthdprntdracul...tch-li-ne-720p
http://www.rup.co.il/wnthdprntgone-g...tch-li-ne-720p
http://www.rup.co.il/wnthdprntno-goo...h-li-ne-720p-0

Not possible for JOINER TO join the Cluster

Lastest Forum Posts - December 12, 2014 - 9:30am
Folks, how are you all? I need some help here, the story is as follows...

Some time ago I implemented a XtraDB Cluster using the packages on version 5.6.20-68.0-56-log. This cluster's version has four nodes and it's in production, running very well with no problems at all. I've got another one running version 5.5.39 with the same configuration files on all the four nodes and no problems to implement the cluster (considering out some variables presented below for 5.6).

On both scenarios, the setup sequence was the same: to get the Percona Repository installed on CentOS 6.5 machines, install the Percona-XtraDB-Cluster-56 and xtrabackup as well (just for a double check).

[wb@textenv-node01 ~]$ sudo yum -y install Percona-XtraDB-Cluster-56 percona-xtrabackup
[wb@textenv-node02 ~]$ sudo yum -y install Percona-XtraDB-Cluster-56 percona-xtrabackup
[wb@textenv-node03 ~]$ sudo yum -y install Percona-XtraDB-Cluster-56 percona-xtrabackup

Configuration files were created with the following basic configs:

#
#: arquivo configuração, nó # 1
#
[mysqld]
user=mysql
server_id=1
datadir=/var/lib/mysql
log_bin=node01-bin
binlog_format=ROW
log_slave_updates=true
enforce_gtid_consistency=true
default_storage_engine=innodb
innodb_locks_unsafe_for_binlog=1
innodb_autoinc_lock_mode=2
innodb_log_group_home_dir=/var/lib/mysql
innodb_log_files_in_group=2
innodb_log_file_size=2G
#: wsrep variables
wsrep_provider=/usr/lib64/libgalera_smm.so
wsrep_cluster_name=mycluster
wsrep_node_address=192.168.0.101
wsrep_node_name=node01
wsrep_cluster_address=gcomm://192.168.0.101:4567,192.168.0.102:4567,192.168.0.10 3:4567, 192.168.0.104:4567
wsrep_slave_threads=2
wsrep_sst_method=xtrabackup
wsrep_sst_auth=sst:123

#
#: arquivo configuração, nó # 2
#
[mysqld]
user=mysql
server_id=2
datadir=/var/lib/mysql
log_bin=node02-bin
binlog_format=ROW
log_slave_updates=true
enforce_gtid_consistency=true
default_storage_engine=innodb
innodb_locks_unsafe_for_binlog=1
innodb_autoinc_lock_mode=2
innodb_log_group_home_dir=/var/lib/mysql
innodb_log_files_in_group=2
innodb_log_file_size=2G
#: wsrep variables
wsrep_provider=/usr/lib64/libgalera_smm.so
wsrep_cluster_name=mycluster
wsrep_node_address=192.168.0.102
wsrep_node_name=node02
wsrep_cluster_address=gcomm://192.168.0.101:4567,192.168.0.102:4567,192.168.0.10 3:4567, 192.168.0.104:4567
wsrep_slave_threads=2
wsrep_sst_method=xtrabackup
wsrep_sst_auth=sst:123

#
#: arquivo configuração, nó # 3
#
[mysqld]
user=mysql
server_id=3
datadir=/var/lib/mysql
log_bin=node03-bin
binlog_format=ROW
default_storage_engine=innodb
innodb_locks_unsafe_for_binlog=1
innodb_autoinc_lock_mode=2
innodb_log_group_home_dir=/var/lib/mysql
innodb_log_files_in_group=2
innodb_log_file_size=2G
#: wsrep variables
wsrep_provider=/usr/lib64/libgalera_smm.so
wsrep_cluster_name=mycluster
wsrep_node_address=192.168.0.103
wsrep_node_name=node03
wsrep_cluster_address=gcomm://192.168.0.101:4567,192.168.0.102:4567,192.168.0.10 3:4567, 192.168.0.104:4567
wsrep_slave_threads=2
wsrep_sst_method=xtrabackup
wsrep_sst_auth=sst:123

#
#: arquivo de configuração, nó # 4
#
[mysqld]
user=mysql
datadir=/var/lib/mysql
server_id=4
log_bin=node04-bin
binlog_format=ROW
log_slave_updates
default_storage_engine=innodb
innodb_locks_unsafe_for_binlog=1
innodb_autoinc_lock_mode=2
innodb_log_group_home_dir=/var/lib/mysql
innodb_log_files_in_group=2
innodb_log_file_size=2G
#: wsrep variables
wsrep_provider=/usr/lib64/libgalera_smm.so
wsrep_cluster_address=gcomm://192.168.0.101:4567,192.168.0.102:4567,192.168.0.10 3:4567, 192.168.0.104:4567
wsrep_cluster_name=mycluster
wsrep_node_name=node04
wsrep_node_address=192.168.0.104
wsrep_sst_method=xtrabackup
wsrep_sst_auth=sst:123

The cluster is running as I said...

[root@node01 ~]$ mysql -u root -pxxxxxxx -e "show status like 'wsrep_cluster_size'"
+--------------------+-------+
| Variable_name | Value |
+--------------------+-------+
| wsrep_cluster_size | 4 |
+--------------------+-------+

So, with those configuration files, I started a new project, but now to test the version Ver 5.6.21-70.1-56. I simple copied all the configuration I have currently running very well as showed previously. The new version I'm testing is:

[root@testenv-node01 ~]$ mysqld --version
mysqld Ver 5.6.21-70.1-56 for Linux on x86_64 (Percona XtraDB Cluster (GPL), Release rel70.1, Revision 938, WSREP version 25.8, wsrep_25.8.r4150)

The bootstrap was OK, but the second node is not joining the cluster even having the SST completing with an OK message at the end (gotten from the innobackup.backup.log).

[root@testenv-node01 ~]$ sudo tail -f /var/lib/mysql/innobackup.backup.log
xtrabackup: Transaction log of lsn (1627264) to (1627264) was copied.
141212 16:48:55 innobackupex: Executing UNLOCK BINLOG
141212 16:48:55 innobackupex: Executing UNLOCK TABLES
141212 16:48:55 innobackupex: All tables unlocked

innobackupex: Backup created in directory '/tmp'
innobackupex: MySQL binlog position: filename 'node01-bin.000002', position 120
141212 16:48:55 innobackupex: Connection to database server closed
innobackupex: You must use -i (--ignore-zeros) option for extraction of the tar stream.
141212 16:48:55 innobackupex: completed OK!

The mysql error log on the second node says that the SST completed with errors:

2014-12-12 16:49:47 5698 [Warning] WSREP: Failed to prepare for incremental state transfer: Local state UUID (00000000-0000-0000-0000-000000000000) does not match group state UUID (d4022a87-820a-11e4-bcf4-5793c1c5841f): 1 (Operation not permitted)
at galera/src/replicator_str.cpprepare_for_IST():456. IST will be unavailable.
2014-12-12 16:49:47 5698 [Note] WSREP: Member 1.0 (node02) requested state transfer from '*any*'. Selected 0.0 (node01)(SYNCED) as donor.
2014-12-12 16:49:47 5698 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 5)
2014-12-12 16:49:47 5698 [Note] WSREP: Requesting state transfer: success, donor: 0
2014-12-12 16:49:47 5698 [Note] WSREP: (dff2f8f7, 'tcp://0.0.0.0:4567') turning message relay requesting off
2014-12-12 16:49:57 5698 [Note] WSREP: 0.0 (node01): State transfer to 1.0 (node02) complete.
WSREP_SST: [ERROR] xtrabackup process ended without creating '/var/lib/mysql//xtrabackup_galera_info' (20141212 16:49:57.174)
[...]
WSREP_SST: [ERROR] Cleanup after exit with status:32 (20141212 16:49:57.297)
WSREP_SST: [INFO] Removing the sst_in_progress file (20141212 16:49:57.326)
2014-12-12 16:49:57 5698 [ERROR] WSREP: Process completed with error: wsrep_sst_xtrabackup --role 'joiner' --address '192.168.0.102' --auth 'sst:123' --datadir '/var/lib/mysql/' --defaults-file '/etc/my.cnf' --parent '5698' '' : 32 (Broken pipe)
2014-12-12 16:49:57 5698 [ERROR] WSREP: Failed to read uuid:seqno from joiner script.
2014-12-12 16:49:57 5698 [ERROR] WSREP: SST failed: 32 (Broken pipe)
2014-12-12 16:49:57 5698 [ERROR] Aborting

Just to get you guys aware, I've got the user sst with 123 as its password well created on MySQL:

[root@testenv-node01 ~]$ mysql -u root -e "show grants for sst@localhost\G"
*************************** 1. row ***************************
Grants for sst@localhost: GRANT RELOAD, LOCK TABLES, REPLICATION CLIENT ON *.* TO 'sst'@'localhost' IDENTIFIED BY PASSWORD '*23AE809DDACAF96AF0FD78ED04B6A265E05AA257'

Trying to test manually the xtrabackup command as per the documentation to check if it's doing the right thing, I've got the following:

[root@textenv-node01 ~]$ innobackupex --user=sst --password=123 /tmp/

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.

Get the latest version of Percona XtraBackup, documentation, and help resources:
http://www.percona.com/xb/p

141212 17:17:36 innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup' as 'sst' (using password: YES).
141212 17:17:36 innobackupex: Connected to MySQL server
141212 17:17:36 innobackupex: Executing a version check against the server...
Can't use an undefined value as an ARRAY reference at /usr/bin/innobackupex line 1069.

The Xtrabackup packages I've got installed on these new machines:

[root@testenv-node01 ~]$ xtrabackup --version
xtrabackup version 2.2.7 based on MySQL server 5.6.21 Linux (x86_64) (revision id: )

Any lights in here? Any advice?

How to contribute a patch

Lastest Forum Posts - December 12, 2014 - 9:10am
Where are the notes telling me the steps/requirements for contributing a bug-fix patch?

I have tracked down a bug to the API C lib that impacts (perl, python, ...) API users relying on the secure_auth param.
I have a one-line patch which I've successfully tested. I've downloaded the 5.6 source via bzr.

The easiest thing would be for me to upload the patch to github and then reference that in my bug report. But I'm sure there are more comprehensive steps I could follow.

thanks,
Nic

Percona Monitoring Plugins - missing in CentOS 7 repo

Lastest Forum Posts - December 12, 2014 - 4:28am
Hi,

The "Percona Monitoring Plugins" are missing from the CentOS 7 repo.
[I've had puppet complaining about this after I changed a server to CentOS 7]

Is there a timeline?
As far as it goes I've installed the packages from CentOS 6 repo and are working just fine!

Regards!

Repo down?

Lastest Forum Posts - December 12, 2014 - 12:00am
Failed to fetch http://repo.percona.com/apt/pool/mai...cise_amd64.deb Could not connect to repo.percona.com:80 (162.220.4.217). - connect (111: Connection refused)

I have had problems reaching the repo the last couple of days, is it a known problem?

Do I need to install xtrabackup on a remote machine as well ?

Lastest Forum Posts - December 10, 2014 - 7:12pm
Hello ,

I have taken a backup using xtrabackup and want to restore it on a remote MySQL server. I have copied backup files on a remote server.
Now how Can I get MySQL using backup files data an running?
Do I need to install xtrabackup on remote server as well ?

Do I need to install xtrabackup on a remote machine as well ?

Lastest Forum Posts - December 10, 2014 - 7:05pm
Hello ,

I have taken a backup using xtrabackup and want to restore it on a remote MySQL server. I have copied backup files on a remote server.
Now how Can I get MySQL using backup files data an running?
Do I need to install xtrabackup on remote server as well ?

Percona XtraBackup 2.2.7 is now available

Latest MySQL Performance Blog posts - December 10, 2014 - 7:03am

Percona is glad to announce the release of Percona XtraBackup 2.2.7 on December 10, 2014. Downloads are available from our download site or Percona Software Repositories.

Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies with large data sets and mission-critical applications that cannot tolerate long periods of downtime. Offered free as an open source solution, Percona XtraBackup drives down backup costs while providing unique features for MySQL backups.

Bugs Fixed:

  • Non-default value for innodb_log_block_size variable would cause assertion when preparing the backup. Bug fixed #1391216.
  • When Percona XtraBackup would run FLUSH ENGINE LOGS during the backup process on GTID master, command was recorded to the slave’s binary log as well, which lead to inconsistency between master and slave. Fixed by adding the NO_WRITE_TO_BINLOG clause to FLUSH ENGINE LOGS to avoid interfering with binary log and inconsistency with coordinates. Bug fixed #1394632.
  • Exporting tables was inefficient when backup contained a large (and unrelated) change buffer. Bug fixed #1366065 (Davi Arnaut).
  • innobackupex was printing the GTID even if the GTID mode was disabled which could cause confusion since it wasn’t incrementing. Now it prints only GTID when GITD mode is enabled and when GTID mode is disabled it prints only filename and position. innobackupex still prints GTID, filename and positions if MariaDB server is being backed up. Bug fixed #1391041.

Other bugs fixed: bug #1386157.

Release notes with all the bugfixes for Percona XtraBackup 2.2.7 are available in our online documentation. Bugs can be reported on the launchpad bug tracker. Percona XtraBackup is an open source, free MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases.

The post Percona XtraBackup 2.2.7 is now available appeared first on MySQL Performance Blog.

Pages

Subscribe to Percona aggregator
]]>