Microsoft Azure PlayFab logo
    • Multiplayer
    • LiveOps
    • Data & Analytics
    • Add-ons
    • For Any Role

      • Engineer
      • Designer
      • Executive
      • Marketer
    • For Any Stage

      • Build
      • Improve
      • Grow
    • For Any Size

      • Solo
      • Indie
      • AAA
  • Runs on PlayFab
  • Pricing
    • Blog
    • Forums
    • Contact us
  • Sign up
  • Sign in
  • Ask a question
  • Spaces
    • PlayStream
    • Feature Requests
    • Add-on Marketplace
    • Bugs
    • API and SDK Questions
    • General Discussion
    • LiveOps
    • Topics
    • Questions
    • Articles
    • Ideas
    • Users
    • Badges
  • Home /
  • General Discussion /
avatar image
Question by Yours Truly · Oct 11, 2019 at 06:21 PM · Custom Game Serversdataphoton

Playfab parallel to existing MySQL backend server,Playfab parallel to current MySQL backend

Hello there,
I am a product manager (not a technical) at a game studio.
Our game is live on play store and AppStore and its multiplayer game with Photon as a game server and Mysql as a backend. Currently, we are looking for liveops solution.
I was wondering if we could able to run Playfab parallel (read-only) to Mysql and use it (Playfab) as a liveops server but post data back to MySQL server.

So in short, Playfab will work to run live operations only but all the data will be stored to the existing Mysql server.

Please let me know your thoughts on this or suggest a better way to do it :)

Thanks

,

Hello there,
I am a product manager (not a technical) at a game studio.
Our game is live on play store and AppStore and its multiplayer game with Photon as a game server and Mysql as a backend.
I was wondering if we could able to run Playfab parallel (read-only) to Mysql and use it (Playfab) as a liveops server but post data back to MySQL server.

So in short, Playfab will work to run live operations only but all the data will be stored to the existing Mysql server.

Please let me know your thoughts on this or suggest better way to do it :)

Thanks

Comment

People who like this

0 Show 0
10 |1200 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

2 Replies

· Add your reply
  • Sort: 
avatar image
Best Answer

Answer by Citrus Yan · Oct 14, 2019 at 08:02 AM

Hi @Siddhesh Narvekar,

So, what you need is the ability to perform Live Ops in PlayFab and then post associated data to the MySQL backend server, is that right? If that’s the case, can you access the MySQL server via a Web API? If you can do that, then it’s possible to perform Live Ops first and then make Webhook calls from Cloud Script to post the data back to the database server.

It would be helpful if you can specify which Live Ops features you want to use, how to use them, and what data you need to send back to the MySQL server, thanks.

Comment
Yours Truly

People who like this

1 Show 4 · Share
10 |1200 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users
avatar image Yours Truly · Oct 14, 2019 at 12:09 PM 0
Share

Hi Citrus,

Thank you for your reply.
Yes, that is correct.
Secondly. we can connect to our MySQL server via Web API.

Following Live Ops features we are planning to implement -

Playfab Authentication
Social - Friends, Tournament, Leaderboard
Commerce - Items, Stores, Economy
Engagement - Push Notifications

avatar image Brendan ♦♦ Yours Truly · Oct 15, 2019 at 01:11 AM 1
Share

My main concern here is that it sounds like you want to use your MySQL data as the source of truth for the state of the game data, while using PlayFab for "LiveOps". The way the LiveOps features in PlayFab work, they're driven by the events generated by things like commerce operations. Our features (commerce, Push, leaderboards, etc.) cannot read directly from your MySQL table, so you would be left trying to sync up data constantly between separate services. That's definitely not recommended.

If you just want to use your data for internal reporting or similar, you could use the Webhooks feature to send event data to your own servers for processing, but if you're looking at using PlayFab features in your game, I would highly recommend making it a clean transition for each feature.

avatar image Yours Truly Brendan ♦♦ · Oct 15, 2019 at 04:00 AM 0
Share

@Brendan Thank you for a reply.
Noted on your points.
Can you please let us know best way to transition from Mysql backend to Playfab?
Do we have to sync up existing data from unity client to playfab each time new user logins?

Thanks
Siddhesh

Show more comments
avatar image

Answer by Yours Truly · Oct 15, 2019 at 12:01 PM

@Brendan Okay got it. Thank you for your help.

Comment

People who like this

0 Show 0 · Share
10 |1200 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Your answer

Hint: You can notify a user about this post by typing @username

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Navigation

Spaces
  • General Discussion
  • API and SDK Questions
  • Feature Requests
  • PlayStream
  • Bugs
  • Add-on Marketplace
  • LiveOps
  • Follow this Question

    Answers Answers and Comments

    3 People are following this question.

    avatar image avatar image avatar image

    Related Questions

    How to handle winning and rewarding in a game? 1 Answer

    Syncing Database Across Many Dedicated Servers 1 Answer

    How to import and export user's data from Playfab? 1 Answer

    what if we want to stop using playfab and shift our title to our custom backend in future after a year from game launch 1 Answer

    Game Server Log Archiving in S3 1 Answer

    PlayFab

    • Multiplayer
    • LiveOps
    • Data & Analytics
    • Runs on PlayFab
    • Pricing

    Solutions

    • For Any Role

      • Engineer
      • Designer
      • Executive
      • Marketer
    • For Any Stage

      • Build
      • Improve
      • Grow
    • For Any Size

      • Solo
      • Indie
      • AAA

    Engineers

    • Documentation
    • Quickstarts
    • API Reference
    • SDKs
    • Usage Limits

    Resources

    • Forums
    • Contact us
    • Blog
    • Service Health
    • Terms of Service
    • Attribution

    Follow us

    • Facebook
    • Twitter
    • LinkedIn
    • YouTube
    • Sitemap
    • Contact Microsoft
    • Privacy & cookies
    • Terms of use
    • Trademarks
    • Safety & eco
    • About our ads
    • © Microsoft 2020
    • Anonymous
    • Sign in
    • Create
    • Ask a question
    • Create an article
    • Post an idea
    • Spaces
    • PlayStream
    • Feature Requests
    • Add-on Marketplace
    • Bugs
    • API and SDK Questions
    • General Discussion
    • LiveOps
    • Explore
    • Topics
    • Questions
    • Articles
    • Ideas
    • Users
    • Badges