This might seem redundant, but I found the instruction for this plugin confusing, so I though I would walk through the process and let everyone see the results. Being a graphic artist, by programming skills are a big ZERO. So I hope this inspires others to step beyond their comfort zone also.
Multi-DB plugin 3.0.6
IP address (18.104.22.168)
Dedicated Server info:
Intel Xeon X3414 2.40GHz quad
Apache version 2.2.17
PHP version 5.2.16
MySQL version 5.0.92-community
Operating system linux
Created a new site
Installed and activated Wordpress Multisite
Verified by creating a sub.site. All is working well
---Assuming all is set up correctly to this point---
STEP 1 & 2 of Multi-DB
Created 16 databases, based on the generated code, provided by WPMU DEV
<(Use WPMU DEV tool) https://premium.wpmudev.org/db-tools/db_sql.php>
Also created a global database per instructions. (see screen shot#1)
Note I chose to manual add the databases through MySQL in my Cpanel
For training purposes:
Initial WP database facts:
Database name: leonaaz_az1
Database username: user
Database password: simplepassword
Database Table prefix: wp_2
Total databases: 18 : 16 generated, 1 WP original, 1 global
All databases has been associated to the same user and password with full privileges.
See Screen shot.
BTY, this is merely a dummy test to learn Wordpress Multisites
This completes Steps 1 & 2 of the WPMU Multi-DB instructions
1/2a. Will it affect performance having 18 databases?
1/2b. Why have a global database? Is it just another database that is named global?
1/2c. Can you explain the 16, 256, 4096 rule for databases?
Next stop coming... STEP #3
This is where the rubber meets the road and can get confusing. My hope is that I can clarify this process as we non-programmers learn together.
Do have a thumbs up... is this correct?