{"guid":"23a9c34a-ff6b-40bc-ab4c-dcee48270b18","title":"MySQL: Warum einen Cluster aufbauen wenn ich auch Replizieren kann?","subtitle":"Ein Einführung in den MySQL InnoDB Cluster","slug":"froscon2020-2586-mysql_warum_einen_cluster_aufbauen_wenn_ich_auch_replizieren_kann","link":"https://programm.froscon.de/2020/events/2586.html","description":"Datenbanken sind das Kernstück moderner Unternehmensanwendungen. Sie dienen zum Speichern und Schützen wertvoller Informationen für zum Teil geschäftskritischer Anwendungen eines Unternehmens. \nAus diesem Grund ist das Sicherstellen der Verfügbarkeit von MySQL Datenbanken ein vorrangiges Anliegen aller Unternehmen. \nMySQL bietet zahlreiche Möglichkeiten ein Hochverfügbarkeit über das OS, VMs oder via Replikation zu erreichen.\nVor allem seit der Einführung der InnoDB Cluster Technologie in MySQL 5.7 wird der Aufbau und der Betrieb einer HA Lösung ständig erweitert und zählt bei der Verwendung auf Virtualisierungs/Containerinfrastrukturen praktisch zu den \"Datenbank Best Practice\".\nDieser Vortrag bietet einen Einstieg in den InnoDB Cluster. Wir werden auf zahlreiche Erweiterungen eingehen (Cloning, Consistancy Levels sowie GTID, PrimaryKey und anderen [Un-] Abhängikeiten auf technischer Ebene eingehen.","original_language":"deu","persons":["ThalheimerC"],"tags":["froscon2020","2586","2020","Databases"],"view_count":113,"promoted":false,"date":"2020-08-23T10:00:00.000+02:00","release_date":"2020-09-04T00:00:00.000+02:00","updated_at":"2023-11-29T16:45:03.874+01:00","length":3597,"duration":3597,"thumb_url":"https://static.media.ccc.de/media/events/froscon/2020/2586-hd.jpg","poster_url":"https://static.media.ccc.de/media/events/froscon/2020/2586-hd_preview.jpg","timeline_url":"https://static.media.ccc.de/media/events/froscon/2020/2586-hd.timeline.jpg","thumbnails_url":"https://static.media.ccc.de/media/events/froscon/2020/2586-hd.thumbnails.vtt","frontend_link":"https://media.ccc.de/v/froscon2020-2586-mysql_warum_einen_cluster_aufbauen_wenn_ich_auch_replizieren_kann","url":"https://api.media.ccc.de/public/events/23a9c34a-ff6b-40bc-ab4c-dcee48270b18","conference_title":"FrOSCon 2020 Cloud-Edition","conference_url":"https://api.media.ccc.de/public/conferences/froscon2020","related":[],"recordings":[{"size":339,"length":3597,"mime_type":"video/webm","language":"deu","filename":"froscon2020-2586-deu-MySQL_Warum_einen_Cluster_aufbauen_wenn_ich_auch_Replizieren_kann_webm-hd.webm","state":"new","folder":"webm-hd","high_quality":true,"width":1920,"height":1080,"updated_at":"2020-09-04T17:43:34.112+02:00","recording_url":"https://cdn.media.ccc.de/events/froscon/2020/webm-hd/froscon2020-2586-deu-MySQL_Warum_einen_Cluster_aufbauen_wenn_ich_auch_Replizieren_kann_webm-hd.webm","url":"https://api.media.ccc.de/public/recordings/47780","event_url":"https://api.media.ccc.de/public/events/23a9c34a-ff6b-40bc-ab4c-dcee48270b18","conference_url":"https://api.media.ccc.de/public/conferences/froscon2020"},{"size":125,"length":3597,"mime_type":"video/webm","language":"deu","filename":"froscon2020-2586-deu-MySQL_Warum_einen_Cluster_aufbauen_wenn_ich_auch_Replizieren_kann_webm-sd.webm","state":"new","folder":"webm-sd","high_quality":false,"width":720,"height":576,"updated_at":"2020-09-04T17:43:13.849+02:00","recording_url":"https://cdn.media.ccc.de/events/froscon/2020/webm-sd/froscon2020-2586-deu-MySQL_Warum_einen_Cluster_aufbauen_wenn_ich_auch_Replizieren_kann_webm-sd.webm","url":"https://api.media.ccc.de/public/recordings/47778","event_url":"https://api.media.ccc.de/public/events/23a9c34a-ff6b-40bc-ab4c-dcee48270b18","conference_url":"https://api.media.ccc.de/public/conferences/froscon2020"},{"size":41,"length":3597,"mime_type":"audio/opus","language":"deu","filename":"froscon2020-2586-deu-MySQL_Warum_einen_Cluster_aufbauen_wenn_ich_auch_Replizieren_kann_opus.opus","state":"new","folder":"opus","high_quality":false,"width":0,"height":0,"updated_at":"2020-09-04T17:42:34.827+02:00","recording_url":"https://cdn.media.ccc.de/events/froscon/2020/opus/froscon2020-2586-deu-MySQL_Warum_einen_Cluster_aufbauen_wenn_ich_auch_Replizieren_kann_opus.opus","url":"https://api.media.ccc.de/public/recordings/47776","event_url":"https://api.media.ccc.de/public/events/23a9c34a-ff6b-40bc-ab4c-dcee48270b18","conference_url":"https://api.media.ccc.de/public/conferences/froscon2020"},{"size":92,"length":3597,"mime_type":"video/mp4","language":"deu","filename":"froscon2020-2586-deu-MySQL_Warum_einen_Cluster_aufbauen_wenn_ich_auch_Replizieren_kann_sd.mp4","state":"new","folder":"h264-sd","high_quality":false,"width":720,"height":576,"updated_at":"2020-09-04T17:42:25.542+02:00","recording_url":"https://cdn.media.ccc.de/events/froscon/2020/h264-sd/froscon2020-2586-deu-MySQL_Warum_einen_Cluster_aufbauen_wenn_ich_auch_Replizieren_kann_sd.mp4","url":"https://api.media.ccc.de/public/recordings/47774","event_url":"https://api.media.ccc.de/public/events/23a9c34a-ff6b-40bc-ab4c-dcee48270b18","conference_url":"https://api.media.ccc.de/public/conferences/froscon2020"},{"size":54,"length":3597,"mime_type":"audio/mpeg","language":"deu","filename":"froscon2020-2586-deu-MySQL_Warum_einen_Cluster_aufbauen_wenn_ich_auch_Replizieren_kann_mp3.mp3","state":"new","folder":"mp3","high_quality":false,"width":0,"height":0,"updated_at":"2020-09-04T17:41:13.494+02:00","recording_url":"https://cdn.media.ccc.de/events/froscon/2020/mp3/froscon2020-2586-deu-MySQL_Warum_einen_Cluster_aufbauen_wenn_ich_auch_Replizieren_kann_mp3.mp3","url":"https://api.media.ccc.de/public/recordings/47768","event_url":"https://api.media.ccc.de/public/events/23a9c34a-ff6b-40bc-ab4c-dcee48270b18","conference_url":"https://api.media.ccc.de/public/conferences/froscon2020"},{"size":206,"length":3597,"mime_type":"video/mp4","language":"deu","filename":"froscon2020-2586-deu-MySQL_Warum_einen_Cluster_aufbauen_wenn_ich_auch_Replizieren_kann_hd.mp4","state":"new","folder":"h264-hd","high_quality":true,"width":1920,"height":1080,"updated_at":"2020-09-04T15:41:19.493+02:00","recording_url":"https://cdn.media.ccc.de/events/froscon/2020/h264-hd/froscon2020-2586-deu-MySQL_Warum_einen_Cluster_aufbauen_wenn_ich_auch_Replizieren_kann_hd.mp4","url":"https://api.media.ccc.de/public/recordings/47724","event_url":"https://api.media.ccc.de/public/events/23a9c34a-ff6b-40bc-ab4c-dcee48270b18","conference_url":"https://api.media.ccc.de/public/conferences/froscon2020"}]}