{"id":99154,"date":"2019-10-13T15:15:22","date_gmt":"2019-10-13T12:15:22","guid":{"rendered":"https:\/\/www.javacodegeeks.com\/?p=99154"},"modified":"2019-10-10T15:36:33","modified_gmt":"2019-10-10T12:36:33","slug":"read-replicas-spring-data-configuring-databases","status":"publish","type":"post","link":"https:\/\/www.javacodegeeks.com\/2019\/10\/read-replicas-spring-data-configuring-databases.html","title":{"rendered":"Read replicas and Spring Data Part 1: Configuring the Databases"},"content":{"rendered":"

This is a series of blog posts on our quest to increase our application\u2019s performance by utilizing read replicas.<\/p>\n

For this project our goal is to set up our spring data application and use read repositories for writes and repositories based on read replicas for reads.<\/p>\n

\n
\"\"<\/figure>\n<\/div>\n

In order to simulate this environment we shall use PostgreSQL instances through Docker.<\/p>\n

The motives are simple. Your Spring application has become increasingly popular and you want it to handle more requests. Most of the applications out there have a higher demand for read operations rather than write operations. Thus I assume that your application falls into the same category.
Although SQL databases are not horizontally scalable on their own, you can work you way with them by using read replicas.<\/p>\n

Our goal is not to make an actual Read replication in PostgreSQL<\/p>\n

\n
\"\"<\/figure>\n<\/div>\n

thereforeinstead of configuring any replication<\/p>\n

we will just copy some data from both databases<\/p>\n

This is the script we shall use to populate the databases.<\/p>\n

\n
\n\n\n\n
\n
01<\/div>\n
02<\/div>\n
03<\/div>\n
04<\/div>\n
05<\/div>\n
06<\/div>\n
07<\/div>\n
08<\/div>\n
09<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n
24<\/div>\n
25<\/div>\n
26<\/div>\n
27<\/div>\n<\/td>\n
\n
\n
#!\/bin\/bash<\/code><\/div>\n
set -e<\/code><\/div>\n
 <\/div>\n
psql -v ON_ERROR_STOP=<\/code>1<\/code> --username <\/code>\"$POSTGRES_USER\"<\/code> --dbname <\/code>\"$POSTGRES_DB\"<\/code> &lt;&lt;-EOSQL<\/code><\/div>\n
    <\/code>create schema spring_data_jpa_example;<\/code><\/div>\n
 <\/div>\n
    <\/code>create table spring_data_jpa_example.employee(<\/code><\/div>\n
        <\/code>id  SERIAL PRIMARY KEY,<\/code><\/div>\n
        <\/code>firstname   TEXT    NOT NULL,<\/code><\/div>\n
        <\/code>lastname    TEXT    NOT NULL,<\/code><\/div>\n
        <\/code>email       TEXT    not <\/code>null<\/code>,<\/code><\/div>\n
        <\/code>age         INT     NOT NULL,<\/code><\/div>\n
        <\/code>salary         real,<\/code><\/div>\n
        <\/code>unique(email)<\/code><\/div>\n
    <\/code>);<\/code><\/div>\n
 <\/div>\n
    <\/code>insert into spring_data_jpa_example.employee (firstname,lastname,email,age,salary)<\/code><\/div>\n
    <\/code>values (<\/code>'John'<\/code>,<\/code>'Doe 1'<\/code>,<\/code>'john1@doe.com'<\/code>,<\/code>18<\/code>,<\/code>1234.23<\/code>);<\/code><\/div>\n
    <\/code>insert into spring_data_jpa_example.employee (firstname,lastname,email,age,salary)<\/code><\/div>\n
    <\/code>values (<\/code>'John'<\/code>,<\/code>'Doe 2'<\/code>,<\/code>'john2@doe.com'<\/code>,<\/code>19<\/code>,<\/code>2234.23<\/code>);<\/code><\/div>\n
    <\/code>insert into spring_data_jpa_example.employee (firstname,lastname,email,age,salary)<\/code><\/div>\n
    <\/code>values (<\/code>'John'<\/code>,<\/code>'Doe 3'<\/code>,<\/code>'john3@doe.com'<\/code>,<\/code>20<\/code>,<\/code>3234.23<\/code>);<\/code><\/div>\n
    <\/code>insert into spring_data_jpa_example.employee (firstname,lastname,email,age,salary)<\/code><\/div>\n
    <\/code>values (<\/code>'John'<\/code>,<\/code>'Doe 4'<\/code>,<\/code>'john4@doe.com'<\/code>,<\/code>21<\/code>,<\/code>4234.23<\/code>);<\/code><\/div>\n
    <\/code>insert into spring_data_jpa_example.employee (firstname,lastname,email,age,salary)<\/code><\/div>\n
    <\/code>values (<\/code>'John'<\/code>,<\/code>'Doe 5'<\/code>,<\/code>'john5@doe.com'<\/code>,<\/code>22<\/code>,<\/code>5234.23<\/code>);<\/code><\/div>\n
EOSQL<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Since we shall use and Docker and Docker Compose the script above shall be used in order to initialize the database. Now on to create our Docker Compose stack.

<\/div> <\/div><\/p>\n
\n
\n\n\n\n
\n
01<\/div>\n
02<\/div>\n
03<\/div>\n
04<\/div>\n
05<\/div>\n
06<\/div>\n
07<\/div>\n
08<\/div>\n
09<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n
24<\/div>\n
25<\/div>\n
26<\/div>\n
27<\/div>\n
28<\/div>\n
29<\/div>\n
30<\/div>\n
31<\/div>\n
32<\/div>\n<\/td>\n
\n
\n
version: <\/code>'3.5'<\/code><\/div>\n
 <\/div>\n
services:<\/code><\/div>\n
  <\/code>write-db:<\/code><\/div>\n
    <\/code>image: postgres<\/code><\/div>\n
    <\/code>restart: always<\/code><\/div>\n
    <\/code>environment:<\/code><\/div>\n
      <\/code>POSTGRES_USER: db-user<\/code><\/div>\n
      <\/code>POSTGRES_PASSWORD: your-password<\/code><\/div>\n
      <\/code>POSTGRES_DB: postgres<\/code><\/div>\n
    <\/code>networks:<\/code><\/div>\n
      <\/code>- postgresql-network<\/code><\/div>\n
    <\/code>ports:<\/code><\/div>\n
      <\/code>- <\/code>\"127.0.0.2:5432:5432\"<\/code><\/div>\n
    <\/code>volumes:<\/code><\/div>\n
      <\/code>- $PWD\/init-db-script.sh:\/docker-entrypoint-initdb.d\/init-db-script.sh<\/code><\/div>\n
  <\/code>read-db-<\/code>1<\/code>:<\/code><\/div>\n
    <\/code>image: postgres<\/code><\/div>\n
    <\/code>restart: always<\/code><\/div>\n
    <\/code>environment:<\/code><\/div>\n
      <\/code>POSTGRES_USER: db-user<\/code><\/div>\n
      <\/code>POSTGRES_PASSWORD: your-password<\/code><\/div>\n
      <\/code>POSTGRES_DB: postgres<\/code><\/div>\n
    <\/code>networks:<\/code><\/div>\n
      <\/code>- postgresql-network<\/code><\/div>\n
    <\/code>ports:<\/code><\/div>\n
      <\/code>- <\/code>\"127.0.0.3:5432:5432\"<\/code><\/div>\n
    <\/code>volumes:<\/code><\/div>\n
      <\/code>- $PWD\/init-db-script.sh:\/docker-entrypoint-initdb.d\/init-db-script.sh<\/code><\/div>\n
networks:<\/code><\/div>\n
  <\/code>postgresql-network:<\/code><\/div>\n
    <\/code>name: postgresql-network<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

As you see our configuration is pretty simple. If you are careful enough you would see that I gave the number one to the read-db. This is because in the future we will add more replicas to it.<\/p>\n

What I also did is bounding the machines to different local ips.<\/p>\n

If you have problem binding addresses like 127.0.0.*:5432
You should try<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n<\/td>\n
\n
\n
sudo<\/code> ifconfig<\/code> lo0 <\/code>alias<\/code> 127.0.0.2 up<\/code><\/div>\n
sudo<\/code> ifconfig<\/code> lo0 <\/code>alias<\/code> 127.0.0.3 up<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

If you are unsuccessful then just change the ports and it will work. It might not be as convenient but it\u2019s still ok.<\/p>\n

So let\u2019s get up and running our Docker Compose stack.<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n<\/td>\n
\n
\n
docker-compose -f .<\/code>\/postgresql-stack<\/code>.yaml up<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

We must be able to query data in both postgresql instances.<\/p>\n

\n
\n\n\n\n
\n
01<\/div>\n
02<\/div>\n
03<\/div>\n
04<\/div>\n
05<\/div>\n
06<\/div>\n
07<\/div>\n
08<\/div>\n
09<\/div>\n
10<\/div>\n
11<\/div>\n<\/td>\n
\n
\n
docker <\/code>exec<\/code> -it deploy_read-db-1_1 <\/code>\/bin\/bash<\/code><\/div>\n
root@07c502968cb3:\/<\/code># psql -v --username \"$POSTGRES_USER\" --dbname \"$POSTGRES_DB\"<\/code><\/div>\n
db-user=<\/code># select*from spring_data_jpa_example.employee;<\/code><\/div>\n
 <\/code>id<\/code> | firstname | lastname |     email     | age | salary<\/code><\/div>\n
----+-----------+----------+---------------+-----+---------<\/code><\/div>\n
  <\/code>1 | John      | Doe 1    | john1@doe.com |  18 | 1234.23<\/code><\/div>\n
  <\/code>2 | John      | Doe 2    | john2@doe.com |  19 | 2234.23<\/code><\/div>\n
  <\/code>3 | John      | Doe 3    | john3@doe.com |  20 | 3234.23<\/code><\/div>\n
  <\/code>4 | John      | Doe 4    | john4@doe.com |  21 | 4234.23<\/code><\/div>\n
  <\/code>5 | John      | Doe 5    | john5@doe.com |  22 | 5234.23<\/code><\/div>\n
(5 rows)<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

We pretty much set up for our next step. We have some databases up and running and we are going to spin up a spring application running upon them. The next blog<\/a> focuses on implementing an application running upon our primary database.<\/p>\n

\n\n\n\n
\n

Published on Java Code Geeks with permission by Emmanouil Gkatziouras, partner at our JCG program<\/a>. See the original article here: Read replicas and Spring Data Part 1: Configuring the Databases<\/a><\/p>\n

Opinions expressed by Java Code Geeks contributors are their own.<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

This is a series of blog posts on our quest to increase our application\u2019s performance by utilizing read replicas. For this project our goal is to set up our spring data application and use read repositories for writes and repositories based on read replicas for reads. In order to simulate this environment we shall use …<\/p>\n","protected":false},"author":936,"featured_media":24013,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[936,491,30,854,321],"class_list":["post-99154","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-enterprise-java","tag-docker","tag-jdbc","tag-spring","tag-spring-boot","tag-spring-data"],"yoast_head":"\nRead replicas and Spring Data Part 1: Configuring the Databases - Java Code Geeks<\/title>\n<meta name=\"description\" content=\"Interested to learn about Read replicas? Check our article explaining how to read repositories for writes and repositories based on read replicas\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.javacodegeeks.com\/2019\/10\/read-replicas-spring-data-configuring-databases.html\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Read replicas and Spring Data Part 1: Configuring the Databases - Java Code Geeks\" \/>\n<meta property=\"og:description\" content=\"Interested to learn about Read replicas? Check our article explaining how to read repositories for writes and repositories based on read replicas\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.javacodegeeks.com\/2019\/10\/read-replicas-spring-data-configuring-databases.html\" \/>\n<meta property=\"og:site_name\" content=\"Java Code Geeks\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/javacodegeeks\" \/>\n<meta property=\"article:published_time\" content=\"2019-10-13T12:15:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2014\/04\/docker-logo.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"150\" \/>\n\t<meta property=\"og:image:height\" content=\"150\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Emmanouil Gkatziouras\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@javacodegeeks\" \/>\n<meta name=\"twitter:site\" content=\"@javacodegeeks\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Emmanouil Gkatziouras\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/2019\\\/10\\\/read-replicas-spring-data-configuring-databases.html#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/2019\\\/10\\\/read-replicas-spring-data-configuring-databases.html\"},\"author\":{\"name\":\"Emmanouil Gkatziouras\",\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/#\\\/schema\\\/person\\\/5eee031b356c7682e1fd24c8297561c6\"},\"headline\":\"Read replicas and Spring Data Part 1: Configuring the Databases\",\"datePublished\":\"2019-10-13T12:15:22+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/2019\\\/10\\\/read-replicas-spring-data-configuring-databases.html\"},\"wordCount\":394,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/2019\\\/10\\\/read-replicas-spring-data-configuring-databases.html#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.javacodegeeks.com\\\/wp-content\\\/uploads\\\/2014\\\/04\\\/docker-logo.jpg\",\"keywords\":[\"Docker\",\"JDBC\",\"Spring\",\"Spring Boot\",\"Spring Data\"],\"articleSection\":[\"Enterprise Java\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.javacodegeeks.com\\\/2019\\\/10\\\/read-replicas-spring-data-configuring-databases.html#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/2019\\\/10\\\/read-replicas-spring-data-configuring-databases.html\",\"url\":\"https:\\\/\\\/www.javacodegeeks.com\\\/2019\\\/10\\\/read-replicas-spring-data-configuring-databases.html\",\"name\":\"Read replicas and Spring Data Part 1: Configuring the Databases - Java Code Geeks\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/2019\\\/10\\\/read-replicas-spring-data-configuring-databases.html#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/2019\\\/10\\\/read-replicas-spring-data-configuring-databases.html#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.javacodegeeks.com\\\/wp-content\\\/uploads\\\/2014\\\/04\\\/docker-logo.jpg\",\"datePublished\":\"2019-10-13T12:15:22+00:00\",\"description\":\"Interested to learn about Read replicas? Check our article explaining how to read repositories for writes and repositories based on read replicas\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/2019\\\/10\\\/read-replicas-spring-data-configuring-databases.html#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.javacodegeeks.com\\\/2019\\\/10\\\/read-replicas-spring-data-configuring-databases.html\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/2019\\\/10\\\/read-replicas-spring-data-configuring-databases.html#primaryimage\",\"url\":\"https:\\\/\\\/www.javacodegeeks.com\\\/wp-content\\\/uploads\\\/2014\\\/04\\\/docker-logo.jpg\",\"contentUrl\":\"https:\\\/\\\/www.javacodegeeks.com\\\/wp-content\\\/uploads\\\/2014\\\/04\\\/docker-logo.jpg\",\"width\":150,\"height\":150},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/2019\\\/10\\\/read-replicas-spring-data-configuring-databases.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.javacodegeeks.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Java\",\"item\":\"https:\\\/\\\/www.javacodegeeks.com\\\/category\\\/java\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Enterprise Java\",\"item\":\"https:\\\/\\\/www.javacodegeeks.com\\\/category\\\/java\\\/enterprise-java\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Read replicas and Spring Data Part 1: Configuring the Databases\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/#website\",\"url\":\"https:\\\/\\\/www.javacodegeeks.com\\\/\",\"name\":\"Java Code Geeks\",\"description\":\"Java Developers Resource Center\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/#organization\"},\"alternateName\":\"JCG\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.javacodegeeks.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/#organization\",\"name\":\"Exelixis Media P.C.\",\"url\":\"https:\\\/\\\/www.javacodegeeks.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.javacodegeeks.com\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/exelixis-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.javacodegeeks.com\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/exelixis-logo.png\",\"width\":864,\"height\":246,\"caption\":\"Exelixis Media P.C.\"},\"image\":{\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/javacodegeeks\",\"https:\\\/\\\/x.com\\\/javacodegeeks\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/#\\\/schema\\\/person\\\/5eee031b356c7682e1fd24c8297561c6\",\"name\":\"Emmanouil Gkatziouras\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/5c6d031d211ab786ec335687ad6f3f076f93f47e24c92d78041d2f805ee6c291?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/5c6d031d211ab786ec335687ad6f3f076f93f47e24c92d78041d2f805ee6c291?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/5c6d031d211ab786ec335687ad6f3f076f93f47e24c92d78041d2f805ee6c291?s=96&d=mm&r=g\",\"caption\":\"Emmanouil Gkatziouras\"},\"description\":\"He is a versatile software engineer with experience in a wide variety of applications\\\/services.He is enthusiastic about new projects, embracing new technologies, and getting to know people in the field of software.\",\"sameAs\":[\"http:\\\/\\\/egkatzioura.wordpress.com\\\/\",\"https:\\\/\\\/gr.linkedin.com\\\/in\\\/gkatziourasemmanouil\"],\"url\":\"https:\\\/\\\/www.javacodegeeks.com\\\/author\\\/emmanouil-gkatziouras\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Read replicas and Spring Data Part 1: Configuring the Databases - Java Code Geeks","description":"Interested to learn about Read replicas? Check our article explaining how to read repositories for writes and repositories based on read replicas","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.javacodegeeks.com\/2019\/10\/read-replicas-spring-data-configuring-databases.html","og_locale":"en_US","og_type":"article","og_title":"Read replicas and Spring Data Part 1: Configuring the Databases - Java Code Geeks","og_description":"Interested to learn about Read replicas? Check our article explaining how to read repositories for writes and repositories based on read replicas","og_url":"https:\/\/www.javacodegeeks.com\/2019\/10\/read-replicas-spring-data-configuring-databases.html","og_site_name":"Java Code Geeks","article_publisher":"https:\/\/www.facebook.com\/javacodegeeks","article_published_time":"2019-10-13T12:15:22+00:00","og_image":[{"width":150,"height":150,"url":"https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2014\/04\/docker-logo.jpg","type":"image\/jpeg"}],"author":"Emmanouil Gkatziouras","twitter_card":"summary_large_image","twitter_creator":"@javacodegeeks","twitter_site":"@javacodegeeks","twitter_misc":{"Written by":"Emmanouil Gkatziouras","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.javacodegeeks.com\/2019\/10\/read-replicas-spring-data-configuring-databases.html#article","isPartOf":{"@id":"https:\/\/www.javacodegeeks.com\/2019\/10\/read-replicas-spring-data-configuring-databases.html"},"author":{"name":"Emmanouil Gkatziouras","@id":"https:\/\/www.javacodegeeks.com\/#\/schema\/person\/5eee031b356c7682e1fd24c8297561c6"},"headline":"Read replicas and Spring Data Part 1: Configuring the Databases","datePublished":"2019-10-13T12:15:22+00:00","mainEntityOfPage":{"@id":"https:\/\/www.javacodegeeks.com\/2019\/10\/read-replicas-spring-data-configuring-databases.html"},"wordCount":394,"commentCount":0,"publisher":{"@id":"https:\/\/www.javacodegeeks.com\/#organization"},"image":{"@id":"https:\/\/www.javacodegeeks.com\/2019\/10\/read-replicas-spring-data-configuring-databases.html#primaryimage"},"thumbnailUrl":"https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2014\/04\/docker-logo.jpg","keywords":["Docker","JDBC","Spring","Spring Boot","Spring Data"],"articleSection":["Enterprise Java"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.javacodegeeks.com\/2019\/10\/read-replicas-spring-data-configuring-databases.html#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.javacodegeeks.com\/2019\/10\/read-replicas-spring-data-configuring-databases.html","url":"https:\/\/www.javacodegeeks.com\/2019\/10\/read-replicas-spring-data-configuring-databases.html","name":"Read replicas and Spring Data Part 1: Configuring the Databases - Java Code Geeks","isPartOf":{"@id":"https:\/\/www.javacodegeeks.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.javacodegeeks.com\/2019\/10\/read-replicas-spring-data-configuring-databases.html#primaryimage"},"image":{"@id":"https:\/\/www.javacodegeeks.com\/2019\/10\/read-replicas-spring-data-configuring-databases.html#primaryimage"},"thumbnailUrl":"https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2014\/04\/docker-logo.jpg","datePublished":"2019-10-13T12:15:22+00:00","description":"Interested to learn about Read replicas? Check our article explaining how to read repositories for writes and repositories based on read replicas","breadcrumb":{"@id":"https:\/\/www.javacodegeeks.com\/2019\/10\/read-replicas-spring-data-configuring-databases.html#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.javacodegeeks.com\/2019\/10\/read-replicas-spring-data-configuring-databases.html"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.javacodegeeks.com\/2019\/10\/read-replicas-spring-data-configuring-databases.html#primaryimage","url":"https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2014\/04\/docker-logo.jpg","contentUrl":"https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2014\/04\/docker-logo.jpg","width":150,"height":150},{"@type":"BreadcrumbList","@id":"https:\/\/www.javacodegeeks.com\/2019\/10\/read-replicas-spring-data-configuring-databases.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.javacodegeeks.com\/"},{"@type":"ListItem","position":2,"name":"Java","item":"https:\/\/www.javacodegeeks.com\/category\/java"},{"@type":"ListItem","position":3,"name":"Enterprise Java","item":"https:\/\/www.javacodegeeks.com\/category\/java\/enterprise-java"},{"@type":"ListItem","position":4,"name":"Read replicas and Spring Data Part 1: Configuring the Databases"}]},{"@type":"WebSite","@id":"https:\/\/www.javacodegeeks.com\/#website","url":"https:\/\/www.javacodegeeks.com\/","name":"Java Code Geeks","description":"Java Developers Resource Center","publisher":{"@id":"https:\/\/www.javacodegeeks.com\/#organization"},"alternateName":"JCG","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.javacodegeeks.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.javacodegeeks.com\/#organization","name":"Exelixis Media P.C.","url":"https:\/\/www.javacodegeeks.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.javacodegeeks.com\/#\/schema\/logo\/image\/","url":"https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2022\/06\/exelixis-logo.png","contentUrl":"https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2022\/06\/exelixis-logo.png","width":864,"height":246,"caption":"Exelixis Media P.C."},"image":{"@id":"https:\/\/www.javacodegeeks.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/javacodegeeks","https:\/\/x.com\/javacodegeeks"]},{"@type":"Person","@id":"https:\/\/www.javacodegeeks.com\/#\/schema\/person\/5eee031b356c7682e1fd24c8297561c6","name":"Emmanouil Gkatziouras","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/5c6d031d211ab786ec335687ad6f3f076f93f47e24c92d78041d2f805ee6c291?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/5c6d031d211ab786ec335687ad6f3f076f93f47e24c92d78041d2f805ee6c291?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5c6d031d211ab786ec335687ad6f3f076f93f47e24c92d78041d2f805ee6c291?s=96&d=mm&r=g","caption":"Emmanouil Gkatziouras"},"description":"He is a versatile software engineer with experience in a wide variety of applications\/services.He is enthusiastic about new projects, embracing new technologies, and getting to know people in the field of software.","sameAs":["http:\/\/egkatzioura.wordpress.com\/","https:\/\/gr.linkedin.com\/in\/gkatziourasemmanouil"],"url":"https:\/\/www.javacodegeeks.com\/author\/emmanouil-gkatziouras"}]}},"_links":{"self":[{"href":"https:\/\/www.javacodegeeks.com\/wp-json\/wp\/v2\/posts\/99154","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.javacodegeeks.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.javacodegeeks.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.javacodegeeks.com\/wp-json\/wp\/v2\/users\/936"}],"replies":[{"embeddable":true,"href":"https:\/\/www.javacodegeeks.com\/wp-json\/wp\/v2\/comments?post=99154"}],"version-history":[{"count":0,"href":"https:\/\/www.javacodegeeks.com\/wp-json\/wp\/v2\/posts\/99154\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.javacodegeeks.com\/wp-json\/wp\/v2\/media\/24013"}],"wp:attachment":[{"href":"https:\/\/www.javacodegeeks.com\/wp-json\/wp\/v2\/media?parent=99154"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.javacodegeeks.com\/wp-json\/wp\/v2\/categories?post=99154"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.javacodegeeks.com\/wp-json\/wp\/v2\/tags?post=99154"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}