Hello.
Dear community, I have a question about high-load development with Phalcon.
Phalcon PHP provides instruments to set the correct sources for the Model's data-tabels. But, internally, Phalcon does not work with "JOIN" when the tables for the SQL-query located on different database-servers ( https://forum.phalcon.io/discussion/398/splitting-data-over-multiple-databases ). So, to resolve "miltiple databases JOIN" problem, I need to use (for example) 2 queries for 2 tables and then join queries results with php-code. It works nice and fast.
But there is nice thing called "MySQL Cluster", and it can accept 1 big-join-query and collect data from multiple database nodes. https://www.clusterdb.com/mysql-cluster/70x-faster-joins-with-aql-in-mysql-cluster-7-2/
Which method is scalable and preferable?