… pool. – Failed Over. – Sharding. – Query Router. In addition it is better support stored-procedure and transparent between Mysql Server and application client…
Post: Is your MySQL Application having Busy IO by Oracle Measures ?
January 8, 2012 By 1 Comment
… for “sharded” MySQL the numbers are not that high – many what would be considered medium scale MySQL installations would get there. With MySQL we… performance with multiple MySQL instances on powerful storage. When you move to multiple instances and you have to “shard” your data in… at MySQL we often start “sharding” or splitting data other way because operationally working with large table and data sizes in MySQL can…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 22 Comments
… following graph: One significant advantage of Shard-Query over Hive is that it works with existing MySQL data sets and queries. Another… with all MySQL storage engines. This set of benchmarks evaluates how well Infobright community edition (ICE) performs in combination with Shard-Query… the data, performance can be improved significantly: $ cat shards.ini [default] user=mysql db=ontime password= port=5029 column=date_id mapper…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…=’Contains all avaialble data from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘ontime_fact’G *************************** 1… cluster of 1 to 20 nodes. cd shard-query #generate a config for 20 shards (adjust to your number of nodes) php… my.cnf [client] port=3306 socket=/tmp/mysql-inno.sock [mysqld] socket=/tmp/mysql-inno.sock default-storage-engine=INNODB innodb-buffer…
Post: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
… give a quick preview, then explain exactly how Shard-Query works.Yes, Shard-Query scales very well at 20 nodes Distributed set… incremental materialized view optimizations can be applied. Shard-Query works only on sets Shard-Query takes relational algebra to its logical maximum… of compute resource which speaks SQL, but right now only MySQL storage nodes are supported. Amdahl’s law applies to the…
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
…, such as DECIMAL field got whole another meaning in MySQL 5.0 MySQL generally supports legacy storage format for a while, even… shard and measuring its capacity) Setting up the Slave(s) If you want to minimize downtime it is best to use MySQL… a bit so if something happens (like MySQL crashes) you have only one/few shard to deal with. P.S Happy New…
Post: MySQL Limitations Part 4: One thread per connection
October 27, 2010 By 14 Comments
… post is about the way MySQL handles connections, allocating one thread per connection to the server. MySQL is a single process with… hundreds of application server instances. When you have a heavily sharded or otherwise horizontally scaled application, it’s not only easy… limitations. And because MySQL is a multi-threaded database for Web usage that tends to be used in sharded environments with tons…
Post: An update on Percona Live MySQL Conference & Expo 2012
November 30, 2011 By 2 Comments
… a cadre of the core MySQL developers to submit talks about what is new in MySQL, the MySQL roadmap for the future, and… DRBD, partitioning, community toolkits, security, using MySQL with NoSQL, geospatial functionality, cloud computing, Cluster, search, sharding, memcached, high availability, DevOps, Big Data…
Post: Percona's Sessions at the O'Reilly MySQL Conference and Expo
April 7, 2011 By Leave a Comment
… operations Forecasting MySQL Performance and Scalability Summary tables, aggregate tables and materialized views using Flexviews Scaling Applications with Caching, Sharding and Replication (Monday Tutorial) Innodb and XtraDB Architecture and Performance Optimization (Monday Tutorial) Using MySQL 5.5 Performance…
Post: Friends of Percona Get 20% Off at the MySQL Conference!
February 24, 2011 By 5 Comments
… operations Forecasting MySQL Performance and Scalability Summary tables, aggregate tables and materialized views using Flexviews Scaling Applications with Caching, Sharding and Replication (Monday Tutorial) Innodb and XtraDB Architecture and Performance Optimization (Monday Tutorial) Using MySQL 5.5 Performance…
