… entitled “The Hazards of Multi-writing in a Dual-Master Setup“. In my experience many people do not understand the difficulty…
Post: Webinar: The Hazards of Multi-writing in a Dual-Master Setup
November 5, 2012 By Leave a Comment
Post: Upcoming Percona XtraDB Cluster - Installation and Setup webinar
September 12, 2012 By Leave a Comment
… http://www.percona.com/webinars/percona-xtradb-cluster-installation-and-setup. If you register for the webinar but cannot attend, you…
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
…-in-the-neck problems. Combining all above, now we can setup distributed replication systems with masters in different data centers. This… is much more complex than an average MySQL master-slave setup. Potential performance penalty: Although to have performance numbers I am… run different benchmarks, I expect that for simple master-slave setups the response time and throughput will be affected (and not…
Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80
February 25, 2013 By 10 Comments
… all the added costs So, how about if you could setup a small Arch Linux ARMv6-based hardware device which runs… reader (likely build into your laptop or PC already) Network setup A network lead and spare network port on your router…% Installing MySQL system tables… OK Filling help tables… OK [...more setup information, please read...] [Optional] Set Percona server to startup at…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
… have some spare CPU for binary log parsing. Run the setup script: This will create the metadata tables and capture the… binary log position. php ./setup_flexcdc.php –ini consumer.ini $ php setup_flexcdc.php setup starting setup completed If the setup detects any problems (such… exit with an error. It will exit with a message “setup completed” otherwise. Verify installation The binary log stores it progress…
Comment: Why MySQL could be slow with large tables ?
March 11, 2009 By 141 Comments
… WHERE NOT MachineName IS NULL AND MachineName !=” ORDER BY MachineName SETUP A: We have a web application that uses MS SQL… more or less 30 seconds. SPECS of SETUP A: OS: Windows XP Prof Memory: 512MB SETUP B: It was decided to use…-3 mins to invoke the same query used in SETUP A. SPECS of SETUP B: OS: Red Hat Linux 4 Memory: 512MB…
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
… remains operational. Use with extreme caution even in master-slave setups, because slaves won’t automatically reconnect to master in this… split brain? This is a dangerous setting in multi-master setup, but should simplify things in master-slave cluster (especially if… one primary component in the cluster. In our 2 nodes setup, when the communication between the 2 nodes is broken, the…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
February 3, 2012 By 102 Comments
Well, I use keepalived with Direct Routing for loadbalancing. We setup a vip (192.168.5.141) in the config, and… is about 50x faster. You are right about my setup, in my setup I could remove the readVIP and just set it… VIP can be removed from the config in my particular setup, but I’d thought it was a nice exercise for…
Post: Setting up XFS on Hardware RAID -- the simple edition
December 16, 2011 By 9 Comments
… you have a server with standard hardware RAID setup running conventional HDDs. RAID setup For the sake of simplicity you create one… similar): (sym-link /var/lib/mysql into here when you setup mysql) Are there alternatives? Yes. Can you have separate partitions… is a commonly missed step related to getting the IO setup properly. The best choices here are between ‘deadline’ and ‘noop…
Post: State of the art: Galera - synchronous replication for InnoDB
October 27, 2009 By 15 Comments
… to support LVM snapshot and xtrabackup which will make the setup of new node even easier. The current annoyance I see… it will provide 
, but efforts on test setup and deployment should be comparable with MMM setup. – Scale Writes. Galera allows to write… to make the same for Postgres. So MySQL-Postgres cluster setup is not so far ahead On “Company page” Codership says…
