In case you live under a rock, the MySQL conference starts on Tuesday. There are 8 concurrent tracks of content. Aside from my own talks, here are the sessions I would most like to see.
On Tuesday:
This is my 2nd year in Pythian, and the first in Santa Clara as part of the Pythian company, but I will not be alone.
This year Pythian will have a good number of MySQL members. We will wait for you at Pedro's restaurant , if you are not registered yet, please do so NOW!!! Register yourself and join us.
The official announcement from the company:
"Pythian organizing an event that by now may be considered a tradition: The MySQL community dinner at Pedro’s! This dinner is open to all MySQL community members as many of you will be in town for the MySQL Conference that week."
We will wait there for all of you....
In case you live under a rock, the MySQL conference starts on Tuesday. There are 8 concurrent tracks of content. Aside from my own talks, here are the sessions I would most like to see. On Tuesday: Tutorial: Innodb and XtraDB Architecture and Performance Optimization. Peter’s talks are always great, and this is a perennial favorite. If you have never been, you should go to this one. You will realize how little you really know about InnoDB/XtraDB, and how much it matters.
Somebody asked me for a useful example of Oracle 11gR2′s new analytical LISTAGG function that uses a WITHIN GROUP syntax. They’d noticed an update to the askTom that showed how to use it. This post shows how to list values without a displayed aggregation column and how to use a JOIN and GROUP BY clause with the new analytical feature.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
COLUMN list FORMAT A10
COLUMN last_name FORMAT A10
COLUMN names FORMAT A42
COLUMN members FORMAT 9,990
SELECT m.account_number AS account
, c.last_name AS last_name
, LISTAGG(c.first_name||DECODE(c.middle_name,NULL,NULL,' '||SUBSTR(c.middle_name,1,1)||'.'),', ')
WITHIN GROUP (ORDER BY 2) AS names
, COUNT(*) AS members
FROM contact c INNER JOIN member m … |
When you install a Galera Cluster for MySQL for High Availability (HA) it is not enough to install the Database Cluster to achieve this goal. You also have to make the application aware of this HA functionality. This is typically done with some kind of load balancing mechanism between the database and the application.
We have several possibilities how to make such a load balancing possible:
(a slightly modify rebroadcast of Florian’s post)
If you are interested by High availability solution with MySQL, Florian Haas from and myself myself will be co-presenting next Tuesday a tutorial on the topic. It is never too late to register!
For the ones who are already registered, here’s advance information which you will find useful.
As our tutorial is going to be highly interactive, every attendee will have the opportunity to follow along with Florian and me as we walk you through several deployment scenarios for Pacemaker MySQL high availability. We’re coming with pre-installed virtual machine images for you to use.
Florian took care of the Libvirt/KVM (or Libvirt/Qemu) and VMware images for you while I has prepared virtual appliances for VirtualBox. The …
[Read more]For those of you coming to the High Availability Deep Dive tutorial that Yves Trudeau and myself will be co-presenting next Tuesday, here's advance information which you will find useful.
Now updated and fixed for Planet MySQL. Sorry about the earlier inconvenience.
For those of you coming to the High Availability Deep Dive tutorial that Yves Trudeau and myself will be co-presenting next Tuesday, here's advance information which you will find useful.
Now updated and fixed for Planet MySQL. Sorry about the earlier inconvenience.
<
p>
After the fun with InnoDB and MyISAM and massive partitioning it's time to move on to some other storage engines. So for the next round of fun i chose ARCHIVE:
mysql> create table t1 (id int primary key auto_increment, val int)
engine=archive partition by hash(id) partitions 1023;
Query OK, 0 rows affected (0.26 sec)
mysql> insert into t1 values(NULL,1);
ERROR 1194 (HY000): Table 't1' is marked as crashed
and should be repaired
mysql> drop table t1;
ERROR 2013 (HY000): Lost connection to MySQL server
during query
PS: MariaDB does not seem to be affected ...
A big thanks to the Rocky Mountain Oracle User Group (RMOUG).
They have just added MySQL as a new Special Interest Group
(SIG).
The first official meeting will be held at the Quarterly
Education Workshop on May 18th. This will be at the Colorado
Oracle Broomfield offices. We plan on having Ronald Bradford,
Dave Stokes, George Trujillo and myself all attending and
presenting.
More information about RMOUG can be found here -
www.rmoug.org