… Q: Can you compare the use of subqueries/multiple joins vs. multiple queries (e.g. temp tables)? For performance, … query automatically would be more costly than just running the query in a suboptimal form. Q: Doesn’… rows that you’ll get skewed results. For instance, if there’s a gap of id’s …
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… no effect on standard MySQL replication from this instance, since MySQL replication is asynchronous. What about … NOT mean you can’t modify data on multiple cluster nodes simultaneously. You can. It does … them. When someone joins a group, you run a transaction that adds the relationship row …
Post: Multiple MySQL instances on Fusion-io ioDrive
October 7, 2011 By 6 Comments
… and IO resources available on modern hardware. Idea is to run multiple instances of MySQL to gain better performance on Fusion-io ioDrive… highlight: Running multiple instances shows good improvement in throughput. 1.4x-1.8x for 2 instances and 1.6-2.4x for 4 instances. If you have sharding environment which allows you separate database into multiple instances you may try 2-4 instances setup to…
Post: Looking at Redis
August 27, 2009 By 27 Comments
… applications. Also nothing stops you from running many Redis instance on single server to get advantage of multiple cores. I call Redis semi… is only simple per instance password based authentication in place, so if application can talk to the instance it can access all… about 1.5 core being used. I have not tried running multiple instances and I’m not sure the network and TCP stack…
Comment: Can we improve MySQL variable handling ?
February 19, 2012 By 8 Comments
… nice to get real support for running multiple instances of MySQL on the same server via named instances like Oracle also– I’m sure…
Post: High availability for MySQL on Amazon EC2 – Part 2 - Setting up the initial instances
June 29, 2010 By 9 Comments
… public i386 machine aki-aca44cc5 instance-store So, lauching 2 of these, yves@yves-laptop:~$ ec2-run-instances ami-1cdf3775 -n 2 -g hamysql -t m1.small -k yves-key RESERVATION r-a29c31c9 834362721059 hamysql INSTANCE i-a23a21c9… manager MySQL, just the host running it. I’ll also skip the raid configuration of multiple EBS volumes since it is not…
Post: Is your MySQL Application having Busy IO by Oracle Measures ?
January 8, 2012 By 1 Comment
… get a lot better performance with multiple MySQL instances on powerful storage. When you move to multiple instances and you have to “shard” your data in some way anyway there is no difference whenever you run these instances on… not the same thing. How many of us are running 5TB per MySQL instance ? 20TB ? Over 50TB ? I believe this is to…
Post: Emulating global transaction ID with pt-heartbeat
November 4, 2011 By 6 Comments
… nutshell, this feature enables you to have multiple heartbeat rows in your heartbeat table, and multiple instances of pt-heartbeat, one per server…), and start an instance of pt-heartbeat per server. It just works. Everyone who runs replication should be running pt-heartbeat already to… that advice: everyone should not only be running pt-heartbeat, but they should be running it with the new version, and making…
Comment: Scaling to 256-way the Sun way
November 12, 2008 By 13 Comments
… as multiple boxes, however I think for medium-large scale applications this happens because we have to because of limited single instance scalability and operational issues. Even in this case we would like to see some relatively small number of instances running. For example running 2 instances on 16 core box, not 16. Now about…
Comment: Scaling to 256-way the Sun way
November 12, 2008 By 13 Comments
… really instances) matter because of operational complexity etc. Performance optimization and management is more complicated with multiple instances on one server than running on… the end scaling Single instance applies to all segments while being able to get scalability with multiple instances only to some of them…
