What's up, everyone? Tate down here. Welcome back to another video. Today, we're gonna be talking about the games that I wish I had as a kid. Now, not only are we gonna be talking about games that came out back when I was a kid, that I never got a chance to play, but also some current modern-day games that I wish I had back when I was a kid, because I would have absolutely loved them. Let's get right into this video. So what first is my favorite game on the PlayStation 4, and that is Spider-Man. I absolutely love this game. You guys know that I talk about Marvel all the time. I love anything Marvel. I love Spider-Man, and this game was amazing. I remember playing back on the PlayStation 1 or maybe even PC, a Spider-Man game, and the mechanics were okay back then, but they really upgraded with the modern technology of video games, the gameplay of the Spider-Man game. The mechanics of just something simple like web-slinging was amazing and so on point and something that I actually haven't seen in a video game in forever, and I absolutely love that. The combat aspect of the game was also amazing with the different gadgets that you can unlock through with the game for Spider-Man. It was a lot of fun, and the story itself was so in-depth. I absolutely love the story of Spider-Man, and it is an easy platinum. I think I earned the platinum within two weeks, but that's because I dove into the game and I just started playing the game and only that game, because I loved it so much. So I put all my other games on hold and only started to play this game. This game was amazing, and it's something that's when I was a kid, if this game came out, it wouldn't be too challenging to be able to pick up the mechanics and still would have been a lot of fun, but this game is definitely the top game that I wish when I was a kid I got to play, but I'm so glad I got to play it now, and it only came out a couple years back. The next game is another modern-day game, and that is Horizon Zero Dawn. I think that the whole story aspect of this game that you're basically... It's kind of like the past where it's all bow and arrow, but it's with machines and they're the enemies, and of course humans as well, but that whole aspect of bow and arrow, along with the machines as being the monsters and the animals among the worlds, I think that whole aspect is very amazing, and I think if I was a kid playing this game, it would have been a lot of fun and it would have blown my mind. Now, I absolutely love this game. I'm not... I don't even think I'm halfway through the game, but this game is so, so fun that I wish that it came out when I was a kid, so I could have experienced it when I was younger as well. And this game is a lot of fun. If you haven't played it, I absolutely recommend it because it is one of the games that the story is on point, the gameplay is on point. Everything about this game is amazing. The next game is a game that did come out back in, I think, 2005 on the PlayStation 2 and other consoles, but back then it is a game that I missed out on. However, they did remake it back in 2020 and that's whenever I played this game for the first time and I absolutely fell in love with it. That is destroy all humans. I absolutely love this game. It's a lot of fun and a lot of fun just to go and basically deck around with.  It's a lot of fun, just all the destruction with the spaceship, all of your probing and all the weapons that you have. It is a crazy, funny game and I think the time period is back in the 50s or 60s according to all the vehicles and everything or maybe even earlier, but the concept of the game is amazing and I love the story. I love the missions. Now, of course, the version that I played was the remastered version for the PlayStation 4 which came out in 2020. Now that game has, like it said, it's remastered so the graphics are a lot better. A lot of things are more improved. Now the remastered version, you can go into the files and you can see images of what the original version looks like compared to the new version for things like vehicles, your alien, different buildings. So you get a comparison of what it looks like before and after it was remastered, which was a lot of fun, but I think even the original version, I think I would have had a lot of fun playing it back when I was a kid if I would have had the chance to play it back on the PS2 because I absolutely loved it and at least they remastered it and I got to play this game at this stage in my life. The next game is a game that I must say is not for everybody and that is a simulator game, car mechanic simulator. Now, I'm a huge car guy. I love vehicles and I love car games because you can go and customize your cars and different things like that but this takes a real life aspect to it where you can totally go and strip a vehicle and rebuild it from scratch which was something that if this game was out back when I was a kid I would have loved to play it because I always had, when I was younger, I always went and took things apart. I always went and basically took things apart and tried to see if I could put them back together so this game would be right up my alley back when I was a kid and of course back then even I loved vehicles, I loved cars and I think it would be something fun that I would have loved to play when I was a kid. Now, this game here, it's a little bit grindy to go and get the platinum and I did get the platinum on the PS4 maybe a couple months back but back when I was a kid I would have likely only played this game to just go and have fun and play cars and basically build vehicles from scratch and that whole aspect to it not really trophy hunts but more of just having fun on a game and this game is definitely doable for that and the last game we're going to be talking about is a game that I did miss back when I was a kid I think it came out around 2005 as well I might be completely wrong with that but it did get remastered for the PS4 as well back in 2020 and that game is Spongebob Battle for Bikini Bottom Rehydrated Now this game here, Spongebob was a huge part of my childhood I absolutely loved the show and I do remember playing a few video games of Spongebob but this game in particular I know I never got a chance to play whenever it got remastered it was on my radar and for Black Friday it became 50% off which is why I decided to purchase this game to kind of relive part of my childhood that I missed and this game was amazing you basically go through Bikini Bottom and doing different missions and everything and it's something that you can easily get trophies for and it's a platinum that I'm able to eventually get but I purchased this game mainly for part of my childhood because I loved Spongebob growing up never got a chance to play this game and I wanted to now after playing the remastered version of course the graphics are more enhanced but I think this game would have been a lot of fun playing it back in the day when it was released on the PS2 and I kind of wish I had the chance to play it back then but I'm glad I got the chance to play it now so these are the games that I wish I had played when I was a kid like I said some of these games are modern games that I just simply wish came out back when I was a kid so I could have enjoyed them back then but some are just simply ones that I missed back when I was a kid and luckily they were remastered later down the line and I'm so thankful I had the opportunity to play them as a remastered version so comment down below what are some games that you wish you had as a kid and I'll see you guys in the next video please take care peace


In this study, the MCM-48 mesoporous material was used as an active adsorbent for the removal of four-nitroaniline for nitrobenzene amine from wastewater. Characterisation of the material included SEM, EDAX, XRD, BET, PSD, and FDIR. The material was tested in batch experiments using different concentrations of four-nitroaniline and the results indicated that the material had a high affinity for the compound. The Langmuir isotherm best described the adsorption data with a maximum uptake of 90mg per G. The kinetic data supported the pseudo-second-order model indicating that the adsorption process was chemical in nature. Overall, these results suggest that MCM-48 can be used as an effective adsorbent for the removal of four-nitroaniline from wastewater. This article was authored by Nisrin S. Ali, Hamden Hahera, Isom K. Saleh, and others.


