FileMaker Training Review
Contact us at support@rcconsulting.com
(805) 946-6552
FileMaker Training Review
Welcome everyone to another awesome day of filemaker training filemaker the filemaker platform a really cool development platform for building your own custom filemaker applications i'm richard carlton creator of fmtraining. tv where we do live stream training every day at one o'clock here pacific time it's we have people joining us from all over the world it's very cool we want to welcome everyone and uh so today's broadcast is day four of a very awesome well it's four four four day day four of five days of awesomeness it's a deep dive into syncing your filemaker solution to an offline device or syncing it around the world to multiple servers so those servers can access the information worldwide at high speed really so that's the idea is taking filemaker and deploying it so if you have a team in europe a team in the us you want them to have fast filemaker performance you need the stuff that we have in this webinar so doing a little bit of
maintenance up front here i want to let everyone know that the daily the daily live stream trainings are uh provided by or sponsored by fmtraining. tv i'm the creator of the training team there that there's about four or five video editors and we put together on-demand filemaker video content every year for every release plus daily live streams it's really awesome and because people like you help purchase our bundles it helps us pay for and afford these broadcasts it's really great so if you want to know more about the upcoming broadcast you go to fmtrain. tv and you can press the live tab and we'll show you the upcoming schedule down at the bottom about the next six business days of what of the training that we have and then uh cool so then let me just keep running through the announcements here so we are broadcasting in high definition on 1080 uh to youtube twitch and discord um and we will be talking and so as
i'm talking here and presenting or jesse is talking presenting our guest speaker i'll be over you'll see me over here kind of typing and doing stuff over here i'm actually communicating because there's three different chats going at once on this broadcast very interesting if you want to help help support these broadcasts help support this this training which is really free nothing in the world is really free someone has to write a check to pay for it that's me if you want to help support what we're doing definitely make sure you buy one of our training bundles the training bundle right here which includes all the training plus a special version of our crm fm starting point and that includes a full full copy of filemaker pro for mac or windows right so filemaker pro 19. and actually that's an error right here as far as filemaker pro advanced i just caught that uh they we've been we've been steadily removing all the advances everywhere in the
world in fact it says it right there twice i have looked at this screen a hundred times since nineteen shift and i have never maybe you folks caught it you should say something to me because i am definitely not perfect now if you already have filemaker pro on your mac or windows computer then definitely check out our training here once again you'll get on-demand training it's much more organized this is a little bit free-flowing ad hoc we do have people here who get grumpy at me for taking questions and stuff and so once again this is not the same as on-demand training this is kind of like if you have a speaker and an auditorium and they're talking and they're taking questions this is that kind of deal so that's very cool um for devcom we're coming up to the filemaker developer conference and so if you think that you might want this bundle right here this bundle right here is normally uh the single person
bundle we have a double double bundle which saves a ton of money for two people a ton of money it's a really a good deal so it's the claris dev con slash engage double double deal it's like going to the burger place and saying i want a double double uh in and out burger right uh if you want to check that out you can go to bitly dot co b i t dot l y forward slash fm double will be the link that will get you there which is pretty good um and then today's broadcast once again is by jesse barnum he's the ceo of 360 works jesse makes mission critical software that if you want to deploy filemaker to the enterprise you really must use this software i i don't i don't want to say you you you you absolutely must use this software there's probably five percent of you who could probably if that who could not even not even that i just say you
can't build what he has done for what he's charging the synchronization software which you're going to see is amazing it's really inexpensive relative to what you're getting and so i i'm just going to say you have to have jesse right and if you and i know people say well you can't say that it's like hey this broadcast is not not being paid for by apple not being paid for by clarus i could say whatever i want right so i say you need jesse if you want to fight about it we'll fight right jesse are you there can i fight for you or is he gone we lost jesse he's probably not i was too busy i was too busy laughing to find my unmute button i know i'm sorry about that yeah well people are like you don't really need jessie screw jesse right no no no no no no no you have to have jesse must have jesse no jesse no no enterprise for you
that's the way it is if you want to take filemaker to the enterprise you must have the third-party software to make it work period and and you're like why is that well i'll show you in just a second but before we do jesse does have a good deal on the software he doesn't do this for free he wants money for his hard work i don't blame him uh so if you want 15 deal off i told him if you're going to come here and show this everyone here is going to want a deal all these people here going to want a deal i can see them line up i got tk i got bob i got scott i got robert from texas i got joe from cologne uh wow uh point richmond everyone's showing up brotterman from arkansas michael uh gravel from montreal i got iis delta whiskey from indonesia which is always exciting we got course top cat cambera dave one dave two gadi ken nate scott tk
and did i get everyone here and these are only the people that i can actually see there are literally for every one of you that talk here and we see here there's about eight to ten lurkers people who are stealthily lurking about right so let's talk about what we're doing today what are we doing and why do you need jesse so i'm gonna click over here see if this will play i want you to look at this i'm gonna pause this as we go here in fact what i'm going to do is i'm just going to close this i'm going to pop this as a video right here i want you i want everyone to see this is really amazing stuff so this is what we are talking about in the enterprise this is the latest version of this graphic this is probably the complete one so the idea is that you're going to set up servers if all you need is like europe and part of the united
states then you can set up two servers right but if you have east coast and west coast the united states and europe and you've got india and you've got japan you've got australia we can do all this jesse does all this his software makes filemaker work in this configuration filemaker without jesse won't do this filemaker by itself filemaker server only does one only does one by itself what we're doing is we're showing that it's going to synchronize this data see so all of them are synchronizing together so if you make a change in one location the change gets pushed to all the other locations and you're like why are we doing all these servers well the reason we do all these servers because people log on to the closest server and so as you can see here they would log on the closest one and you're like well how do they know what the closest one is well you come to the right place we have an
answer for all that and the reason why do we do it this way well one is that we want people to be close to the server which gives us great performance right that's one two in the event of an unsavory accident right so you have a server that goes down or there's a problem or something else happens those people who are affected by that can quit filemaker and reopen it and they would be redirected to the closest server so they can continue to access the solution meanwhile you can call your it folks and say hey please resurrect our server once it's up and running it auto resyncs and gets up to date then those people can come back in again so this is really good stuff this is so when you see all the animations like this this is normally the stuff that you get in our uh in our paid on-demand video courses a lot more animated a lot there's no questions people doesn't people
don't ask us questions because they're not there but this is the kind of stuff you get very good very good artwork so uh there are people who are going to ask questions we do have some lurkers lurking by from 360 works if you have a tech question we'll try to throw it out there to you we do have an agenda for today and one of the things we're going to do is we're going to give you the keys to the castle we're going to give you a launcher file and i'm not quite ready for the launcher file yet i'm getting it loaded up but we're going to take the launcher file we're going to post it here so everyone can log in and you're going to notice at the top of the computer as you log in it's going to redirect you to the closest filemaker server it's really cool and jessie's going to walk us through a bunch of this so so jesse are you there are you ready to
you know i'm ready to go and i've got quite a few bullet points on my kind of demo list i don't know if i'm going to get through all of them today but i'm probably going to demo a little faster that i've been going in the last few days because i want to make sure that i i hit as many of these bullet points as i can first thing i want to show here just like what richard was talking about is um the dns feature and i mentioned this on day one but i want to just show you guys something new so if you were here on day one you saw that we had four servers we have a which is california b which is virginia c which is ireland d which is mumbai last night we added e which is sydney so we are now operating in four different continents and i want to show you what i did to get the domain name servers to add that
sydney server um so i'm using route 53 from amazon and uh i won't go into how i got here because we did that on day one but previously i had four checks now i have five checks so i added this new health check and when you add a health check with with route 53 amazon wants to know what do we call this i'm just going to call this fmsp5 what's the protocol i could pick either http or https we're going to be talking to the data api on filemaker server so that requires https uh then we're talking about our domain name and i just realized that i made a title here that should have been e so i'm glad we edited this i'll fix it um so that is the server that we're talking to since this is our fifth check i guess i could have done check fmspe and then it wouldn't have maybe i wouldn't have made that mistake but um but this is the server that we're
gonna check this is the port that we're checking it on and this is the url that we're checking i'm checking to make sure by specifying this product info url that's always on whenever the data api is on so by calling this url i'll be able to make sure that a filemaker server is running and b the data api is running if the data api were to stop or found the server were to die then that check would start to fail and this would change to an unhealthy status now that i've got this health check set up now i can go over to my dns setup and uh you know i'll delete the one that i added and i'm going to add it back in just so everybody can see the steps here because this is a really cool feature that you can use not just for not just for filemaker not just for replication this is an amazon feature not again a filemaker feature a 360 works
feature or embarrassing feature if you're ever creating a website or web application on amazon and you are distributing it across multiple uh servers in multiple regions you'll need to know how to do this so this is good to know even if you're not uh thinking about it for mirror sync so i'm going to create a new record set the host name fmsp demo you'll notice that that matches the ones that i already have set up it's because everybody's going to type in the same host name to get to the server i could do an a address and type in an ip address here but rich already has servers set up with a certain domain name so i'm going to pick cname instead and cname basically means this isn't this name here fmspdemo is an alias for some other name and i already have that on my clipboard right here 1701e that's the sydney server i like to set that this is the time to live this
is essentially how long that value is cached setting it to a long value means that uh clients will cache that value for a long time which reduces the traffic to amazon setting it to a short value increases the traffic to amazon and the cash time is much shorter i like to set it really short that way if i need to make a change i only need to wait one minute for that change to kick in down here so this stuff up here this is regular dns stuff that you'll use amazon for any time that you want to set up a dns entry if you're setting up a web server or filemaker server you should know how to do this stuff that i just showed you now in the lower part we get to the kind of deluxe stuff where we're getting to the different types of routing choices so simple basically means this always goes to that i'm not going to talk about weighted failover or geo-location i'm
going to talk about latency in this case yeah want the shortest latency right yep latency is saying this server and if i look at my other ones they all have a region assigned to them u. s east u. s west uh ap south one which is mumbai and eu west one which is ireland so this new one is in sydney which is ap southeast one and then i give it some name and the name should be different than all the other servers and so i'm just going to call it fmsp ap southeast 1. it doesn't matter what i put here as long as it's not the same as anything else i've ever created this last section is optional associated with health check if i pick no then amazon will always route the queries to whatever the nearest server is but if i pick yes and then i pick that new check that i added fmsp5 then it will route it to the nearest server if that server
is running the server's not running then it will take it to the next closest place so use combining this latency dns feature with the help terrific redundancy and speed because it will take you to the nearest server unless the server's down and then take you to the next near server and i hit create there and so now i've got my five entries back again they've all got a time to live of 60. so if i wanted to make a change to any of them it would only take a minute to make that change let me show you under the hood how this is actually working i'm going to go to terminal which is what i usually use for my dns checks i'm doing ns lookup which is a built-in command that just basically says do a dns check and i'm looking for this name fmspdemo. 360works. com so i do that my server is the google server uh the google server is talking to the amazon
server because that's where the 360works. com domain is hosted and then it's going to say this is the interesting line right here fmspdemo. 360works. com goes to and this is the c name part stands for canonical name it does it goes to 1701b. atrcc. com b remembers the east coast i'm in atlanta so i'm closest to the east coast server if you were to do anybody who wants to if you want to try this on your own computer give it a shot and it's look up fmspdemo. 360works. com and you'll get either a b c d or e depending on which region you're closest to and then down here is the actual ip address so when filemaker goes to connect to this filemaker doesn't know that any of this magic is happening at amazon's end it just says hey where is the server amazon is going to reply back it's kind of sneakily sticking in the closest one and filemaker doesn't know the difference filemaker is just
like okay well here's the server i'm going to go to detail since i added that sydney server so everybody knows how that works so that's um i'm going to i'm going to move on from there i'll have some other points where i can stop for questions but since i've got so much to get through i want to show this next thing which you haven't seen yet unless you saw richard and i uh demo this two or three years ago okay is is this the one where you're going to push the update this is the one where i'm going to crush the server i'm going to crash it on purpose okay okay when you get to the part we're going to push the update we need to put a security credential in for these people to use so we need to do that and then push that out because right now they can't log in okay cool all right sounds good so i think that i think that our
security credential that's already you and i set that days ago and it's already been pushed to all the servers so we can do it with or without the update okay off the check though um the uh so i've got this running every 10 seconds and i'm going to go into um i'm going to go into my server notice that the title tells me i'm in northern virginia that's because it's closest one to me and i'm just going to create some records i'll create an expenses thing because i have any creative ideas of what else to do uh and new motorcycles should definitely go on my expense report uh since the sync is running uh every so often in the background uh if i were to look here i would see that this stuff should hopefully be getting pushed to all those different servers so i'm making the change in virginia mirasync is going to pick that change up from virginia and it's going
to write it to the other servers and yeah you can see right here zero three so it's writing those four expense records that i just created to the other four servers so that is working that's great now so let's remember i've got five records here in my expenses table now i'm going to do something really awful actually always kind of makes me happy for some perverse reason i don't know why i like doing this but i'm going to fm server and i'm going to kill this process this is not a nice gentle hay when you're done stop this is you're dead you're gone okay so that's like really bad don't ever do that to your server unless you're you're dealing with uh fake files uh like this or unless you're running mirror sync so that file that server is now dead and i can prove it to you if i try to go here database servers database server is not running when you
stop the database or so that almost certainly corrupted my file um yep take it to the bank baby take it yeah yeah that file is dead um i could try and open this file and i could try and do a consistency check on it i have some uh files that take three hours to do consistency checks on for some of my larger clients so rather than do the consistency check what i'm going to do is i'm going to go to last night's backup and last night's backup and actually i'm going to stop the auto sync this will actually all work with auto sync on but i want to stop it so that i can make sure that everybody sees what's happening at the speed that i'm talking about it and not have it happen behind my back so i'm turning off the auto sync i don't need this anymore i've already killed it i am going to trash this dead file of course if it was real i
would move it to some damaged folder or something like that so i could have it just in case but i know i don't really need it for this demo now i'm going to my backup this is my daily backup from the 22nd which is last night at 11 pm so this is last night's backup does not have the new records that i just added so i am going to put this into my live database folder and then i am going to go back in the server admin console and i'm going to start my database server now in reality i would if my server was dead i would definitely be like rebooting the server and making sure that it's okay so that file is uh is up and running i need to open it server admin actually hadn't caught up to the fact that file was dead and gone so it was just momentarily thinking that everything was fine and still showing the old open file um so before
i you know what the sync is not finished yet i'm going to close this file because i don't want the sync to run yet on this file oh you know what the reason the sync is taking so long is because it's still trying to get filemaker server to do something um and oh and uh i wanted to show you guys i i wrote this down in my bullet points and i'm not referring to my bullet points i wanted to show you guys that and i don't have time to go back and redo it but if while the server had been crashed if i had come in here and did another dns look up it actually within 90 seconds of crash and server it would have come up saying canonical name is 1701a because that's my next closest server and if i had tried to connect back in with filemaker pro client it would have worked but my uh title bar would have said northern california
instead of northern virginia and i'm sorry i skipped that and i'm almost tempted to you got listen jesse you're not unless you're gonna skip out on us tomorrow we got plenty of time we really do i'm gonna cancel that sink and i'm gonna read i'm gonna crash it again yeah do it twofer double crash baby you're like no no no don't do this it's kind of like breaking a window it's like you know you're not supposed to all right so that file is dead uh and if i reload here it's really dead and just to make sure it's really dead will come into this live thing i'm going to trash that file now it might take up to 90 seconds before it goes away and the reason is because it takes about 30 seconds for that health that health check runs every 30 seconds we can come over here and we can look at our health check and so the one i just
killed was b which is which is two so hasn't amazon has not figured out yet that i've killed it uh so why don't we why don't we pause for a minute and if there's any questions now is a good time to answer them while we're waiting for amazon to kick in uh tk says later people can log on to only using a web browser they need um yeah i don't we're not trying to do web direct on this tk i mean i guess we could but um how many i mean how many fires do you want me to light on live tv at one time so um i think pro and go or easier demos besides if they're people here watching and they're not doing pro or go then i'm not sure they're entirely following us uh i would assume that most everyone here has at least pro but i would point out that everything i'm demoing would work that would work just like this with web direct as well
yeah you would put in that same url in your browser and then amazon would route you to the next closest server so so so d vike says it didn't work for me it kept returning to 1701b right and that and that's the east coast server right so i wonder if i mean i'm not sure you know you know what i just realized our health check actually is checking to see if the data api is running and the data api could potentially be running even though the database itself is not so let me make sure yeah that's what it is i need i'm just going to i'm simulating the server as completely dead so i'm just going to turn off the data api and then you know within a little bit of time again 30 seconds or so amazon should realize that's really dead yeah you'd want to normally we do a test to see if there's actually a file that comes back available file or something like
that in the list yeah that would be a better check is to check that the file is actually there it's a little bit more complicated because of the way authentication works in the data api you need to make two two requests oh yeah that's right you know you need to make a login request and then get that token and then make a second request amazon health check can only make one request and it has to be a hard-coded request so in order to do that you would need to set up like a php script or javascript or some server side check maybe a lambda function or something that would do that check for you and then return a success or fail um let's see while i am waiting for this to to go questions anyone questions questions let me let me talk about um what i'm going to demo next uh just so i can get through it a little bit quicker once this comes up
i am going to take that backup file i'm going to post it live on filemaker server b it will not ha it's last night's backup so it's not going to have those new expense records that i just created six records in that expenses table so then the question is what do we do about those missing records and the answer is mirror sync we will start mirrorsync up and running again and then oh wait wait wait wait wait just stop i just had a revelation so you're saying that this will take a backup and bring it up to date so we actually so normally people say oh i lost 15 minutes of work or or if you're a real ding dong and you back up once a day i lost a day's worth of work of my last backup this is horrible this would restore as long as you have it synced to a second server yeah well yeah yeah yeah yeah yeah yeah we'll pull it from the second
server and push it back on the first this is amazon has now figured out that the server is dead okay yeah he just uh dv d-vikes d dykes dikes do you likes i don't know whatever yeah yeah whatever the valkyrie yeah duvalc yes whatever i mean i i whatever yeah it works now he says i see him every year at dev count notice that our name our dns switch has now kicked in now when we're requesting from amazon fmsp. 360 fmsp demo it's telling us 1701. so let's see what happens when i switch over to filemaker and i go to the same host that i've been using which is fmsp demo so you know this is just an ssl thing so i say okay here fmsp use enterprise x3 i can log in now this is going to be a little slower for me because i'm going to the west coast of the east coast but notice the title bar here northern california any
it person having to do anything without anybody freaking out within about 90 seconds um that dns change happens on amazon amazon realizes it's down and it rounds me to the next closest server in my case that's northern california uh but you know depending on my geography if i was in i don't know newfoundland or something like that maybe it'd be faster to go to ireland um so uh so that is how that is how that works now what i and that actually the feature i'm just showing you right now is not specifically technically speaking a nursing feature that is an amazon feature now i'm going to show you where mirror sync plays into this so okay we know the server's down so we called it guy ring ring ring blew up he goes oh i'll take care of it and he goes over there and puts the backup back on he puts the backup back up no we didn't uh yeah i don't remember did you move it
i don't think i didn't see you moving i didn't you're right i need to put that back up back in there okay so there's last night's backup notice the modification time 11 pm last night so let's go in and let's open that file up so that file is now ready to go and now let's tell mirrorsync to do something so mirrorsync is now going to see that that's in uh that so mirrorsync keeps an internal timestamp of when it last synced with the server and it stores that on the server um oh you know what this isn't working because my data api is still off but this is instructional no this is i i couldn't plan this better because what this is showing is that even with that server that mirrorsync can't talk to it right now but even with that server down mirrorsync is still able to sync just fine with all the other servers so mumbai ireland western california you know western
u. s and sydney are all still running all still in sync with each other yeah when i go to the data api our resident uh certified flight instructor ken just told you just beat you the punches yeah you gotta turn the dappy back on so yeah thank you i love it when people tell i actually i sincerely do love it when people help me with my demos without being facetious no i'm being serious too the problem is this like game they play with me here when you're not here and they let me like dig a deep hole and they could have stopped me like 30 minutes ago and they let me keep going because they see how far it goes it's like a i think a drinking game richard and the weeds do they say nothing or do they maybe just give you a little hint like huh maybe that won't work just just to mess with you they could be tough on me they're hard people so
yeah so uh so then you need to turn that on and now it's uh we're going to be happy now so i've turned the data api on and by the way while this is running if i come back in here amazon has already picked up that the data api is back on and is now routing traffic to 1701b that actually happened fashion i thought i was expecting to have to check that a few times what's happening right now is mirror sync is going into what i call recovery mode and mirror sync knows the last time that it synced with eastern u. s is i don't know just say 4 30 p. m so when mirasync goes to sync with it again as far as filemaker is concerned the last time it synced with mirrorsync was at 11 pm last night mirrorsync knows that's not what i thought so it knows that there is some mismatch it knows that the file is talking to you right now
is not in the same state that it was in the last time that mirosing talked to it so it switches to a different mode recovery mode in recovery mode it will not delete any records those expense records are missing from the eastern uh east eastern us but instead of mercy going hey these records are missing they must have been deleted let me go delete them everywhere which is what it would normally do nerdsync will say hey these records are missing but i'm in recovery mode so let me get them from another server and put them back so it also does some extra deduplication checking to make sure that it's not creating any duplicate records during the sync which makes the sync run a little slower but that finished and it ran and i've got a bunch of insertions i've got 11 insertions here in my audit log there's my four test records in my expenses table so let's go take a look now that the server's
up i should just be able to close this i'm not sure filemaker caches my dns or not let's see what happens honestly i really don't know what's going to happen here yeah which one are you in yeah which one will filemaker put me in cool filemaker picked up the dns change and put me into virginia server so now i'm going to the one that was dead and if i go to expenses so so what i said yeah so so when i said okay so here i'm going to escape out of out of here i'm just going to make your window smaller for a second go back to my animated video here so for those of you who i might everyone pretty sharp here but when we blew up the server down here in this corner down here you see this where we blew this server up in the bottom right the restoration here when we we bring the server back up and we use a backup safe from
yesterday or whenever it was an hour a couple hours ago then what happens is that mirrorsync does a kind of a not a yeah but it's it's it's his commit rollback is this acid kind of stuff where it finds the records it's more enterprisey than it than i even it's more enterprise than i even thought i mean because it basically takes the other servers and it reconstructs where the hell it should be it's almost kind of like i mean i hate to say like a raid drive but almost like the idea if you drop the raid drive out and put it in the other drives kind of yeah combine forces to rebuild it right kind of thing so exactly like they're like a checksum yeah yeah yeah so it's kind of interesting how that works that's pretty amazing stuff so you know um so even more enterprisey than normal so that's pretty impressive and let me also point out that we've been demoing this kind of transcontinental
servers all around the world but what i just showed you i think probably everybody in this call can agree that this would be a really valuable feature even if all your users are located in one place yeah if you had mission critical say like you had a server that just couldn't go down and you're like screaming that right then you put two filemaker servers side by side in the same data center they you have groups of people using both um they just divvies them up however you want to divvy them in terms of load or whatever and and then if one dies then that then every then the company keeps going but then you get it buys you some time so your i. t person can like resurrect things right so exactly yeah um and you get that scalability benefit of your users get split across two servers instead of one so when both servers are running they're basically able to handle twice the load
when one server goes down you've got all the load on one server but mirror sync will recover that server as soon as it comes back up yeah so uh that is what i wanted to show there as far as the recovery from backup should we should we open the floodgates and pass out that launcher file well we can i am you know i was thinking about what we want to do this from structural standpoint so everyone here so we give the file out then what we're going to do is probably kick everyone you know in a couple hours or something um and then we'll do it again tomorrow but i'm going to send out an invite to everyone jesse and if you want to you know they can send them an invite and then we'll give them the revised password in the broadcast tomorrow we'll change the password but i want to see if we can we're up i i don't think we're going to have more than 50 or 60
people here today uh watching this but if we really put the word out there that we're trying to break filemaker i will have people show up we'll turn on web direct too we'll try to web direct just to light everything on fire and that way we can uh then that way we can address that so then uh there's a question here can a cr can a corruption also be synced to the corrupt file on the other server well okay so back to this diagram here real quick i'm going to use the diagram here to answer the question so the idea is that this server crashes down here right and so we throw that well we take the file and we move it out of the way we mark it as crash we don't ever use it again then we restore a backup on here so if we follow that process we don't have corruption if you never use a crash file the chance of running on corruption are
really slim really really slim so so he's saying well if you had corruption uphill could it push the corruption downhill i mean i guess if you were a i want to say a goofball but say you're say like you're working up here i'm and i'm drawing pictures on the screen here jesse the this moving map thing um if you're in the on the us east and say so jesse they say this is jesse's headquarter server so he makes a change here and then he marks the little flag indicator to push up updates to everyone right and say that during him doing the development work he crashed the file and opens it and crashed it opens it so he himself through his bad actions puts corruption into the file then he sticks it on the server and then you tell the server to distribute that everywhere yeah you're going to take that corrupted file and spread it everywhere right so it'll be if you so there's there's i i
see that it's kind of a three-part answer if if by corruption some people use the term corruption to mean users doing dumb things and that will definitely get synced if a user goes in and deletes a ton of records or does replace field contents uh that they shouldn't have done mirrorsync can't tell that from saying it's supposed to do and it will get you have people who use that corruption word like that because if they do they get slapped down here because that's because that's this user's uh data entry error that's all that is right that's not correct so yeah as far as like the file actually getting corrupt mirrorsync will not sync corruption so if your hub file or your spoke file were you know if you kicked the power cord and the file didn't get fully written and you plugged it back in and it said are you sure you want to use this consistency check blah blah blah and you said yeah yeah just use it it's
fine and then it turns out the file's not fine and like it's crashing all the time and like the indexes are messed up and things like that mirror sync is not going to sync that corruption back and forth it will only sync the data from the records that can be ascertained through the data api back and forth so you don't have to worry about that the only time that i could see a case where file level corruption could be transmitted from one server to another is uh if mirrorsync copies the entire file so notifications syncing record contents but yeah right that's what i was the entire file listen a vast majority of corruption issues i i'm not being a i'm like a like a you know a mother here mothering everyone so i'm mothering you you'll be mothered you will love it i will mother you and you will like it um you remind me so much of my mother oh god i'm sure so yeah so the
problem is is that is that most corruption is caused by human factors developers who are under we have we've talked about this you weren't here but they're under pressure they don't have good backups they don't back up off enough it crashes they have to restore the boss is like go go go we're all down what are we going to do why do you suck you're a horrible developer go go go we're going to fire you we need a better someone's better and when you're under that pressure you're inclined to do stuff that you shouldn't do like use a corrupted file if you do that and the file is corrupt then if if if mirrorsync pushes that file to other places you're just i mean whatever yeah but even then it's only an issue if you do it on the hub mirrorsync will never push a file from a spoke to another spoke or from a spoke to a hub but if you have corruption on the hub
mirrorsync won't sync that to the spokes but if you do something like use the database version feature which we haven't demoed yet or if you you know you add a new spoke and it's an initial sync in those cases mirrorsync will copy the file from the hub to the spoke and then any corruption in the hub file would go with it to the spoke correct a mundo so yeah so try not to uh be that person right so um all right we're gonna go back to you jesse here um so do we wanna like let people play with this a little bit or want to let them log in i think that would be fun okay so everyone raise your right hand and and you swear that you will only do good safe data on live tv and you will not it will be all safe for work right ken tuley and tk and a couple of people who i know are just like all right so uh we
have i'm gonna post it over here i'm gonna put make your screen full screen jesse uh we're back to full screen on you i'm going to disseminate disseminate i am going to push out the uh the player file here so here it comes wim so everyone can download that and it's actually kind of a cool one because it allows you to you those be the button that you see and then you'll see the um you know the button that you see and then the um and then obviously you can log into a specific server if you want to verify that right so the credentials i'm also posting in another message here oh that's the stop stop stop that will not work let me edit that stop edit it's not admin it's live stream live stream and it's not case sensitive on the username but the password is numbers technically that's case sensitive so there we go there we go there we go cool so everyone can now
log in and if you want to add or edit a record or whatever you want to do um put your own put your own pay attention to the sorry go ahead richard then put your own contact record into the contact table this has have a lot of records in it um and put your picture in there if you want whatever okay and did you make it so the launcher has buttons to open the servers directly oh yeah yeah yeah they have a choice in fact if you want to go get grab the uh let me post it to you uh and actually here let me close this file first so now i just got the one okay cool closest server us west perfect perfect so i'm going to try close the server that should take me to virginia and then nathan was going i got northern california if you were going to deploy um and keys up in canada the closest data center to can't do they have a canadian
data center is it ohio the closest one to them uh they have a tour there's toronto oh okay i don't think there is a is there a western canada like a vancouver i can't recall yeah i don't i don't know but yeah there's obviously i mean for nathan it's a little far away for him um and there's obviously quite a few data regions around that you could use we only did i mean as it is about this is a thousand dollar demo for me folks so it's five servers and we've been running these badass servers for like a week so i'm in palm beach today jesse guess that got me to virginia yeah palm beach is i mean the scheme of things a hell of a lot closer there than california or ireland right or mumbai india mr scott yeah yeah okay so yeah kind of neat so you put a reddit and so we're watching so for those of you wondering about this so if you come
we're watching down here at the bottom so if you make an edit it will so as you write you should keep track of the edits here right so so so do some experiments connect to the server closest to you make some changes and within 10 or 20 seconds it should be on the other servers so try connecting to the other servers see if a first of all see if your changes are there and second of all see what the speed is like um you know if this uh if you're connecting to like if you're in the us and you connect to the sydney server for instance then you'll get a pretty good idea of why people in australia don't want to connect to a server in california because it's pretty awful and so that's the whole point of why we're doing all this right is because it's obviously much faster to talk to a filemaker server that is geographically closer to you and so by trying the different
servers in the different regions you'll get an idea of you know how significant that that performance difference is yep i'm seeing records pop up here got tom popping up in here i put a record in there don't forget to put a picture ron is there pacific blue uh ken tully is there awesome mickey mouse okay random person although uh let's see let's see mickey mouse images here created by jesse barnum was you you're mickey mouse apparently so yeah not a problem let me see i could put looks like we got a few people on our ireland server yeah cool well remember even if you're lurking here you feel free to come play it's there's no penalty or anything and you can come nobody's on our mumbai server yet so if you're in asia give it a shot yeah we might leave them i might come back on saturday and just invite people because sometimes the uh my middle eastern and indian people come in on the
weekends kind of weird but yeah we do have three people on the uh on the city server that's cool yeah yeah yeah i knew sydney would be australia there's a lot of people there uh lots of spinning wheel on sydney yeah it can because you're in albuquerque bro it's 200 mil listen it's like at least 200 milliseconds to sydney uh way slower right remember uh yeah well it's okay it should be slow right that's why listen that's why we put the servers in all the continents if you get the closest one it'll be kind of kind of quick and snappy and if you have to go way away then yeah it's going to be ugly i mean for ken the backup for people in the western us as the eastern u. s and vice versa right if you're in europe you were serious about europe you'd put one in ireland one in frankfurt germany so you could like switch between those areas right um there's sydney um there's
also japan about a third of all the filemaker users are in japan it's crazy and i have none none of them are customers with me because um they they i they don't like me or whatever the issue is or i'm too like japanese whatever works for that but yeah there's about a third of all the filemaker users worldwide in japan it's pretty interesting so and uh so it's it's this is a lot of fun for me going through and seeing people connect to these different servers at the same time seeing what's going on why don't we do an invite tonight what we'll do is we'll change the password then we control it but let's do an invite like everyone i'll send out a newsletter everyone saying hey it's like a big a big party it's quite crash the filemaker server right melting melting the enterprise right yeah i mean you got these you got these badass servers yeah i know yeah we need to try to so
we'll turn on webdirect tonight we'll do it more seriously um that would be great got some more records in here let's see who do we have now dave uh dave vac vac vacley's fact how do you feel let's pronounce his name v-a-k-l white the likes read his last name i just call him dave when i see him dave well the problem is that's dave three or number four here because so far i've got dave learning dave engel and this is dave okay so dave three uh there you go and then uh one record is blank and then scott kane is there the number one oh my gosh scott m dude is that you you're like a badass look at that photo that's amazing so yeah he's awesome so yeah pretty neat stuff going on questions folks questions questions well sydney is being used from new zealand yeah of course it should be right i would love to know the ping time from new zealand to uh
to sydney right i mean i don't even know i'm going to post a message that i just happen to see in the sync console and this is this is a feature and maybe somebody was intentionally testing this i'm not sure but it tried to update one of the records in the contacts table and it couldn't because that record was locked and that's that's exactly what we want to happen because this operation will be tried on the next thing so that mirrors noting that it needs to try that record again the next time it sinks so i just wanted to point that out i noticed that on the screen while it was running okay so michael gravel is in northern virginia he says sydney is very very slow right that's that's not that's just that's that's okay that's physics right so here stop so i want to make sure everyone understands this right i mean this is kind of like a fundamental here right so uh and michael i'm assuming you've
been around a while so you understand this but i mean so i'm going to bring up this this diagram here so where all these people are here right so the whole reason that we put the servers here is because going across the world here sucks filemaker has a specification of a minimum speed or a maximum slowness a maximum latency of 150 milliseconds between the united states and australia is frequently over 200. so filemaker's official recommendation is for australia users who are accessing american server don't do it and if you have an american user accessing an australian server don't do it they don't say don't do it but they said the the speed the minimum speed you need to have is 150 and i've been telling you because what uh one of you folks here has been doing it was aj or au or a n or nj or whatever it was i can't remember did great speed testing and we knew that it was consistently
like 210 too slow so you put the servers local local it gives you high speed access and they all stay synced up that's the whole point right we all get that yep cool so uh dave three says jesse uh is pretty close in the pronunciation so okay yeah yeah nj is a guy in australia who did the analysis force did a really great job and so we know concretely um yeah and so once again you're saying some people i got people in the united states trying all these other servers out they should all pretty much suck okay uh jake if you're on the call could you enable icmp traffic on the firewall because then we could do some ping tests and that would kind of you know get to what richard's talking about if jacob is that would be well we could do that tomorrow for sure if he's not here right yeah uh but we'll do some pink tests it'll be good but you're gonna see that
from the united states to australia it's just slow um and uh and then you know just go i mean from basically from over here from east to west on a good day it's about 70 milliseconds right so it's not kind of okay the east and west can be backups for each other but really if the american servers fail they're going to be hard up because then they're going to be probably shunted over to ireland i would guess um yeah so if you've got users in australia if you're in the united states and you have some users who might potentially be connecting from australia the crappy speed that you're seeing is the same as the crappy speed they're going to see to try to connect from australia to you and that's with the well-designed solution i mean nick has designed this to be really way inefficient this is a best-case scenario yeah if you have a system like most are done with really wide fat tables and
a bunch of unstored calcs and things like that it's going to be even far worse than what you're seeing here so this this is the reason to do this is to see what your users will see if they're connecting to your server from somewhere else yeah so what we'll do is we'll bring uh uh we'll do we'll get the ping testing ready for tomorrow so you can see that but yeah that's the whole point i mean if you have a multi-national corporation or if you want to use those words sounds awful lawyer lawyerly but if you have uh customers or users using the same filemaker solution in different continents you really need to look at the solution this will make them so much happier and you won't have people all the enterprise guys go around behind you the i. t guy is going foil motor sucks look how slow it is well it sucks and slow because you haven't rolled out really an enterprise grade solution right so
um comments coming in it took me 11 seconds to open sydney that's dave three says that and then four seconds the usc test west yes that's pretty quick average is 175 milliseconds from new zealand to australia really okay this okay back up the 75 is here in california you went to that um 75 147 133 is california if you're looking for the ip address in australia i don't have one for you right now that's not blocked behind a firewall we will release the um the firewall ping block what what port number is that you said or is it is it just a uh it's icmp and i i don't know the port number i usually just enable all icmp ports i think it might be 25 but i'm more positive yeah yeah yeah yeah yeah so uh so yeah so that's kind of how that works so this is how you start to see this uh mr scott says chris irving uses wire shock for f and
when performance benchmark and monitoring yeah i mean i've used listen so wireshark is good um you just have to kind of have a very controlled experience with it um because the way networks work and stuff like that you just can't put it on the network and measure because you can't collect other things on the network that are happening too when we do wireshark testing between servers and clients we actually we actually try to remove everything else um uh from that network and yeah and by the way mr scott i i i wanted to check with him before i mentioned this and i did uh he's at apple and uh he's been using uh nursing for i believe several years uh and has just recently bought uh server server licenses to start using this stuff that we're demoing now so wow so a real enterprise deployment well it'd be great if if and i'd love to do a short success story about that just you know i mean if
he's out here but the problem that apple hates doing that they don't like that kind of pr yeah but um yeah yeah yeah so new zealand to california was 170 uh 75 milliseconds which is about what they were getting from wherever uh nj was to california so uh it's it's in that it's over 150 and it's in that kind of area where it's going to start to stink uh mr scott i don't go ahead i was going to say i think the distance from new zealand to australia it's it's a long way i think it's like uh somebody's going to laugh at me from new zealand or australia because i'm going to get this wrong but i think it's probably not too dissimilar from like east coast to west coast of the united states you know it's a good long distance yeah it's a four-hour flight yeah mr scott says combining um combining mirrorsync with webdirect where the underlying solution is 100 theme smart data denormalization
short to hops no yeah i mean so that's uh so that's the whole point of the starting point enterprise right so um he's talking about creating a solution from scratch it's lean design i just posted a link for those of you who saw that a little bit ago um which is the uh the fm it's a it's our enterprise it's the version of starting point but it's all been lean designed there's uh almost no store stored calculation summaries it's all very very lean that's why this solution works so well for that it's about as fast as you can make it um i think generally the performance would be faster than web direct i guess mr scott and nick hunter are two the big web direct fans um so anyway that's how that goes but uh yeah pretty interesting uh yeah web direct only solution yeah well if you're building from scratch feel free obviously building a crm out and making it lean is a lot of
work i can tell you because that's why and how we built what we built yeah so this is we spent a lot of time talking about this um so the when you the reason this actually generally works is i mean the mirror sync is really good but you have to have a lean design database you can't get to uh you can't get to enterprise level class applications without that which means as you're building relationships the foundation of everything yeah you need to start off with good software design before you even start to think about the hardware yeah so scott's talking about having really flat table occurrence groups things like that that's what this is so this is uh basically it's a crm see how they're grouped like this if you do a big spider diagram and lots of craziness you're gonna your life will be very miserable and so um this enterprise version we actually found during uh we talked about this one day we
were doing a uh kind of a jesse was going through it and doing an audit and he found a couple non lean things in it and we went back and fixed them and so this the the version this version here the 20. 0. 1 has a couple other performance enhancements where we were unnecessarily shuffling the preferences record and one of the fields in the preferences record had several megabytes of text in it which was a mistake it needed to be in a different table and so because we were constantly banging away on the preferences record people were getting this update and then the update would include this two megabyte you know two makeup or two bytes of text or whatever it was there's a lot of characters in there it's a bunch of javascript so we optimized that so the idea is to keep this as fast as possible um nick is a big fan of web direct my biggest challenges with webdirect is that it
does seem to be flaky if you send it if you sent webdirect out to 100 people you're going to have 10 people come back and say it randomly just does crazy on their computer even if they're using the right browser and so because of that getting uh barbecued by customers like that i don't like to have that kind of failure rate and it's not just me you ask all the big consultancies they they stay away from it because they don't no one likes to get yelled at and i don't want to get yelled at so as a result we stay away from things that will get us yelled at i think web direct has its per uses in my case i would use it when pro and go won't go there but there are a handful of people who just will just use it just because they prefer that over other stuff which is fine so that's cool um so i've been keeping an eye on the sink as it's
been running and it looks like um at our peak at our busiest point in time i saw the sink take about 120 seconds so it's running every 10 seconds so if you do the math that means that pretty much every time you make a change in 130 seconds just over two minutes it will be in the other four servers around the world uh and so to kind of just summarize you know the benefits and what what's being accomplished here we're able to have a local copy of filemaker server running on five different servers around the world anybody around the world can use that dns latency feature to automatically connect to whichever one is going to be fastest for them have a low latency kind of uh not quite local network speed but you know a a fast wide area network speed to a you know a relatively close geographic server work on the data on their own server and then in the background within 20
minutes or 20 seconds to 120 seconds have all that distributed around the world to all of the people that they're collaborating with and then if any one of the servers goes down the combination of amazon's dns combined with mirrorsync will route that to another server and then when that server comes back up amazon will take care of restoring it to the condition that it was in and then amazon will take care of routing the traffic back to that so i think uh you know from an enterprise standpoint you know we're checking off two of the pretty big uh check boxes on the enterprise check mark which is reliability and scalability yep all right and uh you know those are i would say those are only those are up there with security you know those are the three kind of the holy trinity of its security reliability and scalability and um and so i think we're we're hitting two of the three and then this has
nothing to do with security so that's you know a whole separate conversation no absolutely um but uh but yeah this is i'm really happy with how how this demo is going i'm really glad that everybody participated it was really cool it was really cool seeing people hit it from like australia uh and and all over the world uh so i know richard you and i did a demo two years ago devcon on local clustering where we had two servers basically running on the same lan as each other and we were using that elastic load balancer and we used nursing to keep them in sync this is the first time i've personally gotten to see uh mirrorsync and all the years i've been working on it i've never actually gotten to see mirrorsync live with a bunch of users in all different countries and continents around the world and then mirrorsync running uh you know smoothly in the background keeping it all in sync so this has been
i think just as much fun for me to see it as it has been for me to present it and someone said i purchased mail mirrorsync this morning based on this week's demo it has been great jesse is so amazing um i love him i'm jealous of his wife um no it doesn't say that but people are buying by i'll hopefully copy you by the product because here's the thing i mean we have a bunch of lurkers here and the lurkers lurk we don't know who they are they they quietly sit in the background quietly in the background so we don't know who they are but you are here so feel free to cash in and get a good deal on the software or come to our fmtrain. tv and get a awesome bundle of training and that way we can pay the bills because my amazon bill this month is going to suck it's going to be my normal bill plus probably 1200 bucks just for the demo
for you folks so anyway um you're uh as we say in the business here we go you're worth it right um not sure ken is worth it uh hot air balloon guy he's a little sketchy him and tk i don't know about him but but honestly uh but uh no it's it's a lot of money that's why when people you let people know by the training if they already have filemaker and they don't need filemaker then just have them get this the video training it really helps this you know they get something out of it we get to email them keep them connected to the community and uh so that's it for now we'll catch y'all tomorrow check oh you bought a copy on monday what ken what did you buy a copy of mirror sink ken holy cow so we've had several purchases jessie awesome thank you ken yeah so jesse you're not you can you can have more than top ramen for dinner
tonight that's good thank you all right cool all right everyone i appreciate it we'll catch you tomorrow pl and we'll see you guys tomorrow invite your friends we want to break we want to melt we're going to okay the tomorrow's broadcast we're going to call it melting the enterprise all right cool thanks hey you realize we're still running the credits here right so everyone can hear us i'll talk to you later that's fine i just thought everyone want to know what's going on right so very cool all right cool all right this isn't enough and the guys just stepped up the whole way calm cool collected the quarterback great read good patience more importantly great job up front protecting this quarterback to give you a chance and that's all you can ask for trying to rally down 10. 9 25 short motion by amendola from the left brady takes the shotgun step stands and throws it left ramadan reaches up and snaps a high throw and lands inside the tent with an eye again he makes the ground
Daily Open Q&A with FileMaker Experts. Questions about Installation, Upgrading, Purchasing or How to make FileMaker work for you in your company to increase ROI.
Get up to speed with the FileMaker Video Training Course!
Top Rated Course by FileMaker Expert, Richard Carlton.
http://fmtraining.tv/fmpro19.php
Experience Richard's dynamic and exciting teaching format, while learning both basic, intermediate, and advanced FileMaker development skills. With 30 years of FileMaker experience and a long time speaker at FileMaker's Developer Conference, Richard will teach you all the ins and outs of building FileMaker Solutions.
The course is 60 hours of video content! Transform your business with the FileMaker Platform
Richard has been involved with the FileMaker platform since 1990 and has grown RCC into one of the largest top tier FileMaker consultancies worldwide.
Richard works closely with RCC's staff: a team of 30 FileMaker developers and supporting web designers. He has offices in California, Nevada, and Texas.
Richard has been a frequent speaker at the FileMaker Developers Conference on a variety of topics involving FileMaker for Startups and Entrepreneurs, and client-server integration.
Richard is the Product Manager for FM Starting Point, the popular and most downloaded free FileMaker CRM Starter Solution.
Looking for FM Starting Point free software download: http://www.fmstartingpoint.com
2122 9th St., Suite 102
Los Osos, CA 93402
(805) 946-6552
FileMaker Pro is a simply powerful software used to create custom apps that work seamlessly across iPad, iPhone, Windows, Mac, and the web
Free FileMaker Training Videos Channel https://www.youtube.com/user/FileMakerVideos
FileMaker 19 Video Training Course Introduction-FileMaker 19 News-Learn FileMaker From The Experts
FileMaker 19 New Release - Top 10 Need To Know Items in FileMaker 19 - FileMaker Top Ten News
https://youtube.com/watch?v=kRDXfpMrjvM
FileMaker Purchasing Options-FileMaker Training-Best Way To Purchase FileMaker 19-FileMaker 19 Video
https://www.youtube.com/watch?v=LlZqf_8N1Ho
https://www.youtube.com/watch?v=LlZqf_8N1Hou0026list=PLjTvUZtwtgBTCbN3Sr7yn6weIyIofDoMLu0026index=3
A database management system (DBMS) is a computer software application that interacts with the user, other applications, and the database itself to capture and analyze data
Video introduction to iOS App Training https://www.youtube.com/watch?v=cVxQe_yAshw
Free FileMaker videos check out ...http://www.filemakervideos.com
Download the FileMaker Pro and FileMaker GO for mobile devices training videos at http://www.fmtraining.tv
Download FileMaker Go video training at https://fmtraining.tv/fmgo19.php
Download FileMaker Full Video Training Bundle at https://fmtraining.tv/subscription.php
Learn how to use FileMaker to create an app with the FileMaker Training Series
Comment, Like and Share All of Our Videos.
Feel Free to Embed any of Our Videos on Your Blog or Website.
Follow Us on Your Favorite Social Media
https://www.facebook.com/FileMakerVideos
https://twitter.com/filemakervideos
Join us for live training on Twitch daily at 1pm Pacific
https://www.twitch.tv/fmtraining
https://www.youtube.com/user/FileMakerVideos
https://www.filemakervideos.com/
https://fmstartingpoint.com/downloadform3.php
Download FM Starting Point
https://filemakerfree.com/signup.html
FileMaker 17 manual For Novises kindle
https://rcconsulting.com/courses.html
https://www.guidetofilemaker.com/
Blogger sites
https://fmtrainingtv.blogspot.com/
WordPress sites