… so called “micro” benchmark which concentrates on particular simple storage engine functions and we use it to see performance and scalability… PK values. PBXT is much worse here because of InnoDB clustering by primary key. InnoDB does not need an extra lookup… data by Primary KEY, as I understand PBXT will not support clustering and will not able to reach InnoDB results, but I…
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
…, such as filtered replication or cross storage engine replication, though which are not typically used …environments. Though DRBD also could be extended to support one if needed. Now, do not get …automated fail over. Whenever you’re using MySQL Cluster, DRBD or MySQL Replication you have to …
Post: Percona and the MariaDB Foundation
December 19, 2012 By 3 Comments
… of when and how Percona Supports MariaDB. We support all variants and flavors of “MySQL” -…MariaDB, for example, includes the XtraDB storage engine – our enhanced variant of Innodb. Percona … software, including Percona Server, Percona XtraDB Cluster, Percona XtraBackup, and Percona Toolkit, all …
Post: MySQL Northern European Customer Conference
October 17, 2007 By 7 Comments
… – there were no one from MySQL Development Support or Consulting teams and Sales Engineers were as close as you could get. Though… understand if it will be recommended transactional storage engine or just default storage engine will switch from MyISAM to Falcon. It was… to see to have some work done outside of MySQL Cluster – for example quite possible their solution could help a lot…
Comment: Replication of MEMORY (HEAP) Tables
October 18, 2010 By 7 Comments
You could replace MEMORY with NDBCLUSTER like Andrew Morgan describes here: http://www.clusterdb.com/mysql-cluster/replacing-memory-storage-engine-with-mysql-cluster-2/ The NDB engine also supports multiple replication links.
Comment: Announcement of Percona XtraDB Cluster 5.5.20 GA release
May 1, 2012 By 11 Comments
… percona server 5.5.20, I would be testing xtradb cluster with three nodes. I went through your documentation provided with… did all of the configuration go for example default_storage_engine, query_cache_size, e.t.c…. Is it something built… for the cluster. I am new in this field and being a startup company cannot afford to get paid support from percona…
Comment: Predicting Performance improvements from memory increase
August 8, 2008 By 6 Comments
…, The NDB engine supports data on disk and in memory. http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-disk-data.html The important factor to consider when upgrading memory on an NDB Cluster is that the…
Comment: MySQL Partitioning - can save you or kill you
June 28, 2012 By 45 Comments
…Timestamp), PK –> (ObjectClass, ObjectInstance, Timestamp) – Unique. Using InnoDb engine as the client is very finiky about…(Strange…??) 2. We are using mysql ndb cluster version Distrib 5.1.56-ndb-7…base mysql version (5.1.56) supports partitions, but does not support partition pruning. 3. The …
Post: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
…not how to get it. Most distributed engines work with rows. They break the queries… another open source tool called Flexviews which supports incrementally maintaining materialized views. While writing Flexviews,… have any limitation in resources in a cluster (cpu, memory, disk, power,etc) then split…
Post: Recover BLOB fields
July 1, 2010 By 4 Comments
…BLOBs. An InnoDB table is stored in a clustered index called PRIMARY. It must exist even if… varchar(120), `N_FIELDS` int(10), PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 Here COMPACT format is…NO is FIL_NULL. Percona InnoDB Recovery Tool supports now recovery of long fields. It is still…
