Myriad Databases vs Stations Explained

But technically, there is usually only one database (per site) and all your various data lives within it. In this article we will explore the elements within the database, the correct terminology to use and why you might want to think about what will work best for you.

This diagram represents a simplified view of the structures used to store data in a Myriad 5 Playout installation:

Microsoft SQL

• Optimised 'fast' searching
• Cached data for common tasks
• Scalable data storage
• Myriad 5 Playout never directly accesses your data
• Can be expanded to include enterprise level protection (such as clustered servers) 

For most situations, we don't need to worry about how clever SQL is and can just enjoy the benefits!

You will normally only have a single SQL instance running at each site. Even if you want (or need) to run multiple Databases then you would normally host them all within a single SQL instance.

Database

The Database should be considered the overall 'container' for all of your Myriad 5 Playout related data within your SQL instance. In the vast majority of cases, you will only have a single Database at each site but there are exceptions (see MediaWall below).

Each Database contains a single MediaWall and one or more "Stations".

If you do need to use more than one Database then you will need to use Myriad Profiles to load Myriad 5 Playout with different Data Locations settings to 'point' to the different Databases and corresponding MediaWall files.

MediaWall

Now we start to get into the more recognisable parts of Myriad 5 Playout. The MediaWall part of the Database is used to store all the information about the content stored within your MediaWall.

You can make the MediaWall as large as you like (within reason) so it is easy to separate content on a shared MediaWall.

If you absolutely have to have separate MediaWalls for Stations on a single site then you will need to have multiple Databases (within a single SQL instance) with each containing a totally independent MediaWall. As previously mentioned, you could then use Profiles to allow a single workstation to select which Database to work with at startup.

Stations

In Myriad 5 Playout, the term "Station" can be considered to refer to an individual 'Scheduled Log' along with all the corresponding settings for that Log. The Scheduled Log is a 'playlist' of content that can be played in Live or AutoFade. The Log can be generated by a scheduling system (like AutoTrack Pro), manually created or by Myriad Schedule itself (see Introducing Myriad Schedule) 

Consider these scenarios: 

• Multiple services running from your site (e.g. Hot FM and Hot Gold).
• Automated 'sustain' service that runs 24/7 and is 'faded' up when needed.
• A training facility that you can teach on without effecting 'on air'.

In each of these scenarios, having multiple Stations is the best answer to achieve the end result! Let's take a closer look.

Multiple Services From A Single Site

This is probably the most obvious use for multiple Stations. In this case Hot FM and Hot Gold share a single MediaWall which is divided into different areas to contain the station specific content (like jingles etc). Songs are in a common area although some Songs are only scheduled on one or the other service (and some are scheduled on both).

There are two Stations added to the Myriad Database, and then Myriad Schedule or Myriad AutoTrack Pro is used to schedule unique content to each.

In the Hot FM studio, the Hot FM Station is loaded by default and used for all live and automated programming. LIkewise, the Hot Gold Station is loaded by default in the Hot Gold studio or by the Hot Gold automation PC.

Any Myriad 5 Playout workstation in the building can switch between the Stations as required using the Station options on the File Menu.

You cannot have two workstations running the same Station in Live / Automation at the same time so the answer is to have two Stations, one that is always running and one that you can use in the studio whenever you like.

They could be using the same content (i.e. AutoTrack Pro has sent the same 'Log' to each Station), have totally different content (e.g. you could just let Myriad Schedule pick your automation output) or have a more complex 'Parent / Child' relationship.

Hold on, a Parent / Child what?

Here is where it starts to get a little more complex, Stations can exist as their own entities or as a Child of another Station. If a Station is a Child of another Station then it will look to the parent to provide content if none exists.

In the context of an Automation Sustain Service, the Automation Station might be the Parent and the Studio Station is the Child. In this case, if you only sent the Log output from AutoTrack to Automation Station then the Log in the Studio would appear empty but if you clicked on the Fill This Hour option on an empty Hour, rather than fill the hour using a log file (from your scheduling system) or using Myriad Schedule, it would instead automaticall copy the hour from the parent Automation Station.

Now lets reverse that relationship so now the Studio is the Parent and the Automation Station is the Child. In this case, if you only scheduled content into the Studio Station (the Parent) but leave the Automation Station running 24/7, as the Automation Station gets to the end of each hour it will copy the next hour from the Parent (the Studio) including all the latest edits and Voice Tracks added to the system.

This configuration is perfect if you normally run from the studio in Live and also use the studio for editing the log and adding Voice Tracks but also want to have a 24 hour automated service that the presenters can just fade up at the end of the day!

And the Training Station scenario?

Now that we have taken a look at Child / Parent relationship, creating a Training Station becomes a lot easier to implement. You would simply create a Station that is a Child of your main Station and use that for Training. The presenters could click on the Fill This Hour option for any hour in the Log that they wanted to practice with and it would copy the hour from the Parent Station, but because it is a totally separate Station, nothing they did would effect your main output.

But wait, there is more....

You can also tag a Child Station as being specifically for training in which case the following special rules apply: 

Good question, and the short answer is that each Station can maintain On-air Control of itself but OCP (the thing that drives your website with what is playing etc) can only be connected to by one Station at a time.

So in the case where you have a Studio Station and a Automation Station, both have could have On-Air control (of themselves) but only one of those can connect to OCP at anyone time.

This is fantastic for Automation scenarios, as you can set up Myriad Playout in the Studio to connect to OCP, and set it to "never release", so as long as it has On Air control it will force it's connection to OCP, and not let go until On Air control is lost.

Then configure the Automation PC to "Immediately Release" instead, so the moment the studio tries to connect to OCP, Automation releases its connection to OCP.  It will then attempt to reconnect regularly, so the moment the Studio releases, it will then reconnect automatically.

A quick overview of the various parts that makeup the 'database' in Myriad as well as some practical scenarios to explain just why it is some complex! In a future post we will delve more into to Myriad 5 Playout works with Myriad OCP and how it can be used to drive many digital platforms from studio signage to twitter.