you know uh spencer heard the atl michael thing first one tonight again on the buyback scherzer yellow it's let's go stride game just at the over let's go stride easy all right we've got a shea langlears eggy risario blue oscar colos to 150 on the rookie nice one there paul gulchman and josh young rookie you got 10 specter more from about 20 dollar and bonus bed on i know sweat now i gotta sweat steward on alvarez technicolor felton bar show and your don and one box museum i think somebody will in that goll turn around i don't want to that's gonna be a sweat if you pick somebody who's good in sunday yeah that's gonna be an actual sweat all right probably scottie's chapter because he's nasty but there you go it's always a it's always a good bet it's a couple beaches we get that's right it is always nice rap 80 to 50 always a nice course we're getting close to masters now pates and shea langlears 275 game used jersey redemption come on let's see it see a big name that's riley green on the canvas collection right i agree a single player signature swatches triple relic autograph of james outman nice one there congrats of the dodgers good bet vaughn yeah look at you vaughn block of the night she let me in five hundred fifty what uh yeah that ain't happening i'm out of here scottie sheffler wins this weekend we could probably work something out jerry panya my sweat furgy jankins the 299 on the auto on car nice one there at jeremy congrats buddy come on there we go give me five hundred dollars i don't know this guy thinks he is let's come on scottie let's go scottie got colas the 299 on the yellow or gold regman and spencer steer rookie jersey at 28 of 35 for the reds congrats on that one there jeremy that will do it for your break buddy thanks as always for the support and get them right out to my man i think we've got a chance on i think the least or the smallest odds are like minus eight or plus 800 to win so i think anybody right true some cash just gonna get the right one come on scottie courageous punch cork moss did he really no okay thanks that would be the best fight ever dude yeah that'd be wild very very strong on cork parking cork moss no reason at all that's mr jeremy beat courageous armbar jaden springer what is going on unreal unreal good luck as always mr jeremy be let's do buddy going on everyone sam here with latent sports cards from five boxes of at 23 bowman's best university football delight for jeremy beat it's good luck here jeremy let's do it buddy that is going to be the uh rolling through the sec signs of the times for alabama and a gold jacquory brooks also for bama to 50 god refractor and tony will be screen do 99 tyler van dyke ready go wisconsin mm-hmm gold lava a j swan to 50 uh steven you are next to 150 jordan travis you are next buddy to 10 blake shaping nice one there congrats on that dude let's go five and ten the nittany lion collector with the drew alar nick singleton do a lot of come on jeremy let's go baby jeremy's got some lines from this absolutely that's nasty jeremy hell yeah man your voice that is going to the right home man we are let's go that's awesome congrats jeremy hell yeah man yeah i'm a kai lemon at 25 on the orange for usc that was good man and then refractor rato kendall milton for georgia we need that super for you jeremy we need that dual super i know how filling colors one year at the bout of league yeah right studious stars tyler bukner and green jerry and dickie to 15 or aqua whatever you want to call it uh grand mirts that is to 99 grand mirts to 150 jalen daniels 75 lake shaping to 100 is koolaid makinshree got marshawn loyte of 50 on the gold for usc a refractor riley lennard for duke and then elements of the game to 75 michael pennick's nice one there congrats buddy go jeremy three to go gold studious stars quinshaw judkins 250 and orange nico is it i'm a levo i'm a levo something like that yeah around there for tennessee on the color match have you ever seen a place for roger's fair it's a 99 kilo williams three mini diamonds yellow to 75 jerry and dickie got pink lava jordan travis for florida state remini imus 99 odric estimate we've got gold jadenott 13 of 50 for cowl on the auto uh refractor olufashado for your boys penn state and then orange wow travis hunter-schedure sanders two duels let's go man that's clean too true orange hunter and schedure on the duel that's nasty man so sick congrats on that one there uh mr jeremy three boxes two duels thank you kazuto picking up some spots for tomorrow or thursday it might be for thursday o' tile the short print here kade clubnick and chris vezina next one here is going to be a gold drake may 32 of 50 umc got drew aller refractor three mini diamonds the 99 quichot judkins gold to 50 cooper legas that is a uh blue mason smith to 150 got zavier worthy to 100 and nick singleton another one of your boys let's go repent state autos so far love it that is god dude a triple this time eight of ten drake may jordan travis kade club nick who knows damn those are all all acc guys that's awesome let's go jeremy another one dude multi third multi auto in the brink in four boxes it's incredible dude eight of ten and then quinshawn judkins prospect jersey auto congrats on that one for uh old miss now you uh oh how state uh thank you kazuto with some more spots appreciate you buddy your separate orders for kazuto elements of the game cam rising to 25 that is a gold julian Fleming to 50 uh tyler van dyke pares jones to 25 gold to 50 will rogers you got nine left total blue to 150 nick singleton this yeah and to 100 bow nicks 15 in on sunday that was all we got man ruben owens eight of 15 for annum that is a autrogust may refractor auto Notre Dame and jj mccarthy for michigan that will do it for your break there mr jeremy thanks is always for the sport my friend awesome break get him around to where you said that was awesome dude that was really awesome that was sweet jason w within art of sport spot yeah that was a good that was a good break man that was a very good break was that 2023 right yeah for steven steven you're up buddy yeah we'll get to it tim yeah i got you we'll do it tonight for sure tim still a little bit of a cue but yeah we got you 45 minutes or so less than an hour i would say for sure good luck here mr uh steven let's go steven good luck sir who are you looking for in this steven we can make it happen that'd be dope and that'd be dope that would be dope steven i'd be in on that good luck on everyone sam here with late in sports guards doing not doing the random we're ripping two boxes of 23 leaf art of sport solo edition for uh steven oh it's good luck here steven art of sport solo edition fancy box for this man i got to get it to rip away pack it's like an all mac uh we're starting off with a jammer and auto five of five hell yeah that's pretty sweet we'll take that all day steven we'll be coming back soon and next one here too steven really got crazy luck this year man i know dude lost everybody once clark coming back he's been out for like ever it seems like yeah i don't know yeah for the rest of the season he is another auto is going to be doc gooden uh nice one there that is going to be number one of two so two super low numbered autos right there doc gooden thank you legend his number got retired by the meds actually that'll do it for your break there steven thanks again for the support as always buddy get him right out to my man that's dope that's dope yeah not bad honestly not bad at all steven uh give me one sec everybody i'll be right back to grab some water publish one sec tnt does like those celtics on they do like to show the celtics celtics lakers on thursday all right well the machine next thomas peter you're up next by the way buddy mr and miss smith show really what's a big fan of the movie brah brah pit i did grab him too peter let's go yes he did yes he did per request he did all right good luck going on everyone sam here with late sports garage i've been two boxes of 23 top scrim baseball logo for actor edition four at thomas h so good luck here thomas see some logo for actor luck q and lb or loyal america wow luck here thomas michael harris rookie torque and gorman etl michael mm-hmm peter what order do you want uh me to do them into do you want the football first or last on soto logo for actor pass now let's see it you got an orange and a green so lennon so sir rookie green brice harper to 99 orange bobby wit 22 25 not bad tim anderson and adley ruchman football first i got you maddison tell marty as you kill two of our rookie mike trout and rip baby root all right i'll do for box one see box two here it's always up almost 40 i'm the most exciting game shocker a little marimelle act tonight is the night that the zags go down i got down five times this year so damn that's not good that was crazy where they ring nothing no wow unranked rara and bobby wit that's surprising true very true all right i got a blue and a uh green that's aswaldo cabrera blue hoze l2 beta 150 with the space city got green corbin burns to 99 for the uh brewers uh jordan grossians rookie and mookie bets second logo for actor pack got a purple in it mark viento skirt michael as a purple von grissom to 250 nice one there for the uh braves now a red sock michael toglia and a kade cavalli pretty solid uh definitely solid second box there that'll do for your break uh thomas thanks again for the support buddy get him out to my man shoney with a good one spot thank you buddy why are you ripping good one actually take are you is that you think it's Thursday i'd imagine peter black with 32 for market so this is done coming up after this and we're going to collect some more boxes the last batch of them by the andrew with a bowman chrome hobby university mitral with an absolute an absolute prism and then two star wars black and then an absolute definitive and then two prisms all right good luck here pete going on everyone sam here with late sports cards written three boxes for peter a got uh one 23 bowman's best university football delight and two 23 24 bowman university chrome basketball delights so good luck here pete let's do it buddy uh no it's actually a different different uh it's actually a different thomas thomas j um ripping the definitive tonight see something crazy out of this that is a marshawn loyd orange is dante more to 25 all right we've got brady cook green to 99 draughty beyond sanders how to say yellow jj mccarthy to 75 pink lava to 100 travis hunter got green to 99 antonio gauge jr orange auto robbie ashford 17 and 25 for auburn kind of a color match second color match age cori brooks refractor on the auto for alabama and drew aller 1 to 75 elements of the game grads on that pete not too shabby there and going back to penn state run it back to bowman chrome university delights now all right starting off with rob dillingham 299 purple tyler burton 2 uh 399 to 299 shan stewart for duke purple to 399 amando baycott and then green to 99 zayad laury for marquette got armando baycott first refractor bob miller first refractor jackson shellstatt we've got a isaac hollier ice one there too at 150 for usc and the o7 throwback mark sears first base auto alabama got throwback dusty stromer 299 for gonzaga it's the guy on tv i'm about to say you got gonzaga on right now and then a base auto simian wilcher for st john's not bad there either all right pete see another one come on you see the brawny lebron right here a dual superfractor on i'm not gonna be right now man a dusty stromer one 99 el marco jackson 2 399 to 299 taren shannon 399 isaac mcnealy and then dishaun harris smith to 299 got prince of ligbet first refractor georgia amore first refractor first refractor kevin mccollar then big kahuna stefan castle for the yukon huskies love it now roll skis all day ryan caulkbrenner for kraton first base auto green laden blocker for arkansas nice one there as well got a first base auto or not first but base auto of kaleb love not bad there either transfer from what he was trying to unc right and then cormac ryan true gold 3450 first auto for unc as well so two extra autos in those two boxes which very nice the game went in the night that one here because he did that's that's right that will do it for your break there mr peter thanks as always to the sport buddy get him right out to my man that's box that picked for you peter yeah sorry about that pete i mean not not terrible either but i get stuff that's true you're a tar heels guy right yeah no no problem pete thank you buddy of course i love transfer i felt like he was yeah i know it's weird it must have been some like young guy coming in or something yeah rj davis i guess the point yeah yeah good call the colex just everybody so you really let's go we're savage man what a savage for him it's a john coming up with a horn and horn for john 30 jobs or something no good luck here john let's do it buddy going on everyone say i'm here with late in sports cards we've been two about our one box of 22 23 penini one in one basketball for john z so good luck here john let's see it buddy 22 23 one let's see a downtown or a timeless might be might looks like yeah yeah oh yeah that is mccall bridge yeah 94 99 timeless moment is manu jnobly lefty yes sir 25 at 25 nice one there john congrats buddy yeah 2012 uh western conference finals haven't that bat the other name was funny i know like come on manu get out there it's weird that that happened twice yeah i think it happens a lot because they have the they have the mascot already has like the batman suit in there yeah true and he's always got the true manu jnobly must be a lot of bats around yes so congrats on that one uh john that was pretty awesome get that right out to you buddy j martin i think they lost the heat it is right 2012 or they even it was at the end of thunder um lost the heat but they didn't win it that year they won it when like four they went to why it was there like why i was older yeah i think it was all right gotta collect some personals here maybe sorry that's been a three must have been a three okay whoops that's all right we put them back all right be right back everybody yeah one of two bailey zappy nike swoosh rpa book damn kevin h with the afc east pretty good timing he's got the start this weekend but next up one of three laundry tag rookie auto james cook one spot kevin h rookie dual relic two of five brock purdy is that a glove what is going on here i think it's a helmet sticker and a glove of some sort look at the patch on this thing that is for the rams erin donnell or erin donnell cooper cup and matt stafford look at the the ramp patch oh my gosh three of five congrats on that one there rams that's so cool man wow it's a heartbreak let me talk about this card real quick that's a heartbreaker dude let me talk about this card one of one nfl shield auto chris godwin what for the box my boy hell yeah man every sunday yes sir alex h let's go dude hell yeah man that is disgusting so sick i sick precision c d lamb rpa numbered six of only 10 oh baby that guy's on fire right now too that team is on fire and oh look at that 19 of 39 patch auto arch manning that is something right there that's a monster for you jeremy big congrats that's one reason to buy the full case i guess arch manning patch auto 19 of 39 look at that man one of one anthony richardson booklet laundry tag congrats on that jordan that is a freaking monster jordan good stop jordan oh my god dude oh my gosh what a banger absolute banger rookie nfl shield rpa khalil Shakir afce's ryan n let's go true rpa shield that's gross one of my favorite parallels it is cj strav black and order 25 let's go oh holy cow let's go that's not what i was expecting let's go we will mag that for the texans that is just in c this thing is nice one of five lugo patch star swatch signatures jalen hurts he is him jersey numbered as well what a monster for ronal ar i think he is him i think he's he had a rough start yesterday turn it around fast in the second half that is nasty man what a patch good receivers team tandems whoa payton manning and jeff saturday whoa hell yeah man let's go that's sick oh that's so freaking awesome on the dual auto going to david w in the cults whoa holy crap man blake shaping super factor let's go all right everybody god man andrew coming up next all right mr andrew let's do it buddy going on everyone sam here with latent sports cards we're in one box of 23 24 bowman university chrome basketball hobby for andrew p it's good luck here andrew let's do it buddy see what's in this uh dj Wagner on the insert like certain castle sharpshooters oh yeah uh henna hidalgo to 299 that's one there for north chudain boogie ellis orange isaac collier i swung there uh andrew true orange isaac collier number to 25 that's awesome that will work just fine congrats buddy so awesome erin bratchel everybody's got undecided majors man these guys are yeah shocking to focus angelory spiritual factor major in basketball bro it's cartel john so when it was said graduate it said undecided he was like how does that even confuse mandel they caught what what class is where he's quote unquote taking uh el marco jacks to graduate what you guys have been undecided major zaden hi to 299 and a j ho guard go wane picking up a couple of spots tomorrow mr wane p let's go wane steven with a braves spots in a stadium club tomorrow as well thank you as well green auto armando baycott to 99 it's pretty good box actually two pretty good names congrats on that one there number one sold out no seven to go and i met number one or yes wait i think goona cody williams shorter printed card number one is nine first refractor j j number two is eight still left and that's bulls cab business bellies magic flavors okay jared mccain l ellis extractor mckenzie and bako cook blue brawny james to 199 damn dude pretty solid and scottie middleton blue wave camera and brink that's sags go 199 extractor tyson chatman vance taylor we locked himself out of the house yesterday this whole mess he uh went on a walk with hono accidentally he didn't bring his key because he was gonna go in through the garage and then he accidentally locked the garage door so ah i'm gonna do it he was locked out when be rookie midnight nice your desire then i'll maybe i guys ridiculously camera and brink purple shimmer oh yeah erin bradshaw to 399 camera has the same thing a couple weeks ago but it was at three o'clock in the morning that he woke me up to wake him get him in first extractor camera and brink what was he doing he started at uh our tall boy d is uh roddy james big kahuna auto haley van lith the 150 three autos now an extra auto there where you start he started our buddies an engagement party and then i don't know where he did that 3 a.m he comes knocking on the door i was like come on man first refractor justin edwards and base out of rj jones that'll do for your break there uh andrew pretty solid overall my man get him right out to buddy i'm a defensive you like him it's probably not something that would like go infested anything yeah but if you like jobs yeah why not see k-rats knocking the door and go my man the roofers are coming in three hours dude all kinds of problems all kinds of battles going on over there oh man according to 4206 von let me know about oh yeah city ordinance code 4206 are coming at 7 a.m every time they'll be there sharp watching their phones waiting to start at 7 a.m uh mitchell with an absolute yeah they're probably out there before that's when the compressors take oh yeah all right good luck here mitchell good luck buddy here we go not everyone sam here with late in sports car there's been one box of 23 panini absolute football hobby for mitchell l it's good luck mitchell come on i'll see you kaboom mitchell why not see kaboom something big here we got to get rid of these clear packs man the same retail bro going to be open yeah davis mills and christian kirk it's an orange 275 breeze honk your redemption jalen carter uh rookie premier material autos quad nice one there he's an eagle great rookie for the eagles potential rookie of the year and then tj walk tools of the trade 84 out of 249 got draft diamonds to 100 keenan allen and base of naji a rookie of miles murphy to 275 looks like a gold brock purdy nine of 10 that'll work great timing on that one there uh mitchell congrats buddy second year purdy auto to 10 yeah that is not bad man on the gold stars that'll play for sure and then a monron jerk off to 199 with lions that's a uh nice purdy for sure great timing on that yeah that is working right there for sure man that is working stars are good right there in jones and a kirk cousins you can play ball oh yeah big time to uh 16 is james cook you know what this parallel is called it that's what kind of what it looks like they're like no not marvel uh the human joystick 10 of 50 dante hall signature standouts for the chiefs nice one there k c and late in tune to 199 war room materials jersey card rookie jersey that will do if you break their mitchell not bad man get him right out to your buddy thanks as always rpcs big purdy fan on sunday big purdy fan on sunday yeah no problem thank you mitchell that's what i thought rpc was a big purdy guy yeah huge purdy guy huge niners guy huge nine he's just a bit just a fan of the nfc in general i would say especially this upcoming not this sunday but yep next sunday good choice rpc got two rings on the finger those are 700 i believe 710 i think now 710 710 on those yeah uh kyle kyle coming up with a prism in an absolute what's up meep good luck here kyle going on everyone say i'm here with late in sports cards from two boxes for kyle c we got one at 23 absolute football hobby and one 23 prism football hobby so start with your absolute good luck here buddy victor then thomas then adam that's it in q right now i think that's going to take us all the way to the end but got draft diamonds to 100 alvin kamara swift and base j caner to 275 and devon a chain rookie uh premier material autos quad nice one there for the bins rats kyle jersey and that uh base of remandre and stefan digs got brenton strange to 75 for the jags a rishi rice nice one there to 100 35 of 100 color match red uh for the chiefs and then a can absolutes of frankor says heiners rushing yards in college we're a minus 123 yards for two touchdowns gotta be a type you gotta be a type there's no way minus 123 yards in two touchdowns that'd be insane what it's second day geez dude okay yeah there's so this is a weird weird box man base and base uh gardener min-shoe to 75 nice one there we've got a dual tony pollard and cd lamb to 99 team tandem and nice 41 to 99 three-color patch of cj shroud and grats on that one that's awesome dude spencer versus rpc is kind of like a boss fight i know kind of dig it it's uh it's something man something let's see something big out of here kyle like how they just thumbs down each other each time yeah do you imagine if it was chief's lions dude yeah i would be a war for two weeks that would be a war for the end of time because whoever won would not let the other one ear but like the end of it the unbelievable guy uh forest camo coming out here to be a silver davante adams forest camo michael wilson rookie to 15 uh 12 to 15 nice one there benet and very silver alan lasard that is nice for she writes to 100 on the auto that's nasty whoever she writes autos not bad it's a 149 prism auto color match of a guy in the super bowl you rpc wilson and zack evans there's some chiefs for you there we go cue the thumbs up from rpc i don't know keth walker drake london to 99 charlie jones and j can't subject to that you know who's that subject to that you know oh the one yeah i'm in the state uh red wave minka to 149 witherspoon and anton harrison pc won the world series rookie year yeah god man way back when what oh one jsn prism break to 199 and to on a wind field for the bucks bishon and tyree wilson i want one reason they were there they lost though marcus alan they won't to uh one two no 249 is erin jones on the orange from your gib's rookie and darryl silver perris johnson rookie orange to 249 chris godwin bucks seder tillman and a dealing right tim with the spurs in number seven tomorrow appreciates you buddy silver logan wilson hyper to 175 travis etn jr juju brentz and perris johnson orange wave michael wilson again to 60 going for the rainbow foskey and jack kim wilson i was on the other day reshmatic erin rogers hands of it probably silvery eye adiabi rookie ought to talk here and miles murphy there's also a lot of talking for like an hour of that a true it's kind of weird silver will anderson 225 davante smith eric gray and kj henry red wave to 149 tomorrow hamlin got keanu benton and josh downs ricky that'll do it for your break of their uh kyle thanks again for the sport is always buddy do appreciate it get it right out to you my friend i have to miss their victor star was black good luck here victor going on everyone sam here at latin sports car there's been two boxes of 23 tops star wars chrome black hobby for victor r let's good luck here buddy star wars chrome black box one base window to 199 ala sakira and a highlight our fantastic fights of rey and kylo ren an auto is father of the mandalorian 42 of 50 on the gold that is bernard bullen father of the mandalorian nice one there and then we've got box bus green to 99 babu frick 75 is neon nub and blaze malice on the base and then auto is moth uh gergerid uh is michael pennington is moth jarger uh gergerod gergerid very nice that will do it for your break there mr victor thanks again for the sport buddy get right out to my man donny b crumb and a rpc love the donny uh donny b crumb laugh it's a good one donny b the b stands for bot all right i got thomas j coming up now good luck at thomas going on everyone sam here with latin sports cars have been uh two boxes for thomas j got 123 absolute football 123 definitive baseball so good luck here buddy see something nuts out of one of these go thomas store the absolute got adam up next after this and that's it right now jettos and a manra got jail and waddle to 100 for the uh dolphins rookie auto pookin akua nice here we go to 199 that'll work the rams very cool and then pacheco and kelsey to 199 dual jerseys team tandem for the chiefs i feel like pacheco could play like detackle how you not wrong bro it's a ridiculous henry and russa wilson very true got orange joe mixon 275 color match for the vangals uh jaden reed is rookie jersey auto 220 out of 399 for the packers rookie premier and then tray talker uh three of 99 rookie jersey for the raiders david montgomery and kenneth walker i've also got a draft diamonds of debo to 100 ryan tanahill to 100 on the red and then auto of ken tray miller rookie premier materials autos quad for the saints nice one there so yeah no jersey in that one sorry about that thomas it is on average unfortunately with this annoying uh but let's do your definitive now but thomas come on what's up jt jt what's up buddy chillin well man how you doing today jt you dervish 5 of 30 on the game use jersey congrats on that one there this is dope three of 15 david orteez a little big poppy action there record game use patch also very cool uh very obviously game used 18 of 25 is kyle tucker dirty i have some dirt on that that's always awesome helping daughter with homework oh boy oh gosh say sounds tough uh many paths can see now 34 50 rookie auto for the royals the pass watch the subjects who working on jt it's not math yeah god the math 24 of 40 is roger clements game use jersey auto for the red sox red sox roger clem dog we've got nice trish and cossus that is rpa 8 of 50 congrats on that one there at thomas that's awesome man 8 of 50 cossas with city connect jersey art of this program really space yeah this is nasty man four of 10 ronabakunya jr that is really sick game used patch auto gold frame purple that's just awesome mvp congrats on that buddy and then triple 8 of 10 at pete lanzo keith hernandez and david right there he is that is awesome man there he is there he is of course so it's you and the guy you always pull and david right yeah congrats on that one there that's awesome i'm in that's gonna do it for your break there at thomas thanks again for the support is always buddy get right out to my man thank you sufan with spots in tiered tomorrow tiad random teams of iMac good release days tomorrow guys yeah man 10 i'm sorry uh 10 20 i believe we started out yeah for some icons that's weird yeah strange 10 20 start tomorrow guys i'm an icon yeah it's really sick let's throw back jerseys oh yeah i love when they use the the alternates or the city connects and stuff and i can't wait to see more of them in upcoming products which one yeah the triple that's dope and nice here's the shorts nice daughter oh yeah love it all right adam two zims for adam yeah this is the last one in queue if no more orders come in we'll call it a night but uh still a room for a couple like small ones yeah absolutely tim no problem at all no problem at all thanks for waiting got two leaf art of uh sport yeah our sport solo is back here if anybody wants them two leaf arts yeah forest we'll be breaking some iMac in the morning i'll be breaking some at night and we'll be doing icons on fanatics live and kyle have personals on channel two tomorrow so good luck going on everyone sam here with late sports guards there's been three uh two boxes of 23 putting any prism football hobby for adam h so good luck adam see you adam good luck buddy so i'm probably waiting for when i get here probably blue wave dj turner to 199 oh it is true mind we do have a true goal come out come on come on adam the chief it is a luxurious need that is a traumatizing man that is legitimately traumatizing great punch awesome card though two of ten i think the beast he's really good luxurious need very nice and tony harrison and bijan wow that is like yeah that's not a good time flashbacks man the punch the punch actually pull his black shimmer yeah he did that's right we're getting a lot of sneakies man silver jsn we've got a courtland Sutton to 225 to 225 eight of 225 it's like tillman tyree wilson yeah i max freaking awesome dude i'm pumped rips my max tomorrow survive other times orange tank delt to 249 that'll work i wake up by 1025 okay what's up i probably got by 1025 maybe that's why let's call that call the roofer wait a little uh don't let me start on the roofers to uh 225 i will say they did a good job chew chew bohub or 225 it looks great they just suck timing was not ideal no silver jsn green scope keenan allen is 75 that is a jalen hyatt and immanuel wilson picture tennings see all of the roof looks yeah dany dimes the 125 chariot sneed congrats again adam zack ebbons charlie jones punch of destiny it was the punch of death punch of death we got our first auto here silver is alex singleton dishawn jackson to 99 blue ice for the eagles see what's in isaac foskey three picks last year for 57 yards i don't know what to put that on there these are my pc hockey players guy that i know is gonna end up giving back to the player as a birthday gift that's not bad actually debon who is your who is it if you don't mind me asking burrow uh the 175 jalen hurts hainer and merrigan yeah we go with new jen hopkins so by max crossby okay cool cool cool so 149 is critter samuel hamble and keanu benton looking mercer silver of mac jones i remember you saying that yeah there is davis rookie uh silver auto just going to her for the chargers their call and juju brentz i don't think i went ice with any hockey players around here now now i can't imagine for sure silver hype rock party that is dk meccaf to 199 although i do know ryan carpenter's brother he was on the josh downs and michael wilson he was on the nights for a while but he was up at boarding school and his brother wasn't he lived here i don't think he ever went to school here he was always up in boarding school for hockey yeah that's not that's like yeah it's all boarding schools man yeah that's like canada kit like the two big ones are both boarding school for hockey everybody went there if you're any good got trained by two that's kind of wild actually it's kind of crazy one of the provinces the lands five people uh damata yadams dak prescott to 49 on the purple power right in z t silver joe burrow on the throwback uh jaylon thompson to 60 orange wave god gonzalez and zack sharpening silver of nick chubb that is going to be bernie cosar to 149 franchise legends auto mims and there is this without wanting to cry uh it's nice doesn't matter purple power to 49 a miles murphy to 175 on the hyper rishi rice for rookie and dalton concaid rookie as an orange wave tyreek stevens into 60 dorian williams and jaren hall holland to 199 christian mccafrey iven pace jr and duce vaughn silver will mcdonald rookie orange to 249 is christ jones the chiefs jordan adison rookie and mazzi smith silver david bactari red wave kyler murray to 149 luke schoonmaker and nolyn smith silver jaylon herzall purpose to 175 matt stafford for the rams tanner mckay and dylan horton see it see something crazy here purple ice coming up joss jacob's that is gardener minchew purple ice to 225 shroud rookie and ty jay spears silver curtain samuel to 225 doran pain the commanders will levis rookie and byron young silver justin tucker got a kj henry rookie auto going to the commanders for the commanders i should say tuli-tuli polo two and jonathan mingo that will do it for your break there adam thanks as always my man do appreciate it get him right out to you buddy all right michael with another absolute let's do it let's run it back michael run it back go grab that in just a sec here yeah have a go on tim thank you tell adam we say thank you as well appreciate you tim thank you tim and adam tim and adam you'd know better than i would yeah hey eric picking up the uh trailblazers in one two four five and six thank you eric eric w all right one second everybody be right back autograph booked at 25 of ronald lacuna jr whoo Christopher w with the braves refractor protector to 10 and it is a gold and it is adley rutchman oh my god one of 10 baltimore josh will are with a big time adley there we go up won't stop had a 30 byron buxton and then rpa uh four of 10 gunner henderson my gosh man three colored game used rpa gunner henderson all right you guys ready for the one-on-one booklet ready ready bofa whoa one kyle schwarber dude what a patch on that i'm assuming that's from the second eye because that's the loop of the l that's a loop loop of the second l with the star from the eye that's so nasty oh my god man wow david or t schristen causes dual autograph boston 14 of 15 there we go yeah michael c yep vaughn i am uh we're going through the same emotions currently heart beating faster breathe oh my god look at that on card and everything come on man that's beautiful oh my god yeah the aid of 75 shohei otani that's huge finest intimidators auto going to the al west thomas k that's huge holy hell man that is awesome you get like that is a rookie taj bradley frozen fracter number three of five three of five taj bradley frozen fracter that is an expose rookie jordan walker cardinals number 250 nice sp there we go good few boxes here the inks one of one green oswald foradza nice congrats on that one yankies going to uh if i could find them that'd be sick uh daniel c congrats daniel good stuff dude that's awesome big poppy jersey autograph five of ten rod red socks heck yeah boston love this one that's greg m great guys a lot of the Ortiz is now too and colas josh chisum and dual auto mets to 15 bread baby david right epic yeah love see a dual on card auto already from brian g and the mets we're gonna get this one in a mag that's pretty here everybody brandy rosarita one of one less in the rays come on baby jake just missed it wow dude one of one right all right mr michael again michael l and nothing else in q after this i'm back indeed yep yes it is shorts just seven to go the first one right good luck michael here we go buddy going on everyone sam here at latin sports cards ripping uh one box of 23 panini absolute football hobby for michael l it's good luck here michael let's do it buddy and ryan tannell that is to 16 seven to 16 sam howell second year got to 399 trey tucker rookie at jersey ball auto for the raiders the rookie premier and adam feeling in myles sanders two-color patch and jersey with panthers i got those the first ones around me of what snickers ice cream bars those go hard they do they do indeed you got some yeah i got a six pack nice a little six pack that the twix ones are pretty good too if you're a twix yeah you got about those here judy and marquette's valdez scantling uh nice green to 25 erin rogers 22 to 25 that's actually not bad at all color match as well god darryl johnson is to 199 for the cowboys absolute legends auto and then nice to be your gyms jumbo patch 21 of 49 for the lions i do like these these are really nice jumbo patches don't hit a lot of them they're not easy to hit though that's the only thing to being numbered to 49 you think they'd come out more uh mini box for you here next one's about buddy that's is uh jason kelsey to 100 and deontay johnson got hendon hooker to 275 for the lions a bj ojolari to 50 for the cardinals and then nice patches of hasan reddick and brandon gram 34 49 for the eagles team tandem three color and three color very nice that will do it for your break there mr mitch thanks again buddy as always for the support uh get right out to my man yeah thank you mitch appreciate you buddy um there's nothing left in queue here everybody all right let me drop you guys this link to tomorrow i'm mac basketball and diamond icons with forest there's your link to it uh random hits sold out the first one sold out on the second one uh then imac p yt again the nets bowls calves pistons pelicans magic spurs all still available in the first one and you've got a bunch of imac got what 10 cases of it yeah 10 cases and then uh some phoenix p yts then i started six with some stadium club let me go until about uh 1240 tomorrow finishing off with some prime racing so thank you all again for getting the brakes filled up today do appreciate it i will see you guys again tomorrow


