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:
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:
…[Mehr]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 …
[Mehr]
Galera ist die synchrone Multi Master Lösung für
MySQL.
Auch wenn wir bei PXC oder MariaDB Galera Cluster immer von
Galera sprechen,
ist Galera nur ein Provider.
Provider? Was meinst Du damit?
Bei der Konfiguration von “Galera” gibt
es zwei Optionen
wsrep_provider und wsrep_provider_options
Bei ersterem wird der Provider eben Galera definiert.
Die bei der zweiten Option handelt es sich um die Konfiguration
eben diese Providers.
Die restlichen wsrep_ Optionen sind für wsrep.
https://launchpad.net/wsrep
wsrep API defines a set of application callbacks and replication library calls necessary to implement synchronous writeset replication of transactional databases and similar applications. It aims to abstract and isolate replication implementation from application details. Although the main target of this interface is a certification-based …
[Mehr]MySQL Enterprise Backup 3.10 delivers significant improvements in terms of speed, compression, flexibility, efficiency and security. Join us to understand how those improvements can help you better manage your backups. You will learn about:
· Two new compression options – their benefits, and where & how to use them
· New Advanced Encryption Standard (AES) Security - and best practices for securing backups using it
· Further enhancements to our very popular “Zero Space” one step streaming backup and recovery, now available for tables
· New filtering options for partial backups
Performance is always top of mind for MySQL developers and DBAs. This is precisely why we designed new tools to help you assess and improve MySQL performance, and made them available within MySQL Workbench 6.1. Join us in this webinar to discover and learn how to use:
Der Call for Proposals für die von Sonntag, den 28. September
2014 bis Donnerstag, den 02. Oktober 2014 in San Francisco
stattfindenen ORACLE Open World 2014 ist nun offen.
More:
http://www.oracle.com/openworld/call-for-papers/index.html
Hallo,
anbei ein Überblick über die Vorträge in diesem Halbjahr.
Zudem gebe ich noch eine öffentliche Schulung im Linuxhotel zu LXC und neuen Linuxfeatures (Anfang Mai)
Viel Spaß :)
Erkan
Expand your knowledge with Jess Balint; he will share his experience as a seasoned Java application developer who both uses and develops MySQL Connector/J. Having previously helped modernize Connector/ODBC, Jess has recently implemented support for MySQL Fabric in Connector/J. In this technical webinar, you'll learn low-level details about optimizing client/server communication, as well as high-level integration with connection pools and application frameworks like Spring. This session will cover:
How does MySQL spread and become business critical in your organization? What are the typical adoption and deployment models, and their implications? How can IT Managers, architects and DBAs proactively “operationalize” MySQL deployments in order to reduce TCO, improve operational efficiently and limit risks? Join MySQL Sales Consultant John Kehoe who will share best practices from the field. He will help you understand with numerous examples how to choose the right MySQL solution according to your needs, and how to strategically operationalize your MySQL deployments with a proven method.