Real-time database performance tuning

A computer-implemented method comprising:

• identifying one or more configuration changes related to a primary database to be tested for performance purposes, the primary database running on a first database instance;
• testing, by a database service provided by a cloud provider, performance of a second database instance with the one or more configuration changes applied by:
• creating the second database instance including a test database that is a replicated copy of the primary database, the second database instance created with the one or more configuration changes applied, and
• sending instructions to a database traffic proxy to change a configuration at the database traffic proxy to route database traffic destined for the primary database to both the primary database and the test database, wherein the database traffic proxy serves as a database endpoint for one or more database applications that send database traffic to the database endpoint,
• routing, by the database traffic proxy, database traffic, sent by one or more database applications to the database endpoint and received by the database traffic proxy and destined for the primary database, to both the primary database and the test database, and
• wherein routing the database traffic to both the primary database and the test database is based on the database traffic proxy forking the database traffic to both the primary database and the test database so that the database traffic, which otherwise would have been routed only to the primary database, is routed to both the primary database and the test database;
• determining that the test database exhibits better performance than the primary database based on performance data collected for both the primary database and the test database;
• and
• routing, by the database traffic proxy, database traffic destined for the primary database to only the test database, wherein the test database serves as a new primary database.

A system comprising:

• a database service implemented by a first one or more electronic devices, the database service including instructions that upon execution cause the database service to:
• identify one or more configuration changes related to a primary database to be tested for performance purposes, the primary database running on a first database instance;
• test, by the database service, performance of a second database instance with the one or more configuration changes applied by:
• creating the second database instance including a test database that is a replicated copy of the primary database, the second database instance created with one or more configuration changes applied, and
• sending first instructions to a database traffic proxy to change a configuration at the database traffic proxy to route database traffic destined for the primary database to both the primary database and the test database;
• determine that the test database exhibits better performance than the primary database based on performance data collected for both the primary database and the test database;
• and
• send second instructions to the database traffic proxy to change a configuration at the database traffic proxy to route database traffic destined for the primary database to only the test database, wherein the test database serves as a new primary database;
• the database traffic proxy implemented by a second one or more electronic devices of a service provider network, the database traffic proxy serving as a database endpoint for one or more database applications that send database traffic to the database endpoint, the database traffic proxy including instructions that upon execution cause the database traffic proxy to:
• receive first instructions to route database traffic, sent by one or more database applications to the database endpoint and received by the database traffic proxy and destined for the primary database, to both the primary database and the test database;
• route the database traffic to both the primary database and the test database;
• wherein the instructions that upon execution cause the database traffic proxy to route the database traffic to both the primary database and the test database comprise instructions that upon execution cause the database traffic proxy to fork the database traffic to both the primary database and the test database so that the database traffic, which otherwise would have been routed only to the primary database, is routed to both the primary database and the test database;
• receive second instructions to route database traffic destined for the primary database to only the test database;
• and
• route the database traffic to only the test database.