This topic is 1844 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.
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
Learn how 360Works MirrorSync is being used in the ConnEDCt app built with FileMaker for medical research and healthcare improvements across the world!By 360Works
Case Study: FileMaker Clinical Data Capture Software Uses 360Works MirrorSync
Learn how MirrorSync is being used in the ConnEDCt app built with FileMaker for medical research and healthcare improvements across the world
“We have used MirrorSync from versions 3 to 6 for FileMaker Pro/Go to FileMaker Server. In our experience it is the most reliable technology for syncing FileMaker databases over inconsistent and slow connections.”
- Caleb Ruth, Data Performance LLC
At 360Works, we believe in making FileMaker plug-ins and tools with outside-of-the-box thinking to help FileMaker Developers build what works best by extending the functionality of their FileMaker solution to solve real-world problems.
FileMaker Developer and Business Owner, Caleb Ruth, was generous enough to spend time sharing with us some of the aspects of his work with health information systems which leverage 360Works MirrorSync.
Read the Full Story Stay updated with 360Works