… below. Having never experimented with GlusterFS, though, I decided to give it a shot. I set up a 3 node cluster in AWS, got the volume mounted, and went to try to install MySQL. It failed miserably on the mysql… able to get the server up with –skip-grant-tables and insert a few rows into an InnoDB table, but trying to run…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… release of Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL on April 17, … xtrabackup tmpdir was set up on tmpfs. Bug fixed #1086978 (Alex Yurchenko). Issues with compiling Galera on …innodb_thread_concurrency has been defined to throttle InnoDB access, and work load contained DDL statements, a cluster…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… modify data on multiple cluster nodes simultaneously. You can. It does NOT set an lower bound … we take when deploying conventional stand-alone MySQL Innodb with asynchronous slaves. We may not think about…to ensure it’s caught up with the master?). Synchronous replication with PXC and Galera is no…
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
…MySQL performance but it is even more important for HA systems. It is so important to avoid swapping with HA that NDB cluster… setting, which basically controls how important is the file cache for Linux. Basically, with InnoDB… bad for a cluster and we often ended up is strange, unexpected states…
Post: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
…engines work with rows. They break the queries up into the lowest level sets possible… a cluster (cpu, memory, disk, power,etc) then split the problem up … SQL, but right now only MySQL storage nodes are supported. Amdahl…you will be able to set up computation over ICE, InnoDB, Vectorwise and other …
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…cluster with sysbench. We will use sysbench from the EPEL repo. First, let’s create a database and a userfor it. mysql…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… utility: InnoDB file size on disk: 42GB (with indexes) # du -sh * 203M ibdata1 128M ib_logfile0 128M ib_logfile1 988K mysql 2.1G… times and throughput. Setting up a cluster using the AMI images You can easily test Shard-Query for yourself. Spin up the desired number… transaction-isolation=READ-COMMITTED user=mysql wait-timeout=86400 To be continued You can now set up a cluster from 1 to 20 nodes…
Post: Percona testing: Quick test clusters with kewpie!
January 13, 2012 By Leave a Comment
…cluster, I wanted to share a quick way to set up an ad-hoc cluster on a single machine to help people play with…-125552 INFO Using default-storage-engine: innodb 20120113-125552 INFO Using testing mode:…startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection…
Post: Percona XtraDB Cluster: Multi-node writing and Unexpected deadlocks
August 17, 2012 By 17 Comments
…MySQL replication. For those who don’t know, it gives you: Fully Synchronous replication with…cluster-wide, it uses optimistic locking. Initially a transaction on PXC behaves much like a regular Innodb…mysql> set autocommit=off; Query OK, 0 rows affected (0.00 sec) node1 mysql…you end up with one of …
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
… mysql replication are independent from each other. Q: I installed Percona as cluster database working with Zabbix (innodb),…large history tables, so it can keep up with the writes and/or configure and rethink…traditional Master Slave scenario when the data set is very large? Can you swap in Binaries …
