…XtraDB Cluster (PXC), and also to solicit use cases from the readers. One of the prominent usages…node by the chef. The second node is then added which SSTs with node1 (based on gcomm… state transfer) is not feasible. It also helps when node data integrity is compromised. So, naturally duration…
Post: Percona XtraDB Cluster (PXC) in the real world: Share your use cases!
June 17, 2013 By Leave a Comment
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
… I will explain you how to fix your cluster in case it breaks after a distribution upgrade that implies an update… cman ccs [root@percona3 percona]# yum -y install cman ccs Then on ALL nodes, stop Pacemaker and Corosync [root@percona1 ~]# /etc…/cluster/cluster.conf –addnode percona3 Node percona3 added. we need then to delegate the fencing to pacemaker (adding a fence device…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
… performance is a case-by-case decision. There are other drawbacks to using temporary tables in this way, for example when using replication, a temporary table could vanish if the slave restarts and then subsequent queries against the… you want to choose (movies, in this case) with values known to be consecutive. Then you could choose a random value, look…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
…to the Development process a lot more effectively when I know the relationships between tables versus … ENGINE=InnoDB DEFAULT CHARSET=latin1 Notice that in the case of child_A there is an implicit …constraints that you might have missed and can then write into your metadata file. Donate – This …
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
….1 for example) is tested with a cold buffer pool. Then the query is tested again without restarting the database. The… InnoDB when the database is cold, but the opposite is true when the database is hot. SSB Flight #3 Here in some cases… worse when small amounts of data are examined. Conclusion In some cases MyISAM is faster than InnoDB, but usually only when the buffer…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… easiest case, we will make s2 a master and redirect replication on the other servers to s2. This scenario can happen when…> change master to master_port=10002; mysql> start slave; # And then check the number of records from the t table s1… cannot totally forget old-style replication positioning. Conclusion Reconfiguring replication when using GTIDs is usually straightforward: just connect the slave to…
Post: Choosing a MySQL HA Solution - MySQL Webinar: June 5
May 28, 2013 By 1 Comment
… the choice is made without adequately considering all three perspectives. When too much attention is paid to one of these aspects… other layer of the system stack) and then conclude with some typical use cases where a given approach may be well-suited or particularly contraindicated. If this topic interests you, then register today…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
… to take a snapshot of a particular MySQL schema and then reload it with a different schema name on the same… seem possible. Further discussion with the client clarified the use case: clients make a mistake and need to compare their old… in time. When running Percona Server, you can utilize the –export flag during the –apply-logs phase and then re-import those…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… performance hit that comes with DRBD. When you run a virtual machine, in most cases your virtual disk is basically nothing more…-level master and its binary logs are fully intact, and then the binary log filters are executed on the intermediate server… of MHA. Q: How do you monitor MySQL to determine when it’s not responsive? A: The easiest way to do…
Post: Memory allocators: MySQL performance improvements in Percona Server 5.5.30-30.2
April 15, 2013 By
… allocates heap area and then creates requested block(s) there. That optimization helps to avoid fragmentation in case of many small allocations and allows to free all blocks from specific heap at once. But in the case when we need memory only for a single block this 2 layers approach is quite inefficient and in some cases can…
