…. The post focuses on the key aspects of synchronous replication setup with high-availability guarantees like split-brain immunity. Nobody likes… simple and uncomplicated. Their post focuses on following aspects: Initial setup Setup of other nodes with SST (Xtrabackup SST) Integration of chef…, integration of HAProxy as a loadbalancer. To elucidate, their initial setup goes into bootstrapping the first node. Note that in the…
Post: Percona XtraDB Cluster (PXC) in the real world: Share your use cases!
June 17, 2013 By Leave a Comment
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… one here. Our goal will be to go from setup #1 to setup #2 on the picture below, following various scenarios: For…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
… been disabled at boot… [ OK ] Checking Network Manager… [ OK ] Global setup… [ OK ] Loading kernel modules… [ OK ] Mounting configfs… [ OK ] Starting cman… been disabled at boot… [ OK ] Checking Network Manager… [ OK ] Global setup… [ OK ] Loading kernel modules… [ OK ] Mounting configfs… [ OK ] Starting cman…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… other one with Linux servers. The Solaris side is cleverly setup using zones and ZFS and this provides a very low… spare drives per controller, I have 2 for the whole setup. A small but yet interesting saving. All put together, ZFS…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
… focused on the implications of enabling GTIDs on a production setup. The manual describes very nicely how to switch to GTID…
Post: My Sessions at Percona Live MySQL Conference and Expo 2013
April 1, 2013 By Leave a Comment
… well as a practical look at what configuring a PXC setup looks like. Again, Galera / MariaDB Galera Cluster users should fit…-cluster The Hazards of Multi-writing in a Dual-Master setup This talks covers the basics of why multi-writing multi…/live/mysql-conference-2013/sessions/hazards-multi-writing-dual-master-setup BOF: Galera / Percona XtraDB Cluster for MySQL I also submitted…
Post: Virident vCache vs. FlashCache: Part 1
May 16, 2013 By 3 Comments
… draw between vCache and FlashCache. Ease of basic installation. The setup process was simply a matter of installing two RPMs and… the vCache documentation is superior. Winner: vCache. Ease of post-setup modification / advanced installation. Many of the FlashCache device parameters can…
Comment: Death match! EBS versus SSD price, performance, and QoS
May 13, 2013 By 55 Comments
… migrating to AWS we have a more powerful and robust setup for $10,000/month. Since this article was written AWS… managed to still extract very good value from my AWS setup.
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… have rerun tests on several our boxes. You can find setup/config details at the very end of this post. Hardware… view: I hope this sheds more light on our tests setup and clarifies the scope of descriptors optimization. Server Configuration: [mysqld…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…, FlashCache still does quite well, massively outperforming the HDD-only setup, but it doesn’t even really come close to the…
