Join MySQL technical expert John Kehoe to learn how to achieve High Performance and Availability in a Clustered Environment in Part II of our Best Practices for Using MySQL in SaaS webinar series. John will show you how to maintain SLAs for a large user base with minimal effort and cost, reviewing the following key topics:

• MySQL in SaaS and Cloud
• Replication
• HA, Self-Healing, and Data Integrity
• Provisioning, Monitoring, and Resource Management.

In case you missed it, John's extremely popular SaaS Best Practices, Part I is now available on demand. It covers: MySQL 5.6, Securing MySQL, Monitoring MySQL, and MySQL Enterprise Edition.

If distribute your applications via SaaS, or plan to, you won’t want to miss Part II, or Part I!

Noch eine Woche Zeit, bis zum Sonntag, den 15. Juni 2015 um Vorträge für die DOAG 2014 Konferenz & Ausstellung, einzureichen. Die DOAG 2014 Konferenz & Ausstellung findet von Dienstag, den 18. November 2014 bis Donnerstag, den 20. November 2014 in Nürnberg statt. Lassen sie Andere ab Ihren Erfahrungen partizipieren und sie bekommen einen Konferenzpass.

Mehr:
http://www.doag.org/de/events/konferenzen/doag-2014/fuer-referenten.html

Diese Woche fand sehr erfolgreich Treffen des DOAG Datenbank Community Teams statt. Es wurden die Themenverantwortlichen festgelegt, die DOAG 2015 Datenbank besprochen und weitere Aktivitäten geplant.

Am Donnerstag, den 19. Juni 2014 findet um 18:00 Uhr (CEST) der englischsprachige ORACLE Live Webcast zum Thema "MySQL Fabric - High Availability & Automated Sharding for MySQL" statt.

Die Referenten sind
Andrew Morgan, ORACLE Principal MySQL Product Manager
Mats Kindhal, ORACLE Senior Principal Software Developer      

More:
https://event.on24.com/eventRegistration/EventLobbyServlet?target=registration.jsp&eventid=799719&sessionid=1&key=89EB5C10637527482E1B7B01006FBE68&sourcepage=register

Jetzt Vorträge für die DOAG 2014 Konferenz + Ausstellung, die von Dienstag, den 18. November 2014 bis Donnerstag, den 20. November 2014 in Nürnberg stattfinden wird, einreichen und dann als Referent an der Konferenz teilnehmen.

Mehr:
http://www.doag.org/de/events/konferenzen/doag-2014/fuer-referenten.html

MySQL Fabric is built around an extensible and open source framework for managing farms of MySQL Servers. Currently two features have been implemented - High Availability (built on top of MySQL Replication) and scaling out using data sharding. These features can be used in isolation or in combination. MySQL Fabric aware connectors allow transactions and queries to be routed to the correct servers without the need for a proxy node, so operations run as quickly as ever. In this webinar you will learn what MySQL Fabric is, what it can achieve and how it is used - by DBAs, Dev-Ops and developers. You'll also be exposed to what is happening under the covers. In addition to the presentation, there will be live on-line Q&A with the engineering team. This is a great opportunity to learn about the latest developments directly from the people building them.

Danke Jockel…der Tip ist zwar schon etwas betagt, hat mir aber grad weitergeholfen.
CREATE TEMPORARY TABLE war mir bislang entgangen…!

Grüsse von etwas weiter nördlich…
Dirk

Completing a successful MySQL upgrade represents the way to benefit from all the new features and improvements available in the latest MySQL release. Join us for this webinar where our experts will provide you with the knowledge you need as well as best practices enabling you to successfully upgrade to MySQL 5.6. We will cover:

• MySQL 5.6 key features and enhancements
• Best Practices to upgrade to MySQL 5.6 from previous versions

Most general performance issues come down to query performance. Once you've identified a query that requires further examination using SHOW PROCESSLIST, Performance Schema, the Slow Query Log, or MySQL Enterprise Monitor's Query Analyzer, you then need to determine exactly *why* it was slow. In order to do that, you need to determine what the MySQL optimizer did when executing it, what it is likely to do when executing it in the future, and why it made those decisions. This is where EXPLAIN (including the new JSON based output), along with the new Optimizer Trace feature, provides you with the needed information to understand what happened, why, and how you can tweak the query, your schema, or the optimizer itself in order to improve the query's performance. As we go along, we'll also demonstrate how the new Visual Explain functionality available in MySQL Workbench 6.1 helps us to visualize these results. In this technical webinar we will cover:

Tag der Arbeit: Mal eben einen Galera Cluster upgraden

Gegeben ein Galera Cluster für welches im Repository neue Pakete vorhanden sind.

> yum info galera
Installed Packages
Name        : galera
Arch        : x86_64
Version     : 25.3.2
Release     : 1.rhel6
Size        : 29 M
Repo        : installed
From repo   : mariadb

Available Packages
Name        : galera
Arch        : x86_64
Version     : 25.3.5
Release     : 1.rhel6
Size        : 7.6 M
Repo        : mariadb

> yum info MariaDB-Galera-server
Installed Packages
Name        : MariaDB-Galera-server
Arch        : x86_64
Version     : 5.5.36
Release     : 1.el6
Size        : 102 M
Repo        : installed
From repo   : mariadb

Available Packages
Name        : MariaDB-Galera-server
Arch        : x86_64
Version     : 5.5.37
Release     : 1.el6
Size        : 25 M
Repo        : mariadb

Rolling Upgrade

Einer der tollen Features von Galera ist die Möglichkeit des …