oli's blog

MySQL Server Error Codes and Messages 1200 - 1249

Taxonomy upgrade extras: 

1150 - 1199 1250 - 1299


  Error: 1200 SQLSTATE: HY000 (ER_BAD_SLAVE)
  Message: The server is not configured as slave; fix in config file or with CHANGE MASTER TO

How does the MySQL error message look like?

MySQL Error codes and messages

Taxonomy upgrade extras: 

Just a general rule with error messages: Usually they are not as good as they could be. But nevertheless read them carefully. Most of the time they tell you what you need to know…

MariaDB, Galera and MySQL Support

FromDual is a support partner of MariaDB plc, Codership Oy and Oracle Corporation. This gives us the opportunity to offer you customized enterprise support subscriptions for your mission-critical MariaDB, Galera or MySQL databases for all three vendors.

Results from using PBXT with AVG_ROW_LENGTH

Taxonomy upgrade extras: 

We dug some further with this problem of too big rows. The results you can find below.

Partitioning with PBXT MEMORY tables

Taxonomy upgrade extras: 

Further discussion we had about PBXT MEMORY tables partitioned:

Q: Is there a good case where partitioned PBXT MEMORY tables could make sense?

AVG_ROW_LENGTH = 12

Taxonomy upgrade extras: 

Hi Stewart,

Thanks for your comment. Paul made some similar conclusions:

MySQL Plugins and UDF's

Taxonomy upgrade extras: 

At the DOAG 2010 we found that there are already a lot of Plugins etc. for MySQL available. Therefor it will be a good time to start with a collection of Plugins, UDF’s etc. available.

Why shall 2 LCPs be kept?

Taxonomy upgrade extras: 

Hi Baomin Wang,

After some thinking an talking to some colleagues I found the answer:

Why shall 2 LCPs be kept?

Taxonomy upgrade extras: 

Hi Baomin Wang,

  1. I come back with an answer later…

Advanced MySQL DBA Workshop - draft

Taxonomy upgrade extras: 

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.

Who is corrupting InnoDB blocks?

Taxonomy upgrade extras: 

Because I have seen this week again a similar situation I thought about what could cause such InnoDB block corruptions. I came to the following evil-doers:

FromDual references

Taxonomy upgrade extras: 

What customers say about FromDual

Translate...
Wir sind mit der Funktionalität und der Einführung sehr zufrieden. Das gesamte Cluster läuft absolut stabil. Dies ist ein erheblicher Vorteil für unseren Kunden denn wir können unsere Dienstleistungen unterbrechungsfrei anbieten. Wir werden Galera bei weiteren Projekten einsetzen und bestehende Master/Slave-Anwendungen umstellen.
A. Rempening, Datenbank-Administrator, KiKxxl GmbH
 
Neben den fachlich sehr fundierten Tipps und Diskussionen hat mich die unkomplizierte und effiziente Art und Weise von FromDual beeindruckt! Das waren wertvolle Tage und meine Erwartungen wurden sogar übertroffen!
T. Schneider, Leiter IT, Mespas AG
 
Wir fühlen uns beim FromDual Support sehr gut betreut :)
Andreas Rose, DBA bei der AVM GmbH in Berlin

Case study / Referenzbericht

KiKxxl Gmbh: Hochverfügbare Kommunikationsservices auf Basis der MySQL Datenbank und Galera Cluster (Highly available communication services based on a MySQL database and Galera Cluster) (PDF, 420 kbyte)

Pages

Subscribe to RSS - oli's blog