… two main reasons that I don’t like DRBD with virtual machines. First is the disk… same machine if you use the BLACKHOLE storage engine) in between the actual master and the…What is my recommendation for MySQL 5.6? Is MHA ready for MySQL 5.6? A: My personal recommendation for MySQL 5.6, based on what…
Post: Power of MySQL Storage Engines
March 5, 2007 By 3 Comments
…. NDB cluster is yet another example I’d put in here. I do not feel it is ready as main storage engine for most of applications just yet but for some cases it may be handy. The fact which is… this point is the fact MySQL has only Storage Engine pluggable but SQL layer is kind of fixed same for all. This dramatically limits what you…
Post: Countless storage engines
May 3, 2007 By 6 Comments
…MySQL did one step – announced MySQL supports Plugginable Storage Architecture. In that time nobody was able to predict what is…me list Transactional Storage Engines I heard of on Conference and main impression about…. soon. Falcon The Storage Engine which is developed in MySQL. The performance we see…
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
… get to the point what we’re comparing here – it is mainly DRBD to MySQL Replication based techniques (lets leave MySQL Cluster and Continnuent alone… work. This is not to mention other things you can do with MySQL Replication, such as filtered replication or cross storage engine replication, though…
Post: MySQL opening .frm even when table is in table definition cache
November 21, 2011 By 8 Comments
… DB_TYPE. i.e. what storage engine it is. We can ignore the upper limit on number of storage engines for MySQL and understanding the relationship between… work out which Storage Engine to ask to drop the table. The main consequence of this bit of code is that MySQL may cause unnecessary…
Post: MySQL Performance Engineer opening
May 13, 2008 By Leave a Comment
… hire someone who could focus on such tasks. What are we expecting from MySQL Performance Engineer ? Such person should have a passion for… to find the truth source code is your best friend. One should have good MySQL knowledge including main storage engines, and best have experience using…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
…systems would work as well. What is really needed is ability to create atomic …storage engines. Fast Backup You simply do file copy in the binary form so it is…MySQL Server to continue, which is done by running UNLOCK TABLES or simply closing connection. 5) Mount backup Filesystem: mount /dev/Main…
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
…is feasible to move to Innodb and when staying on MyISAM is preferred ? I generally prefer to see Innodb as the main storage engine…MySQL server – in particular Optimizer may have harder time because costs between storage engines…
Post: MySQL Architecture meeting at Google
April 24, 2008 By 2 Comments
…MySQL architecture mainly focusing on storage engine vendors and other extension areas. It was very interesting to see all these storage engine…storage engines with MySQL which was previously hard because of defined row by row retrieval interface and nested loops used for joins. However what…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
…Storage Engines both looking at number of third party storage engine presented, main marketing message – Storage Engine partnership with IBM, “Clash of Database Egos” – Storage Engine…what is…
