{"guid":"04b52daf-d0a0-4b2e-b9ff-294551265734","title":"600k QPS on MySQL Galera cluster","subtitle":"the tale of 600.000 queries per second","slug":"froscon2015-1499-600k_qps_on_mysql_galera_cluster","link":"http://programm.froscon.de/2015/events/1499.html","description":"The world of high availability mysql has seen several solutions over the last decade or so. All of them were flawed in some way, none were perfect. One of the new kids on the block is Galera cluster for MySQL. It's fully open source and scales surprisingly well. In this talk we'll look at a case study of how we deployed a 600k QPS cluster sucessfully","original_language":"eng","persons":["W. Heck"],"tags":["Databases"],"view_count":409,"promoted":false,"date":"2015-08-22T15:15:00.000+02:00","release_date":"2015-08-22T02:00:00.000+02:00","updated_at":"2025-01-26T21:15:12.909+01:00","length":3473,"duration":3473,"thumb_url":"https://static.media.ccc.de/media/conferences/froscon/2015/1499-sd.jpg","poster_url":"https://static.media.ccc.de/media/conferences/froscon/2015/1499-sd_preview.jpg","timeline_url":"https://static.media.ccc.de/media/conferences/froscon/2015/04b52daf-d0a0-4b2e-b9ff-294551265734-timeline.jpg","thumbnails_url":"https://static.media.ccc.de/media/conferences/froscon/2015/04b52daf-d0a0-4b2e-b9ff-294551265734-thumbnails.vtt","frontend_link":"https://media.ccc.de/v/froscon2015-1499-600k_qps_on_mysql_galera_cluster","url":"https://api.media.ccc.de/public/events/04b52daf-d0a0-4b2e-b9ff-294551265734","conference_title":"FrOSCon 2015","conference_url":"https://api.media.ccc.de/public/conferences/froscon2015","related":[{"event_id":257,"event_guid":"import-d7310428128bd6d0f1","weight":1},{"event_id":259,"event_guid":"import-f8cc78c9575d839934","weight":1},{"event_id":261,"event_guid":"import-1aaacfb27e0ed9e4d2","weight":1},{"event_id":274,"event_guid":"import-ae29300d42341fb7a7","weight":1},{"event_id":282,"event_guid":"import-53979b437c73249202","weight":1},{"event_id":296,"event_guid":"import-71f3844c0e513307ed","weight":1},{"event_id":299,"event_guid":"import-788d446dd3e67f067e","weight":1},{"event_id":322,"event_guid":"import-993023a4b97a66cd6a","weight":1},{"event_id":339,"event_guid":"import-5364d3cfa913a79114","weight":1},{"event_id":379,"event_guid":"import-859b155bfec32458a2","weight":1},{"event_id":1682,"event_guid":"import-424b431b28ea3a4a99","weight":1},{"event_id":1935,"event_guid":"Uo38_f5Bc4djTtf3Phgwzw","weight":1},{"event_id":1948,"event_guid":"3QioQqB0iLfI0WUwkTtsQg","weight":1},{"event_id":2000,"event_guid":"D3xo4XG-ODco6UgUOw5-1A","weight":2},{"event_id":2041,"event_guid":"RdFRTf4HCcVqg7o8UCEuqQ","weight":1},{"event_id":2170,"event_guid":"DvpNPWPGVgSqGcOI1WK45g","weight":1},{"event_id":2235,"event_guid":"dN7QONPJousa5xBD6XQxgg","weight":1},{"event_id":2246,"event_guid":"5hkhmuwi5J8ZHMfd5k7veg","weight":1},{"event_id":2563,"event_guid":"01b2b2a6-a23a-48e4-aae9-bb77b14850ee","weight":1},{"event_id":2570,"event_guid":"1d6346e7-3892-4c16-8678-2b59c1f49027","weight":2},{"event_id":2571,"event_guid":"0a0ee64d-16d9-4f21-93f5-0041966acd2b","weight":1},{"event_id":2572,"event_guid":"0fce34a8-d056-484b-8a8c-9b13c38ef25f","weight":1},{"event_id":2574,"event_guid":"62d203e6-6dd6-4ab4-87f0-64197e13853d","weight":1},{"event_id":2577,"event_guid":"81e7a37a-1be3-4d76-98da-42afa71fa2ee","weight":1},{"event_id":2578,"event_guid":"fb3204b2-7e48-4202-89b8-b5c9ab7eeb03","weight":1},{"event_id":2587,"event_guid":"89b01590-66cd-4804-9235-f63f073da68d","weight":1},{"event_id":2589,"event_guid":"144fa201-9632-4ef3-bc07-6e1b98285c6d","weight":1},{"event_id":2618,"event_guid":"d4feda86-cee8-45c3-b62a-4bff418a0dee","weight":1},{"event_id":2625,"event_guid":"d3635fe2-4455-4118-8fd8-2c917de22a9e","weight":1},{"event_id":2630,"event_guid":"8fcc49f3-d76f-486c-aebf-26108b39fb74","weight":1},{"event_id":2631,"event_guid":"8a9c7888-b460-45a4-a746-2cd21caffbf3","weight":1},{"event_id":2723,"event_guid":"bcntKBHQb1WsmpjP4ZuVKA","weight":1},{"event_id":2865,"event_guid":"b2a8a8fe-646f-4e32-a4d8-67a163573e36","weight":2},{"event_id":3064,"event_guid":"5ec0931d-d3aa-44d4-b9b3-a7e5ecbf7dec","weight":1},{"event_id":3067,"event_guid":"8a1472b6-c188-40d6-9e84-ce2aed18291b","weight":1},{"event_id":3073,"event_guid":"deadbcbf-a450-4005-99d1-054b38e58b86","weight":1},{"event_id":3382,"event_guid":"7b5e1f40-3260-48f3-b5b0-b5b192a88737","weight":1},{"event_id":3400,"event_guid":"da58a4d0-7b3e-42a6-a720-792fc2503d45","weight":1},{"event_id":3404,"event_guid":"927868f5-bec9-457b-85c1-e248d971dcc7","weight":2},{"event_id":3425,"event_guid":"f4f1d770-7229-4259-86e2-3916a45142ca","weight":1},{"event_id":3434,"event_guid":"8918cb01-0d95-4cf7-bcf2-db04e9ee8061","weight":1},{"event_id":3454,"event_guid":"97e86b22-bd65-4ce7-9ba3-0fa6817cd715","weight":1},{"event_id":3603,"event_guid":"798573a8-f544-48f0-abaf-ebc405f03f4a","weight":1},{"event_id":3620,"event_guid":"dd070191-1d1c-4b9c-a887-e4950a688cdb","weight":1},{"event_id":3633,"event_guid":"530f0400-e4e8-4d99-909d-4cfc8121c0b0","weight":1},{"event_id":3638,"event_guid":"c06dd4c2-c637-445d-9c72-92204a35eeff","weight":1},{"event_id":3656,"event_guid":"1a6657a2-b6c2-4acc-b8fc-5ec081c0877f","weight":1},{"event_id":3695,"event_guid":"c300b194-2a85-4705-92aa-b4e789882303","weight":1},{"event_id":3700,"event_guid":"b5be9501-88f1-4d9f-a5aa-269c8ff22d37","weight":1},{"event_id":3790,"event_guid":"6575fcac-cfae-4286-b464-67842ae6842d","weight":1},{"event_id":3802,"event_guid":"a588243f-a16e-4298-9e66-d26fb949aaea","weight":1},{"event_id":3812,"event_guid":"d180c287-0760-4421-9406-fedac5a3639c","weight":1},{"event_id":3864,"event_guid":"63dd83b9-27e4-4122-8a45-48ca7c92e13e","weight":1},{"event_id":3873,"event_guid":"da554088-7556-43ca-81f0-1de27299973a","weight":1},{"event_id":3880,"event_guid":"da855d30-e440-49f1-b811-afac8cd3ed43","weight":1},{"event_id":3894,"event_guid":"d7c3b762-a657-4670-a41b-3a8829a6bb13","weight":1},{"event_id":3896,"event_guid":"567b415b-22c0-4371-86e8-454ad43734f8","weight":2},{"event_id":3933,"event_guid":"3c930882-c4ad-4b8d-985d-0157d33986df","weight":1},{"event_id":3995,"event_guid":"e2yAwfFgLsMMoT8wkETYsw","weight":1},{"event_id":4063,"event_guid":"f98d396e-6f2b-57e9-b82f-ad1a6ba48655","weight":1},{"event_id":4071,"event_guid":"84a54d6b-290e-5eb4-a79c-5fdfbc5e18e9","weight":1},{"event_id":4084,"event_guid":"2735a8a0-57c9-5c9b-ae60-cf272a0e18fa","weight":1},{"event_id":4391,"event_guid":"c2d5346f-bd26-43c3-8c19-bbcdf52cd6e3","weight":1},{"event_id":5751,"event_guid":"2b7d1c38-d3e0-4978-ac30-95aed9e7b0d7","weight":1}],"recordings":[{"size":251,"length":3481,"mime_type":"video/mp4","language":"eng","filename":"froscon2015-1499-en-600k_QPS_on_MySQL_Galera_cluster_sd.mp4","state":"downloaded","folder":"h264-hq","high_quality":false,"width":720,"height":576,"updated_at":"2016-02-03T14:10:11.393+01:00","recording_url":"https://cdn.media.ccc.de/events/froscon/2015/h264-hq/froscon2015-1499-en-600k_QPS_on_MySQL_Galera_cluster_sd.mp4","url":"https://api.media.ccc.de/public/recordings/7309","event_url":"https://api.media.ccc.de/public/events/04b52daf-d0a0-4b2e-b9ff-294551265734","conference_url":"https://api.media.ccc.de/public/conferences/froscon2015"},{"size":26,"length":3473,"mime_type":"audio/mpeg","language":"eng","filename":"froscon2015-1499-en-600k_QPS_on_MySQL_Galera_cluster_mp3.mp3","state":"downloaded","folder":"mp3-audio-only","high_quality":true,"width":null,"height":null,"updated_at":"2015-08-23T10:50:34.656+02:00","recording_url":"https://cdn.media.ccc.de/events/froscon/2015/mp3-audio-only/froscon2015-1499-en-600k_QPS_on_MySQL_Galera_cluster_mp3.mp3","url":"https://api.media.ccc.de/public/recordings/7397","event_url":"https://api.media.ccc.de/public/events/04b52daf-d0a0-4b2e-b9ff-294551265734","conference_url":"https://api.media.ccc.de/public/conferences/froscon2015"},{"size":168,"length":3482,"mime_type":"video/webm","language":"eng","filename":"froscon2015-1499-en-600k_QPS_on_MySQL_Galera_cluster_webm.webm","state":"downloaded","folder":"webm","high_quality":false,"width":720,"height":576,"updated_at":"2016-02-03T14:10:15.897+01:00","recording_url":"https://cdn.media.ccc.de/events/froscon/2015/webm/froscon2015-1499-en-600k_QPS_on_MySQL_Galera_cluster_webm.webm","url":"https://api.media.ccc.de/public/recordings/7396","event_url":"https://api.media.ccc.de/public/events/04b52daf-d0a0-4b2e-b9ff-294551265734","conference_url":"https://api.media.ccc.de/public/conferences/froscon2015"},{"size":20,"length":3473,"mime_type":"audio/opus","language":"eng","filename":"froscon2015-1499-en-600k_QPS_on_MySQL_Galera_cluster_opus.opus","state":"downloaded","folder":"opus","high_quality":true,"width":null,"height":null,"updated_at":"2015-08-23T10:51:05.902+02:00","recording_url":"https://cdn.media.ccc.de/events/froscon/2015/opus/froscon2015-1499-en-600k_QPS_on_MySQL_Galera_cluster_opus.opus","url":"https://api.media.ccc.de/public/recordings/7398","event_url":"https://api.media.ccc.de/public/events/04b52daf-d0a0-4b2e-b9ff-294551265734","conference_url":"https://api.media.ccc.de/public/conferences/froscon2015"}]}