What is Monitoring as a Service (MaaS)?

Typical monitoring solution as for example the MySQL Enterprise Monitor, Nagios/Icinga, Cacti, Munin, etc. consist more or less of 2 components:

Request a Service Key for the Performance Monitor for MySQL

To provide you a correct configuration and to grant you access to our system we need some information from you.

Fields marked with an asterisk (*) are required.

CREATE TABLE `order` (
  id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
, name VARCHAR(64) NOT NULL
) ENGINE = InnoDB;

INSERT INTO `order` VALUES
  (NULL, 'Test order 1')
, (NULL, 'Test order 2')
, (NULL, 'Test order 3');


CREATE TABLE pos (
  id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
, order_id INT UNSIGNED NOT NULL
, name VARCHAR(64) NOT NULL
, amount SMALLINT NOT NULL
, price DECIMAL (6,2) NOT NULL
, status TINYINT NULL
) ENGINE = InnoDB;

INSERT INTO pos VALUES
  (null, 1, 'Schrauben', 50, 0.10, 0)
, (null, 1, 'Muttern', 50, 0.10, 0)

Introduction

Galera is a synchronous Multi-Master Replication for MySQL. It is therefore in competition with several other MySQL architectures:

Im Admin-Magazin 2011/06 hat es einen netten Artikel über MySQL und PostgreSQL Performance Tuning: Duell der Datenbanken: In einem Shootout messen sich MySQL und PostgreSQL

Susanne hat dabei PostgreSQL, wir MySQL betreut...

Summary: In this article we have a short look at a simple MySQL example program written in Vala.

With a partner we are planning and Advanced MySQL DBA workshop. As the name says it should be a workshop. Its planned duration is 2 days. So within 2 days we can cover 4 to 8 topics more deeply.

Requirements: VirtualBox, VMware, own Laptop?

Possible exercises during the workshop

• Set-up a Master-Master replication with 2 Slaves
• Load balance on master with MySQL Proxy and on Slaves with LVS.

Abstract: In this article we discuss how big is the performance impact of MySQL TRIGGERs compared to application side logging (with INSERT) into a MySQL table.

One of our partners recently asked me on what platforms do we usually see MySQL installed out there...

The last 5 years I gave the answer: Typically it is 80% Linux, 10% Windows, 5% Solaris and 5% all others. But this was only the picture of my limited view and I was not sure how objective this was.

This time I really wanted to know it and so I collected the information of about 570 MySQL installations of customers.

The following numbers came out:

Today the German speaking MySQL User Group (DMySQLAG) was officially founded in Berlin.

The association advocates:

• the information of the use, the handling and the experience with MySQL and development in the MySQL Eco-System as well as systems which use MySQL.
• the exchange of experience between MySQL users about MySQL and other systems.
• the Advice and Cooperation with Oracle and vendors of other systems.
• the submission of suggestions of the members to Oracle and vendors of other systems.

Heute wurde in Berlin die Deutschsprachige MySQL Anwender Gruppe formal gegründet.

Der Verein fördert:

• die Information über den Einsatz, den Umgang und die Erfahrung mit MySQL und Entwicklungen im MySQL Eco-System sowie Anwendungssysteme welche MySQL nutzen.
• den Erfahrungsaustausch zwischen den Benutzern über MySQL sowie anderer Systeme.
• die Beratung und Zusammenarbeit mit Oracle und Herstellern anderer Systeme.
• die Unterbreitung von Mitgliedervorschlägen an Oracle und Hersteller von anderen Systemen.

In our last customer project we had around 600 Gbyte of data in a MySQL database. Because this database consumed a significant amount of our disk space and backups with the InnoDB backup tool took pretty long we wanted to find out if we could get rid of some of the tables.
This application was growing over the last 10 years and it was not clear if some tables are still in use or not.

But how to find out when a table was touched last? MySQL/InnoDB theoretically could know about but does not report this information.

Ein Kunde, welcher mit digitalen Zertifikaten zu tun hat, hatte ein Problem mit einem solchen. Also mussten wir nachforschen, was das Problem war.

