Tag: MySQL

Presented at INSYNC 21

Session ID: 100360

MySQL is the largest open-source database in the world. It's a product that resides under the wings of Oracle Corporation and still it survives with it's big brother Oracle Database as the flagship product in Oracle Corp. This is an open-source product which means that, as opposed to Oracle Database, you can get it for free. We'll discuss features and we'll go into some details what we experience as the strong points and what are the weaknesses. I will guide you through the basic installation of the most recent release MySQL 8.0, we'll go through the basic concepts of the database and we will set up a replica.

Pre-reqs: Laptop with Internet connectivity Active AWS account with Admin privs. Oracle Database client, e.g., SQL Developer Get hands-on with the Amazon Relational Database Service (RDS), a managed cloud database platform from Amazon Web Services (AWS). AWS engineers will guide you through setting up, configuring and accessing relational databases (Oracle, MySQL, PostgreSQL). They’ll discuss what…

MySQL 8 is now available and is the most recent update to the MySQL database.  It is packed with updates and changes in this presentation we will take at look at those updates and changes.  We will also explore the new features of MySQL 8 as well as well as what has been deprecated and…

MySQL offers enterprise security benefits that you may not be aware of and some that you may be aware of.  In this presentation we will explore MySQL database security at community edition up to enterprise edition.   The security capability is much more then most would think especially with enterprise edition.  Come explore how you can…

In forever changing Technology world, What an Oracle DBA should know to support every day activities in MySQL database! This presentation is focused on fast tracking the traditional Oracle DBA into the world of MySQL. Rapidly changing technology makes an Oracle DBA’s daily tasks as challenging as it can be. Instead of supporting only Oracle…

There are a lot of considerations on how to move Oracle from on premise to AWS. Should we spin up an EC2 instance and install run and Oracle database there?  Should we use Amazon's Relational Database Service?  What do we still do in AWS RDS?  Should we convert from Oracle to MySQL, PostgreSQL or Aurora?  How…

MySQL is the most popular database on the web and the demand for qualified Database Administrators and Developers is very high.  A popular way to learn MySQL and show mastery are the MySQL DBA and MySQL Developer certifications.  This session will cover the areas of competency required by each of the exam, how to study…

Original Broadcast: Monday, December 14, 2015 The world's most popular open source database provides a free, open source database management system that is easy to install, manage and maintain. MySQL is fast, extremely reliable and widely deployed by many throughout the world. In fact, many of the world's largest and fastest-growing organizations such as Facebook, Google,…

With MySQL being the most popular open source DBMS in the world and with an estimated growth of 16 percent anually until 2020,we can assume that sooner or later an Oracle DBA will be handling a MySQL database in their shop. This beginner/intermediate-level session will take you through my journey of an Oracle DBA and my…

Oracle is the most powerful DBMS in the world. However, Oracle's expensive and complex replication makes it difficult to build highly available applications or move data in real-time to data warehouses and popular databases like MySQL. In this talk you will learn how Continuent Tungsten solves problems with Oracle replication at a fraction of the…