Olá, @Gabriel!
Realizei recentemente a migração de um Mautic para Cloud da Oracle, com sua ajuda.
A ideia original dessa migração seria otimizar o envio dos e-mails, que na hospedagem compartilhada antiga estava lentíssimo.
Fiz todas as configurações da máquina seguindo seu curso de Oracle Cloud (com uma máquina de 5 núcleos +24GB e 120GB SSD), setando, inclusive, 4GB de memória para o Mautic, pelas configurações do php. Para minha grande surpresa, ao disparar hoje uma campanha de segmentos (tanto em fila quanto ‘imediamente’) para aproximadamente 20 mil contatos, tivemos novamente uma demora absurda. Não cheguei a cronometrar o envio sem fila, mas em fila, demorou aproximadamente 8 horas para entregar 19000 e-mails. Você pode conferir o e-mail aqui.
Certo que é um e-mail bem formatado, mas acredito que não deveria demorar tanto.
Nas minhas pesquisas pela internet encontrei um tutorial do joeyk (da comunidade do Mautic), mas me pareceu um pouco complicado implementar.
Você saberia me dizer qual seria a melhor forma de otimizar esses envios?
O encaminhamento dos e-mails para a pasta spool (em lotes de 800) ocorreu muito rápido. A demora mesmo se deu para o envio dos e-mails pelo SMTP (mautic:emails:send).
Informações importantes:
Serviço para envio de email: Amazon SES - SMTP
Amazon SES Region: US East (N. Virginia)
Versão do Mautic: v4.4.10
Log de erros do Mautic:
[2024-05-27 05:02:53] mautic.NOTICE: PHP Notice - SessionHandler::gc(): ps_files_cleanup_dir: opendir(/var/lib/php/sessions) failed: Permission denied (13) - in file /var/www/mail.verboencarnado.com.br/htdocs/vendor/symfony/http-foundation/Session/Storage/Handler/StrictSessionHandler.php - at line 106 {"maxlifetime":1440} {"hostname":"cloud.verboencarnado.com.br","pid":86536}
[2024-05-27 11:55:17] mautic.NOTICE: PHP Notice - SessionHandler::gc(): ps_files_cleanup_dir: opendir(/var/lib/php/sessions) failed: Permission denied (13) - in file /var/www/mail.verboencarnado.com.br/htdocs/vendor/symfony/http-foundation/Session/Storage/Handler/StrictSessionHandler.php - at line 106 {"maxlifetime":1440} {"hostname":"cloud.verboencarnado.com.br","pid":96235}
[2024-05-27 13:41:26] mautic.NOTICE: PHP Notice - SessionHandler::gc(): ps_files_cleanup_dir: opendir(/var/lib/php/sessions) failed: Permission denied (13) - in file /var/www/mail.verboencarnado.com.br/htdocs/vendor/symfony/http-foundation/Session/Storage/Handler/StrictSessionHandler.php - at line 106 {"maxlifetime":1440} {"hostname":"cloud.verboencarnado.com.br","pid":98671}
[2024-05-27 11:00:55] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\ConnectionLost: "An exception occurred while executing 'SELECT u0_.is_published AS is_published_0, u0_.date_added AS date_added_1, u0_.created_by AS created_by_2, u0_.created_by_user AS created_by_user_3, u0_.date_modified AS date_modified_4, u0_.modified_by AS modified_by_5, u0_.modified_by_user AS modified_by_user_6, u0_.checked_out AS checked_out_7, u0_.checked_out_by AS checked_out_by_8, u0_.checked_out_by_user AS checked_out_by_user_9, u0_.id AS id_10, u0_.username AS username_11, u0_.password AS password_12, u0_.first_name AS first_name_13, u0_.last_name AS last_name_14, u0_.email AS email_15, u0_.position AS position_16, u0_.timezone AS timezone_17, u0_.locale AS locale_18, u0_.last_login AS last_login_19, u0_.last_active AS last_active_20, u0_.preferences AS preferences_21, u0_.signature AS signature_22, r1_.is_published AS is_published_23, r1_.date_added AS date_added_24, r1_.created_by AS created_by_25, r1_.created_by_user AS created_by_user_26, r1_.date_modified AS date_modified_27, r1_.modified_by AS modified_by_28, r1_.modified_by_user AS modified_by_user_29, r1_.checked_out AS checked_out_30, r1_.checked_out_by AS checked_out_by_31, r1_.checked_out_by_user AS checked_out_by_user_32, r1_.id AS id_33, r1_.name AS name_34, r1_.description AS description_35, r1_.is_admin AS is_admin_36, r1_.readable_permissions AS readable_permissions_37, u0_.role_id AS role_id_38 FROM users u0_ LEFT JOIN roles r1_ ON u0_.role_id = r1_.id WHERE (u0_.username = ? OR u0_.email = ?) AND u0_.is_published = ?' with params ["EdV-MaUtIC", "EdV-MaUtIC", 1]: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away" at /var/www/mail.verboencarnado.com.br/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 115 {"exception":"[object] (Doctrine\\DBAL\\Exception\\ConnectionLost(code: 0): An exception occurred while executing 'SELECT u0_.is_published AS is_published_0, u0_.date_added AS date_added_1, u0_.created_by AS created_by_2, u0_.created_by_user AS created_by_user_3, u0_.date_modified AS date_modified_4, u0_.modified_by AS modified_by_5, u0_.modified_by_user AS modified_by_user_6, u0_.checked_out AS checked_out_7, u0_.checked_out_by AS checked_out_by_8, u0_.checked_out_by_user AS checked_out_by_user_9, u0_.id AS id_10, u0_.username AS username_11, u0_.password AS password_12, u0_.first_name AS first_name_13, u0_.last_name AS last_name_14, u0_.email AS email_15, u0_.position AS position_16, u0_.timezone AS timezone_17, u0_.locale AS locale_18, u0_.last_login AS last_login_19, u0_.last_active AS last_active_20, u0_.preferences AS preferences_21, u0_.signature AS signature_22, r1_.is_published AS is_published_23, r1_.date_added AS date_added_24, r1_.created_by AS created_by_25, r1_.created_by_user AS created_by_user_26, r1_.date_modified AS date_modified_27, r1_.modified_by AS modified_by_28, r1_.modified_by_user AS modified_by_user_29, r1_.checked_out AS checked_out_30, r1_.checked_out_by AS checked_out_by_31, r1_.checked_out_by_user AS checked_out_by_user_32, r1_.id AS id_33, r1_.name AS name_34, r1_.description AS description_35, r1_.is_admin AS is_admin_36, r1_.readable_permissions AS readable_permissions_37, u0_.role_id AS role_id_38 FROM users u0_ LEFT JOIN roles r1_ ON u0_.role_id = r1_.id WHERE (u0_.username = ? OR u0_.email = ?) AND u0_.is_published = ?' with params [\"EdV-MaUtIC\", \"EdV-MaUtIC\", 1]:\n\nSQLSTATE[HY000]: General error: 2006 MySQL server has gone away at /var/www/mail.verboencarnado.com.br/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:115, Doctrine\\DBAL\\Driver\\PDO\\Exception(code: HY000): SQLSTATE[HY000]: General error: 2006 MySQL server has gone away at /var/www/mail.verboencarnado.com.br/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: HY000): SQLSTATE[HY000]: General error: 2006 MySQL server has gone away at /var/www/mail.verboencarnado.com.br/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117)"} {"hostname":"cloud.verboencarnado.com.br","pid":99225}
[2024-05-27 14:18:18] mautic.NOTICE: PHP Notice - SessionHandler::gc(): ps_files_cleanup_dir: opendir(/var/lib/php/sessions) failed: Permission denied (13) - in file /var/www/mail.verboencarnado.com.br/htdocs/vendor/symfony/http-foundation/Session/Storage/Handler/StrictSessionHandler.php - at line 106 {"maxlifetime":1440} {"hostname":"cloud.verboencarnado.com.br","pid":100358}
[2024-05-27 15:17:31] mautic.NOTICE: PHP Notice - SessionHandler::gc(): ps_files_cleanup_dir: opendir(/var/lib/php/sessions) failed: Permission denied (13) - in file /var/www/mail.verboencarnado.com.br/htdocs/vendor/symfony/http-foundation/Session/Storage/Handler/StrictSessionHandler.php - at line 106 {"maxlifetime":1440} {"hostname":"cloud.verboencarnado.com.br","pid":102015}
[2024-05-27 19:02:13] mautic.NOTICE: PHP Notice - SessionHandler::gc(): ps_files_cleanup_dir: opendir(/var/lib/php/sessions) failed: Permission denied (13) - in file /var/www/mail.verboencarnado.com.br/htdocs/vendor/symfony/http-foundation/Session/Storage/Handler/StrictSessionHandler.php - at line 106 {"maxlifetime":1440} {"hostname":"cloud.verboencarnado.com.br","pid":107064}
[2024-05-27 19:33:14] mautic.NOTICE: PHP Notice - SessionHandler::gc(): ps_files_cleanup_dir: opendir(/var/lib/php/sessions) failed: Permission denied (13) - in file /var/www/mail.verboencarnado.com.br/htdocs/vendor/symfony/http-foundation/Session/Storage/Handler/StrictSessionHandler.php - at line 106 {"maxlifetime":1440} {"hostname":"cloud.verboencarnado.com.br","pid":107750}
Se puder me ajudar ficarei novamente imensamente grato.