June 20, 2013

Post: 10 years of MySQL User Conferences

…. MySQL Cluster and MySQL Press were announced during this event; “High Performance MySQL” 1st edition written by Jeremy and Derek was also available. MySQL … back on MySQL and the needs of the MySQL community covering other technologies, as it is relevant to MySQL users. MySQL, MariaDB, Percona …

Post: Shard-Query EC2 images available

… to spread processing over up to 20 nodes. The Infobright Community Edition (ICE) images are available in 32 and 64 bit varieties…=’Contains all avaialble data from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘ontime_fact’G *************************** 1…-isolation=READ-COMMITTED user=mysql wait-timeout=86400 To be continued You can now set up a cluster from 1 to 20…

Comment: Intro to OLAP

… are a few questions , in terms of OLAP with native community edition MySQL cluster running on Redhat Linux we need a lot of insite… we are looking at changing SQL server 2008 Enterprise to MySQL community edition for our telecom apps. I would appreciate all help. Cheers

Post: Webinar: Building a highly scaleable distributed row, document or column store with MySQL and Shard-Query

… techniques employed by Shard-Query to implement a distributed MySQL database. The focus will then proceed to the types…: Distributed row store using XtraDB cluster Distributed append-only column store using Infobright Community Edition Distributed “document store” using XtraDB cluster and Flexviews

Post: Read/Write Splitting with PHP Webinar Questions Followup

… traditional MySQL asynchronous replication. edit: PXC is really a bit like semi-synchronous replication, in that changes are queued on all cluster nodes… Europe. Join Percona and the MySQL community in Santa Clara, April 22-25 2013 for the Percona Live MySQL Conference & Expo. Watch more…

Post: Pacemaker, please meet NDB Cluster or using Pacemaker/Heartbeat to start a NDB Cluster

… Heartbeat-2 project in 2 parts, the clustering and communication layer, Heartbeat and the resources manager, …cluster_start #!/bin/bash #Give some time to the nodes to connect /bin/sleep 15 /usr/local/mysql… by dumping the cib in xml format, editing and reloading. In term of commands, it means…

Post: Distributed Set Processing with Shard-Query

…the final result set. Intern-node communication One or more gearman queues …any limitation in resources in a cluster (cpu, memory, disk, power,etc) … SQL, but right now only MySQL storage nodes are supported. Amdahl’… TABLE IF EXISTS `aggregation_tmp#74082863` ; Edit *MIN/MAX are only distributable …