… application I can then compare using MySQL to using MySQL + Memcached, and then to other solutions…email address ). Seems simple enough right? My two tables each contain 5M rows of data. …bigger boxes, the read-only slaves, the complex sharding systems, the discussions on cluster, more memcached. We…
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 141 Comments
… table scan even if only few percent or rows are accessed. Lets do some computations again. Consider table…close to two full table scans (as 60mil of rows need to be read) – this is way wrong…data sets. In MySQL single query runs as single thread (with exeption of MySQL Cluster) and MySQL issues IO …
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
…built-in mysql replication are independent from each other. Q: I installed Percona as cluster database working …xtrabackup itself while holding a lock using FLUSH TABLES WITH READ LOCK. MyISAM support is experimental. Apart… faster then writing only to 1, the reason for this is that only 1 node has…
Post: Migrating to XtraDB Cluster Webinar follow up questions
June 6, 2012 By 3 Comments
…cluster. Q: Are adding/updating mysql user accounts replicated? Yes, provided you use CREATE USER or GRANT. DML on the mysql.* tables…, depending if it needs to read or write. Splitting read and and write DB handles is… will prevent replication from working if you only do it on some nodes), then I…
Post: Automation: A case for synchronous replication
September 19, 2012 By 2 Comments
…only for queing event in relay log. Now lets see how Synchronous Replication solutions such a Percona XtraDB Cluster and MySQL Cluster…cluster provides – such as it is safe to read and write from any node and application will work properly. The fact cluster…familiar Innodb tables. MySQL Cluster is …
Post: Recovering Innodb table Corruption
July 4, 2008 By 22 Comments
… you simply rebuild table by using OPTIMIZE TABLE ? This is because Running in innodb_force_recovery mode Innodb becomes read only for data operations and so you can’t insert or delete any data (though you can create or drop Innodb tables): mysql… cases such as if data dictionary or “root page” for clustered index is corrupted this method will not work well – in…
Post: Using MMM to ALTER huge tables
March 27, 2008 By 11 Comments
… things that would break logical replication if tables on master and replica are different. binary… cluster – it should display db2 as active master (“writer”) and db1 as standby master (having only “reader… different IP for MySQL or ensure some load balancer/proxy does this, set read-only manually on…
Post: Percona Toolkit 2.1.8 released today with beta support for MySQL 5.6
January 9, 2013 By Leave a Comment
… running the tools on Percona XtraDB Cluster or MySQL 5.6 are advised to…table-checksum doesn’t ignore tables for –replicate-check-only. When using –replicate-check-only, filter options like –databases and –tables…-heartbeat respected the MySQL time zone, but this caused false readings (e.g. very…
Post: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
…fail over in both directions. Aside from MySQL Cluster, which is more special-purpose, this is…buffer pool with the following query: select table_schema, table_name, page_type, count(*) from …read-only workload to the passive server. It doesn’t have to be the tools I used — it could be MySQL…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
…MySQL server with improved performance and high availability. Of course there is MySQL Cluster…live with it. They anyway read stale data from the slave…tables and other tricks we use when such need arises but we still can’t deny – MySQL… for Prepared Statements is only fixed in MySQL 5.1 and Most…
