# Ngā Taapiri Whakahaerehia: Postgres me Redis

Source: https://support.kapsulehost.com/mi-nz/site-addons

Mā te ripa Āpitihanga koe e āhei ai ki te hono i tētahi pātengi raraunga PostgreSQL whakamanahinihia, i tētahi momo Redis whakamanahinihia rānei ki tētahi paetukutuku, me te kore e hanga, e tiaki rānei i tētahi tūmau mō taua mea. Mā KapsuleHost e whakarite, ka hoatu ki a koe tētahi aho hono, ā, ka tangohia mā runga anō i te horopaki marama ina whakakorehia e koe.

## Kei Hea Ngā Āpitihanga

Whakatuwherahia **Ngā Paetukutuku**, pāwhiritia te paetukutuku, whakatuwherahia te rōpū **Ngā Taupānga** kei te tahua maui o te paetukutuku, kātahi ka kōwhiritia **Ngā Tāpiritanga**. Ko te taitara o te whārangi ko **Ngā āpitihanga whakamanahinihia**.

E rua ngā kōwhiringa kei roto i te rārangi hokohoko:

| Āpitihanga | Whakamahinga māori |
|---|---|
| PostgreSQL | Te pātengi raraunga matua mō tētahi tono kāore i runga i te MySQL |
| Redis | Te penapena tere (caching), te rokiroki wāhanga, me ngā rārangi mahi papamuri |

