Neuigkeiten

Hi handon,

In the MPM installation guide I can find this:

This means that the item FromDual.MySQL.check is not known to the Zabbix Server. Then you have possibly forgotten to ad the mysql module template to the host you want to monitor.

This seems to be not true any more! Now it is the mpm module. We will fix this in the documentation asap!

When you have added the mpm module to the/a server and disable/enable it once Zabbix should detect it and start polling the agent.

I hope this helps. If not, please let …

Hello amatus,

Not sure if I understood you correctly. But the output is in the following Before and After code boxes…

I have changed this now a bit for beeing more clear.

Please elaborate a bit more if I missed you. Regards, Oli

Question: How does the MPM MaaS agent send data to the service?

Answer: The MPM MaaS agents uses a simple HTML file upload to send data to the service.

Question: Is it possible to encrypt the data the MPM MaaS agent is sending to the service?

Answer: Currently the MPM MaaS agent only does a plain HTML file upload. So NO data encryption happens at the moment. If we see high demand of customers for this feature we will implement it.

Question: Is there a company behind this MySQL monitoring service?

Answer: …

Question: What is the MySQL Performance Monitor (MPM) monitoring and what data is the agent sending?

Answer: The MPM agent is gathering mainly the output of:

SHOW GLOBAL STATUS;
SHOW GLOBAL VARIABLES;
SHOW ENGINE INNODB STATUS;

and some data of the INFORMATION_SCHEMA and the PERFORMANCE_SCHEMA

Question: What MPM modules do you provide at the moment?

Answer: You can find a list of the provided modules here.

How to test MySQL Monitoring as Service (MaaS) for free?

To get MaaS for MySQL follow these steps:

• Request a MaaS trial service key. It will take up to 48 hours until you receive it. We only hand out trial service keys if your data are filled in correctly.
• Download the Performance Monitor for MySQL.
• Install the Performance Monitor for MySQL. The installation documentation is here.
• Run the Performance Monitor for MySQL with the configuration file we provide you by e-mail.

What is Monitoring as a Service …

Hello Reid,

Try to break it down into smaller pieces. Do the VIP manually first:

shell> ifconfig bond0 192.168.1.100   # or what ever you device is

Then try to ping it from local:

shell> ping 192.168.1.100

Then try to ping it from remote. If this works take it down again:

shell> ifconfig bond0 down

and continue with heartbeat.

Typically with virtual machines I have the problem of configuring the VM networking correctly. Did you make sure you can ping a normal IP from outside and between both nodes?

New version of FromDual’s Performance Monitor for MySQL (MPM) v0.7.2 is out

Dear MySQL User,

On December 2^nd 2011 FromDual released the new version v0.7.2 of its MySQL Performance Monitor. The new version can be downloaded from here.

The Performance Monitor for MySQL is an agent which is hooked into the agent of the well known Monitoring solution called Zabbix. Zabbix is an integrated Enterprise Monitoring solution which can produce performance graphs and alerting.

The changes in the new release are: …

Please continue here.

Rumbi pointed me to a bug in the PDF!

The first Slave S should point to Master M on port 3315.

I have fixed the PDF now. Thanks Rumbi!

This concept/PoC is old! Nowadays we do not need this anymore.

What in this blog post was described nowadays is called Multi-Source Replication. If you really need Multi-Source Replication I would go for Tungsten Replicator.

This concept/PoC is old! Nowadays we do not need this anymore.

What in this blog post was described nowadays is called Multi-Source Replication. If you really need Multi-Source Replication I would go for Tungsten Replicator.

Canias is a great ERP product but there is still some potential to improve it. We only focus on MyISAM/InnoDB installations of Canias v6.0.2 in this article. For other DB back-ends those recommendations might be obsolete.

A general problem is, that in InnoDB Primary Keys are crucial in MySQL. Canias often lacks a Primary Key. In this case InnoDB will use the Unique Key for the Primary Key.

In InnoDB data are sorted by the Primary Key so it is a good idea to have the Primary Key on CLIENT and COMPANY as well …

Yesterday we released the new version of the MPM v0.8. The most important new features are:

• All modules are now available under GPL (including InnoDB and NDB module!).
• The MySQL Performance Monitor agent can now be use for Monitoring as a Service. We provide the Monitoring solution. You just have to install the agent.

Currently we are looking for people who want to test the new feature. If you are interested please get in contact with us.

Dear user,

Our website is currently overloaded. Please try again in a few minutes.

Your FromDual team

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', …

If you cannot wait you can read Building Galera Replication from scratch…

Yes I know! :)

It will NOT work with 1.0… We did some tests earlier with 1.0 and they failed. The results made it into into 1.1…

Follow the Galera documentation as well!

What was needed in addition in my case:

yum remove boost.x86_64 boost-devel.x86_64
yum install boost141.x86_64 boost141-devel.x86_64 openssl-devel.x86_64
yum install ncurses-devel.x86_64 bison.x86_64 bison-devel.x86_64
yum install gcc44.x86_64 gcc44-c++.x86_64

ldconfig -p | grep libboost_program_options

ln -s /usr/lib64/libboost_program_options.so.5 /usr/lib64/libboost_program_options.so

Hello Vineet,

Great if it was a help for you…

I did it from source because of several reasons:

1. I have a complicated environment (up to 50 MySQL instances running potentially in parallel) and deb/rpm packages would not help here. So I have to use binary tar balls. By the way: our 17-node Galera Cluster was built on such a set-up.
2. Version 5.5 is definitely the way to go.
3. The binary tar ball I got did not contain everything I needed (garbd, rsync SST script).
4. I just want to know how it …