?url_ver=Z39.88-2004&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Adc&rft.title=Un+estudio+sobre+bases+de+datos+MySQL%2C+copias+de+seguridad+y+caso+de+estudio+en+AWS&rft.creator=S%C3%A1nchez+Aloc%C3%A9n%2C+Alejandro&rft.contributor=L%C3%B3pez+Fern%C3%A1ndez%2C+Daniel&rft.subject=Computer+Science&rft.description=El+objetivo+principal+de+este+proyecto+es+aportar+los+conocimientos+necesarios+sobre+bases+de+datos+MySQL+para+comprender+y+desplegar+sistemas+de+copias+de+seguridad+que+permitan+la+recuperaci%C3%B3n+de+los+datos.+Adem%C3%A1s+de+explicar+las+distintas+alternativas+y+m%C3%A9todos+que+existen%2C+vamos+a+realizar+un+caso+de+estudio+basado+en+una+arquitectura+real+que+nos+permita+ejemplificar+el+proceso+y+tener+distintas+consideraciones+en+su+realizaci%C3%B3n.+Nuestro+caso+de+estudio+consiste+en+la+implantaci%C3%B3n+de+un+sistema+autom%C3%A1tico+de+copias+de+seguridad+de+bajo+impacto+en+el+rendimiento+haciendo+uso+del+almacenamiento+en+la+nube+y+las+bases+de+datos+de+AWS.+Usaremos+esta+plataforma+para+almacenar+las+copias+completas+e+incrementales+de+nuestro+sistema.+Adem%C3%A1s+de+almacenar+las+copias%2C+usaremos+las+mismas+para+replicar+nuestra+base+de+datos+al+estado+de+alguna+de+estas+copias%2C+lo+que+nos+permitir%C3%A1+realizar+operaciones+sin+impactar+el+servidor+principal.+Tambi%C3%A9n+utilizaremos+esta+base+de+datos+replicada+para+realizar+copias+de+seguridad+l%C3%B3gicas%2C+que+nos+podr%C3%A1n+ayudar+a+analizar+los+datos+de+la+base+de+datos+o+migrar+la+base+de+datos+a+otro+sistema+con+mayor+facilidad.%0D%0AAbstract%3A%0D%0AThe+main+objective+of+this+project+is+to+provide+the+necessary+knowledge+about+MySQL+databases+to+understand+and+deploy+backup+systems+that+allow+Point-On-Time+recovery.+In+addition+to+explaining+the+different+alternatives+and+methods+that+exist%2C+we+will+perform+a+case+study+based+on+a+real+architecture+that+allows+us+to+exemplify+the+process+and+detail+different+considerations+in+its+realization.+Our+case+study+consists+of+the+implementation+of+an+automatic+backup+system+with+low+performance+impact+using+cloud+storage+and+AWS+databases.+We+will+use+this+platform+to+store+full+and+incremental+copies+of+our+system.+In+addition+to+storing+the+copies%2C+we+will+use+the+copies+to+replicate+our+database+to+the+state+of+one+of+these+copies%2C+which+will+allow+us+to+perform+operations+without+impacting+the+main+server.+We+will+also+use+this+replicated+database+to+perform+logical+backups%2C+which+can+help+us+to+analyze+the+database+data+or+migrate+the+database+to+another+system+more+easily.&rft.publisher=E.T.S.I+de+Sistemas+Inform%C3%83%C2%A1ticos+(UPM)&rft.rights=https%3A%2F%2Fcreativecommons.org%2Flicenses%2Fby-nc-nd%2F3.0%2Fes%2F&rft.date=2021-07&rft.type=info%3Aeu-repo%2Fsemantics%2FbachelorThesis&rft.type=Final+Project&rft.type=PeerReviewed&rft.format=application%2Fpdf&rft.language=spa&rft.rights=info%3Aeu-repo%2Fsemantics%2FrestrictedAccess&rft.identifier=https%3A%2F%2Foa.upm.es%2F68155%2F