Hi Bruce,

Sorry but I have no recent performance comparisons with other apps.

I can't say that I recommend having 2 sites using the same database where one writes and the other only reads. You may try such a thing but its not something I'm supporting or encouraging.

We do have a scheme where a different connection string can be used for writes than reads that was intended for this kind of replication. In most of the MySql data layer the connection string is determined with code like this:

private static String GetReadConnectionString()
        {
            return ConfigurationManager.AppSettings["MySqlConnectionString"];

        }

        private static String GetWriteConnectionString()
        {
            if (ConfigurationManager.AppSettings["MySqlWriteConnectionString"] != null)
            {
                return ConfigurationManager.AppSettings["MySqlWriteConnectionString"];
            }

            return ConfigurationManager.AppSettings["MySqlConnectionString"];
        }

but I'm not 100% sure this is done consistently in 100% of the MySql data layer code but is probably correct in most places. If you were to report any methods that don't have this I would be willing to update them.

Hope that helps,

Joe