Mobile Services: Going Live and Beyond

2. Mobile Services: Going Live and Beyond Kirill Gavrylyuk, Lead Program Manager Paul Batum, Program Manager 3-511

3. Connected Apps Windows Store iOS Android Windows Phone 8 iOS Android HTML 5/JS Notifications Auth Data Scheduler REST API Server Logic Scale Diagnostics & Logging

5. DEMO Event Buddy

6. Source Control and Deployment Mobile Services (git repository) Team Foundation Service (git repository) Local git repository

7. DEMO Automation

8. DEMO Scripts Unit Testing Using Zumock

9. Node.js Tools

10. Dev & Test Summary • Keep scripts in source control (TFS) • Use Git to deploy server scripts • Automate using Azure CLI • Test scripts using mock frameworks

12. SQL Database vs Table • Use SQL Database for • relational data • rich query, sorting, filtering, multiple indexes • Use Table for • key-value pair tuples (e.g. game state) • simple queries, basic or no filtering

13. Table Storage with Custom APIs • exports.get = function (request, response) { • varazure = require('azure'); • vartableService = azure.createTableService(‘session', '<your storage key>'); • varquery = azure.TableQuery.select().from(‘session').where(‘eventIdeq?‘, eventId); • tableService.queryEntities(query, function (error, todoitems) { • if(!error) { • response.send(200, todoitems); • } else { /* … */} • }); • };

14. Working with images / blobs Blob Storage Mobile Service 2 3 1 4 • Request a blob url • Request a SAS token • Send back a blob url • Post a blob

15. Blob Storage SAS • function insert(item, user, request) { • varazure = require('azure'); • varblobService = azure.createBlobService('<account-name>', 'account-key>'); • blobService.createContainerIfNotExists(item.containerName, • accessLevel, function (error) { • if(error) { returnerrorHandler(error); } • varsharedAccessPolicy = {Permissions : /* ... */, Expiry : /* ... */}; • varsasQueryUrl = blobService.generateSharedAccessSignature(item.containerName, • item.resourceName, sharedAccessPolicy); • item.imageUri = sasQueryUrl.baseUrl + sasQueryUrl.path; • request.execute(); • }); • }

16. DO NOT use compute intense scripts • function insert(item, user, request) { • //... • images.forEach(function (image) { • varpng = easyimg.jpg2png(image, quality:10}; • //... • }

17. USE SQL where appropriate • postTable.where({id : commment.postId}).read( { success : pushToUsers }); • //… • functionpushToUsers(users) { • users.forEach(function (userId) { • channelTable.where(userId : userId).read({ • success: function(channels) { • channels.forEach(function(channel) { • push.wns.sendToastText04(channel.uri, {text1: item.text } ); • }); • } • }); • }); • } JOINS BETTER IN SQL

18. USE SQL where appropriate • varsql = "SELECT channel FROM devices " + • "INNER JOIN posts ON devices.userId = posts.userId " + • "WHERE posts.id = ?"; • mssql.query(sql, [comment.postId], { • success: function(channels) { • channels.forEach(function(channel) { • push.wns.sendToastText04(channel.uri, {text1: item.text } ); • }); • }

19. AVOID doing 1000s requests in parallel • Use Notification Hubs • Split the work into batches and process in the background • varsql = "SELECT channel FROM devices " + • "INNER JOIN users ON "; // TO DO: query users in SF • mssql.query(sql, [geofences.SF], { • success: function(channels) { • channels.forEach(function(channel) { • push.wns.sendToastText04(channel.uri, • {text1: “New Coffee” } ); • }); • }

20. AVOID client side JOINs • IEnumerable<Session> sessions; • Events = awaitApp.MobileService.GetTable<Event>() • .Where(e => e.Start > DateTime.Now) • .ToEnumerableAsync(); • foreach (var e in Events) • { • sessions = awaitApp.MobileService • .GetTable<Session>() • .ToEnumerableAsync(); • /*....*/ • } IEnumerable<Session> sessions; Events = awaitApp.MobileService .GetTable<Session>() .Where(e => s.Start > DateTime.Now) .ToEnumerableAsync(); /*....*/ LOTS OF API CALLS //JOIN in server scripts: varsql = "SELECT * FROM sessions " + "INNER JOIN events ON events.date > ?"; mssql.query(sql, [startDate], { /*....*/ }

21. Perf tuning tips • Choose the right data store • Use Blob Storage for binary blobs • AVOID compute-intense scripts • USE MSSQL when SQL is best • AVOID 1000s requests in parallel • USE client-server communication efficiently • DO NOT join tables on the client • DO batch updates as appropriate

23. Mobile Services Tiers service level agreements pricing & licensing $ General Availability99.9% *prorated daily **Active devices refers to the number of unique devices that have both obtained your Mobile Services powered app from a public app store and have made at least one call to your mobile service over the past 30 days.

24. Go Live! • Choose the right Tier • Disable Dynamic Schema • Ensure Auth is ON, use SSL • Lock permissions • Setup dev/ test environments • Think versioning

26. DEMO Creating & Configuring Alerts

27. DEMO Monitor your app with New Relic

28. Monitoring & Troubleshooting • Availability monitoring / alerts • Better with partners: New Relic

30. Add version to your Mobile Services client • publicclassVersioningHandler : DelegatingHandler{ • protectedoverride Task<HttpResponseMessage> SendAsync(HttpRequestMessagerequest, CancellationTokencancellationToken) { • request.RequestUri = newUri(request.RequestUri.AbsoluteUri.ToString() + “?version=2.0"); • returnbase.SendAsync(request, cancellationToken); }} • publicstaticMobileServiceClientMobileService = newMobileServiceClient( • "https://eventbuddykg.azure-mobile.net/", • "lLsNsvgOmQBfUGOHgKkIgnFwblJpla63", • newVersioningHandler() • );

31. Add version to your scripts • function insert(item, user, request) { • if (request.parameters.version < 2.0) { • session.room = 'Not entered'; • } • request.execute({ • success: function () { • if (request.parameters.version < 2.0) { • deletesession.room; • } • request.respond(); • } • }); • }

32. Prepare for breaking changes • DEMO

33. Versioning Considerations • Include client version in requests • Handle version differences in scripts • Plan your upgrade strategy

34. Summary • Use source control for server scripts • Automate using CLI & PowerShell • Unit test using mock frameworks • Be efficient about network and server scripts • Pick the appropriate tier • Think about versioning upfront

35. Mobile Services at Build Mobile Services – Soup to Nuts Josh Twist – Thursday 2pm Cross-Platform w/ Mobile Services Chris Risner – Thursday 4pm Protips for Mobile Services Chris Risner – Thursday 5pm Connected Win Phone Apps YavorGeorgiev – Friday 9am Going Live and Beyond Kirill and Paul – Friday 10:30am Delivering Push Notifications to Millions ElioDemaggio – Friday 12pm Who’s that user? Dinesh Kulkarni – Friday 2pm Developing Windows Apps Nick Harris – Friday 2pm

36. Resources • Get started with Mobile Services: • http://www.windowsazure.com/en-us/develop/mobile/ • Get started with the Azure CLI: • http://www.windowsazure.com/en-us/develop/nodejs/how-to-guides/command-line-tools/ • Copying a SQL Azure Database: • http://msdn.microsoft.com/en-us/library/windowsazure/ff951631.aspx • Setting up New Relic: • http://blog.newrelic.com/

37. Required Slide *delete this box when your slide is finalized Your MS Tag will be inserted here during the final scrub. Evaluate this session • Scan this QR codeto evaluate this session and be automatically entered in a drawing to win a prize!