Join Continuent and our customers Modernizing Medicine and Marketo to learn how to run business-critical MySQL applications in the cloud or on-premises. Modernizing Medicine is a fast-growing SaaS company, offering electronic medical records management solution. Matthew Lang, Sr. Site Reliability Engineer at Modernizing Medicine, describes how Modernizing Medicine serves thousands of customers

I’m a big fan of the MySQL command line tool ie the default text client modestly named: mysql. I use it everyday because you can do almost everything with it (DML, DDL, DCL, administrative tasks,...).

It has many options including generate xml or html output.

$ mysql --help | grep "\--html" -H, --html Produce HTML output.

On Tuesday Sept.10 I went to PHP TechTalks with Rasmus Lerdorf, Sebastian Bergmann, and Stig Bakken. Great initiative by Stig Bakken @ Zedge. The TechTalks focused on new features and best practices and for PHP 5.4 and 5.5.
Great feeling of going to the roots of LAMP and MySQL. Thanks for the invite Stig!

(For more have a look at https://zedgetechtalksphp.eventbrite.com/).

It is our great pleasure to announce that Harrison Fisk will deliver a "MySQL at Facebook" keynote at MySQL Connect!

Our keynote lineup is now as follows:

Saturday, September 21, 9:00 a.m.–10:00 a.m.
The State of The Dolphin

Join Edward Screven, Oracle’s Chief Corporate Architect, and Tomas Ulin, Vice President of MySQL engineering, for the State of the Dolphin keynote address. Learn about Oracle’s MySQL strategy as well as the latest innovations and plans for MySQL.

10:00 a.m.–10:20 a.m.
MySQL At Facebook

MySQL has come a long way at Facebook, now hosting one of the world's largest online data set. Don't miss Harrison's exciting keynote about MySQL at …

While we are working hard on the final push of Percona Server 5.6 GA (I know that many people are waiting on this, but stay with us – we want to ensure that we have a quality release with great performance), I decided to make an experimental build of Percona Server 5.6 with the TokuDB engine.

It’s available here: http://www.percona.com/downloads/TESTING/Percona-TokuDB/.

If you are interested, please test it and provide us with feedback. If things look good, in couple months we may release an official Percona Server 5.6 with TokuDB.

The post …

If you happen to have some free time tomorrow and are in Madrid please come along to the second Madrid MySQL Users Group.

Details can be found here. The meeting will be in Spanish. I look forward to seeing you.

When I worked for MySQL I saw frequent complaints that the UNIQUE constraint didn't stop users from inserting NULLs, multiple times. For example:
CREATE TABLE t (s1 INT, UNIQUE (s1));
INSERT INTO t VALUES (NULL);
INSERT INTO t VALUES (NULL); /* This does not cause a "unique constraint violation" error */

There are now eleven generously-commented bugs.mysql.com reports:
#5685, #6829, #7479, #8173, #9844, #17825, #19377, …

Ich brauche mal Hilfe. Sonntag haben wir in Bayern Volksentscheide zu 5 Verfassungsänderungen. Im Landtag haben CSU, SPD, FDP und FW dafür gestimmt nur die Grünen nicht. Die Änderungen gehen zurück auf eine Aschermittwochsrede Seehofers in der er die deutsche "Leitkultur" in die Verfassung aufnehmen wollte. Da das 2/3 der Stimmen im Landtag und Volksentscheid hat die CSU zu verhandeln begonnen. Herausgekommen sind 5 Verfassungsänderungen:

• Förderung gleichwertiger Lebensverhältnisse und Arbeitsbedingungen 
• Förderung des ehrenamtlichen Engagements
• Angelegenheiten der Europäischen Union
• Schuldenbremse
• Angemessene Finanzausstattung der Kommunen

By going to the download section of  SkySQL website  some users have noticed “MariaDB Audit Plugin”. This auditing feature for MySQL has been requested by more and more customers. Legal constraints make it mandatory for more and more companies to keep logging information about database access and activity.

It is very important for the MySQL [...]

So, now I’ve got my Raspberry Pi’s tested, and running MySQL Cluster we’ll need some form of checking it’s up and running, as with the rest of our MySQL servers.

Monitoring via a Remote Agent

First issue, of course, is that, with my existing MEM console, I have no need to re-install MEM, but rather want to deploy an agent so that I can monitor the MySQL Cluster.
This poses it’s first problem, as there isn’t an ARM-ready agent software available. Remember, it’s not a supported platform. So what can we do? Setup a remote Enterprise Monitor agent, so that, we can monitor the MySQL Cluster, albeit at the sacrifice of not having the agent local on each Raspberry Pi, and hence, not be able to capture the o.s. data.

Config change

So, on my Ubuntu server, I go to the agent install directory:

  cd /opt/mysql/enterprise/agent/etc
  vi mysql-mypi01-agent.ini
  :1,$ …