Okay, for instance, at this moment with the proliferation of web, the application is growing huge, it's growing as a very fast pace. When you open, when you put your application on the net, at first maybe it's only 20 concurrent users or probably 10 GB data. But then after that, what is happening is that it grows a lot. Maybe in the next week or so, it already grows your application or your database, already grows 50 or 100 GB. That means you're actually hosting a lot of millions of records in tables. So what is the solution for that? You know why? Because whenever any connection, whenever a lot of connection accessing one table, a big table, it's going to be slow. It's a recipe for a slow performance. Why? Because locking happening everywhere in the table and the index size of the table is huge. This is the solution for that. I'm going to share with you. Racing the bar, okay. So like I mentioned in the web, our application grows a lot at a huge pace. Now, coming back a little bit, just a backtrack. I believe you guys know that in 2010, MySQL comes under our code. So not every one of you. I believe at that time, many of you feel, hey, MySQL will be gone maybe in a few months. Raise your hand if you think about that. Okay, thank you for your honesty. Anyway, what happened is after five years, we are still here. So there's a reason why we are still here. And the reason is because many big companies already adopting open source technologies and we cannot avoid it. Companies cannot fight the wave, the big wave of open source coming. So we have to adopt, we have to embrace. So MySQL has been strong in the web application. We are strong in the open source application, right? And it's only right that Oracle embraces us as well. So this is just a brief picture of our artwork. We are releasing products regularly every year, okay? Now in application, because we are facing with such a huge growth, the application needs to be responsive and agile, in which in this case, we need some sort of high availability, right? Meaning that if you have one single server, if you have one single database server, what happens if that server, what happens is that server down. You can't think one thousand and one reason why that server can come down. Can you think of one faulty in the hardware, you know, electricity drop, all these many, many reasons for one single server to go down. So we need high availability. If we have redundancy, one, you know, master ends at least a clone of one server. So we have two servers. So one server down, the other still serving the data. The entire data is still running, your application is still running, right? Next is scale data in user groups. When coming to a huge data growth, your data is growing by leaps and bounds. Now, what you want to do is you want to scale accordingly. You don't want to buy one big server, 32 sockets, one terabyte of RAM, to be able to handle your application for the next seven years, right? It's a huge initial investment for you, isn't it? You want to start with small. You want to start with a low-commodity server, right? Low-commodity server like two sockets, maybe 30 GB RAM, and then grow and grow and grow according to when your application grows accordingly. So your database, your investment grows according to your application grows, right? OLTP and analytics, you need to have some sort of OLTP and analytics functions as well, right? Like a big data, it's the trend that big data is coming into the technology, right? So this is for you to help you to be able to make informed decision in a faster manner. Elastic as well for server-provisioning because we are adopting the cloud. Okay, sorry about that. Elastic means that we are adopting the cloud. It actually can provision the server from the cloud easily, right? Okay, so this is the technical definition of MySQL Fabric. It's extensible and easy to use framework for managing a farm of MySQL server. So it's basically a distributed database. Distributed database, right? And this is what it gives you. Okay, first of all, are you all aware? Oh, no, sorry, not aware. Do you know the term sharding, right? Sharding is used in a lot of places. Okay, sharding means is that say if you have 100 million records in one table, you split it, for example, into 10 servers. So each server have 10 million records, right? What happens is that after that, in each of the server, because the workload is also split, the data size is also split, right? So it's easier for you to manage the performance of your database because everything is split, including your workload, right? So that is sharding. Then the second function of MySQL Fabric is edge high availability. Now, all of you have already known that one of the major functions of feature of MySQL also available in community is the replication, okay? You guys are aware of replication is, right? Master and slave, the slave is the clone, right? So the slave will pull all the data from all the data changes from the master. And this is the high availability that we use in Fabric. How we contribute, what is the value of Fabric in the replication is that normally replication is done when replication, when a master is down, the slave should take over as the new master, right? Now, normally with replication, that is done manually. There is no other way you have to do it manually. You have to do a change master command and all this stuff. But with Fabric, it is done automatically. It means that the Fabric process will actually detect whether the master is down or up or down. When it's down, it immediately promotes the slave into become the new master. And then the rest of the slave will connect to the new master and pull the data from the new master. So that is the major two functions. The additional function is that, okay, as you know, one of the reason why people use replication is that to split workload, right? The character of web application mostly is 90% of them, 90% of the workload for web application is read, right? Take, for example, Google's, Wikipedia, Amazon. Most of the time, when you go to Amazon, you are click, click, click, looking, looking, searching, searching, searching. And then at the end of the day, you might not buy anything, isn't it? Right? And now, by nature, the workload of web is 90% read. So what happens is that, normally, people split, people have the master and then a couple of slaves to actually handle the read. So the master is free from any read operations. The master only handle the write operations, update, insert, delete. That's it. So the slave move to, the slave that can handle, handle the read. Now with, without fabric, without fabric, you have to direct, direct manually your read and write from the application into the slave or the master, without fabric. But with fabric, you can act, it will be directed automatically to the slave. You can set it that way. Right? Okay. At this moment, at this moment, okay. Fabric, fabric is work together with the connector, master connectors. Right? The connector has to be fabric aware. Has to be fabric aware means that you have to download the latest version. Right? At this moment, the one that is supported is phytonjavaphp.net.net and C is still a lab. Sorry. Yup. So, take note of this phytonjavaphp.net. Yes. Anyone need the USB? Want to copy the file? The zip archive. How does it archive? Because it's like trying to use it. No. It's okay. One wants to use it. The gzip, I think. The gzip. It's just BOM. Come again? It's a BOM file. Is there a problem opening that? Anyone have problem opening the zip except the gentleman? Okay. Let me continue first. Right. So, now the data. Okay. When we talk about data, we put data in the storage. You can be it sand or storage area network, shared storage, right? Or local disk. Anyway, you need storage to put the data in. Right? Now, normally on an advanced layer, like if you have a high level of storage, right? The storage itself is able to do, you know, redundancy. It's able to do high availability. The storage itself. So, they do, they sync each other. If you have a high level of storage, that is, that costs you a lot. I don't even want to share the price. Okay. Right. Now, normally with MySQL, for us, we use high availability on the, like I mentioned to you, we are using replication. That means on the application layer, on the database layer. Right? So, we don't use the storage to actually sync each other. We just use the replication. Now, but when we talk about HA, it's not just enough to only secure the HA for the storage. You have to secure the application server as well. Right? Your application server needs to be more than one. Because if that's application server down, you are gone. Right? So, you need to have at least two application servers and then probably have, probably put a load balancer on top of the application server. Any load balancer, be it software or hardware will be. Now, over here, we need access to data is where your database software is. The database, you need the database software to access the data in the storage. Right? Okay. There is, okay, but now what we add here is the routing in between each other, between the data. Okay? The data, base of that is the MySQL server. Right? On top of that, from application server to the database, we need, normally people connect directly from app to the database. Right? So, we need a routing function, but if you connect directly, what happens if the network is down? Then you are gone. Your application is gone. So, you need a redundancy as well. A routing from the app to the database server. Right? So, this database, this routing, we can actually strengthen it to cross each other as well. So, it increases the high availability. Right? So, just a little bit of replication type that we have in MySQL is that, in MySQL, the default is asynchronous, asynchronous replication. What it means by asynchronous replication is that your master, the master server, will not wait for the slave to be updated. So, it's the responsibility of the slave to actually pull the data from the master and update itself. Right? That is the default. But starting from, okay, starting from MySQL 5.5, we have what we call semi-synchronous.  It will send the change into the slave file system or relay log first. Right? It will send the changes to the file system of the slave server. Okay? And then it returns back, say, okay, acknowledge, and then the transaction is done. Right? So, this is in a way making sure that the changes whatever happened is already in the file system on the slave. But take note is that these changes has not been, it's not been replayed in the database yet. It's only on the file system, on the log, on the relay log. So, what the storage database needs to do is that it needs to pull the data from the relay log and replay it in the database itself. So, that's why we call it semi-synchronous because it is not fully synchronous. Right? By the way, but if you want a synchronous replication solution, that is another, that's a different solution. It is not replication. It is what we call MySQL cluster, the one in the middle here. MySQL cluster. That is another product of MySQL. It is also available in community edition as well if you like to give it a try. Okay? That one is the only solution that can do active, active within MySQL. Active, active solution means that you have two servers, active, active. One down, the other ones still active. Your application only need to redirect to the active one. Right. So, now, this is the framework of Fabric. So, the Fabric controller is the one that keeps the data. Right? It actually, the Fabric actually keeps the data in one small database, MySQL database as well. So, it uses MySQL database to keep, to store all the data of the routing. Right? This is in the process as well. Now, as I mentioned just now, it is using the connector. PHP, phyton, java.net connector. What happened is that all the information of all the, the MySQL Fabric structure architecture that you already set up, it will be routed and it will be updated into the connector cache, your MySQL connector cache. Right? So, when it is updated, every time there is a change in your architecture in the Fabric, say if there is the note down, right? And then it will be updated in, the status will be updated into the Fabric process, into the Fabric store. And then it, Fabric store will actually update your connector cache. That's the, and this is the, actually the entire architecture of your Fabric, the HA group. Right? Okay. So, you notice that all the, like, that in this case, we have a connector cache, right? Now, at this point, any questions? First. Okay. There is one thing that, that you might, you might want to ask. What happened if the Fabric store down? Because the Fabric store is the, is the one, is the, is the database that is the store where, is the, sorry, is the place where they put all the routing information, which is master, which is slave, and how many, how many servers do you have and all this stuff, which one is read-write, which one is read-only, all this stuff. What happened is it's down. Don't worry. Don't worry. Your application can still access the data. Why? Because all the information already in the connector cache. As, as long as, as the information is there, you don't have any problem. It will still be running. And then, when you bring up the, the Fabric store again, it will just join again and you don't have any problem at all. Right? So, this is the, the effect of the failover. So, we are using replication here. Primary is basically, basically the master, the one that receives all the writes. Right? This is the term that we will be, we will be using in the hands-on workshop as well. You will, you will notice that. Secondary is the, is the replication slave. It will, it only accepts read-only transactions. Right? And then, failover, when, when we have primary, when the primary is down, or the master is down, the slave will automatically tick, will, will become the new slave. Sorry, the new master. And it will all be managed by the Fabric process. Right? Over here we have a high availability group concept. In, in this, what it means is that in high availability group, you have, you have, you have one master. Only one master. Right? But you have, you can have a number of slaves. Some slave, you want to start it to become a slave, only slave. Slave that is ready for you to be, to, to take, to take over when the master is down. On the other hand, you might have a number of other slaves that you only assign for read-only transactions. So, and this is part of the one, one group HA.  You can put it that way. You can set it that way. Later, at this point, maybe you guys, a lot of, a lot of question mark in your, in your, in your mind. But later when you do a hands-on workshop, you will see. Okay. When we define a group first, we define a group first, and then we add server to the group. This is the HA group that we talked about just now. And then after, and then we promote one server to be the primary first. When we set up for the first time, right? And then we activate after, after everything is done, after we put all the, all the master, sorry, all the server that we want to be part of that HA group, then we activate it. We activate the anti-HA group. So now the fabric will monitor the entire HA group. Okay. So, right, so scaling, in this case, we actually scale horizontally, horizontally. So we don't need to, we don't need to invest a big machine in the beginning, but we just start small.  Most of, some of you are doing startup, right? Any one of you doing startup here? Right? Okay. You don't want to invest, you don't want to invest a million dollar machine, isn't it? You, you run, right? Doesn't make sense. Might as well just buy a commodity server, HP, Dell. It's only cost probably 5, 10,000, right? That's it. So, and then you, when your application database grows, you just add more server, add more server, add more server. Done. So you, when you get the income, you buy more servers. Easy as that, right? And as you can see, right now my scale, the latest version is 5.6. The next one is 5.7. And at this moment is still alpha release. Soon, maybe next month, it will become beta release or release candidate, right? We are actually aiming to launch 5.7 to be ready for production use by October. Okay. As you can see there, that is the difference in performance between the different versions. You can see that how fast my scale 5.7 as compared to the current version, 5.6. So, when it comes out, you will be happy to see a performance increase a lot. So, just a little summary of the benefit of Sharding. Okay. The benefit of Sharding is that we can do a right scalability, handle more rights because at first you have one server. You add more server, more server, more server, so you have more, right? Then that means you are actually handling, you can handle more rights. Now, large dataset, database too large. So, since database too large, definitely it's a recipe for slow performance. What you want is you want to put more servers to manage the performance better. And of course, the improved performance. Okay. Right? I don't think I need to read it. Sharding architecture. This is the architecture of Sharding. So, over here you can see more clearly of what, how the architecture is. Okay. At first you have connectors. This is the application, this is the connectors that you put in the application server. Right? Right? So, as I mentioned earlier, the fabric store or the fabric node here will actually be talking regularly with the connector in the application. It will update the entries for the information in the connector cache to make sure that you get the latest routing information. Right? And then on this side, you have all the shards and a global group. Okay. So, right. So, this is all the shards. Say, this is all the big tables that you have. Say, you have 100 million records. You split it across different shards, different servers. Right? Right? So, okay, the global group is the group where you want to put table that you don't want to shard. Right? You definitely, in your schema, definitely there is some tables that is small. Say, it's like reference table. Maybe, in terms of the employee, you know the employee department table, EMPDPT table? Maybe department table is reference. Right? Small table. Where you have it, you have a transaction table that 100 million records. But there is some small table that only have 20, 30 records. Do you want to shard it? Do you want to split it across a lot of shards? Doesn't make sense. Right? You want to just keep it that way in one server. So, you put that table in the global group. All this table is accessible from all the, for all transactions. Right? Okay. This is the HA group. Like I mentioned, this is the global group. Primary secondary. We have primary secondary as well. HA group, we have primary secondary, which is master and slave. Master and slave. And all this is the extra replicas that I mentioned. If you want to have more ability to take up more read operations. Okay. I think I spent too much time talking sharding setup. Okay. This one, you will be doing it. Okay. You will be able to do more operation in terms of maintenance. You can actually move the shards from one server to the other. From one data, the data from one shard to the other shard. Right? You can actually also split the shard because your data is going to grow. Right? In one shard, maybe that one shard is already too big and then you want to grow. You want to split it into two servers as well, another server. So, you have to split the shard. Okay. Everyone already has your file. Anyone still need the file? The VM? Okay. Cool. You're cool? Right. Anyone still need the USB? No? Yes. Everyone cool? Okay. Right. So, first of all, open the zip file. You can open the zip file, right? It's not corrupted, right? Cool. Okay. So, in this case, what you need to do is if you run Windows, just run the VirtualBox Windows. If you run Linux, then you can run any Linux version that you want. Okay. Just install the VirtualBox first and then we need to do an import. When it is done, when you click on the VirtualBox, it will appear like this. Without this. All these are empty. When the first time you run VirtualBox. Okay. When you see this already, you just import. Sorry. Yeah. Import. Just import. Okay. And then choose the OVA file that you just downloaded and that you just copied. Next. And then don't forget to re-initialize, make address, and then just click import. That's it. It will be importing and it will probably take a few minutes depending on your laptop. And probably most of you are already using SSD. It should be fine. Anyone have any problem installing? No? There are a couple of things that not in the slide actually. I just found out in the VM that we need to do. There will be a number of replication troubleshooting steps that we need to do. Just a little bit. The good thing is that you will get to know how to deal with the replication issue like this. When it's done, when the import is done, please start it. Just click on it and then click start. Stay running. Okay. Fine. No problem. Stay running? Right. Right. Oh. Yeah. So I just downloaded this. Okay. Sorry about that. Right. I should put that in the next slide. Yeah. Because actually most of you guys are using Macbook, right? Macbook. Okay. Right. Yeah. Next slide. Yeah. Next slide. Yeah. Next slide. Yeah. Next slide. Yeah. Next slide. Yeah. Next slide. Yeah. Next slide. Yeah. Yeah. Yeah. Yeah. Yeah. So in demo settings, change it from post-molation to the next slide. Yeah. Yeah. Okay. Yeah. Yeah. Yeah. Okay. That's done. Okay. Everyone that's already done with the import can just access it to music route and one and the password. One, two, three, four, five, six. Sorry. Okay, after you're done with this page, this slide, stop first. We are going to need to do some replication fixing. There is another, guys, in the application, in the apps folder just now included in the zip file, there is a program called Putty. Use this to access the VM using the IP provided. Use this because if you are typing on the VM window itself, you cannot copy and paste. You need to type everything. If you're using Putty, you can copy and paste the command. You don't want to waste time typing. For those of you that are using Linux, you don't have issues. You just have to SSH to the VM. Now, if you have done this slide, you definitely will have seven MySQL instances running in there. Seven MySQL instances in one VM. It will take some time when you start it for the first time, when you start the script. Those are the instances that we are going to use for the fabric. One of them, which is <IP_ADDRESS>.4, is going to be the fabric store. It is actually in your zip file, in the document folder. MySQL fabric managed setup. Managed setup is basically to set up the environment and to set up the admin password for your XMLRPC connection. And then the start, of course, to start the fabric process. Come again? You want? Easy. Now, what we need to do here is show slave status. You will see the status of the slave, the slave process. These two should be running. If not running, then your application is broken. In order to go there, you have to do this first. Just connect. Use MySQL client. Connect to 3.3.07. One of them is, this is the global group slave. The thing is that we might not have enough time, but we just do it as fast as possible. So, when you connect to this, both of them are yes? Or one no? Yes, sure. Sorry, guys. Hopefully, I don't really think that we have enough time to adminize already some other session updates.  Because we have tried to use a new client, something like this. We really like to communicate with people in another session. I mean, there are more ways of doing this. And we can also continue with our next workshop. Okay, we've only just one more thing. Yes, sure. Okay, the rest of them, when you do it, when you just follow the instructions, it's okay. But this step, you need to do it first for this VM. Because I used this VM before, and then I found that there are some things that are not done right. Okay, what you need to do is, over here, you should see some error if your slave is not up. I would say do this. Okay, check this first. The retrieved GTID and the executed GTID, are they both the same? Right now, are they both the same? If they are the same, then that means you already executed the entire transaction for this. If not the same, then you might get an error. You know what? It's not enough time. It's very hard for me to go ahead and use this. Anyway, it's possible. Can you post full or part of your slides? Then people, if they wanted to follow themselves, so they need you to explain everything. Is it useful for people if you distribute the slides to... I have inside the... Okay, right. Maybe explain if they can do it on their own, or give you contact information if they want to ask you questions. Sure, sure. If you want to give a talk on this, we can also organize this. Guys, okay. So for now, since we don't have enough time, so I would say I will just give my contact. So if you have any problem running the instructions that I give you in the slides, just let me know. I'll get you to the steps. There are some things that need to be done on the replication. We need to... Basically, we need to insert a blank transaction first in all the slides. Basically, that's the idea. But it's just that we don't have enough time at this point. Right? So sorry, guys. Sorry, sorry, sorry. Right, so sorry, guys. Thank you very much to join this session. I hope you guys enjoy the zip file that I gave you. Let me know if you have anything and any information you have at home.