Weil das Zertifikat in binärer Form vorliegt, ist es in einem BLOB gespeichert und wir mussten es aus der Datenbank herausklauben um einige Tests damit durchzuführen.

Als erstes kam mir in den Sinn, das Zertifikat mit dem Befehl SELECT INTO OUTFILE zu erhalten. Aber das Verifizierungstool reklamierte und sagte uns, dass das Zertifikat ein falsches Format habe.

A customer who is handling digital certificates had a problem with one of those. So we had to investigate.
Because the certificate is in binary form it is stored in a BLOB and we had to extract it from the database to do some verifications.

What first came to my mind was to extract the certificate with the SELECT INTO OUTFILE command. But the verification tool complained and told us that the certificate has a wrong format.

If you ask around about shared hosting setups with MySQL everybody is frightened. In fact it looks like shared hosting is one of the most difficult setups you can get.

The number of users is big, the number of tables huge and the load pattern is completely unpredictable and the queries often very, let us say: non-optimal.

Here one of the DBA wisdoms come into play: Controlling developers is like herding cats.

If you talk to the Shared MySQL Hoster they confirm that this setups are very demanding!

From the Cooperation of these two companies arises the biggest independent service provider for MySQL and MariaDB in Europe.

Hamburg, Uster -- February 28, 2011 - The Hamburg based PrimeBase Technologies and the near Zürich located FromDual are forming a Cooperation for MySQL products and services, starting March 1st, 2011.

This Cooperation enables both companies to offer a complete set of services for all MySQL and MariaDB customers.

The customers of both parties now have he possibility to demand a 24x7 support service from their provider.

Wir sind am DOAG Regionaltreffen in München am Mittwoch den 23. März mit unserem Vortrag MySQL Replikation - Scale-Out, Master-Master, Backup (der Vortrag wird in deutscher Sprache gehalten).

FromDual releases its new version v0.5 of its MySQL Performance Monitor working with Zabbix.

What has changed so far in this release:

• Recommended Location has changed to /usr/local
• FromDual agent log files are rotated now.
• There are now 2 different packages: One for the Agent and one for the Templates.
• Some of the graphs were improved.
• Missing status and system variable information were added and some were fixed.
• Verbosity of logging information was adjusted.

2000 - 2049

• 
  Error: 2050
  (CR_FETCH_CANCELED)

  Message: Row retrieval was canceled by mysql_stmt_close() call

• 
  Error: 2051
  (CR_NO_DATA)

  Message: Attempt to read column without prior row fetch

1700 - 1749
2050 - 2099

• 
  Error: 2000
  (CR_UNKNOWN_ERROR)

  Message: Unknown MySQL error

• 
  Error: 2001
  (CR_SOCKET_CREATE_ERROR)

  Message: Can't create UNIX socket (%d)

1650 - 1699
2000 - 2049

• 
  Error: 1700 SQLSTATE: HY000
  (ER_GRANT_PLUGIN_USER_EXISTS)

  Message: GRANT with IDENTIFIED WITH is illegal because the user
  %-.*s already exists

1600 - 1649
1700 - 1749

• 
  Error: 1650 SQLSTATE: HY000
  (ER_SLAVE_IGNORE_SERVER_IDS)

  Message: The requested server id %d clashes with the slave startup
  option --replicate-same-server-id

1550 - 1599
1650 - 1699

• 
  Error: 1600 SQLSTATE: HY000
  (ER_VIEW_INVALID_CREATION_CTX)

  Message: Creation context of view `%s`.`%s' is invalid

1500 - 1549
1600 - 1649

• 
  Error: 1550 SQLSTATE: HY000
  (ER_EVENT_COMPILE_ERROR)

  Message: Error during compilation of event's body

• 
  Error: 1551 SQLSTATE: HY000
  (ER_EVENT_SAME_NAME)

1450 - 1499
1550 - 1599

• 
  Error: 1500 SQLSTATE: HY000
  (ER_SUBPARTITION_ERROR)

  Message: It is only possible to mix RANGE/LIST partitioning with
  HASH/KEY partitioning for subpartitioning