Published some content from staging slots and they appeared in production web database?

Question

I'm looking into this issue where I'm trying to understand how this event queue and publishing works with respect to shared master db with 2 CM Instances & respective 2 CD instances with dedicated web database.

I'm referring to this blog post

Whereas according to blog, respective CD's Event-Queue database table register corresponding CM instance details from where the request initiated.

I need help to understand how event-queue and publish queue is initiated from CM to CD. Have anyone came across this scenario. Please help. Thanks.

Answer 1

Fix: Leave the sitecore settings InstanceName empty in all cms staging and production instance. It will by default pick up the InstanceName +website name from IIS. Below is the code that sitecore uses to get instance name:

string setting = GetSetting("InstanceName", null);
    if (!setting.IsNullOrEmpty())
    {
        return setting;
    }
    string machineName = MainUtil.GetMachineName(); // this function returns ((SystemInformation.ComputerName ?? Environment.MachineName) ?? string.Empty);
    try
    {
        string siteName = HostingEnvironment.SiteName;
        if (!string.IsNullOrEmpty(siteName))
        {
            machineName = machineName + "-" + siteName;
        }
    }
    catch
    {
    }
    return machineName;
}