The FLODIS dataset is a comprehensive resource for understanding the impacts of floods on people and economies. It combines data on displaced populations, fatalities, and economic losses with satellite imagery of flooded areas to create a spatially explicit picture of the flood hazards associated with different disaster events. This allows researchers to better understand how floods affect different regions and communities, and to identify areas where additional protection measures are needed. This article was authored by Benedict Mester, Kottier Freela, and Jacob Skew.


Good morning, and thanks for joining us on Facebook live for our latest town hall discussion today We are talking about the Zika virus how concerned should Pennsylvanians be and what the wolf administration is doing to prevent the spread of Zika which is of particular concern for Pregnant women or those planning to become pregnant. So joining us today is Health Secretary Dr. Karen Murphy Physician General Dr. Rachel Levine Dr. Sharon Watkins Epidemiology Bureau Director for the Department of Health Dr. Lauren Robinson Deputy Secretary for Health Promotion and Disease Prevention for the Department of Health Patrick McDonald acting Secretary of the Department of Environmental Protection and Andy Kyle DEP's Environmental Program Manager. Welcome to you all. Thanks for being here So today our panel is taking your questions posted from Governor Wolf's Facebook page about the Zika virus But before we start with that I'd like Dr. Murphy and Secretary McDonald to each give sort of a brief overview of why this topic is so important And how each of their departments are being proactive to address it. So Dr. Murphy will start with you. Thank you Megan And thanks for having us here today Now that summer is well underway. So is mosquito season So we have diseases that are associated it with mosquitoes particularly Zika this year to To monitor so the wolf administration takes this threat very seriously We have developed a plan with Secretary McDonald and the Department of Environmental Protection Along with the Department of Health today, you'll hear from the Department of Health experts in Zika We have published the our plan on our website and your the participants here are free to go on the website to take a look at that and To heed The information and the warnings that are that are on our plan The Department of Health not only is working with DEP, but with the Center for Disease Control We are provided with almost daily updates from the Center for Disease Control and we will keep Our our information on our website current according to that we currently have 36 cases reported all of Those who had visited Affected countries, we don't have any local transmission as of yet, but we will be aggressively monitoring this throughout the season Thank you and Secretary McDonald sure and Excited to be here and explain The department's role in the Zika prevention Campaign our primary role is mosquito surveillance monitoring. We've done that for many years primarily related to West Nile virus But now we're doing it in addition for the Zika virus There's two types of mosquitoes that can transmit the virus one of them is fairly common within the state another We haven't seen for for over 10 years now within the state, but we are monitoring for both There's a number of things that that people can do to prevent Mosquitoes and we can talk a little more about those as we go through through the day Thank you both. All right. Well to get started. I think we should just sort of Go into like what is Zika virus and how is it spread? So Dr. Watkins? I'd like to start with you You could just give us a quick, you know, what is Zika? Sure? Zika virus is one of the viruses that is transmitted by a mosquito Pennsylvania's are familiar with this type of with a mosquito transmitted virus. We have West Nile virus here in Pennsylvania Now how is Zika spread is a little different than West Nile virus? most Transmission of Zika occurs because an infected mosquito bites. I mean a Mosquito bites an infected person and then rebites another person However, it can also be transmitted from an infected male to a sexual partner It can be transmitted by a pregnant woman to her baby at the time of delivery or during pregnancy And then we also worry about blood blood transmission during blood products And I guess also this is an obvious but is Zika virus dangerous and I think you know for some Maybe not but for those that are expecting it can be devastating as we've seen in the news absolutely Most Zika viruses infections are asymptomatic.  So they're things like a rash or a fever some joint pain or a headache However, we are concerned about pregnant women and that's that's where why we're really talking today because there are birth defects that are associated with this Microcephaly we've all heard about that in the news, but some other central nervous system defects that the child Could be born with We're also concerned about a neurological disorder called Guillain-Barre syndrome and that has been associated as well Okay Let's get to some Facebook questions and Sarah asks this and I think Dr. Watkins if you could take this one as well with the CDC's updated map showing a low potential for Zika outbreaks in Pennsylvania How high do you believe the risk is for Pennsylvania residents? You know that that's a that's a tough question I mean we believe that there is a low to moderate risk But certainly not zero and Pennsylvania does have as Secretary Murphy said 36 travel associated cases And we do have a competent vector. So the risk is not zero and we were taking all the appropriate actions we need to And does the risk vary throughout the state? The risk would vary throughout the state and it varies by the density of the vectors Which I'm sure the our colleagues are going to talk about it varies by the amount of travelers who are coming into that area who may be carrying the virus with them and Just you know varying by the amount of standing water and the amount of time people are outside And another question from Sarah and dr. Robinson if you could take this one She asks do we really need to take precautions and change our lifestyle to avoid infection or is the likelihood of contracting the virus? So low for Pennsylvania residents that we really don't need to take extreme measures That's a great question So I think it's really important for people to take precautions to protect themselves against mosquitoes not only for the Zika virus But also because we know that we have West Nile virus here The main risk right now to Pennsylvanians is for folks who are traveling to areas that have High levels of the Zika virus again We do not have any local transmission in the state of Pennsylvania and the United States at this point So it's important for people to take precautions when they're traveling and to wear deat when they're outside So that's wearing an insect repellent when you go outside and that's something that folks should be doing pretty much any time It's mosquito season and so I wouldn't call those extreme measures But it is important to protect yourself and know what your risks are and this just came in my head But deat is is has been deemed a safe Repellent for pregnant women. Yes, and that's a great question So deat is not only safe for kind of everybody in the general public but for pregnant women For children who are playing outside deat is approved and is safe for people to use Let's take some questions over to D. E. P. Lauren asks. Are there approved mosquito preventions? That are more likely to prevent Zika from spreading sure and I think along the lines of the last answer It's it's we focus on mosquito prevention generally Because that reduces the likelihood of Zika transmitting so there are a lot of simple things you can do I mean, I think most people don't aren't aware the type of mosquito. We're talking about here only travels Within 50 yards of its aquatic habitat.  So anything you can do to reduce standing water If you have an ornamental pool and it's you don't have fish in it or aerate it You know make sure you address that Even things, you know, I have kids you leave out the kids toys It collects a little rainwater in it that can be that can be a place that that water collects So it's making sure that you're reducing the those kinds of Opportunities for the mosquitoes to breed and thrive. Okay What about like spraying your yard? Is that a is that something you can do or do you recommend that? You can use EPA approved Insect insecticides we make sure make sure you're following all the instructions on the labels Read any warnings on those labels But there's a number of products that are available At local hardware stores and other places that that can help address Avoiding that standing water is probably the biggest one. You avoid the problem entirely if you get rid of the standing water Okay, and then David asks is it possible to test for Zika in mosquitoes or in animals such as birds as the state Does with West Nile if so is the state doing that? I'll turn it over to Andy Kyle to answer part of that in a minute, but the the key part is the difference between West Nile and Zika is The mosquitoes get get the West Nile virus from birds And then transmit it to humans here. You're talking about Zika being in humans Mosquito getting it from human and then another human you know another human getting it from that mosquito as as the vector So right now what we're testing for is just the presence of a mosquito that could be a Zika carrying mosquito We're not at this point testing for Zika itself in the mosquitoes Andy, I don't know if you want to add Not you've said pretty much what we need to say We will be testing the mosquitoes in our lab For Zika. We won't be testing any birds or any of the other animals that's mentioned in the in the question so Dr. Levine we have a question from Linda Marie She says would you recommend that every woman who is thinking about trying to conceive undergo a screening test to determine if they've been Exposed to Zika prior to getting pregnant. Thank you for that question No, we would not recommend that women who are thinking about getting pregnant get screened For the Zika virus really most women in Pennsylvania will not have been exposed to this virus and the current tests are really only appropriate for recent exposure If you have traveled however to an area with ongoing Zika transmission We do recommend that you talk with your health care provider and consider postponing pregnancy for at least at least eight weeks after travel Okay, and then following up also from Linda Marie if a woman has been exposed to Zika before pregnancy How long is the virus active in the body? I think you sort of just addressed that but what what is the recommended length of time to wait before trying to conceive? Okay, sure. Well the current evidence that states that people would have the virus for around seven to ten days If they contract it and women should wait at least eight weeks from exposure time For instance, if they travel to a Zika affected area before trying to get pregnant It's also important to remember that Zika can be sexually transmitted So if their partner has traveled to a Zika area transmission and then had symptoms They actually they should wait for at least six months before trying to get pregnant Also from Linda Marie and Dr. Robertson if you could address this one She says do we know anything about with regard to becoming pregnant after exposure to Zika virus and does the body create? Anabodies that prevent reinfection. That's a great question. So based on the available scientific information we have up to today we think that as a Woman gets exposed to the virus her body mounts the response and she recovers she gets better Like with other viruses she will develop some type of immune response so that if she gets exposed in the future She wouldn't get as sick or wouldn't have symptoms We don't know if these are antibodies. We're not really sure what this means and and I think a follow-up question We don't know what that means going forward So a woman could have the Zika virus get better and feel completely fine But we don't know today what that means for her future pregnancies Okay, and then one more she Linda asks in essence if a woman becomes pregnant after Contracting the virus and recovering from it. Can she contract the virus again during her pregnancy or even after her pregnancy? Putting her unborn baby at risk So she could contact the virus again We wouldn't know what her response to that virus would be or her response to the Zika virus would be at that time And we wouldn't know what her risk would be to our unborn baby I think this this is all information that will be forthcoming and that folks should definitely Get the latest information from the Pennsylvania Department of Health website And the CDC is really good about providing updates about the Zika virus as they come to know this information And I think like your your your physician is is staying in touch with the CDC as well So if you have those quite right you can go and ask them as well Okay, and then okay, so this is one that's on I think a lot of people's mind with the summer Olympics coming up Emily Rose asks what does the Department of Health and the Department of Environmental Protection think of? Pennsylvania residents traveling to Rio for the Olympics due to the overwhelming number of Zika outbreaks that are originating in Brazil. Dr. Murphy So the CDC's recommendation Recommendations include pregnant women should not go to the Olympics So those that are already pregnant we are also encouraging anyone who is attending the Olympics to Exercise the caution the precautions that we've spelled out here today because we think it's very important You know, I remind everyone that this is a relatively new Disease that we're chained. We're finding out new information about it on a daily basis and I think our advice is precaution and and particularly in those that are planning to have children both male and and female Does DEP have a thought on that on the Olympics? I mean that's when we definitely deferred our colleagues at the Department of Health We have a little bit of extra time here I mean what what haven't our Facebook viewers asked that you think is important to get out to? Pennsylvanians regarding Zika I Think they it's very important to understand the the county health departments across the Commonwealth and Municipal County of Municipal Health Departments are also working on Zika prevention the Department of Health is preparing to to Supply some areas with Zika kits for those that may not have those available to prevent As a preventative as a preventative measure and we will continue the biggest Initiative we have right now is education We have that we launched airport sign signage So those coming in from the affected countries would understand what the implications are and we will continue to educate our 12 million Pennsylvanians so that we can present you we can hopefully prevent the disease from Spreading I think it's also you mentioned it important to emphasize for people to keep in contact if they have questions with their Health care providers with their physicians or other health care providers the Department of Health has put out numerous health alerts To the medical providers in the state Also, I know that the American College of OBGYN Have had weekly alerts to their to their members because obstetrician gynecologists are obviously the health care providers that would need to stay informed so We've been in contact in other Health care authorities have been in contact with their physicians and health care providers So if you have a question in addition to coming to our website or the cdc website contact your health care provider for information That note that individuals who have concerns Should definitely get in touch with their health care providers sooner than later because testing for the virus has a limited window And you want to catch you know catch it in that window. So it's important that they Immediately seek their physicians advice Who gets tested if so I think the CDC says if you've traveled and then you're pregnant and you think you were exposed Is that correct? You're able to get that not everybody can get the test. It's a very complicated algorithm but so To keep it a little simple. I mean if you've traveled or If you if you're pregnant and you've traveled You should be tested if you're pregnant and you have a partner who has traveled who is symptomatic you should be tested and All others there are some Decision marks that that we go through and we have an algorithm that will be is on our website And we are updating that so who who then like is it that you would see your primary care or your OBGYN And they would decide to order a test if need be many times They're consulting with the Department of Health to walk through what test, you know, what test should be ordered when and what's appropriate Okay Anything else? Yeah? Yeah Summer look like Hot right No, I mean Can't stress enough again from from the standpoint of mosquitoes for a variety of reasons Zika being one the prevention element Reduction of standing water the other things we we say are if you need to be outside where Try to cover as much skin as possible, which I know it can be a challenge in the heat, but loose light, you know light clothing Use EPA approved insect repellents to try to prevent Mosquitoes from biting and then in even inside the house remember if you have a hole in your screen That's a pathway for a mosquito to get into your house So make sure you're repairing screens use air conditioning because they like the heat they like being outside so Using air conditioning in your home can help reduce so anything you can do to both prevent Mosquitoes from breeding but then prevent the bites Is what we focus on you talk a little bit more for those who are just tuning in also You mentioned earlier in our panel about the mosquitoes this specific type of mosquito that carries the virus doesn't go outside of a 50 mile radius Sure, so no 50 yard 50 yard 50 yard radius from its aquatic habitat So they breed within standing water, which is why it's important to aerate a pond or you know if you have tarps toys Whatever outside that's collecting water That you're getting rid of that But once they breed I mean the they exist their their entire life they exist within 50 yards of Where they came from in terms of that Asian Tiger? Mosquito which is the one we're concerned about Within the state so if if you're seeing the mosquito Chances are it came from your yard or a neighbor's yard It's it's not something that's coming from half a mile a quarter mile down the street Is there a concern moving forward and this is probably on the national level, but if somebody is infected and then it comes from a different country and then is is bit by a mosquito here because there are some states that have those Mosquitoes correct the the the carrier of the so there are two mosquitoes that are primarily involved one is Sometimes called the yellow fever mosquito that would be as the secretary mentioned Extremely unusual in Pennsylvania has not been seen since the early 2000s The other is the Asian Tiger mosquito has a fancier scientific name and we do see that in Pennsylvania every year and The EP is is finding that as we would expect in Pennsylvania now you outlined exactly the concern if someone was from another country that came from the South America or Central America or Caribbean and actually has the virus and the mosquito bites them and then bites somebody else that would be how it's Transmitted so that really is the basis of all of our precautions is that we want people who've traveled from around the country Since like Central and Central and South America to take a lot of mosquito precautions when they come back And we want everyone to take the precautions that have outlined to prevent that That transmission by those mosquito bites and that hasn't happened Okay, but that's the concern and that's what the prevention is all about. That's correct. Okay, so it's complicated. Yeah. Yeah any closing just remarks about Pennsylvania and what our administration is doing to you know kind of keep our finger on the pulse of all of this just kind of reiterating what each department is doing So the Department of Health is we are addressing the Zika virus on a daily basis in Pennsylvania We developed the collaboration with DEP we have Continual contact with DEP to review. What is the current status and what are our plans? the wolf administration began to plan for Zika back in January We've held Exercises that we are preparing if should there be an outbreak of several individuals several different departments So the Department of Health and the Department of Environmental Protection and the wolf administration are Covering this this virus and What it means to Pennsylvania on a daily basis? No, I think that's exactly right. I mean is as was mentioned earlier. We developed the Zika plan for response In collaboration with Department of Health I think that lays out appropriate steps for both departments to take depending on what we're actually seeing on the ground in terms of Where we're finding the virus how much we're finding Where we're finding mosquitoes how many mosquitoes we're finding so as as information changes the response will change But we've developed an appropriate level of response in appropriate steps to go through as the situation changes, but Yeah Okay, well I unless anyone else has anything else that we I think we covered it we got it we got it done quickly too Thank you all so much for being here today. I really appreciate it and I think that our Facebook viewers Also greatly appreciate the information So we just want to make sure that you know that Governor Wolf is on Facebook as well as Twitter and To continue receiving information on the Zika plan here in Pennsylvania and prevention Please continue to tune in to his social media feeds as well as again Department of Health has a whole host of information on their website. Thanks so much for joining us