Tag: Database

On the example of this real-life project, we will demonstratehow mature MySQL database software is and what an experiencedOracle DBA can expect in the MySQL land. The project included settingup highly available clustered infrastructure and disaster recoverysite for MySQL. The application was migrated to MySQL from a legacy database platform on OpenVMS.

On the example of this real-life project, we will demonstratehow mature MySQL database software is and what an experiencedOracle DBA can expect in the MySQL land. The project included settingup highly available clustered infrastructure and disaster recoverysite for MySQL. The application was migrated to MySQL from a legacy database platform on OpenVMS.

Most DBAs realize that there is a lot more to Oracle backups with RMAN than "backup database;". We will present a script that can be deployed in under 15 minutes on Linux or Solaris hosts to perform disk-to-disk backups of any Oracle database 10g or newer.

Most DBAs realize that there is a lot more to Oracle backups with RMAN than "backup database;". We will present a script that can be deployed in under 15 minutes on Linux or Solaris hosts to perform disk-to-disk backups of any Oracle database 10g or newer.

Most DBAs realize that there is a lot more to Oracle backups with RMAN than "backup database;". We will present a script that can be deployed in under 15 minutes on Linux or Solaris hosts to perform disk-to-disk backups of any Oracle database 10g or newer.

While the concept of an index is straightforward, the implementation of an Oracle indexing strategy is extremely complex. We have many types of indexing available including b-tree indexes and bitmap indexes, as well as table/index hybrids.In addition to choosing the type of index to use, we must also choose which columns to index and which…

While the concept of an index is straightforward, the implementation of an Oracle indexing strategy is extremely complex. We have many types of indexing available including b-tree indexes and bitmap indexes, as well as table/index hybrids.In addition to choosing the type of index to use, we must also choose which columns to index and which…

On the example of this real-life project, we will demonstratehow mature MySQL database software is and what an experiencedOracle DBA can expect in the MySQL land. The project included settingup highly available clustered infrastructure and disaster recoverysite for MySQL. The application was migrated to MySQL from a legacy database platform on OpenVMS.

While the concept of an index is straightforward, the implementation of an Oracle indexing strategy is extremely complex. We have many types of indexing available including b-tree indexes and bitmap indexes, as well as table/index hybrids.In addition to choosing the type of index to use, we must also choose which columns to index and which…

Galera is a generic replication service, providing synchronous multi-master replication. We have used Galera to implement MySQL/InnoDB cluster with features like :* high availability* client transparency* high performance, write scalabilityThe presentation will give an overview of the unique Galera replication method showing the benefits of synchronous operation. Multi-master topology can give considerable performance boost, which…