…, Percona Xtrabackup and Performance and Improvements and new Features in MySQL 5.6 Garrick Peterson, a member of Percona’s RemoteDBA… Swanhart, our Senior MySQL Instructor, will continue the topic of BigData with a talk titled, “Conquering BigData with MySQL and Shard Query” Daniel…… 
So register now! Please also join the Portland MySQL Meetup group for more MySQL-focused events in Portland If you love the…
Post: Percona MySQL University @Portland next Monday!
June 12, 2013 By Leave a Comment
Post: How people are using MySQL... from 1 user to 100 million (upcoming conference talk)
June 11, 2013 By Leave a Comment
MySQL can be deployed in several ways, and that means you … later you have to think about write scalability, and implement sharding ultimately. I will give a talk on this topic at…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 23 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 24 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: Webinar: Building a highly scaleable distributed row, document or column store with MySQL and Shard-Query
February 6, 2013 By Leave a Comment
… a highly scaleable distributed row, document or column store with MySQL and Shard-Query” The first part of this webinar will focus… are needed, and on the techniques employed by Shard-Query to implement a distributed MySQL database. The focus will then proceed to… (massively parallel processing) database applications which can be deployed with Shard-Query and the performance aspects of each. The following types…
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: 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…
