I tried to separate the webserver and mysql server. MySQL server = 16GB RAM and the config of Innodb_buffer_pool_size = 10GB. And my Web server = 4GB RAM
My website connect to my database server using remote access with IP assigned. When I running a website it feels very slowly and then web goes down with the log "Cannot allocate memory for the buffer pool"
Does the webserver need more RAM for Innodb_buffer_pool_size too? Because what I know is that the webserver only run httpd not mysqld. And mysqld handled by remote mysql server.
In my case the web server still need to increase size for Innodb_buffer_pool_size.
Already add "skip-name-resolve" but no luck.
Is anyone here encounter same issue with me?