| MySQL on Slave [message #98413] |
Thu, 31 May 2012 21:21  |
|
I just set up a Master and Slave scenario and I'm trying to use the slave as the MySQL server. I am unable to get any of my websites to run on the new setup as none of them can connect to the database. I have changed the DB connections to reflect my slave server's FQDN and I have also tried using the IP address. I have even tried using the root username and password. I woudl greatly appreciate any direction someone can provide.
There are also some errors when I log into PHPMyAdmin that may or my not be related saying "mysqli extension is missing". I have also attached a few screenshots.
Attachment: 2.jpg
(Size: 78.05KB, Downloaded 176 times)
|
|
|
| Re: MySQL on Slave [message #98474 is a reply to message #98413] |
Mon, 04 June 2012 15:08   |
|
No one? I was able to get a connection to MySQL by opening ports in IPTables. I'm not sure if this is the best way, but it works. I also don't understand why there isn't any documentation on how this is done properly. The problem with mysqli extensions still exists in both the master and the slave. Again, Any help would be greatly appreciated.
|
|
|
|