[Opensim-users] Question about databasew engines

[tringate at gmail.com]

I run three server, each run several different regions.  Each sever runs it’s own copy of mariadb.

I was noticing that those regions which were recently created or restored from a OAR have all tables using the InnoDB engine while the older regions have both the InnoDB and MyISAM type tables in use.  All my regions run the same version of opensim.

Would it make sense to rebuild the database tables for the older regions so all databases were using only the InnoDB engine?

Another thought would be to use one of the servers as only the database server and place all my regions on the other two.  This would remove the database server overhead from the servers running the regions.

Would that affect performance in a positive or negative way?

My LAN is a 1gb LAN not a 10/100 LAN.

Tom