際際滷shows by User: spil-engineering / http://www.slideshare.net/images/logo.gif 際際滷shows by User: spil-engineering / Fri, 31 Oct 2014 08:23:17 GMT 際際滷Share feed for 際際滷shows by User: spil-engineering Percona Live London 2014: Serve out any page with an HA Sphinx environment /spil-engineering/spil-gamesperconalivelondon2014sphinxsearchtitle spil-games-percona-live-london-2014-sphinx-search-title-141031082317-conversion-gate01
At Spil Games we have been using Sphinx for over five years now. At first we used it to offload full text search queries to our MySQL databases, but one year ago we started to use it in a different way: we now serve out any page to any of our 26M daily active users dynamically. This means on every visitor for every pageview he/she makes we will make at least one invocation to Sphinx Search. This session will describe on how we need to pick the right content for our users dynamically based upon their browser capabilities (Flash, HTML5, WebGL,etc) in millisecond ranges using the attribute filtering capabilities from Sphinx. Using Sphinx as one of the main building blocks of our architectural foundations means we have to set it up as highly available as possible and be smart with data loading. Using the background indexing method we relied on for years makes our Sphinx instances respond slower during indexing and graceful index reloading. To overcome this we now use the real-time indexes whenever we update our content database. I will cover the various scenarios of HA and index population we went through with their pros and cons.]]>
At Spil Games we have been using Sphinx for over five years now. At first we used it to offload full text search queries to our MySQL databases, but one year ago we started to use it in a different way: we now serve out any page to any of our 26M daily active users dynamically. This means on every visitor for every pageview he/she makes we will make at least one invocation to Sphinx Search. This session will describe on how we need to pick the right content for our users dynamically based upon their browser capabilities (Flash, HTML5, WebGL,etc) in millisecond ranges using the attribute filtering capabilities from Sphinx. Using Sphinx as one of the main building blocks of our architectural foundations means we have to set it up as highly available as possible and be smart with data loading. Using the background indexing method we relied on for years makes our Sphinx instances respond slower during indexing and graceful index reloading. To overcome this we now use the real-time indexes whenever we update our content database. I will cover the various scenarios of HA and index population we went through with their pros and cons.]]> Fri, 31 Oct 2014 08:23:17 GMT /spil-engineering/spil-gamesperconalivelondon2014sphinxsearchtitle spil-engineering@slideshare.net(spil-engineering) Percona Live London 2014: Serve out any page with an HA Sphinx environment spil-engineering At Spil Games we have been using Sphinx for over five years now. At first we used it to offload full text search queries to our MySQL databases, but one year ago we started to use it in a different way: we now serve out any page to any of our 26M daily active users dynamically. This means on every visitor for every pageview he/she makes we will make at least one invocation to Sphinx Search. This session will describe on how we need to pick the right content for our users dynamically based upon their browser capabilities (Flash, HTML5, WebGL,etc) in millisecond ranges using the attribute filtering capabilities from Sphinx. Using Sphinx as one of the main building blocks of our architectural foundations means we have to set it up as highly available as possible and be smart with data loading. Using the background indexing method we relied on for years makes our Sphinx instances respond slower during indexing and graceful index reloading. To overcome this we now use the real-time indexes whenever we update our content database. I will cover the various scenarios of HA and index population we went through with their pros and cons. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/spil-games-percona-live-london-2014-sphinx-search-title-141031082317-conversion-gate01-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br> At Spil Games we have been using Sphinx for over five years now. At first we used it to offload full text search queries to our MySQL databases, but one year ago we started to use it in a different way: we now serve out any page to any of our 26M daily active users dynamically. This means on every visitor for every pageview he/she makes we will make at least one invocation to Sphinx Search. This session will describe on how we need to pick the right content for our users dynamically based upon their browser capabilities (Flash, HTML5, WebGL,etc) in millisecond ranges using the attribute filtering capabilities from Sphinx. Using Sphinx as one of the main building blocks of our architectural foundations means we have to set it up as highly available as possible and be smart with data loading. Using the background indexing method we relied on for years makes our Sphinx instances respond slower during indexing and graceful index reloading. To overcome this we now use the real-time indexes whenever we update our content database. I will cover the various scenarios of HA and index population we went through with their pros and cons.
Percona Live London 2014: Serve out any page with an HA Sphinx environment from spil-engineering
]]> 1548 2 https://cdn.slidesharecdn.com/ss_thumbnails/spil-games-percona-live-london-2014-sphinx-search-title-141031082317-conversion-gate01-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post http://activitystrea.ms/schema/1.0/posted 0 Spil Games @ FOSDEM: Galera Replicator IRL /spil-engineering/spil-gamesfosdemmysqlgalerareplicatorirl-30623639 spil-games-fosdem-mysql-galera-replicator-irl-140130084217-phpapp01
Spil Games @ FOSDEM: Galera Replicator IRL]]>
Spil Games @ FOSDEM: Galera Replicator IRL]]> Thu, 30 Jan 2014 08:42:17 GMT /spil-engineering/spil-gamesfosdemmysqlgalerareplicatorirl-30623639 spil-engineering@slideshare.net(spil-engineering) Spil Games @ FOSDEM: Galera Replicator IRL spil-engineering Spil Games @ FOSDEM: Galera Replicator IRL <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/spil-games-fosdem-mysql-galera-replicator-irl-140130084217-phpapp01-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br> Spil Games @ FOSDEM: Galera Replicator IRL
Spil Games @ FOSDEM: Galera Replicator IRL from spil-engineering
]]> 65519 5 https://cdn.slidesharecdn.com/ss_thumbnails/spil-games-fosdem-mysql-galera-replicator-irl-140130084217-phpapp01-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post http://activitystrea.ms/schema/1.0/posted 0 MySQL performance monitoring using Statsd and Graphite (PLUK2013) /slideshow/mysql-performance-monitoring-using-statsd-and-graphite-pluk2013/28043740 mysql-performance-monitoring-130826072409-phpapp02-131108095305-phpapp01
MySQL performance monitoring using Statsd and Graphite (PLUK2013) Note: this is a placeholder for the presentation next Tuesday at the Percona Live London]]>
MySQL performance monitoring using Statsd and Graphite (PLUK2013) Note: this is a placeholder for the presentation next Tuesday at the Percona Live London]]> Fri, 08 Nov 2013 09:53:05 GMT /slideshow/mysql-performance-monitoring-using-statsd-and-graphite-pluk2013/28043740 spil-engineering@slideshare.net(spil-engineering) MySQL performance monitoring using Statsd and Graphite (PLUK2013) spil-engineering MySQL performance monitoring using Statsd and Graphite (PLUK2013) Note: this is a placeholder for the presentation next Tuesday at the Percona Live London <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/mysql-performance-monitoring-130826072409-phpapp02-131108095305-phpapp01-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br> MySQL performance monitoring using Statsd and Graphite (PLUK2013) Note: this is a placeholder for the presentation next Tuesday at the Percona Live London
MySQL performance monitoring using Statsd and Graphite (PLUK2013) from spil-engineering
]]> 7759 4 https://cdn.slidesharecdn.com/ss_thumbnails/mysql-performance-monitoring-130826072409-phpapp02-131108095305-phpapp01-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post http://activitystrea.ms/schema/1.0/posted 0 Retaining globally distributed high availability /slideshow/high-availability-with-mysql/25636794 high-availability-with-mysql-130827071931-phpapp01
Example of a solution for retaining globally distributed high availability with MySQL]]>
Example of a solution for retaining globally distributed high availability with MySQL]]> Tue, 27 Aug 2013 07:19:31 GMT /slideshow/high-availability-with-mysql/25636794 spil-engineering@slideshare.net(spil-engineering) Retaining globally distributed high availability spil-engineering Example of a solution for retaining globally distributed high availability with MySQL <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/high-availability-with-mysql-130827071931-phpapp01-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br> Example of a solution for retaining globally distributed high availability with MySQL
Retaining globally distributed high availability from spil-engineering
]]> 803 3 https://cdn.slidesharecdn.com/ss_thumbnails/high-availability-with-mysql-130827071931-phpapp01-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post http://activitystrea.ms/schema/1.0/posted 0 Outgrowing an internet startup: database administration in a fast growing company. /spil-engineering/spil-gamesoutgrowinganinternetstartup spil-games-outgrowing-an-internet-startup-130827063027-phpapp02
Database administration in a fast growing company: problems and solutions.]]>
Database administration in a fast growing company: problems and solutions.]]> Tue, 27 Aug 2013 06:30:27 GMT /spil-engineering/spil-gamesoutgrowinganinternetstartup spil-engineering@slideshare.net(spil-engineering) Outgrowing an internet startup: database administration in a fast growing company. spil-engineering Database administration in a fast growing company: problems and solutions. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/spil-games-outgrowing-an-internet-startup-130827063027-phpapp02-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br> Database administration in a fast growing company: problems and solutions.
Outgrowing an internet startup: database administration in a fast growing company. from spil-engineering
]]> 1079 3 https://cdn.slidesharecdn.com/ss_thumbnails/spil-games-outgrowing-an-internet-startup-130827063027-phpapp02-thumbnail.jpg?width=120&height=120&fit=bounds presentation White http://activitystrea.ms/schema/1.0/post http://activitystrea.ms/schema/1.0/posted 0 MySQL Performance Monitoring /slideshow/mysql-performance-monitoring/25594517 mysql-performance-monitoring-130826072409-phpapp02
MySQL Performance Monitoring using Statsd and Graphite]]>
MySQL Performance Monitoring using Statsd and Graphite]]> Mon, 26 Aug 2013 07:24:09 GMT /slideshow/mysql-performance-monitoring/25594517 spil-engineering@slideshare.net(spil-engineering) MySQL Performance Monitoring spil-engineering MySQL Performance Monitoring using Statsd and Graphite <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/mysql-performance-monitoring-130826072409-phpapp02-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br> MySQL Performance Monitoring using Statsd and Graphite
MySQL Performance Monitoring from spil-engineering
]]> 2457 2 https://cdn.slidesharecdn.com/ss_thumbnails/mysql-performance-monitoring-130826072409-phpapp02-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post http://activitystrea.ms/schema/1.0/posted 0 Disco workshop /slideshow/discoworkshop2013/25515982 discoworkshop2013-130823061205-phpapp02
Disco workshop. From zero to CDN log processing. ]]>
Disco workshop. From zero to CDN log processing. ]]> Fri, 23 Aug 2013 06:12:05 GMT /slideshow/discoworkshop2013/25515982 spil-engineering@slideshare.net(spil-engineering) Disco workshop spil-engineering Disco workshop. From zero to CDN log processing. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/discoworkshop2013-130823061205-phpapp02-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br> Disco workshop. From zero to CDN log processing.
Disco workshop from spil-engineering
]]> 2097 6 https://cdn.slidesharecdn.com/ss_thumbnails/discoworkshop2013-130823061205-phpapp02-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post http://activitystrea.ms/schema/1.0/posted 0 Database TCO /spil-engineering/db-tcomeetup db-tco-meetup-130823043215-phpapp02
Database Total Cost of Ownership: analysis and ideas for improvement.]]>
Database Total Cost of Ownership: analysis and ideas for improvement.]]> Fri, 23 Aug 2013 04:32:15 GMT /spil-engineering/db-tcomeetup spil-engineering@slideshare.net(spil-engineering) Database TCO spil-engineering Database Total Cost of Ownership: analysis and ideas for improvement. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/db-tco-meetup-130823043215-phpapp02-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br> Database Total Cost of Ownership: analysis and ideas for improvement.
Database TCO from spil-engineering
]]> 2303 2 https://cdn.slidesharecdn.com/ss_thumbnails/db-tco-meetup-130823043215-phpapp02-thumbnail.jpg?width=120&height=120&fit=bounds presentation White http://activitystrea.ms/schema/1.0/post http://activitystrea.ms/schema/1.0/posted 0 https://public.slidesharecdn.com/v2/images/profile-picture.png https://cdn.slidesharecdn.com/ss_thumbnails/spil-games-percona-live-london-2014-sphinx-search-title-141031082317-conversion-gate01-thumbnail.jpg?width=320&height=320&fit=bounds spil-engineering/spil-gamesperconalivelondon2014sphinxsearchtitle Percona Live London 20... https://cdn.slidesharecdn.com/ss_thumbnails/spil-games-fosdem-mysql-galera-replicator-irl-140130084217-phpapp01-thumbnail.jpg?width=320&height=320&fit=bounds spil-engineering/spil-gamesfosdemmysqlgalerareplicatorirl-30623639 Spil Games @ FOSDEM: G... https://cdn.slidesharecdn.com/ss_thumbnails/mysql-performance-monitoring-130826072409-phpapp02-131108095305-phpapp01-thumbnail.jpg?width=320&height=320&fit=bounds slideshow/mysql-performance-monitoring-using-statsd-and-graphite-pluk2013/28043740 MySQL performance moni...