Adding load balancer to a wordpress multisite installation
I am trying to add a load balancer to a wordpress application which has multi-site installation.
WordPress saves the server IP address in MySQL tables, since there would be two application servers and a single DB server and a load balancer.
i am using a RackSpace load balancer.
Can anyone please suggest what should the DOMAIN_CURRENT_SITE point to in wp-config.php and do i need to make any changes in the Database to update the IP address, if yes what IP address should be stored in DB.
Also, i am using Lsync utility to sync content of one server to another do i need to sycn wp-config.php as well?
Also, apart from wp-config.php and database are there any changes i need to make?
Also, apart from this most importantly how would the session be managed?
Thanks.
If you are using a Rackspace Load Balancer as per your comment you need to use the Load Balancer IP address in the DB tables.
Just make sure the IP address of the Load Balancer you are using is static and not a Dynamic IP Address.
Can anyone please suggest what should the DOMAIN_CURRENT_SITE point to in wp-config.php and do i need to make any changes in the Database to update the IP address, if yes what IP address should be stored in DB.
DOMAIN_CURRENT_SITE should be your primary domain. The IP address of Load Balancer should be stored in database.
Also, i am using Lsync utility to sync content of one server to another do i need to sycn wp-config.php as well?
No need to sync the wp-config.php.
Also, apart from wp-config.php and database are there any changes i need to make?
Please make sure the "Uploads" directory where all media assets are stored is syncing properly for both servers when new file is uploaded. Test the upload functionality of the wordpress and see if the uploaded media file appears on both the server.
Also, apart from this most importantly how would the session be managed?
Rackspace Load Balancer have "Session Persistence" feature, enable it check the screenshot below. Check the black arrow at the end of the screenshot.
- How/when mysql compiles stored procedures?
- UPDATE column with Y or N if data exists in another table
- #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
- How to get Python MYSQL connection username and password?
- Table is marked as crashed and should be repaired
- Coverting a .BAK file into a .SQL for use in XAMPP phpmyadmin
- Query through JSON Array with multiple values in MySQL
- Housing Society management system database structure
- MySQL DROP all tables, ignoring foreign keys
- When to use prepared statements?
- When *not* to use prepared statements?
- Are Prepared Statements a waste for normal queries? (PHP)
- Deleting rows in mysql table that contain an empty field where more complete rows exist
- MySQL given date between monday and sunday
- JSON_TABLE - how to access fields inside escaped quotes?
- mysqldump - maintain character set and collations
- Why can't a text column have a default value in MySQL?
- Using Hibernate's ScrollableResults to slowly read 90 million records
- Foreign key in the child table is null after persisting @OneToMany
- How to fix products without cover image in PrestaShop
- Laravel Eloquent Query Using Case/When to apply conditions dynamically
- MySQL SELECT a field as NULL if not existent in table
- How can I show all duplicate value from a specific column in MySQL
- Declaring 2 Cursors in a Stored Procedure | SQL Error [1338] [42000]: Cursor declaration after handler declaration
- PHP mySQL - Insert new record into table with auto-increment on primary key
- IF ROW_COUNT() return error
- Date column with associated MAX count value
- Drop Column from Large Table
- MySQL - 'Using index condition' vs 'Using where; Using index'
- Conversion issues in sql - GREATEST(CEILING())