He mea wehe ēnei i te pātengi raraunga MySQL e haere tahi ana me tētahi paetukutuku tukutuku paerewa. Kei te ripa **Putanga Raraunga** taua mea, ā, kāore he whakaritenga e hiahiatia ana: tirohia [Te Hono atu ki Tō Pātengi Raraunga mā roto i te Anga SSH](https://support.kapsulehost.com/mi-nz/database-ssh-tunnel).

![Whārangi ngā āpitihanga whakamanahinihia mō tētahi paetukutuku i roto i te KPanel](https://support.kapsulehost.com/help/screenshots/site-addons.3f3b5ee3.webp)

## Te Tono i Tētahi Āpitihanga

1. Kimihia te āpitihanga kei roto i te wāhanga **Tāpiri tētahi roputu āramatai**.
2. Pāwhiritia **Tāpiri ki te paetukutuku**.

Ka tuhia tonutia te tono, ā, ka puta te āpitihanga i roto i **Ō āpitihanga** me tētahi tohu **PENDING** me te kupu āpiti *E tatari ana mō te kaiwhakarite*. Ka whakahōu anō te whārangi ia tekau mā rima hēkona, nō reira ka taea e koe te waiho tuwhera.

I ia tekau meneti pea, ka mauria e tētahi mahi papamuri ngā tono e taria ana, ka hangaia he pātengi raraunga motuhake me tētahi kaiwhakamahi motuhake mō tō paetukutuku, ā, ka tuhia anō tētahi aho hono kua whakamunatia. Kātahi ka neke te tūnga ki **ACTIVE**.

> **Note:** Me whai whakaaetanga **sites:write** te tono, te tango rānei, i tētahi āpitihanga. Ka taea e ngā mema tīma pānui anake te kite i ngā āpitihanga kei konā me ō rātou tūnga, engari kua hunaia ngā pātene.

### Kotahi o Ia Momo, Mō Ia Paetukutuku

Ka taea e tētahi paetukutuku te pupuri kotahi āpitihanga PostgreSQL me kotahi āpitihanga Redis. Ki te tonoa he tuarua o te momo ōrite, ka whakakāhoretia me tētahi karere e kī ana kua whakaritea kētia, ā, ka huna te rārangi hokohoko i tētahi kōwhiringa i muri i tōna whakaurunga. Ina kua whakaritea ngā mea e rua, ka kī te wāhanga rārangi hokohoko **Kua whakaritea katoatia ngā āpitihanga e wātea ana**.

## Te Pānui i te Tūnga

| Tūnga | Tikanga |
|---|---|
| PENDING | Kua tonoa, e tatari ana i te rārangi mō te kaiwhakarite |
| PROVISIONING | E hangaia ana i tēnei wā |
| ACTIVE | Kua rite ki te whakamahi |
| FAILED | Kāore i oti te whakaritenga; ka whakaatuhia te take i runga i te rārangi |
| DELETED | Kua tangohia, kua kore e whakarārangihia |

Ka whakaatuhia e tētahi rārangi **FAILED** te kupu hapa pono kei raro iho, kaua ko tētahi karere whānui noa. Ki te kore e taea e koe te whakatika i te take, tāruatia ōrite ki roto i tētahi tiikete tautoko: tirohia [Te Whakatuwhera i Tētahi Tiikete Tautoko](https://support.kapsulehost.com/mi-nz/opening-a-support-ticket).

## Te Tiki i te Aho Hono

I te mea kua **ACTIVE** tētahi āpitihanga, ka whakaatu tōna rārangi i tētahi aho hono kua huna, kua whakakapia te kupuhipa ki ngā piko, nō reira ka taea e koe te whakaū i te kaihautū me te ingoa pātengi raraunga mā te tiro poto, me te kore e whakakitea te mōhiohio ngaro.

Pāwhiritia **Kōphi hono** hei tuku i te aho hono katoa ki tō papatopetope. Ka wetewetea i te taha tūmau mō taua tono kotahi anake, kāore anō i tāngia ki te whārangi, nō reira kāore e torere ana i roto i ngā tiritiri mata me ngā whakapae mata. Ka tuhia ia whakakitenga ki te rārangi arotake o te paetukutuku, ā, ka kitea i roto i te [Rārangi Auaha Paetukutuku](https://support.kapsulehost.com/mi-nz/site-activity-log).

Kei roto te aho i te āhua URL māori mō ia pūnaha, e mau ana i te kaihautū, te tauranga, te kaiwhakamahi, te kupuhipa me te ingoa pātengi raraunga i hangaia mō tēnei paetukutuku.

## Te Whakamahi i te Aho Hono ki Tō Tono

Whakapiritia te aho hono ki te wāhi e pānui ai tō tono i tōna whirihoranga. Mō tētahi paetukutuku Node.js, ko te wāhi tika ko te ripa [Secrets](https://support.kapsulehost.com/mi-nz/site-secrets), i raro i tētahi kī pērā i te `DATABASE_URL`, i te `REDIS_URL` rānei, i roto i te horopaki **production**.

> **Warning:** Kaua e whakauru pūmau i te aho hono ki tētahi kōnae ka tāpaetia e koe. Kei roto he kupuhipa e mahi ana. Mēnā ka eke ki tētahi tāwhiti git, me whakaaro he mea kua torere, ā, ko te rongoā pono anake ko te muku i te āpitihanga me te tono anō i tētahi mea hōu, nā te mea kāore e taea te huri i te kupuhuna i te waahi tonu mai i te paewhakahaere.

## Te Tango i Tētahi Āpitihanga

Pāwhiritia **Delete** i te rārangi. Ka pātai mai a KPanel kia whakaūngia, ā, ka tino mārama mai i ngā putanga: ka tangohia tēnei i te pātengi raraunga whakamanahinihia, ā, kāore e taea te whakaora i ngā raraunga.

Ka tohua te rārangi hei mea kua mukua i taua wā tonu, ā, ka tangohia e te kaiwhakarite te pātengi raraunga me te kaiwhakamahi i tōna wā e whai ake nei. Ka whakamutua ngā hononga kei te mahi i taua wā anō.

> **Important:** Kāore he tāwharau tuari i mauria mō tētahi āpitihanga whakamanahinihia i te wā e mukua ana, kāore anō he huri whakamuri. Mēnā kei roto tētahi mea e hiahia ana koe kia pupuri, tukuna ki waho i mua mā te whakamahi i te `pg_dump`, i te `redis-cli --rdb` rānei, i te mea e mahi tonu ana te āpitihanga, ā, e mahi tonu ana te aho hono.

## Te Kōwhiri i waenga i ngā Kōwhiringa

**Whakamahia a PostgreSQL** ina hiahia tō tono i tētahi pātengi raraunga whakapā, ā, kua tuhia mō Postgres: he here kaha, he mahi tahi (transactions), he pou JSON, me te rapu kupu-katoa ka rāwaho atu te whakatinana.

**Whakamahia a Redis** mō ngā mea e whakaaetia ana kia ngaro: ngā kongakonga kua penatia, ngā tatau whakaiti-reiti, te rokiroki wāhanga, me ngā rārangi mahi. Me whakaaro he mea tere me te kore pūmau, kaua he pūnaha pūkete.

**Whakamahia te pātengi raraunga MySQL kua whakaurua mai** mō WordPress, mō ngā mea katoa kua tuhia kē mō MySQL. Ki te tāpiri koe i tētahi āpitihanga Postgres ki tētahi paetukutuku WordPress, kāore he hua, nā te mea kāore e taea e WordPress te kōrero ki a ia.

## Te Whakatika Raru

**Kua roa noa atu te āpitihanga e PENDING ana.** Ka whakahaerehia te kaiwhakarite i runga i tētahi wātaka, kaua i te wā tonu. Waiho te whārangi kia tuwhera, i te mea ka whakahōu anō ia, ā, titiro anō ā muri ake. Mēnā kāore anō kia neke i muri i ētahi wā maha, whakatuwherahia tētahi tiikete tautoko me te rorohiko o te paetukutuku me te momo āpitihanga.

**Kua FAILED te whakaritenga.** Pānuitia te hapa kei te rārangi. Mukua te āpitihanga i rahua, ā, tonoa anō, he haumaru tēnei: kāore rawa he pātengi raraunga e mahi ana i muri i tētahi rārangi i rahua.

**Kāore he aha e tupu ana i te Kōphi hono.** Ka ārai ētahi pūtirotiro i te tuhinga papatopetope ina kāore te ripa e aro mai ana. Pāwhiritia te whārangi i te tuatahi, kātahi ka pāwhiritia anō te pātene.

**Kāore e taea e te tono te hono.** Tirohia ēnei mea e toru, kia tika te raupapa: kei te **ACTIVE** te tūnga āpitihanga, nāu anō i kōphi te aho kaua i te tā anō, ā, e pānui ana tō tono i te uara i tautuhia tūturutia e koe, kaua i tētahi mea tawhito nō tētahi tukunga o mua. He mea tika kia tīmata anō i mua i te tango o te whirihoranga hōu.

**Kua whakakāhoretia ngā hononga i muri i te tuku anō.** Whakaūngia kei te taurite tonu te aho hono kei tō whirihoranga me tērā kei tēnei whārangi. Mā te muku me te tono anō i tētahi āpitihanga ka hangaia he kaiwhakamahi hōu me tētahi kupuhipa hōu, nō reira kāore e mahi te aho tawhito.

## Te Wāhi e Haere ai ā Muri Ake

- [Te Penapena i ngā Kupu Ngaro Tono mō Tētahi Paetukutuku](https://support.kapsulehost.com/mi-nz/site-secrets), te wāhi tika hei pupuri i te aho hono.
- [Te Hono atu ki Tō Pātengi Raraunga mā roto i te Anga SSH](https://support.kapsulehost.com/mi-nz/database-ssh-tunnel) mō te pātengi raraunga MySQL kua whakaurua mai.
- [Ngā Tautuhinga Paetukutuku](https://support.kapsulehost.com/mi-nz/site-settings) mō ētahi atu whirihoranga i te taumata paetukutuku.