Question about databasew engines

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Question about databasew engines

tringate
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
_______________________________________________
Opensim-users mailing list
[hidden email]
http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-users
Reply | Threaded
Open this post in threaded view
|

Re: Question about databasew engines

Melanie
With 3 servers that is feasible, but there is a point where you reach the point of diminishing returns, where network overhead and processing time on that single server will consume more wallclock time than the local server uses in cycles. If you never intend to grow past a handful of regions, it will serve you well.

However, consider that, should you lose that one database, your whole grid will be lost. Look into mysql replication or into galera clustering for an online backup solution that will not let you down in that case. If that is too much, do make daily backups. Using percona tools, it's possible to backup a mysql server without long held locks, so no shutdown is needed to back up.

- Melanie






---- On Tue, 15 Jan 2019 01:04:33 +0000 <mailto:[hidden email]> wrote ----




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

_______________________________________________

Opensim-users mailing list

mailto:[hidden email]

http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-users
_______________________________________________
Opensim-users mailing list
[hidden email]
http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-users