Oficina: Como escalar aplicações PHP

Palestra dada na Campus Party 2012 com participação especial do Alexandre Gaigalas.

Transcript

1. Escalar  aplicações  PHP Augusto Pascutti Wednesday, February 8, 2012
2. @augustohp Wednesday, February 8, 2012
3. HTTP  =  Stateless   (Share  Nothing) Wednesday, February 8, 2012
4. Escalar? Wednesday, February 8, 2012
5. !=  Velocidade Wednesday, February 8, 2012
6. ~=  quanBdade Wednesday, February 8, 2012
7. Escalabilidade  =  Arquitetura Wednesday, February 8, 2012
8. Nosso  ambiente Wednesday, February 8, 2012
9. Wednesday, February 8, 2012
10. Level  1 Wednesday, February 8, 2012
11. Internet Wednesday, February 8, 2012
12. Índices Wednesday, February 8, 2012
13. Índices Um  índice  muito  grande  é  INÚTIL. Wednesday, February 8, 2012
14. Índices CREATE TABLE compras ( id INT AUTO_INCREMENT, data DATE NOT NULL, valor FLOAT NOT NULL, PRIMARY KEY (id) INDEX data_compra(data) ) Wednesday, February 8, 2012
15. Índices SELECT * FROM compras WHERE TO_DAYS(data)-TO_DAYS(data) <= 7 Wednesday, February 8, 2012
16. Índices SELECT * FROM compras WHERE data <= CURRENT_DATE() - INTERVAL 7 DAY Wednesday, February 8, 2012
17. Índices SELECT * FROM compras WHERE data <= ‘2012-01-07’ - INTERVAL 7 DAY Wednesday, February 8, 2012
18. ParBcionamento  VerBcal Wednesday, February 8, 2012
19. ParBcionamento  VerBcal CREATE TABLE usuarios ( id INT AUTO_INCREMENT, login VARCHAR(50) NOT NULL, nascimento DATE NOT NULL ) ENGINE=InnoDB PARTITION BY RANGE (id) ( PARTITION a VALUES LESS THAN (1000), PARTITION b VALUES LESS THAN (2000), PARTITION z VALUES LESS THAN MAXVALUE ); Wednesday, February 8, 2012
20. ParBcionamento  VerBcal CREATE TABLE usuarios ( id INT AUTO_INCREMENT, login VARCHAR(50) NOT NULL, nascimento DATE NOT NULL, pais INT NOT NULL ) ENGINE=InnoDB PARTITION BY LIST (pais) ( PARTITION america VALUES IN (1,2,3), PARTITION europa VALUES IN (4,5,6), ... ); Wednesday, February 8, 2012
21. ParBcionamento  VerBcal CREATE TABLE usuarios ( id INT AUTO_INCREMENT, login VARCHAR(50) NOT NULL, nascimento DATE NOT NULL, grupo INT NOT NULL ) ENGINE=InnoDB PARTITION BY HASH (grupo) PARTITIONS 4; Wednesday, February 8, 2012
22. ParBcionamento  VerBcal CREATE TABLE usuarios ( id INT AUTO_INCREMENT, login VARCHAR(50) NOT NULL, nascimento DATE NOT NULL, grupo INT NOT NULL ) ENGINE=InnoDB PARTITION BY HASH (grupo) PARTITIONS 4; INT Wednesday, February 8, 2012
23. ParBcionamento  VerBcal CREATE TABLE usuarios ( id INT AUTO_INCREMENT, login VARCHAR(50) NOT NULL, nascimento DATE NOT NULL, grupo INT NOT NULL ) ENGINE=InnoDB PARTITION BY HASH (MONTH(nascimento)) PARTITIONS 12; Wednesday, February 8, 2012
24. ParBcionamento  VerBcal CREATE TABLE usuarios ( id INT AUTO_INCREMENT, login VARCHAR(50) NOT NULL, nascimento DATE NOT NULL, grupo INT NOT NULL ) ENGINE=InnoDB PARTITION BY KEY (login) PARTITIONS 4; Wednesday, February 8, 2012
25. ParBcionamento  VerBcal CREATE TABLE usuarios ( id INT AUTO_INCREMENT, login VARCHAR(50) NOT NULL, nascimento DATE NOT NULL, grupo INT NOT NULL ) ENGINE=InnoDB PARTITION BY KEY (login) PARTITIONS 4; =D Wednesday, February 8, 2012
26. Level  2 Wednesday, February 8, 2012
27. Leitura Gravação Replicação Wednesday, February 8, 2012
28. Level  3 Wednesday, February 8, 2012
29. Leitura Gravação Replicação Wednesday, February 8, 2012
30. Leitura Gravação Replicação MySql  Proxy Wednesday, February 8, 2012
31. Wednesday, February 8, 2012
32. Level  1 Wednesday, February 8, 2012
33. Internet Wednesday, February 8, 2012
34. MulB  Processing  Modules Wednesday, February 8, 2012
35. Internet Wednesday, February 8, 2012
36. Level  2 Wednesday, February 8, 2012
37. Wednesday, February 8, 2012
38. •mod_proxy •mod_proxy_hWp •mod_proxy_balancer Wednesday, February 8, 2012
39. •mod_proxy •mod_proxy_hWp •mod_proxy_balancer ProxyPass / balancer://vila-chaves <Proxy balancer://vila-chaves> BalancerMember http://chaves.test.org BalancerMember http://kiko.test.org BalancerMember http://nhonho.test.org </Proxy> Wednesday, February 8, 2012
40. SESSION Wednesday, February 8, 2012
41. SESSION ProxyPass / balancer://vila-chaves \ stickysession=PHPSESSIONID <Proxy balancer://vila-chaves> BalancerMember http://chaves.test.org BalancerMember http://kiko.test.org BalancerMember http://nhonho.test.org </Proxy> Wednesday, February 8, 2012
42. Level  3 Wednesday, February 8, 2012
43. Gravação Leitura Wednesday, February 8, 2012
44. Gravação Leitura •mod_rewrite Wednesday, February 8, 2012
45. Gravação Leitura RewriteEngine On RewriteCond ${REQUEST_METHOD} ^(POST|PUT|DELETE)$ RewriteRule ^/(.*)$ escrita.test.org$1 [P] RewriteCond ${REQUEST_METHOD} ^(GET|HEAD|OPTIONS)$ RewriteRule ^/(.*)$ leitura.test.org$1 [P] •mod_rewrite Wednesday, February 8, 2012
46. Gravação Leitura RewriteEngine On RewriteCond ${REQUEST_METHOD} ^(POST|PUT|DELETE)$ RewriteRule ^/(.*)$ balancer://escrita$1 [P] RewriteCond ${REQUEST_METHOD} ^(GET|HEAD|OPTIONS)$ RewriteRule ^/(.*)$ balancer://leitura$1 [P] •mod_rewrite Wednesday, February 8, 2012
47. Wednesday, February 8, 2012
48. Banco  de  Dados Wednesday, February 8, 2012
49. Front  Controller Wednesday, February 8, 2012
50. SESSION Wednesday, February 8, 2012
51. SESSION CREATE TABLE `session` ( `id` char(32), `data` text, PRIMARY KEY (`id`) ); Wednesday, February 8, 2012
52. SESSION session_set_save_handler ("open","close","read", "write","destroy","gc"); Wednesday, February 8, 2012
53. SESSION function open($path,$name) { return true; } function close() { return true; } Wednesday, February 8, 2012
54. SESSION function read($id) { $sql = "SELECT data FROM session WHERE id = '{$id}'"; $data = array(); // query, fetchAll return $data; } Wednesday, February 8, 2012
55. SESSION function write($id, $data) { $data = serialize($data); $sql = "INSERT INTO session (id, data) VALUES ('{$id}', '{$data}')"; // Insert return true; } Wednesday, February 8, 2012
56. SESSION function destroy($id) { $sql = "DELETE FROM session WHERE id = '{$id}'"; // delete return $sql; } Wednesday, February 8, 2012
57. SESSION function gc($maxlifetime) { // =D return true; } Wednesday, February 8, 2012
58. @alganet Wednesday, February 8, 2012
59. slideshare.net/augustopascutti Wednesday, February 8, 2012