This topic is 2558 days old. Please don't post here. Open a new topic instead.
How to Build FileMaker Web Apps for High Traffic using MySQL Backend and 360Works MirrorSync
Why Sync FileMaker and MySQL?
FileMaker is the best tool for rapid application development, but it is not the most reliable or scalable option for high traffic web sites. MySQL provides that reliability and scalability, but can't compare to FileMaker for development productivity and user friendliness.
360Works MirrorSync bridges this gap, letting you use each tool for its best purpose. Quickly create layouts, scripts, and schema in FileMaker Pro, test and refine them, then use MirrorSync to publish all your record data to MySQL and keep both databases in sync moving forward. You can use industry-standard tools and frameworks (or hire from a vast talent pool) to create highly reliable and scalable web apps.
In the event that FileMaker Server is down or rebooted for any reason (such as software upgrades), your MySQL web app will continue running and serving users. MirrorSync will detect when FileMaker Server comes back online and bring both databases back in sync.
This video, narrated by Junior Perez of 360Works, takes you on a step-by-step walk-through of how to sync between FileMaker Server and MySQL. Junior demonstrates how to start with a completely empty MySQL Server, create the database and tables, and set up an auto-scheduled sync to run every 60 seconds. The process is the same for any other JDBC-compatible database such as SQL Server, Oracle, or PostgreSQL. The license price for syncing one FileMaker Server with any one of these databases is $1,800, with discounts available for educational and non-profit organizations.
If you would like to involve 360Works in configuring your sync, or in creating a web application backed by MySQL, please contact us for consulting and development assistance.
Read More on MirrorSync or Download Now!
360Works MirrorSync Stay updated with 360Works
360Works 25 Year Anniversary and New Portfolio Offer
We are celebrating 25 years in business! Thank you for your support. If you are using a FileMaker plug-in or two from 360Works, we encourage you to try the 360Works Portfolio Bundle to receive all products.
Now through next week enjoy a 25% off sale on our Portfolio Bundle!
You already receive 75% off the entire suite of plug-ins with the Portfolio Bundle deal being offered at $1,995, and with our 25th Anniversary Offer you get an additional 25% off, making your final cost only $1,496.25!
Use code: 360is25 at checkout. (Online orders only, discounts cannot be combined, new portfolio)
This offer is for new Portfolio Bundle purchases only and will be on now, through next week, ending Friday, April 9, 2021.
Already own a product or two from 360Works? You can apply your licenses to receive credit for select products upon checkout of the Portfolio Bundle.
New Website Design
Have you noticed the new look of our website? Be sure to stop by and take a look: https://www.360works.com/products/
New Product Updates
We recently released a new major version of the 360Works Email Plugin, to include OAuth support for Gmail and Office 365. Additionally, we released a new major version of our FileMaker Server offsite backup, 360Works SafetyNet, with improvements for increased safety, reliability, speed, ease of management and lower cost.
Case Study: MirrorSync in Africa for Promasidor
Learn how FileMaker synchronization happens across the continent of Africa using 360Works MirrorSync in a solution for Promasidor Food and Beverage with experience shared from Technology Professional, Serge De Pauw at Promasidor. Read the story.
We are relatively new to MirrorSync (6.12). We can have a system which is syncing with no issues. We create a new record on the FMS in a table that is synced to the Spoke (iPad). After the iPad syncs and receives the new record, the next time the iPad tries to sync, they receive an error that there is a Duplicate ID...
On researching the issue, whenever we create a single record on the Hub, 2 records with the same ID are created on the Spoke with the same ID.
This effectively breaks the sync and needs remediation by the user of the iPad by the deletion of one of the records.
Updated internet plug-in is compatible with FileMaker 19 and macOS 11.0
Lienden, the Netherlands, December 18, 2020–Troi today announced the immediate availability of Troi URL Plug-in 7.0 for FileMaker Pro 19. This is a maintenance update which is tested and made compatible with Claris FileMaker Pro 19 and macOS 11.0.
Improvements in Troi URL Plug-in version 7.0
Troi URL Plug-in 7.0 has the following changes and improvements:
Tested and made compatible with Claris FileMaker Pro 19, including FileMaker Pro 19.1.3 and 19.2. Tested and made compatible with macOS 10.15 (Catalina) and macOS 11.0 (Big Sur). Tested and made compatible with Windows 10 version 20H2 (October 2020 Update), version 1909 (November 2019 Update) and version 2004 (May 2020 Update). Added new switch “-ImageFileName” to the TURL_GetLastProperties function, which will return the filename of the last image downloaded. (macOS) Improved compatibility when running FileMaker Pro 19 in dark mode, the flash dialog is now more visible. (macOS) Improved loading the plug-in with runtime apps created with FileMaker Pro 18. (macOS) Modernized the plug-in. It now uses a more modern framework. (macOS) Improved error reporting when there is a problem loading the plug-in. (macOS) If the plug-in can’t load a bundle at start-up, the plug-in will now write a detailed error to the system.log. See the Console.app in this case (search for FileMaker in the system.log). IMPORTANT (macOS only) The minimum supported FileMaker version is now FileMaker Pro 15. Also the minimum supported Mac OS version is now macOS 10.13 (High Sierra). Several other bug fixes and further (security) improvements. Fixed a bug in the TURL_Get function, when getting images a slash could be added at the start of the name of the image, when storing the image in a container. Improved the FillForm.fmp12 example. Modernized the OAuthWebService.fmp12 example. Small cosmetic improvement of the Regifunc.fmp12 example. More detailed information on all changes and improvements can be found on the URL Plug-in page.
You can download the new version there.
Version 7 needs a new registration string. Upgrading to version 7 is free for all customers who bought a license for version 6 on or after March 20, 2019. Eligible users will be sent a new registration code.
Upgrades from older versions are available from US $ 49. You can order upgrades from our shop.
Free FileMaker Training Webinar This Week!
Join Jesse Barnum, President of 360Works, and Richard Carlton at FileMaker Training TV for live FileMaker training this week (7/20 - 7/24) starting at
1 p.m. Pacific Time/4 p.m. Eastern Time!
Curious about FileMaker sync for worldwide replication across different cities & offline sync? You won't want to miss this week's live training at FileMaker Training TV covering FileMaker for Enterprise and featuring 360Works MirrorSync!
MirrorSync is an elegant synchronization product that makes it simple for people working at home or in the field with poor network connection to work on offline copies of your hosted database, whether on iPads, iPhones, or laptops! It can sync between any combination of FileMaker Pro, FileMaker Go, FileMaker Server, SQL database (MySQL, Oracle, SQL Server, or any database that supports JDBC), Salesforce, WordPress, Amazon DynamoDB, and Amazon RedShift.
During the live training this week, we will cover offline access for your FileMaker customer solution and help you set up multiple servers to support your worldwide FileMaker Team with Server Replication. Here is an overview of the schedule:
Day 1 - We’re covering the basics, including having the Amazon servers already setup. Day 2 - We’re doing the installation of MirrorSync and discussing the mechanics of Synchronization. Day 3 - Final deployment, and Open Q&A. Day 4 - We’re inviting everyone around the world to log in to the closest server. Feel free to edit and add data. Day 5 - Open Q&A: Lean Design & the Enterprise
PLUS, we are offering a special discount for those on the webinar. Be sure to tune in so you can grab your discount code!
Sessions are approximately 1 hour long. View the full schedule and register for FREE at the link below (sessions will be streamed via Twitch).
Watch the FMTraining TV Live Stream!
Stay updated with 360Works