June 19, 2013

Post: Percona XtraDB Cluster (PXC) in the real world: Share your use cases!

… the production environment that we have come across (and our Percona consultants have assisted) is that of HP Cloud. There is… of node2) through Xtrabackup SST (state snapshot transfer). Node3 subsequently joins the cluster with node1 and node2 in its gcomm:// (since… that post, you can refer a post by Peter Boros (“Percona XtraDB Cluster reference architecture with HaProxy”) for details. In their…

Post: Percona MySQL University @Portland next Monday!

Percona as well as local members of the MySQL Community: Vadim Tkachenko, Percona co-Founder and CTO, will talk about Percona XtraDB Cluster, Percona Xtrabackup and Performance and Improvements and new Features in MySQL 5.6 Garrick Peterson, a member of Percona… also join the Portland MySQL Meetup group for more MySQL-focused events in Portland If you love the ideal of Percona MySQL…

Post: MySQL Query Patterns, Optimized - Webinar questions followup

… I gave a presentation on “MySQL Query Patterns, Optimized” for Percona MySQL Webinars.  If you missed it, you can still register… some more tips: Check out upcoming Percona Training classes in North America and Europe. Join Percona and the MySQL community at our events… November 11-12, 2013. We also look forward to the Percona Live MySQL Conference and Expo in Santa Clara, California starting…

Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4

… config… [ OK ] Starting gfs_controld… [ OK ] Unfencing self… [ OK ] Joining fence domain… [ OK ] Starting Pacemaker Cluster Manager: [ OK ] [root@…0 (ocf::percona:mysql): Master percona1 (unmanaged) p_mysql:1 (ocf::percona:mysql): Slave percona2 (unmanaged) p_mysql:2 (ocf::percona:mysql): …

Post: Webinar: SQL Query Patterns, Optimized

…, Optimized.” Based on my experiences solving tough SQL problems for Percona training and consulting, I’ll classify several common types of… status to measure performance. The query patterns will include: Exclusion Join Random Selection Greatest-Per-Group Dynamic Pivot Relational Division Please…

Post: Network at the Percona Live MySQL Conference and Expo

… views of the ecosystem. Beyond the speakers and sessions, the Percona Live MySQL Conference and Expo offers a unique opportunity to… features the Birds of a Feather sessions where you can join attendees with similar interests to discuss common topics of interest… for the evening activities, opportunities to network abound at the Percona Live MySQL Conference and Expo. Connect with MySQL community members…

Post: Keynotes, BOFs, and the Community Networking Reception at Percona Live MySQL Conference and Expo

… on Percona Server and Related Projects Stewart Smith, Director of Server Development, Percona Topic: “Percona Server 5.6” Jay Janssen, Consulting Lead, Percona Topic: “Migrating to Percona XtraDB Cluster” Mark Atwood, Vipul… cloud and big data. If you can join us in Santa Clara for the Percona Live MySQL Conference and Expo, use discount…

Post: Learn About MySQL 5.6 at the Percona Live MySQL Conference

… redefined MySQL performance and usability. Some great talks at the Percona Live MySQL Conference and Expo will provide insight into the… Wednesday morning continues the MySQL 5.6 focus at the Percona Live MySQL Conference. A distinguished group of MySQL experts from… liveliest, most engaging Percona Live event yet. Please join us in Santa Clara, April 22-25 for the Percona Live MySQL Conference and…

Post: Benchmarking Percona Server TokuDB vs InnoDB

After compiling Percona Server with TokuDB, of course I wanted to compare InnoDB … options are: [mysqld_safe] numa-interleave malloc-lib=/usr/local/Percona-Server-5.5.30-rel30.2-500.Linux.x86_64… = 16M max_heap_table_size = 64M sort_buffer_size = 4M join_buffer_size = 4M thread_cache_size = 1000 query_cache_size…

Post: Is Synchronous Replication right for your app?

… talk with lot of people who are really interested in Percona XtraDB Cluster (PXC) and mostly they are interested in PXC… But what does that all actually mean?  Well, at the Percona Live conference a few weeks ago I heard a great…_groups table to define the relationship between them.  When someone joins a group, you run a transaction that adds the relationship…