New on LowEndTalk? Please Register and read our Community Rules.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
Comments
No.
You don't want to know what happens when you use PHP and connect to two MySQL servers.
Do i want to know it?
I want to know.
PHP gets confused.
elaborate?
you can connect to two databases at the same time and get some info from the first one and some other from the second.
I think it brings more performance to cache database-entries with memcached, than to split infos in more databases. To split things in more than one database only makes sence, when you have an extreme high amount of tables (like very large wordpress-mu-installations like wordpress.com)
Why is one of your examples a warez board? :P
Except PHP will get confused and start issuing wrong SQL's to the wrong database.
Some time ago I used MySQL_Proxy to direct write query to the master and read to slaves, lately you can use circular replication...
I have never seen this happen. You open two different database handles. Queries to each go to the respective databases.
You have to remember which is which in your code, but that's not a real challenge.
Do you have more info on PHP getting confused and issuing wrong SQLs to the wrong database?
Have you spent some time tuning the MySQL DB you have now?
OMFG, you are the man