Stations & Databases...What does it all mean!

Liam Burke • Nov 30, 2018

We demystify how Myriad 5 Playout is structured and how it can work for you!

Databases and stations

We tend to throw the word 'database' around a lot in Myriad 5 Playout and depending on the context, we might mean something very different!

But technically, there is usually only one database (per site) and all your various data lives within it. In this post 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.

Consider the diagram below

Database structure

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

Lets look at them one at a time.

Microsoft SQL

Microsoft SQL (MS SQL) is the fundamental technology and platform used to organise and store all the data used by Myriad 5 Playout. There are various versions of MS SQL available but most installations will be using MS SQL Express 2016 which is available for free from Microsoft.

MS SQL is much more than just a data storage system, the SQL Server software manages all the data, optimises the content and also performs tasks (such as searches) on the behalf of client software such as Myriad 5 Playout. This means that when your search for a Media Item on the MediaWall, Myriad actually asks SQL to do the search internally and return the results to be displayed to the user. This has several advantages including:

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

For more instances, 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 as well as one or more Stations.

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

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.

MediaWall

The key thing to keep in mind with the MediaWall is that only one can exist within a Database. This means that if you have multiple Stations at your site (see below) then they will all need to share a common MediaWall. This may involve content spread out with different areas specifically used by certain stations (like Jingles and Adverts) combined with shared resources (such as Songs).

You can make the MeidaWall as large as your 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 'Log' along with all the corresponding settings for that Log. The 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 itself (using InstantTrack Presets - see https://www.broadcastradio.com/let-s-talk-about-scheduling ).

Stations

Many stations will only ever need a single Station but unlike the MediaWall, you can actually have multiple Stations within a single Database...but why would you need them?

Why so complex?

The majority of stations will probably only ever use one Database, one MediaWall and one Station but there are good reasons why you might need more than one Station.

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 setup and 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. Obviously, 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.

Change stations

Automation 'Sustain' Service

This is a very similar scenario to the Multiple Service scenario but instead of it being two separate services, this is often the same service but a separate automated output that is always running and always ready to use.

You cannot have two workstation 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 InstantTrack 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 InstantTrack, it would instead copy the hour from the Automation Station.

This type of configuration would be great if you wanted your studio presenters to have the choice between using pre-scheduled content (eg copy the content from the Automation Station using the Fill This Hour option), manually build an hour by dragging content into the Log or ignore the Log altogether and just drag Media Items into Players.

Now lets reveres 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:

  • Training Stations are always ignored by OCP (regardless of whether they are 'On air')
  • Training Stations can never trigger Split Advert Breaks or Sprit Cart Groups in Myriad Network SE
  • Training Stations do not execute Commands in the Log
  • Training Stations do not action Hardware events in the Log
These simple precautions mean you can train your presenters on all aspects of using Myriad 5 Playout for live playout without the risk of effecting your actual station output.

Caution: Remember that your are still using the same MediaWall so editing Media Items will still impact your main output!

But what about On-air Control and OCP?

Good question!

And one that will probably get it's own blog in the near future but 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) will only listen to 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 would be listened to by OCP. So you could set up OCP so that if the Studio Station is running, then always 'listen' to that. If the Studio Station is not running then 'listen' to the Automation Station. That way when stop using the studio, OCP will default back to the Automation Station which has been happily running in the background and tell OCP what is playing only now OCP will listen!


And the future?

We are busy working on a future release of Myriad 5 Playout that will take this concept to it's natural conclusion, multiple Stations being played simultaneously on the same physical PC. This will allow you to run a handful of automated Stations from a single automation box (subject to licensing of course!).

Well there you have it....

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 OCP and how it can be used to drive many digital platforms from studio signage to twitter.


by Liam Burke 28 Mar, 2024
In anticipation of the release of SmartSign 3, we are looking back at the history of our screen studio signage system as well as a quick look at what the future holds. SmartSign 1 (well just SmartSign) was originally conceived as a simple ‘tally’ indicator to how real world events such as when microphones are active or a phone is ringing. At the time, we were working on the BR Hardware Service as part of the general Myriad 5 development cycle, and wanted a way to showcase the virtual hardware events the BR Hardware Service introduced. One of the aims was to make the system as cost effective as possible so work began on building an application that would run on Windows IOT on a Raspberry Pi. The Pi was ideal as it included physical hardware I/O built in meaning that SmartSign could use both physical and virtual GPIO and even convert physical inputs to virtual inputs for use in other BR software such as Myriad Logging or other SmartSigns.  We soon started to add other ‘tiles’ to the system to allow clocks, date / time, text, images, RSS feeds and more. SmartSign was released in 2016 and was an instant hit with our customers.
by Peter Jarrett 08 Dec, 2023
The latest feature from Broadcast Radio can really make your station stand out from the competition
by Peter Jarrett 12 May, 2023
Myriad v6 Public Beta testing has been going well... REALLY well!
by Liam Burke 19 Apr, 2022
This smart microphone may be ideal for Myriad Anywhere users.
by Blanca Jonathan 28 Jun, 2021
Image Source: Pexels
by Liam Burke 26 Feb, 2021
We are often asked for recommendations for smaller, low cost mixers for stations that are launching on a tight budget or looking to add additional studio capacity as cost effectively as possible. Type 'stereo mixer' into Google and literally hundreds of options will come up but the vast majority of them are not really suitable for use with Myriad because they do not have enough stereo inputs, are designed for sound mixing or do not offer the basic facilities needed to present a radio show. But there are a few that could be considered as a possible alternative to a full broadcast mixer. The Behringer DX2000USB may be the ideal mixer for smaller stations, as long as they are willing to live the compromises it brings when used in a broadcast radio environment.
by Arran Hodges 04 Dec, 2020
This post was originally posted on Arran's blog https://thisisarran.me/index.php/2020/12/04/the-technical-side-of-a-radio-station/ and is reproduced here by his kind permission. If you have a post you'd like share, please contact us and let us know!
Home Studio Mixer Review For Myriad Anywhere
by Liam Burke 28 Jul, 2020
With the World still struggling to adapt to the 'new normal' of working from home and minimising social contact, more and more stations are using Myriad Anywhere to enable presenters to record Remote Voice Tracks or even prevent live shows from their own home studios. Generally, all you need is a good microphone and a pair of headphones (we recommend a headset if possible) but we are hearing from a number of customers who are looking to create a home studio setup to allow them to get more creative and emulate their studio experience. So we thought we would take a quick look at a couple of home mixer options that work well with both Myriad Anywhere and fully installed Myriad Playout.
by Liam Burke 29 Jun, 2020
Sometimes you want to repeat complete Log hours in your schedule. Under normal circumstances, Myriad Schedule (or AutoTrack) will generate a new Log Hour for every hour of the week. But once you have edited and Voice Tracked an hour, it is sometimes good to be able to re-use that Log Hour elsewhere in your schedule or maybe even on another Station (if you are running more than one. This can be done using the Log.CopyHour Command.
Myriad RVT & Anywhere Cloud
by Liam Burke 22 Apr, 2020
We ran the numbers and stations are using Myriad Remote Voice Tracking, a lot! Let's take a closer look.
Show More
Share by: