Hi Akileish,
If you replicate from Oracle to Oracle ,as example, and enable DDL replication, it will create the same logical structure on the target . Essentially the GoldenGate will replay the command to create the index applying the mapping. Of course the internal index structure like number of levels and leaf blocks may be different. Speaking about other database engines it will depend from supported operations for the replication. As example if you replicate from Oracle to MySQL all DDL it is not going to work since DDL replication is not supported for that configuration.

—
Gleb

In our previous post, we described how MySQL Master-HA (MHA) performs a so called slave promotion (also known as master failover) and ensures all remaining slaves in the topology get attached under the new master and become equal in data set.

Another failover solution is the MariaDB MaxScale proxy in combination with the MariaDB Replication Manager. Let’s look at how these two separate products can work together and perform a failover. We will also describe how you can use them.

MaxScale + MariaDB Replication Manager MaxScale

For those unfamiliar with MaxScale: MaxScale is a versatile database proxy written in C that supports not only intelligent query routing but can also function as both a binlog server and intermediate master. MaxScale consists of five plugins: Authentication, Protocol, Monitor, Routing, …

In our MySQL replication tutorial we have covered different aspects of replication including master failover by performing a slave promotion using ClusterControl. The slave promotion will turn a slave into the new master, and re-attach the remaining slaves in the topology under the new master. Keep in mind that ClusterControl will not perform an automated slave promotion in the current version. We do have a helper to find the most advanced slave (Cluster drop down: Find Most Advanced Slave) to determine the best candidate slave.

Another thing to keep in mind is that, as of time of writing, ClusterControl only supports replication topologies using MySQL GTID. You can add your existing MariaDB based replication topology to ClusterControl but promoting slaves can …

On an earlier post I wrote about real time query monitoring on MySQL with a third party tool and without one. The script is useful as it works with MySQL 5.5 and later. However, if you're using a later version of MySQL, you should look at the SYS schema. It is a collection of views, functions and procedures to help MySQL administrators get insight in to MySQL Database usage. It's available to

After nearly ten years working for MySQL, I’m pursuing a new opportunity to expand into new areas of open source data infrastructure as part of the excellent Cloudera support organization.  I’ve been fortunate to work with incredibly talented, dedicated and wonderful people on relational databases, and I’m looking forward to doing the same in the Hadoop space in my new role.  Despite this transition, I intend to remain active in the MySQL community – most immediately, finishing off a handful of half-finished blog posts in the coming weeks.

My various bit roles at MySQL have given me a front-row seat as the company grew from a smaller independent company to a prominent product at Sun to part of a much larger, enterprise-focused portfolio within Oracle.  I’m incredibly proud of the progress MySQL has made over the years, in each stage – but the past 6 years under the stewardship of Oracle are …

Grafana is the leading graph and dashboard builder for visualizing time series, which is a great tool for visual monitoring of MySQL databases. Come learn how to use Grafana for MySQL monitoring.

In this webinar, Torkel Odegaard, Grafana Founder and Creator, will provide an introduction to Grafana and talk about adding data sources, creating dashboards and getting the most out of your data visualization. Then Peter Zaitsev, Percona Co-Founder and CEO, will demonstrate how to set up Grafana and Prometheus for in-depth, completely open source monitoring for MySQL troubleshooting and capacity planning. They will look into some features Grafana has to offer, explain why different graphs are important and how you …

In This tutorial i want to show you how to create CRUDCreate Read Update Delete using AngularJS in Codeigniter I added few step to create create edit delete lists search and pagination application in your Codeigniter framework In this tutorial through you can make simple crud search and

Problem:

When multiple client applications such as web applications, desktop applications and mobile applications written in different languages like php, python, java, objective c, etc. need to perform the same database operation (insert), the same operations done by different client applications and client applications are directly accessing the database table using same SQL statement.

Solutions:We are implementing stored procedure; here the client applications will simply call the defined stored procedures to perform the database operation (insert). In this post let us see about the syntax of the stored procedure and will see an example of insert operation using stored procedure using MySQL.

Syntax:

mysql> DELIMITER //

mysql> CREATE PROCEDURE Procedure_name(arguments) 

     ->  BEGIN 

     -> 

     -> SQL Statements; 

I just joined Chocolatey, which is sort of like yum or apt-get for Windows. HeidiSQL was already listed there but was outdated, so I created a package with the current 9.3 release.

See the package here: https://chocolatey.org/packages/HeidiSQL

Hi Valerie,

In my case (and others I know that hit the same bug) was a simple slave upgrade from 10.0 to 10.1 , and wait .
In my case, the content of FIL_PAGE_FILE_FLUSH_LSN (that MariaDB 10.1 renames to FIL_PAGE_FILE_FLUSH_LSN_OR_KEY_VERSION) was interpreted as a key.
FIL_PAGE_FILE_FLUSH_LSN is *supposed* to be always 0 with the exception of the first page of the first tablespace (0:0) . For this reason was re-purposed by MariaDB for keys, and by InnoDB to store RTREE Split Sequence Number .
Also, the content of FIL_PAGE_FILE_FLUSH_LSN is not part of page checksum, so anything could be there…
According to https://dev.mysql.com/worklog/task/?id=7990 , FIL_PAGE_FILE_FLUSH_LSN was also written in undo tablespace files.
My hypothesis is that for whatever reasons there were pages in 10.0 that has non-zeros in FIL_PAGE_FILE_FLUSH_LSN, …