{"guid":"73bbeee4-7791-42d2-b3bd-317ca12a8895","title":"MySQL 8 - The next big thing!","subtitle":"What's new?","slug":"froscon2018-2201-mysql_8_-_the_next_big_thing","link":"https://programm.froscon.de/2018/events/2201.html","description":"MySQL ist seit vielen Jahren eine der am meist verbreiteten Datenbanken überhaupt. Sie wird heute in vielfältigsten Anwendungen eingesetzt - von dem kleinen, privaten Internetauftritt bis zu unternehmenskritischen Einsätzen wie bei Booking.com oder auch zahlreichen  DAX notierten Unternehmen in Deutschland.\nIm April 2018 hat Oracle sein neues Datenbankmanagementsystem MySQL 8.0 als Nachfolgeversion für die MySQL 5.7 freigegeben.  MySQL 8 enthält zahlreiche Verbesserungen und zusätzliche Funktionen.\nDiese umfassen Erweiterungen im Bereich SQL (Windows Functions, Common Table Expressions), GIS (Spatial Reference Systems), Reliability (ACID DDL, Transactional Data Dictionary), Security (OpenSSL, SQL Roles, New Default Authentication), Invisible Indexes u.v.m.\nDie größte Neuerung betrifft die Unterstützung für NoSQL Datenbanken auf Basis des neuen MySQL X-Protocols. Ab Version 8 kann MySQL somit auch als dokumentenbasierte Datenbank genutzt zu werden und tritt in Konkurrenz zu Document Store Datenbanken.\nIn diesem Vortrag werden wir einen Einstieg in MySQL 8 vermitteln und einige der über 500 neuen Funktionalitäten vertiefen.\n\nDer Vortrag enthält zahlreiche live Demos!","original_language":"deu","persons":["ThalheimerC"],"tags":["froscon2018","2201","Databases"],"view_count":200,"promoted":false,"date":"2018-08-25T00:00:00.000+02:00","release_date":"2018-08-25T02:00:00.000+02:00","updated_at":"2024-12-30T08:45:08.931+01:00","length":3542,"duration":3542,"thumb_url":"https://static.media.ccc.de/media/events/froscon/2018/2201-hd.jpg","poster_url":"https://static.media.ccc.de/media/events/froscon/2018/2201-hd_preview.jpg","timeline_url":"https://static.media.ccc.de/media/events/froscon/2018/73bbeee4-7791-42d2-b3bd-317ca12a8895-timeline.jpg","thumbnails_url":"https://static.media.ccc.de/media/events/froscon/2018/73bbeee4-7791-42d2-b3bd-317ca12a8895-thumbnails.vtt","frontend_link":"https://media.ccc.de/v/froscon2018-2201-mysql_8_-_the_next_big_thing","url":"https://api.media.ccc.de/public/events/73bbeee4-7791-42d2-b3bd-317ca12a8895","conference_title":"FrOSCon 2018","conference_url":"https://api.media.ccc.de/public/conferences/froscon2018","related":[{"event_id":5734,"event_guid":"adde2800-ffa1-44c4-aafd-c4928ee5378d","weight":19},{"event_id":5735,"event_guid":"d494138e-2442-4b08-b06b-43e1aa444701","weight":3},{"event_id":5738,"event_guid":"fafacf91-9842-4a5f-bb02-146250450001","weight":19},{"event_id":5746,"event_guid":"ad920111-8443-4cde-9184-c94aa42a41db","weight":3},{"event_id":5751,"event_guid":"2b7d1c38-d3e0-4978-ac30-95aed9e7b0d7","weight":16},{"event_id":5754,"event_guid":"acca1d2a-792c-4ef0-a76a-33622dc89a7f","weight":14},{"event_id":5758,"event_guid":"ef2ff203-e91d-4b8f-90ad-966fe74d5325","weight":15},{"event_id":5761,"event_guid":"eff9b1c1-1e6b-445f-b153-a0b4a4e58b67","weight":17},{"event_id":5763,"event_guid":"e7828a90-6f0a-439b-a6a8-2e129a00b521","weight":17},{"event_id":5766,"event_guid":"73f1dcb2-25ba-48ff-a02a-3abc33360f03","weight":13},{"event_id":5773,"event_guid":"be056c9c-b6f6-42a3-adb1-0d6e80a1f4c7","weight":9},{"event_id":5784,"event_guid":"065821fd-67da-4565-a380-a6a9d403416e","weight":15},{"event_id":5789,"event_guid":"b4cb8731-0709-4c3e-967b-3766a15ea572","weight":19},{"event_id":5797,"event_guid":"b72de5fc-3cd1-4a76-980c-ca48bac7184f","weight":14}],"recordings":[{"size":227,"length":3542,"mime_type":"video/mp4","language":"deu","filename":"froscon2018-2201-deu-MySQL_8_-_The_next_big_thing_hd.mp4","state":"new","folder":"h264-hd","high_quality":true,"width":1920,"height":1080,"updated_at":"2018-08-25T14:46:00.345+02:00","recording_url":"https://cdn.media.ccc.de/events/froscon/2018/h264-hd/froscon2018-2201-deu-MySQL_8_-_The_next_big_thing_hd.mp4","url":"https://api.media.ccc.de/public/recordings/27043","event_url":"https://api.media.ccc.de/public/events/73bbeee4-7791-42d2-b3bd-317ca12a8895","conference_url":"https://api.media.ccc.de/public/conferences/froscon2018"},{"size":122,"length":3542,"mime_type":"video/webm","language":"deu","filename":"froscon2018-2201-deu-MySQL_8_-_The_next_big_thing_webm-sd.webm","state":"new","folder":"webm-sd","high_quality":false,"width":720,"height":576,"updated_at":"2018-08-25T16:27:42.555+02:00","recording_url":"https://cdn.media.ccc.de/events/froscon/2018/webm-sd/froscon2018-2201-deu-MySQL_8_-_The_next_big_thing_webm-sd.webm","url":"https://api.media.ccc.de/public/recordings/27101","event_url":"https://api.media.ccc.de/public/events/73bbeee4-7791-42d2-b3bd-317ca12a8895","conference_url":"https://api.media.ccc.de/public/conferences/froscon2018"},{"size":301,"length":3542,"mime_type":"video/webm","language":"deu","filename":"froscon2018-2201-deu-MySQL_8_-_The_next_big_thing_webm-hd.webm","state":"new","folder":"webm-hd","high_quality":true,"width":1920,"height":1080,"updated_at":"2018-08-25T16:32:00.633+02:00","recording_url":"https://cdn.media.ccc.de/events/froscon/2018/webm-hd/froscon2018-2201-deu-MySQL_8_-_The_next_big_thing_webm-hd.webm","url":"https://api.media.ccc.de/public/recordings/27110","event_url":"https://api.media.ccc.de/public/events/73bbeee4-7791-42d2-b3bd-317ca12a8895","conference_url":"https://api.media.ccc.de/public/conferences/froscon2018"},{"size":45,"length":3535,"mime_type":"audio/opus","language":"deu","filename":"froscon2018-2201-deu-MySQL_8_-_The_next_big_thing_opus.opus","state":"new","folder":"opus","high_quality":false,"width":0,"height":0,"updated_at":"2018-08-25T16:32:08.615+02:00","recording_url":"https://cdn.media.ccc.de/events/froscon/2018/opus/froscon2018-2201-deu-MySQL_8_-_The_next_big_thing_opus.opus","url":"https://api.media.ccc.de/public/recordings/27111","event_url":"https://api.media.ccc.de/public/events/73bbeee4-7791-42d2-b3bd-317ca12a8895","conference_url":"https://api.media.ccc.de/public/conferences/froscon2018"},{"size":118,"length":3542,"mime_type":"video/mp4","language":"deu","filename":"froscon2018-2201-deu-MySQL_8_-_The_next_big_thing_sd.mp4","state":"new","folder":"h264-sd","high_quality":false,"width":720,"height":576,"updated_at":"2018-08-25T16:32:43.025+02:00","recording_url":"https://cdn.media.ccc.de/events/froscon/2018/h264-sd/froscon2018-2201-deu-MySQL_8_-_The_next_big_thing_sd.mp4","url":"https://api.media.ccc.de/public/recordings/27112","event_url":"https://api.media.ccc.de/public/events/73bbeee4-7791-42d2-b3bd-317ca12a8895","conference_url":"https://api.media.ccc.de/public/conferences/froscon2018"},{"size":53,"length":3535,"mime_type":"audio/mpeg","language":"deu","filename":"froscon2018-2201-deu-MySQL_8_-_The_next_big_thing_mp3.mp3","state":"new","folder":"mp3","high_quality":false,"width":0,"height":0,"updated_at":"2018-08-25T16:33:08.973+02:00","recording_url":"https://cdn.media.ccc.de/events/froscon/2018/mp3/froscon2018-2201-deu-MySQL_8_-_The_next_big_thing_mp3.mp3","url":"https://api.media.ccc.de/public/recordings/27113","event_url":"https://api.media.ccc.de/public/events/73bbeee4-7791-42d2-b3bd-317ca12a8895","conference_url":"https://api.media.ccc.de/public/conferences/froscon2018"}]}