… definition of what serious bugs are. Large Team, Tricky Code During MySQL 3.23 and MySQL 4.0 team the small tight knit… concept easily. Increasing Complexity Each new MySQL version is getting more and more complicated. MySQL architecture has to be additionally complicated to support…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
… Enterprise managing a lot of relatively small MySQL installations or managed hosting provider. For large MySQL web MySQL installations using Sharding or replication IO… than without these technologies but I always in my HA architectures it is a single “point” which can experience “failure”. Note…
Post: How Percona strives to remain neutral and independent
March 21, 2011 By Leave a Comment
…prominent companies in the MySQL ecosystem are Percona customers, including hardware manufacturers, software… proposed architecture. For example, we will not authorize you to say “we developed this proposed architecture… told us that this was a very large number of potential clients and they would…
Post: State of MySQL Market and will Replication live ?
April 9, 2008 By 29 Comments
… performance problems (like scaling Writes with replication or dealing with large data sets). Web crowd simplicity and really had a little… on the medium level. Seriously – MySQL Cluster, Continuent, Master-Master Replication, DRBD or SAN based HA architectures all have their limits which…
Page: Consulting for MySQL
July 31, 2006 By
…architecture which matches your application needs using MySQL Replication, Active-Passive clustering, DRBD, MySQL Cluster, Load balancing and other tools. MySQL Replication Advanced MySQL… for MySQL Want your developers to learn MySQL best practices ? How to work with large data sets in MySQL or…
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 139 Comments
… careful working with large data sets. In MySQL single query runs as single thread (with exeption of MySQL Cluster) and MySQL issues IO requests… populate the caches. With proper application architecture and table design you can build applications operating with very large data sets based on MySQL.
Post: Finding your MySQL High-Availability solution – Replication
November 13, 2009 By 6 Comments
… pushed to the slave(s) leading to data loss. Many large websites that are fine with some data loss rely on… topology is used. The following figure summarize the simplest HA architecture using MySQL replication. All writes are going to the master while… from OpenQuery gave an excellent webinar on it recently. The architecture of a highly available setup using MMM and Master-Master…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 1
October 15, 2009 By 16 Comments
… blow through your available memory. Is there a better architecture? Is there a way to get more scalability out… you blow through your available memory. Is there a better architecture? Is there a way to get more scalability out of… hits in memcached, but the # of writes in MySQL coupled with the still large # of reads takes its toll. Another place where…
Post: MySQL Consulting - Being on your own
February 20, 2007 By 7 Comments
… market is now great for MySQL Consulting. The number of MySQL users is growing rapidly thanks for MySQL Marketing and Sales departments and… investment and start building multi level support systems to handle large volumes but that is surely not the plan for now… on MySQL Performance the scope of our work proved to be much larger. We handle a lot of architecture design for MySQL and…
Post: Return of the Query Cache, win a Percona Live ticket
August 26, 2011 By 4 Comments
…’s new with the MySQL query cache? You may know that it still has the same fundamental architecture that it’s always… the fact that the query cache was configured far too large. This might have taken a lot longer to discover otherwise… InnoDB Architecture and Performance Optimization. These detailed presentations will give you the hands-on experience you need to take your MySQL understanding…
