Neuigkeiten

Has this ever worked before (with < 2.2)?

Error 1305 means, that the agent cannot connect to the zabbix server. We verify: ZabbixServer, ZabbixPort and Hostname

And for hostname the following rule applies: "This MUST match Hostname in Zabbix!"

This is a typical configuration mistake. So I am wondering if it is a config mistake or if something in 2.2 has changed...

It looks for me like check delivers an empty string and expects an int or decimal. One has to check what check delivers exactly and why. Debugging in the fpmmm agent should help on this…

Codership hat heute den Galera Cluster 3.0-beta (24.3.0) basierend auf MySQL 5.6 sowie Galera 2.7 (24.2.7) basierend auf MySQL 5.5 freigeben!

Wichtigste neue Features:

• Galera für MySQL 5.6
• Nutzung der MySQL Global Transaction ID (GTID)
• Cluster-Segmentierung optimiert für WAN Umgebungen
• Nutzung unterschiedlicher Binary-Log Channels für Replikation-Slaves ist jetzt einfacher.
• Optimierung der Kommunikation für grosse Transaktionen.

Download here.

[07:51:52] shyperson: I would suggest to --insert the rule instead of --apendING
[07:52:15] shyperson: Just to make sure there are no other rules allowing mysqlport before

About

glbd is a simple TCP connection balancer made with scalability and performance in mind. It was inspired by pen, but unlike pen its functionality is limited only to balancing generic TCP connections.

Features:

• list of backend servers is configurable in runtime.
• supports server draining, i.e. does not allocate new connections to server, but does not kill existing ones, waiting for them to end gracefully.
• can use epoll API provided by Linux version 2.6 and higher for ultimate routing performance.
• glb is …

Hello Shinguz,

Pay attention: Your script is a bit too restrictive. It will IMHO also close the port for the SST when you use the wsrep_sst_methode = mysqldump. Possibly you should restrict it to the Load Balancer IP or allow access at least from the possible donors.

Cheers,
Oli

I was recently told that it would be better to use REJECT than DROP:

As a general rule, use REJECT when you want the other end to know the port is unreachable' use DROP for connections to hosts you don't want people to see. [ 1 ]

Since MySQL 5.1.43 timestamp is not allowed as partition key any more [ 1 ]. Thus we can do it as follows:

CREATE TABLE ptn_test (
  id INT UNSIGNED NOT NULL AUTO_INCREMENT
, data VARCHAR(64)
, dt DATETIME
, PRIMARY KEY (id, dt)
, INDEX (dt)
) ENGINE = MyISAM
PARTITION BY RANGE ( TO_DAYS(dt) ) (
  PARTITION p_2010    VALUES LESS THAN ( TO_DAYS('2011-01-01 00:00:00') )
, PARTITION p_2011_01 VALUES LESS THAN ( TO_DAYS('2011-02-01 00:00:00') )
, PARTITION p_2011_02 VALUES LESS THAN ( …

Table of Contents

• Accounts not properly closing connections
• Unused indexes
• Who created temporary (disk) tables
• Accounts which never connected since last start-up
• Users which never connected since last start-up
• Totally unused accounts (never connected since last restart and not used to check Stored Program or View privileges) since last start-up
• SHOW FULL PROCESSLIST
• Storage Engines per schema
• Tables without a Primary Key
• Bad SQL queries of users
• SHOW PROFILE in PERFORMANCE_SCHEMA
• SELECT, INSERT, UPDATE and …

We did a similar thing this week with Galera Cluster for MySQL and the Galera Load Balancer (glb).

Here you can find the script.

I have not had the time yet to test it. Please let us know if it does not work or when you were successful...

Hi Fabio,

There are several ways to do this. The most simple one but possibly not what you need is:

mysql> pager grep A
SHOW DATABASES;

The better way to do this IMHO is:

mysql> SHOW DATABASES LIKE 'A';

And the best way (works in MySQL 5.0 and newer) IMHO is:

mysql> SELECT * FROM information_schema.schemata WHERE schema_name = 'A';

I hope this helps you solving your problem?

Regards,
Oli

VirtualBox

Network Interface does not start on Guest System:

MAC Address must be all the same in:

• /etc/sysconfig/network-script/ifcfg-eth0
• /etc/udev/rules.d/70-persistent-net.rules
• AND VirtualBox: Guest
  > Network
  > Adapter
  > Advanced
  > Mac Address

FromDual invites you to check out our 2013 professional course schedule, set out below.

You need to book early to avoid disappointment. Why?

Because we run small, intimate and in-depth classes, giving you more time for -

• individual attention
• lots of interaction
• sharing of insights and experience

Our aim is to give you real value for your money and a genuine return for your investment with us.

Special Addition

Due to customer requests, we have added two of our advanced MySQL training courses in late April …

Overview

• MySQL Security Products
• Useful Security Links
• Security Vulnerabilities Fixed in MariaDB
• Oracle Critical Patch Update (CPU) Advisory for MySQL
• RedHat/CentOS vulnerabilities by CVE name
• Ubuntu Security Notice (USN) for MariaDB
• Ubuntu Security Notice (USN) for MySQL
• Debian Security Advisories
• Debian Security Advisories for MySQL
• MySQL Exploits
• Debian Security Advisories for MariaDB
• MariaDB Exploits
• MariaDB Security Risk Matrix
• Cyber Emergency Response Team (CERT) in Australia and APAC
• MariaDB …

Register here for our MySQL and MariaDB trainings in Switzerland. For our MySQL and MariaDB trainings in Germany you can register directly on-line at the MySQL and MariaDB training class schedule.

Prices

The training fees for Switzerland are:

• SQL for beginner (3 days): CHF 2'880.-
• MySQL for beginner (2 days): CHF 1'920.-
• MySQL for developer (3 days): CHF 2'880.-
• Advanced MySQL (5 days): CHF 4'450.-
• Galera Cluster for MySQL (2 days): CHF 1'920.-

If you wish other training dates, please get in contact with …

You are already familiar with the MySQL or MariaDB and you are challenged to operate a serious MySQL database. If this is the case this training is the right one for you.

Requirements

You are familiar with the MySQL basics and have already some experience with MySQL or MariaDB operations. The SQL language does not look strange to you any more. Further you are familiar with the Linux console and rule the most important UNIX commands.

Audience

• MySQL application developer
• MySQL and MariaDB database …

Will come soon…

Please let us know your intention to for choosing this page!

Will come soon…

Please let us know your intention to for choosing this page!

Hallo MySQL Gemeinde,

Im neuen iX (2012-10) hat es zwei nette Artikel über: MySQL HA-Lösungen (S. 116) und MySQL 5.6 (S. 66).

Viel Spass beim Lesen!

Hello Frazer,

Thank you very much for your valuable feedback. Good that Oracle is doing something in this direction and make MySQL even easier to use!

Oli