courses take place here
Open Source Training: (gleicher Kurs auf deutsch)

MySQL advanced

MySQL for advanced DBA's

MySQL is easily and quick to install. But what then? The amount of data grows, the database becomes business-critical...

In this course you will learn the different kinds of how to install MySQL, tricks for creating tables, querying or changing data and many other interesting useful commands.

Setting-up a database is one thing. But operations of a database is another thing. We will discuss the user privileges and the security concept of MySQL an look at the further steps which are necessary to operate a MySQL database.

Everybody has a backup and who thinks about the restore? You will learn what is important for backup and restore and what possibilities you have with MySQL.

Further the performance tuning is an important task. For most of the MySQL users it has the highest priority. You will learn a systematical way to find and solve MySQL performance problems.

Price

3 days, 2,350.00 € + 19% vat = 2,796.50 €

Full eight clock hours per day, complete set of literature, WiFi, complimentary notebook, full board, drinks (selected wines are charged separately), pastries, homemade cakes, sauna, social program

Extended/reduced amenities on demand:

Surcharge per guest night in two bed rooms (spacious and comfortable rooms) 59.00 € + 7% vat = 63.13 €per night
Surcharge per guest night in the Linuxhotel-flat share 83.00 € + 7% vat = 88.81 €per night
Surcharge per guest night in single rooms (depending on availabity, early reservation recommended) 129.00 € + 7% vat = 138.03 €per night
Reduction for half board instead of full board accomodation -29.41 € + 19% vat = -35.00 €per day
Reduction w/o social program -8.40 € + 19% vat = -10.00 €per evening

Tax deductibility * Terms of cancellation

Schedules/Reservations

Please select your favourite reservation date

Tutors

Oli Sennhauser was for 3 years working as consultant for the company MySQL. Now he is independent MySQL consultant for his own customers.

Thanks to his countless assignments he is very familiar with the matter. The learnings at his customers he passes later on to the next customers. Of course he incorporates all his collected know-how into this course.

prerequisites for attending

The participants should be used in using the Linux console and cope with the most important UNIX commands.

Further the participants should be already familiar with MySQL and the SQL language. For this please have a look at the contents of the courses MySQL and SQL.

If you feel uncertain on this point, we look forward to assist you via email or phone.

Course contents

Backup, restore, recovery

Master/slave and master/master replikation

Aktiv/passiv fail-over cluster with DRBD

Synchronous multi-master replikation with Galera Cluster for MySQL

Overview MySQL Cluster

(In this course we only talk shortly about the concepts behind the software MySQL-Cluster. For the interested we offer a stand-alone training.)

Performance

System configuration

Applikation

Architecture

Course schedule